/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

10 votes279 views1 answer
Unity c# get bool from another script
C#
6 votes265 views1 answer
C sharp check if key in dictionary
C#
1 vote254 views1 answer
How to change a string variables value c#
C#
0 vote276 views1 answer
C# next level script
C#
1 vote302 views1 answer
Unity c# how to restart the level
C#Unity
1 vote256 views1 answer
Get appdata file path c#
C#
1 vote290 views1 answer
Unity string format time
C#
1 vote245 views1 answer
How to set a transform equal to something unity
C#
1 vote257 views1 answer
Make an object disappear from a c# script unity
C#
0 vote259 views1 answer
Go to the corresponding brace visual studio C#
C#