/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

0 vote316 views1 answer
Revision1
C#
0 vote310 views1 answer
Number to string ef example c#
C#
0 vote297 views1 answer
Include multiple siblings at the Level
C#
21 votes374 views3 answers
How to detect collision in unity
C#Unity
0 vote314 views1 answer
Multiply structs c#
C#
0 vote321 views1 answer
RestRequest AdvancedResponseWriter site:stackoverflow.com
C#
0 vote334 views1 answer
Listview inter thread operation not valid
C#
21 votes329 views2 answers
Press key run code unity c#
C#Unity
2 votes296 views1 answer
C# print out whole object
C#
9 votes327 views3 answers
C# round number
C#