/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

2 votes135 views1 answer
Add all elements in a list c#
C#
0 vote122 views1 answer
C# console save file
C#
0 vote158 views1 answer
Razor preview
C#
13 votes133 views1 answer
Check for collision unity c#
C#
0 vote140 views1 answer
How to set border for groupbox in c#
C#
0 vote142 views1 answer
C# string replace comma with newline
C#
30 votes151 views4 answers
Convert string to date in c#
C#
1 vote147 views1 answer
Copy text from a text box c#
C#
0 vote136 views1 answer
Unity color mix
C#
4 votes181 views3 answers
Regular expression for email in c#
C#