Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. The Lounge
  3. Jesús Alvarez Manrique

Jesús Alvarez Manrique

Scheduled Pinned Locked Moved The Lounge
databasecsharpsql-serverwpfsysadmin
19 Posts 12 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • U User 8968497

    Tengo un ComboBox en WPF que relleno mediante la ejecución de un procedimiento almacenado de SQL server, con los nombres de los autores de determinados artículos de prensa. Hasta ahí perfectamente. El problema viene cuando después de seleccionar un autor (Apellidos, Nombre) y solicitar que me descomponga la cadena mediante la función Split(',') me da error al no encontrar el segundo elemento del array. La explicación está en que intenta descomponer el siguiente resultado de la selección en el ComboBox: ComboBoxWPF_LINQ_01.usp_ListadoCompletoAutoresResult, siendo ComboBoxWPF_LINQ_01 el nombre de la Solución y usp_ListadoCompletoAutores el procedimiento almacenado que ejecuto para llenar el ComboBox. El código que utilizo es el siguiente: private void MostrarAutor() {string oAutor, oApellidos, oNombre; string [] CadenaSeparada; DataClasses1DataContext db = new DataClasses1DataContext(); cboAutores.ItemSource = db.usp_ListadoCompletoAutores().ToList(); oAutor = cboAutotes.Text.ToString; CadenaSeparada = oAutor.Split(','); textBox1.Text = CadenaSeparada[0]; textBox2.Text = CadenaSeparada[1]; } Tambien lo he probado con oAutor = cboAutores.SelectedItem.ToString() y tampoco me funciona Las cadenas las necesito para buscar en la base de datos los artículos escritos de cada autor, que figuren en ella. El comboBox se llena perfectamente con cadenas con la siguiente estructura Apellido1 Apellido2, Nombre Apellido1 Apellido2, Nombre Apellido1 Apellido2, Nombre ...................................... (Apellido1 Apellido2, son un sólo campo) Selecciono un Item, y en el texto del combo aparece la cadena seleccionada con la misma estructura, osea, Apellido1 Apellido2, Nombre, y es aquí donde comienzan los problemas, pues cuando hago oAutor = cboAutotes.Text.ToString; ó oAutor = cboAutotes; me devuelve "ComboBoxWPF_LINQ_01.usp_ListadoCompletoAutoresResult", en lugar de devolverme la cadena "Apellido1 Apellido2, Nombre", nada parecido con la realidad.

    Jesús Álvarez Manrique

    J Offline
    J Offline
    Joan M
    wrote on last edited by
    #8

    Jesús, has cometido dos errores garrafales: El primero: estás en un sitio de habla inglesa, por respeto a los demás se habla en inglés siempre, se sea del país que se sea. El segundo: has posteado tu mensaje en el "The Lounge" que es casi el único sitio de "The Codeproject" en el que no se puede hablar de programación. Te recomiendo que postees tu pregunta en la sección "Questions and Answers", sigue el link[^], y que lo hagas en inglés. Si tienes problemas para traducir tu pregunta, puedo traducirla yo por ti. Suerte! ******************************************* Jesús, You've made two big mistakes: 1. You've posted a programming question in "The Lounge", which is almost the only place in :bob: where it is not allowed to do it. 2. You've posted your question in Spanish, this is a site that speaks English and people from around the world speak this language here. I recommend you to post the question in the Questions and answers section, follow the link[^], and do it in English. If you have problems to translate your question to English, let me know it and I will do it for you. Good luck!

    [www.tamautomation.com] Robots, CNC and PLC machines for grinding and polishing.

    https://www.robotecnik.com freelance robots, PLC and CNC programmer.

    A L C 3 Replies Last reply
    0
    • J Joan M

      Jesús, has cometido dos errores garrafales: El primero: estás en un sitio de habla inglesa, por respeto a los demás se habla en inglés siempre, se sea del país que se sea. El segundo: has posteado tu mensaje en el "The Lounge" que es casi el único sitio de "The Codeproject" en el que no se puede hablar de programación. Te recomiendo que postees tu pregunta en la sección "Questions and Answers", sigue el link[^], y que lo hagas en inglés. Si tienes problemas para traducir tu pregunta, puedo traducirla yo por ti. Suerte! ******************************************* Jesús, You've made two big mistakes: 1. You've posted a programming question in "The Lounge", which is almost the only place in :bob: where it is not allowed to do it. 2. You've posted your question in Spanish, this is a site that speaks English and people from around the world speak this language here. I recommend you to post the question in the Questions and answers section, follow the link[^], and do it in English. If you have problems to translate your question to English, let me know it and I will do it for you. Good luck!

      [www.tamautomation.com] Robots, CNC and PLC machines for grinding and polishing.

      A Offline
      A Offline
      Albert Holguin
      wrote on last edited by
      #9

      Good Spanish! ...I'd be happy to translate as well... Muy buen Español! ...yo tambien podria hacer tranducciones si alguien necesita ayuda...

      S 1 Reply Last reply
      0
      • L loctrice

        WTE?!..... -edit- ask this in the correct forum.

        If it moves, compile it

        Z Offline
        Z Offline
        ZurdoDev
        wrote on last edited by
        #10

        The correct response is Como?

        There are only 10 types of people in the world, those who understand binary and those who don't.

        1 Reply Last reply
        0
        • J Joan M

          Jesús, has cometido dos errores garrafales: El primero: estás en un sitio de habla inglesa, por respeto a los demás se habla en inglés siempre, se sea del país que se sea. El segundo: has posteado tu mensaje en el "The Lounge" que es casi el único sitio de "The Codeproject" en el que no se puede hablar de programación. Te recomiendo que postees tu pregunta en la sección "Questions and Answers", sigue el link[^], y que lo hagas en inglés. Si tienes problemas para traducir tu pregunta, puedo traducirla yo por ti. Suerte! ******************************************* Jesús, You've made two big mistakes: 1. You've posted a programming question in "The Lounge", which is almost the only place in :bob: where it is not allowed to do it. 2. You've posted your question in Spanish, this is a site that speaks English and people from around the world speak this language here. I recommend you to post the question in the Questions and answers section, follow the link[^], and do it in English. If you have problems to translate your question to English, let me know it and I will do it for you. Good luck!

          [www.tamautomation.com] Robots, CNC and PLC machines for grinding and polishing.

          L Offline
          L Offline
          loctrice
          wrote on last edited by
          #11

          so will google translate, which is how I figured out what he wanted in the first place.

          If it moves, compile it

          1 Reply Last reply
          0
          • U User 8968497

            Tengo un ComboBox en WPF que relleno mediante la ejecución de un procedimiento almacenado de SQL server, con los nombres de los autores de determinados artículos de prensa. Hasta ahí perfectamente. El problema viene cuando después de seleccionar un autor (Apellidos, Nombre) y solicitar que me descomponga la cadena mediante la función Split(',') me da error al no encontrar el segundo elemento del array. La explicación está en que intenta descomponer el siguiente resultado de la selección en el ComboBox: ComboBoxWPF_LINQ_01.usp_ListadoCompletoAutoresResult, siendo ComboBoxWPF_LINQ_01 el nombre de la Solución y usp_ListadoCompletoAutores el procedimiento almacenado que ejecuto para llenar el ComboBox. El código que utilizo es el siguiente: private void MostrarAutor() {string oAutor, oApellidos, oNombre; string [] CadenaSeparada; DataClasses1DataContext db = new DataClasses1DataContext(); cboAutores.ItemSource = db.usp_ListadoCompletoAutores().ToList(); oAutor = cboAutotes.Text.ToString; CadenaSeparada = oAutor.Split(','); textBox1.Text = CadenaSeparada[0]; textBox2.Text = CadenaSeparada[1]; } Tambien lo he probado con oAutor = cboAutores.SelectedItem.ToString() y tampoco me funciona Las cadenas las necesito para buscar en la base de datos los artículos escritos de cada autor, que figuren en ella. El comboBox se llena perfectamente con cadenas con la siguiente estructura Apellido1 Apellido2, Nombre Apellido1 Apellido2, Nombre Apellido1 Apellido2, Nombre ...................................... (Apellido1 Apellido2, son un sólo campo) Selecciono un Item, y en el texto del combo aparece la cadena seleccionada con la misma estructura, osea, Apellido1 Apellido2, Nombre, y es aquí donde comienzan los problemas, pues cuando hago oAutor = cboAutotes.Text.ToString; ó oAutor = cboAutotes; me devuelve "ComboBoxWPF_LINQ_01.usp_ListadoCompletoAutoresResult", en lugar de devolverme la cadena "Apellido1 Apellido2, Nombre", nada parecido con la realidad.

            Jesús Álvarez Manrique

            E Offline
            E Offline
            Emmanuel Medina
            wrote on last edited by
            #12

            Wow so many downvotes poor guy is in the negative points :laugh: . He should've had some time to learn to use CP tho, it seems he has been a member for 4 months now...

            A 1 Reply Last reply
            0
            • J Joan M

              Jesús, has cometido dos errores garrafales: El primero: estás en un sitio de habla inglesa, por respeto a los demás se habla en inglés siempre, se sea del país que se sea. El segundo: has posteado tu mensaje en el "The Lounge" que es casi el único sitio de "The Codeproject" en el que no se puede hablar de programación. Te recomiendo que postees tu pregunta en la sección "Questions and Answers", sigue el link[^], y que lo hagas en inglés. Si tienes problemas para traducir tu pregunta, puedo traducirla yo por ti. Suerte! ******************************************* Jesús, You've made two big mistakes: 1. You've posted a programming question in "The Lounge", which is almost the only place in :bob: where it is not allowed to do it. 2. You've posted your question in Spanish, this is a site that speaks English and people from around the world speak this language here. I recommend you to post the question in the Questions and answers section, follow the link[^], and do it in English. If you have problems to translate your question to English, let me know it and I will do it for you. Good luck!

              [www.tamautomation.com] Robots, CNC and PLC machines for grinding and polishing.

              C Offline
              C Offline
              Chris Meech
              wrote on last edited by
              #13

              :thumbsup: :thumbsup: :thumbsup: Offer to help out the OP. Always worth a five. :)

              Chris Meech I am Canadian. [heard in a local bar] In theory there is no difference between theory and practice. In practice there is. [Yogi Berra] posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]

              J A 2 Replies Last reply
              0
              • A Albert Holguin

                Good Spanish! ...I'd be happy to translate as well... Muy buen Español! ...yo tambien podria hacer tranducciones si alguien necesita ayuda...

                S Offline
                S Offline
                Slacker007
                wrote on last edited by
                #14

                Joan is from Spain, you know.

                1 Reply Last reply
                0
                • C Chris Meech

                  :thumbsup: :thumbsup: :thumbsup: Offer to help out the OP. Always worth a five. :)

                  Chris Meech I am Canadian. [heard in a local bar] In theory there is no difference between theory and practice. In practice there is. [Yogi Berra] posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]

                  J Offline
                  J Offline
                  Joan M
                  wrote on last edited by
                  #15

                  Who would downvote this kind of post? :sigh: Countered...

                  [www.tamautomation.com] Robots, CNC and PLC machines for grinding and polishing.

                  https://www.robotecnik.com freelance robots, PLC and CNC programmer.

                  1 Reply Last reply
                  0
                  • C Chris Meech

                    :thumbsup: :thumbsup: :thumbsup: Offer to help out the OP. Always worth a five. :)

                    Chris Meech I am Canadian. [heard in a local bar] In theory there is no difference between theory and practice. In practice there is. [Yogi Berra] posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]

                    A Offline
                    A Offline
                    Albert Holguin
                    wrote on last edited by
                    #16

                    Countered as well...

                    1 Reply Last reply
                    0
                    • E Emmanuel Medina

                      Wow so many downvotes poor guy is in the negative points :laugh: . He should've had some time to learn to use CP tho, it seems he has been a member for 4 months now...

                      A Offline
                      A Offline
                      Albert Holguin
                      wrote on last edited by
                      #17

                      I think I was a member for like a year or two before I became active on the site...

                      E 1 Reply Last reply
                      0
                      • A Albert Holguin

                        I think I was a member for like a year or two before I became active on the site...

                        E Offline
                        E Offline
                        Emmanuel Medina
                        wrote on last edited by
                        #18

                        Well, yeah, I meant he should realize that the site member's used language is English and should know, just by reading, that the Lounge is not the place for Programming questions; I've been a member since Aug 2007, but only started replying to posts/questions like 3 weeks ago, still, I knew that. Anyway, I've recommended him a site in spanish so he doesn't get a bajillion downvotes every time he asks a question.

                        A 1 Reply Last reply
                        0
                        • E Emmanuel Medina

                          Well, yeah, I meant he should realize that the site member's used language is English and should know, just by reading, that the Lounge is not the place for Programming questions; I've been a member since Aug 2007, but only started replying to posts/questions like 3 weeks ago, still, I knew that. Anyway, I've recommended him a site in spanish so he doesn't get a bajillion downvotes every time he asks a question.

                          A Offline
                          A Offline
                          Albert Holguin
                          wrote on last edited by
                          #19

                          Was just pointing out the fact that the account was created a while back ago doesn't imply he knows how to use the site. Perhaps he doesn't understand/speak English well so he didn't read the posting rules... ...he's sure gotten flak about it now though... in at least a couple of languages.

                          1 Reply Last reply
                          0
                          Reply
                          • Reply as topic
                          Log in to reply
                          • Oldest to Newest
                          • Newest to Oldest
                          • Most Votes


                          • Login

                          • Don't have an account? Register

                          • Login or register to search.
                          • First post
                            Last post
                          0
                          • Categories
                          • Recent
                          • Tags
                          • Popular
                          • World
                          • Users
                          • Groups