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. General Programming
  3. C#
  4. Using a Stored Procedure in C#

Using a Stored Procedure in C#

Scheduled Pinned Locked Moved C#
csharpdatabasecomquestion
13 Posts 6 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.
  • O Obaid ur Rehman

    When the CommandType property is set to StoredProcedure, the CommandText property should be set to the name of the stored procedure. http://msdn2.microsoft.com/en-us/library/x8ybe6s2(VS.80).aspx[^]

    V Offline
    V Offline
    Vimalsoft Pty Ltd
    wrote on last edited by
    #4

    hi Thanks for your Reply like this cmdselect.CommandText = "get_me"; cmdselect.CommandType = CommandType = StoredProcedure; "get_me" is the name of the Procedure. and this is how i wrote my code, what is Wrong ? Thanks

    Vuyiswa Maseko, Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding VB.NET/SQL7/2000/2005 http://vuyiswamb.007ihost.com http://Ecadre.007ihost.com vuyiswam@tshwane.gov.za

    C 1 Reply Last reply
    0
    • V Vimalsoft Pty Ltd

      Good Afternoon All An new in C#, i have been doing Ado.net in vb.net. i want to use a Stored Procedure to do my database work, and i want to tell my command object that we are going to use a StoredProcedure. if i try this cmdselect.CommandType = CommandType = StoredProcedure; I get an Exception that says

      The Name StoredProcedure does not Exists in the current context

      i have googled and my line looked ok, but i dont know what is wrong with this line Thanks

      Vuyiswa Maseko, Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding VB.NET/SQL7/2000/2005 http://vuyiswamb.007ihost.com http://Ecadre.007ihost.com vuyiswam@tshwane.gov.za

      W Offline
      W Offline
      Walaza
      wrote on last edited by
      #5

      //Try the ff: cmdselect.CommandType = System.Data.CommandType.StoredProcedure; cmdselect.CommandText = "Name_Of_StoredProcedure";

      Mvelo Walaza Developer Telkom SA

      V 1 Reply Last reply
      0
      • M mav northwind

        Hi! The first place to look for parameters should be the documentation - MSDN still is the authority to ask. Try explaining what your cmdselect.CommandType... line does (not what you want it to do, but what the meaning of the statements you've written is!). You'll see that the two assignments you're performing are nonsense. StoredProcedure is an enum value and you have to tell which enum it's a part of. Btw., you don't get an Exception but a syntax error during compilation - that's a huge difference!

        Regards, mav -- Black holes are the places where God divided by 0...

        V Offline
        V Offline
        Vimalsoft Pty Ltd
        wrote on last edited by
        #6

        Thanks man i saw the Problem Thanks

        Vuyiswa Maseko, Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding VB.NET/SQL7/2000/2005 http://vuyiswamb.007ihost.com http://Ecadre.007ihost.com vuyiswam@tshwane.gov.za

        1 Reply Last reply
        0
        • W Walaza

          //Try the ff: cmdselect.CommandType = System.Data.CommandType.StoredProcedure; cmdselect.CommandText = "Name_Of_StoredProcedure";

          Mvelo Walaza Developer Telkom SA

          V Offline
          V Offline
          Vimalsoft Pty Ltd
          wrote on last edited by
          #7

          Thanks man it Worked Thanks

          Vuyiswa Maseko, Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding VB.NET/SQL7/2000/2005 http://vuyiswamb.007ihost.com http://Ecadre.007ihost.com vuyiswam@tshwane.gov.za

          W 1 Reply Last reply
          0
          • V Vimalsoft Pty Ltd

            Thanks man it Worked Thanks

            Vuyiswa Maseko, Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding VB.NET/SQL7/2000/2005 http://vuyiswamb.007ihost.com http://Ecadre.007ihost.com vuyiswam@tshwane.gov.za

            W Offline
            W Offline
            Walaza
            wrote on last edited by
            #8

            Glad to know ;)

            Mvelo Walaza Developer Telkom SA

            V 1 Reply Last reply
            0
            • V Vimalsoft Pty Ltd

              Good Afternoon All An new in C#, i have been doing Ado.net in vb.net. i want to use a Stored Procedure to do my database work, and i want to tell my command object that we are going to use a StoredProcedure. if i try this cmdselect.CommandType = CommandType = StoredProcedure; I get an Exception that says

              The Name StoredProcedure does not Exists in the current context

              i have googled and my line looked ok, but i dont know what is wrong with this line Thanks

              Vuyiswa Maseko, Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding VB.NET/SQL7/2000/2005 http://vuyiswamb.007ihost.com http://Ecadre.007ihost.com vuyiswam@tshwane.gov.za

              B Offline
              B Offline
              baala m
              wrote on last edited by
              #9

              :) this is my suggestion check it out. the line should be cmd.CommandType = CommandType.StoredProcedure;

              V 1 Reply Last reply
              0
              • V Vimalsoft Pty Ltd

                hi Thanks for your Reply like this cmdselect.CommandText = "get_me"; cmdselect.CommandType = CommandType = StoredProcedure; "get_me" is the name of the Procedure. and this is how i wrote my code, what is Wrong ? Thanks

                Vuyiswa Maseko, Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding VB.NET/SQL7/2000/2005 http://vuyiswamb.007ihost.com http://Ecadre.007ihost.com vuyiswam@tshwane.gov.za

                C Offline
                C Offline
                Colin Angus Mackay
                wrote on last edited by
                #10

                Vuyiswa wrote:

                and this is how i wrote my code, what is Wrong ?

                Since this code would generate a compiler error, surely the error message would be able to pinpoint where the error is. Try: cmdselect.CommandType = CommandType.StoredProcedure; Note the dot instead of the second equals sign.

                Upcoming FREE developer events: * Developer Day Scotland Recent blog posts: * Mixins in C#3.0 My website | Blog

                1 Reply Last reply
                0
                • O Obaid ur Rehman

                  When the CommandType property is set to StoredProcedure, the CommandText property should be set to the name of the stored procedure. http://msdn2.microsoft.com/en-us/library/x8ybe6s2(VS.80).aspx[^]

                  V Offline
                  V Offline
                  Vimalsoft Pty Ltd
                  wrote on last edited by
                  #11

                  Thanks it worked

                  Vuyiswa Maseko, Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding VB.NET/SQL7/2000/2005 http://vuyiswamb.007ihost.com http://Ecadre.007ihost.com vuyiswam@tshwane.gov.za

                  1 Reply Last reply
                  0
                  • W Walaza

                    Glad to know ;)

                    Mvelo Walaza Developer Telkom SA

                    V Offline
                    V Offline
                    Vimalsoft Pty Ltd
                    wrote on last edited by
                    #12

                    Thanks Bro

                    Vuyiswa Maseko, Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding VB.NET/SQL7/2000/2005 http://vuyiswamb.007ihost.com http://Ecadre.007ihost.com vuyiswam@tshwane.gov.za

                    1 Reply Last reply
                    0
                    • B baala m

                      :) this is my suggestion check it out. the line should be cmd.CommandType = CommandType.StoredProcedure;

                      V Offline
                      V Offline
                      Vimalsoft Pty Ltd
                      wrote on last edited by
                      #13

                      Thanks i get your point

                      Vuyiswa Maseko, Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding VB.NET/SQL7/2000/2005 http://vuyiswamb.007ihost.com http://Ecadre.007ihost.com vuyiswam@tshwane.gov.za

                      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