/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 vote172 views1 answer
Section in inspector unity
C#Unity
32 votes194 views4 answers
Raycasthit unity
C#Unity
0 vote206 views1 answer
Unity get refresh rate
C#Unity
0 vote133 views1 answer
C# mock ref parameter
C#
0 vote141 views1 answer
C# read last 10 lines of file
C#
1 vote187 views1 answer
2d ray unity
C#Unity
24 votes151 views2 answers
How to destroy an object in unity
C#
0 vote162 views1 answer
C# handle single quote inside string
C#
4 votes161 views1 answer
How to get rigidbody speed in unity
C#Unity
5 votes130 views2 answers
C# check number is odd or even
C#