/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

5 votes106 views2 answers
How to get element dictionary key in c# by index
C#
0 vote107 views1 answer
C# datatable column alias
C#
1 vote110 views1 answer
C# palidrone
C#
0 vote109 views1 answer
C# max sequence contains no elements
C#
1 vote107 views1 answer
Pass Method as Parameter using C#
C#
0 vote137 views1 answer
Unity c# public all codes
C#Unity
0 vote112 views1 answer
Byte array to bitmap C
C#
0 vote148 views1 answer
How to make a destroy reference in unity
C#Unity
1 vote105 views2 answers
Unity for loop array
C#
-1 vote108 views2 answers
Remove specific character from string c#
C#