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 votes249 views1 answer
C# get object property value by name
C#
28 votes307 views3 answers
Check if gameobject is active
C#
0 vote277 views2 answers
C sharp type in word and calculate how much a letter is inside that word
C#
0 vote264 views1 answer
Asp net mvc convert ienumerable to selectlistitem
C#
1 vote262 views3 answers
How to get value of specific row of datatable c#
C#
0 vote227 views1 answer
Unity Type of conditional expression cannot be determined because there is no implicit conversion between 'Color' and '<null>'
C#
122 votes420 views6 answers
C# generate random number
C#
-1 vote260 views1 answer
Dotnet
C#
2 votes258 views2 answers
C sharp or operator in if statement
C#
0 vote281 views1 answer
How to convert c# string to pdf
C#