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

0 vote191 views1 answer
Log4net.dll
C#
1 vote229 views1 answer
UnityEngine.Transform.get_position () (at <a0ef933b1aa54b668801ea864e4204fe>:0) Gamekit3D.MeleeWeapon.BeginAttack (System.Boolean thowingAttack)
C#Unity
2 votes215 views1 answer
Draw sphere gizmo unity
C#Unity
3 votes203 views4 answers
Convert string to array c#
C#
0 vote185 views1 answer
C# resize multidimensional array
C#
128 votes195 views11 answers
String to int c#
C#
1 vote202 views1 answer
C# sort array string by length
C#
0 vote206 views1 answer
Get selected item datagrid wpf
C#
11 votes212 views3 answers
C# loop string array
C#
0 vote195 views1 answer
How to draw gizmos unity
C#