/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 vote93 views1 answer
Decimal in .asp.net core
C#
0 vote99 views1 answer
.net ssh, wait command execute
C#
1 vote87 views1 answer
C# among us
C#
1 vote105 views2 answers
Tostring tmpro unity
C#
0 vote100 views1 answer
C# read xml tag value
C#
0 vote95 views1 answer
Connection string .net core
C#
0 vote100 views1 answer
Blazor image button
C#
1 vote96 views1 answer
Convert char[] to string
C#
0 vote95 views1 answer
How to populate a collection c#
C#
0 vote91 views1 answer
Unity android keycodes
C#