/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

1 vote223 views1 answer
How to run c# code in visual studio code terminal
C#
0 vote170 views1 answer
C# regex replace all line breaks
C#
8 votes133 views3 answers
C# increment by 1
C#
0 vote143 views1 answer
Bytes to httppostedfilebase c#
C#
29 votes131 views2 answers
Car
C#
31 votes151 views5 answers
String to json c#
C#
6 votes175 views2 answers
Unity check collider layer
C#Unity
29 votes157 views3 answers
Online embedded c compiler
C#
0 vote178 views1 answer
Create class for database connection in c#
C#
0 vote169 views2 answers
How to add serilog to your asp.net project
C#