/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 vote262 views1 answer
Get the current directory in unity
C#
0 vote162 views1 answer
Bitwise Left Shift C#
C#
0 vote169 views2 answers
ToLocalIsoString() vs toIsoString()
C#
2 votes171 views1 answer
Windows form rounded corners
C#
95 votes240 views6 answers
C# string reverse
C#
1 vote165 views2 answers
C# bitwise operation
C#
0 vote235 views1 answer
Unity set particle properties through script
C#Unity
0 vote233 views1 answer
How to make dobuble jump unity 2d
C#Unity
1 vote274 views1 answer
Get all devices in game unity
C#Unity
0 vote177 views1 answer
C# foreach char in string
C#