/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 vote219 views1 answer
Look rotation only on y axis in unity
C#Unity
0 vote162 views1 answer
Best free Modern Design frameworks C#
C#
0 vote158 views1 answer
C# datagridview filter textbox
C#
0 vote200 views1 answer
Get Enum Name
C#
0 vote213 views1 answer
Unity exenerate
C#Unity
1 vote163 views1 answer
How to stop a coroutine unity c#
C#
1 vote182 views1 answer
C# not
C#
7 votes149 views2 answers
How to convert int to float in c#
C#
1 vote150 views1 answer
Convert int to binary in c#
C#
0 vote157 views1 answer
Hash password with salt c#
C#