/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

2 votes234 views2 answers
Unity don't destroy on load
C#Unity
3 votes218 views2 answers
Unity pause scene
C#
2 votes229 views1 answer
C# 2-dimensional array sort
C#
31 votes234 views4 answers
C# string to datetime
C#
0 vote222 views1 answer
Freeze rotation in code c#
C#
0 vote204 views1 answer
C# print all properties of an object including children objects
C#
0 vote201 views1 answer
C# reflection
C#
1 vote226 views1 answer
Godot c# export variables
C#
35 votes207 views3 answers
C# remove item from list
C#
0 vote239 views1 answer
Unity FPS camera z axis rotating problem
C#