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 vote341 views1 answer
The type or namespace name 'Notifications' does not exist in the namespace 'Unity' (are you missing an assembly reference?)
C#
0 vote336 views2 answers
Vb.net center form in screen
C#
0 vote347 views1 answer
C# string right extension
C#
0 vote332 views1 answer
Data annotations in asp.net core
C#
0 vote333 views1 answer
Timespan to integer c#
C#
10 votes373 views3 answers
Unity C# instantiate prefab
C#Unity
1 vote330 views2 answers
Get connection string from web.config in c#
C#
2 votes305 views1 answer
Unity deactivate all colliders of a gameobject
C#
0 vote302 views1 answer
C# console out restore
C#
7 votes336 views2 answers
Unity add component
C#