/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 vote395 views1 answer
Unity subtract float every second
C#Unity
1 vote347 views1 answer
How to make a specific scene load only on game start in unity
C#
1 vote334 views1 answer
Unity set parent to root
C#
0 vote353 views2 answers
By value by reference c#
C#
3 votes397 views2 answers
Aspx textarea
C#
3 votes385 views2 answers
How to delete folder with files on c#
C#
0 vote312 views1 answer
C# order a sorted list by key
C#
0 vote332 views1 answer
Serenity.is required field
C#
0 vote358 views1 answer
Get sprite name from gameobject
C#
5 votes391 views1 answer
Unity create scriptableobject asset
C#Unity