Call stored proc c#

using (SqlConnection conn = new SqlConnection("Server=(local);DataBase=Northwind;Integrated Security=SSPI")) {
    conn.Open();

    // 1.  create a command object identifying the stored procedure
    SqlCommand cmd  = new SqlCommand("CustOrderHist", conn);

    // 2. set the command object so it knows to execute a stored procedure
    cmd.CommandType = CommandType.StoredProcedure;

    // 3. add parameter to command, which will be passed to the stored procedure
    cmd.Parameters.Add(new SqlParameter("@CustomerID", custId));

    // execute the command
    using (SqlDataReader rdr = cmd.ExecuteReader()) {
        // iterate through results, printing each to console
        while (rdr.Read())
        {
            Console.WriteLine("Product: {0,-35} Total: {1,2}",rdr["ProductName"],rdr["Total"]);
        }
    }
}

Source: stackoverflow.com

Similar codes

45 votes179 views6 answers
Foreach dictionary c#
C#
5 votes185 views3 answers
C# remove first 5 characters from string
C#
19 votes172 views2 answers
Unity RemoveComponent
C#
0 vote189 views1 answer
Customize yup number
C#
29 votes208 views2 answers
C sharp how to read a text file
C#
3 votes171 views2 answers
How to find a gameobject in unity
C#
0 vote169 views1 answer
C# datetime format ymd
C#
0 vote172 views1 answer
Remove multiple element on list from index a to b C#
C#
9 votes161 views3 answers
Round double c#
C#
0 vote189 views1 answer
Unity how to find the largest value out of 2 numbers
C#