/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 vote177 views1 answer
Unity switch to scene and transfer data
C#Unity
1 vote116 views1 answer
Binding command to event wpf
C#
8 votes112 views1 answer
Stopwatch c#
C#
1 vote160 views1 answer
Unity3d quaternion add 90 degrees
C#Unity
0 vote133 views1 answer
C# modify dictionary in loop
C#
0 vote107 views1 answer
Button commandfield commandargument pass textbox
C#
0 vote122 views1 answer
C# fill values of child from parent
C#
1 vote156 views1 answer
Unity find closest point on line
C#Unity
4 votes109 views1 answer
C# that creates an integer array and displays the sum of all its element values.
C#
4 votes116 views1 answer
Get out of foreach statement c#
C#