/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

0 vote369 views1 answer
Ow-to-return-http-500-from-asp-net-core-rc2-web-api
C#
2 votes365 views5 answers
Photon
C#
5 votes328 views7 answers
If statement
C#
0 vote371 views1 answer
C# excel fix first row
C#
0 vote335 views1 answer
Linq query to fetch parent child data from same table in c#
C#
20 votes358 views1 answer
C# initialize dictionary
C#
1 vote401 views1 answer
Unity agent bake not derecting mesh
C#
45 votes354 views5 answers
Messagebox error c#
C#
48 votes366 views6 answers
C# remove last character from string
C#
6 votes341 views1 answer
Convert int to double c#
C#