/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 vote181 views1 answer
Run async method parallel c#
C#
13 votes265 views3 answers
C# join array
C#
2 votes190 views3 answers
C# quit
C#
0 vote186 views1 answer
How to convert iformfile to byte array c#
C#
2 votes183 views2 answers
Unity get all components in gameobject
C#
1 vote189 views1 answer
Set request timeout c#
C#
0 vote196 views1 answer
Non null array length
C#
0 vote187 views2 answers
Unity list get item at index
C#
0 vote213 views1 answer
C# pi
C#
3 votes184 views1 answer
Bit in sql server c#
C#