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

2 votes110 views1 answer
Change array size in unity
C#
0 vote130 views1 answer
Asp net c# browser cursor wait
C#
1 vote104 views2 answers
C# long to int
C#
2 votes182 views1 answer
How to change the title of the console in c#
C#
10 votes139 views1 answer
Unity check if key pressed
C#Unity
0 vote124 views1 answer
Could not load file or assembly 'Ubiety.Dns.Core, Version=2.2.1.0
C#
0 vote118 views3 answers
Jsonconvert serializeobject and jsonconvert deserialize to list
C#
1 vote132 views1 answer
Double tryparse dot comma
C#
0 vote123 views1 answer
Can't select ui in scene view unity
C#
1 vote159 views1 answer
Remove last comma from string c#
C#