/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 vote187 views1 answer
VSIX Project Context Menu
C#
3 votes189 views1 answer
Initialise icollection c#
C#
0 vote245 views1 answer
Nuget package TSETMC guide
C#
10 votes194 views2 answers
C# check if string is empty
C#
0 vote189 views1 answer
Unity camera movement script
C#
1 vote187 views1 answer
C# unity detect any keyboard input but not mouse input
C#
0 vote198 views1 answer
C# picturebox cursor hand
C#
20 votes288 views4 answers
How to change scenes in unity
C#Unity
0 vote272 views1 answer
How to assign rds CAL for users
C#
3 votes195 views1 answer
C# counting lines
C#