/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

18 votes92 views1 answer
How to remove a component from an object in unity
C#
1 vote250 views1 answer
C# making a folder wpf
C#
1 vote96 views1 answer
How to get the color of other label when clicking c#
C#
0 vote112 views1 answer
The anti-forgery cookie token and form field token do not match.
C#
0 vote102 views1 answer
How to disable vsync in monogame
C#
0 vote105 views1 answer
How to change the volume of all sound effects in monogame
C#
0 vote103 views1 answer
C# clear console read chache
C#
0 vote102 views1 answer
Displayname c#
C#
21 votes85 views6 answers
Button group bootstrap
C#
0 vote130 views1 answer
For what is percent sign in unity c#
C#Unity