How can you call Stored Procedure in ADO.NET?

You will be using SqlCommand object to call and execute stored procedures. If your stored procedure requires any parameters to be passed, then that is done using parameters object.

Create Procedure sProcStudent @RollNo nvarchar(50) As
Select RollNo from Students where RollNo like @RollNo + ‘%’

In this stored procedure, you display set of students whose RollNo match the pattern specified in the parameter @RollNo. For example, if you pass the parameter as ‘XII1’ then all students having their roll no starting with this pattern will be displayed. Now how do you call this stored procedure and pass appropriate parameter using ADO.NET in your .NET application? That is demonstrated using the following sample snippet of code:

sampleCommand = New SqlCommand(“sProcStudent”)
sampleCommand.Parameters.Add(“@RollNo”, Data.SqlDbType.NVarChar, 50)
sampleCommand.Parameters.Item(“@RollNo”).Value = txtStudRollNo.Text.Trim()

In the above code instead of specifying a query in the sampleCommand, you specify the stored procedure name. You specify the parameter name and type using sampleCommand.Parameters.Add method. You then pass data to the parameter using sampleCommand.Parameters.Item method. The data is received from the User using txtStudRollNo textbox. Hence the textbox’s text value is assigned to the parameter.

| How do you prevent a class from overriding in .NET? | How are classes related to objects in .NET Application | How are Delegates different from Events in .NET? | How are system exceptions different from application exceptions in .NET? | How are Value Types different from Reference Types in .NET? | How can a finalize method be suppressed in .NET? | How can you call Stored Procedure in ADO.NET? | How can you force Dispose method to be called automatically in .NET? | How do you call a Base Class Constructor from Derived Class Constructor in .NET? | How do you connect your VB.NET application to SQL Server? | How do you implement Cloning in .NET? | How do you implement Façade Design Pattern in .NET? | How do you implement MVC Pattern in ASP.NET? | How do you install .NET Assembly in GAC? | How is shadowing different from overriding in .NET? | How to prevent a particular .NET DLL from being decompiled? | Illustrate Delay Signing Process of an Assembly in .NET? | What are Reference Types in .NET? | What are the advantages of C#? | What are the advantages of VB.NET? | What are the differences between Namespace and Assembly in .NET? | What are the similar features between class and structure in .NET? | What are Value Types in .NET? | What do you mean by mixed mode authentication in .NET? | What do you mean by Satellite Assembly in .NET? | What do you mean by shadowing in .NET? | What is CTS in .NET? | What is ILDASM in .NET? | What is Managed Code in .NET? | What is Manifest in .NET? | What is MSIL in .NET Framework? | What is the importance of finalize method in .NET? | What is the need for Visitor Pattern in C#? | What is the purpose of bindingRedirect tag in web.config file of .NET? | What is the purpose of CodeDom in .NET? | What is the purpose of dispose method in .NET? | What is the purpose of Ngen.exe in .NET? | What is the purpose of Strong Name in COM Components of .NET? | What is the purpose of virtual keyword in .NET? | What Object Oriented Principles can be incorporated in .NET Application? |