/C#/Pass datatable to stored procedure c# dapper

Pass datatable to stored procedure c# dapper

using (SqlConnection con1 = new SqlConnection(connectionstring))
 {
  using (SqlCommand cmd1 = new SqlCommand("your_procedure_name"))
    {
        cmd1.CommandType = CommandType.StoredProcedure;
        cmd1.Connection = con1;                                               

    SqlParameter Param = cmd1.Parameters.AddWithValue("@parameter_name", dt);
    Param.SqlDbType = SqlDbType.Structured;
        con1.Open();
        cmd1.ExecuteNonQuery();
        con1.Close();
    }
}

Source: dapper-tutorial.net

Similar codes

4 votes304 views3 answers
Get text component unity
C#
0 vote324 views1 answer
Call Textboxfor in cs
C#
2 votes326 views1 answer
Unity can't select move tool
C#Unity
-1 vote324 views1 answer
Randon C#
C#
1 vote350 views4 answers
Check if a string is a palindrome
C#
0 vote362 views1 answer
HttpClient .net Core add Certificate
C#
-1 vote318 views1 answer
C# async in wpf
C#
1 vote311 views2 answers
C# convert bitmap to image
C#
0 vote308 views1 answer
Unity subtract float every second
C#
0 vote313 views1 answer
C# Arithmetic operators
C#