/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

1 vote130 views1 answer
Unity how to end a game with esc
C#
0 vote124 views1 answer
Check property type of collection c#
C#
0 vote122 views1 answer
Conveyor function in f#
C#
1 vote141 views1 answer
Unity c# struct
C#
3 votes150 views2 answers
Unity create empty gameobject in code
C#Unity
2 votes123 views1 answer
Unity click on 2d object
C#
10 votes119 views4 answers
Unity array c#
C#
1 vote187 views1 answer
C# unity change key input in inspector
C#Unity
0 vote130 views1 answer
Valid URL check in c#
C#
0 vote170 views1 answer
Unity gameobject visible to specific camera
C#Unity