/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 vote283 views1 answer
Reference a class by string unity
C#
0 vote260 views1 answer
Json string to JObject object c# camelCasing key .net
C#
0 vote297 views1 answer
Check if object has parent unity
C#
6 votes272 views1 answer
C# Cast double to float
C#
0 vote271 views3 answers
C# format string with 2 decimals
C#
3 votes296 views1 answer
How to make a pause feautre in unity
C#
0 vote274 views1 answer
How to draw gizmos unity
C#
4 votes300 views1 answer
How to write coroutine in unity
C#
0 vote290 views1 answer
C# function as input
C#
4 votes276 views2 answers
C# datetimepicker set weeks after today
C#