/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 vote336 views1 answer
Asp.net disabled checkbox style
C#
0 vote348 views1 answer
How to oppen a site using c#
C#
6 votes390 views1 answer
Function on animation exit unity
C#Unity
0 vote360 views1 answer
How to check if file contains image c#
C#
0 vote344 views1 answer
Coroutine after another
C#
-1 vote344 views1 answer
Entity framework id not auto increment
C#
0 vote352 views1 answer
Override GetHashCode
C#
0 vote325 views1 answer
Black lives matter update arsenal
C#
1 vote309 views2 answers
C# random choice
C#
25 votes322 views2 answers
Time delay C# unity
C#