/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

23 votes163 views4 answers
C# random number between 1 and 100
C#
0 vote186 views4 answers
Project programing languages in codecademy
C#
1 vote186 views1 answer
Connection string in asp.net with username and password
C#
2 votes176 views2 answers
How to deactivate objects through scripts in unity
C#
0 vote201 views1 answer
How to learn c# fast to learn unity
C#
1 vote192 views1 answer
Listview disable resize columns
C#
3 votes173 views1 answer
C# array backwards
C#
0 vote189 views1 answer
C# predict rotation by an angular velocity
C#
1 vote179 views2 answers
Bitwise and c#
C#
0 vote180 views1 answer
Data at the root level is invalid. Line 1, position 1.
C#