/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

9 votes211 views2 answers
How to convert float to int c#
C#
0 vote185 views1 answer
Angular Input has no initializer
C#
0 vote190 views1 answer
C# start file
C#
0 vote182 views1 answer
C# switch expression pattern matching
C#
4 votes191 views1 answer
How to change the color of your text in c#
C#
0 vote190 views1 answer
How to make font factory text to bold in c#
C#
0 vote185 views1 answer
Run async method parallel c#
C#
53 votes586 views6 answers
Load scene unity
C#Unity
2 votes198 views1 answer
Unity comparetag
C#
1 vote182 views2 answers
Unity getcomponent transform.position
C#