Call Simple Store Procedure : Store Procedure « Database ADO.net « C# / C Sharp

1. C# / C Sharp
2. Database ADO.net
3. Store Procedure

Call Simple Store Procedure

using System;
using System.Data.SqlClient;
using System.Data.OleDb;
using System.Data;

class Class1 {
   static void Main(string[] args) {
    SqlConnection cnnUserMan;
    SqlCommand cmmUser;
    object objNumUsers;

    // Instantiate and open the connection
    cnnUserMan = new SqlConnection("server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI");
    cnnUserMan.Open();

    // Instantiate and initialize command
    cmmUser = new SqlCommand("SimpleStoredProcedure", cnnUserMan);
    cmmUser.CommandType = CommandType.StoredProcedure;

    objNumUsers = cmmUser.ExecuteScalar();
    Console.WriteLine(objNumUsers.ToString());
   }
}

           
       

Related examples in the same category

1.	Add parameters to SqlCommand to call stored procedure
2.	Call the SQL Server AddProduct() stored procedure with SqlCommand
3.	Illustrates simple stored procedures with unnamed parameters in the query
4.	Populate a DataSet object using a store procedure
5.	Call the SQL Server AddProduct() store procedure
6.	Get Return from SQL Server store procedure
7.	illustrates how to call a SQL Server stored procedure
8.	Call a store procedure