Breaking News: Grepper is joining You.com. Read the official announcement!

pass datatable to stored procedure c# dapper

Repulsive Reindeer answered on November 19, 2020 Popularity 7/10 Helpfulness 6/10

answer pass datatable to stored procedure c# dapper

pass datatable to stored procedure c# dapper

Comments(1)

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();
    }
}

Popularity 7/10 Helpfulness 6/10 Language csharp

Source: dapper-tutorial.net

Tags: c# dapper procedure

Link to this answer
Share Copy Link