/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 vote140 views1 answer
Canty obituary schenectady ny
C#
-2 votes151 views2 answers
Save image in C#
C#
32 votes127 views4 answers
How to get keyboard input in unity
C#
0 vote135 views1 answer
Mvc dotnet core how does the view pass parameters to controler
C#
0 vote133 views1 answer
C# how to ignore case
C#
0 vote124 views1 answer
How to do Employing defensive code in the UI to ensure that the current frame is the most top level window in c#
C#
3 votes163 views2 answers
Unity mouse click m
C#Unity
1 vote135 views3 answers
C# object is in object list
C#
0 vote170 views1 answer
How to get day name from datetimepicker in c#
C#
24 votes150 views5 answers
Stream to byte array c#
C#