SqlConnection conn=new SqlConnection(“connectionString”); 
SqlDataAdapter da = new SqlDataAdapter(); 
da.SelectCommand = new SqlCommand(); 
da.SelectCommand.Connection = conn; 
da.SelectCommand.CommandText = "NameOfProcedure"; 
da.SelectCommand.CommandType = CommandType.StoredProcedure; 


//csharp/6011