Mega Code Archive

 

Categories / C# Tutorial / ADO Net

 

Call stored procedure with SqlCommand

using System; using System.Data;             using System.Data.SqlClient;     class Program   {     static void Main(string[] args)     {       SqlConnection thisConnection = new SqlConnection(                 @"Data Source=.\SQLEXPRESS;" +                 @"AttachDbFilename='NORTHWND.MDF';" +                 @"Integrated Security=True;Connect Timeout=30;User Instance=true");              thisConnection.Open();       SqlCommand thisCommand = thisConnection.CreateCommand();       thisCommand.CommandType = CommandType.StoredProcedure;       thisCommand.CommandText ="TenRecoreds";       SqlDataReader thisReader = thisCommand.ExecuteReader();       while (thisReader.Read())       {         Console.WriteLine(thisReader["UnitPrice"]);       }       thisReader.Close();       thisConnection.Close();     }   }