/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

31 votes364 views5 answers
Unity get child gameobject
C#Unity
0 vote276 views1 answer
Scale min max to 0 1
C#
0 vote349 views1 answer
Set text in unity invisible
C#Unity
5 votes246 views1 answer
C# remove last item from list
C#
1 vote334 views1 answer
Unity json save array
C#Unity
0 vote283 views1 answer
Vb.net check if datatable has rows
C#
13 votes296 views4 answers
C# how to sort a list
C#
0 vote291 views1 answer
C# odp.net close session
C#
0 vote293 views1 answer
Type or namespace text could not be found unity
C#
2 votes298 views1 answer
Set a value into two variables in the same time in c#
C#