/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 vote319 views1 answer
Unity NetworkBehaviour the type or namespace could not be found
C#
1 vote321 views3 answers
Visual studio reinstall all nuget packages
C#
0 vote317 views1 answer
Card caption
C#
0 vote335 views1 answer
How to make play button in unity
C#Unity
5 votes339 views2 answers
C# datetime iso 8601 format
C#
0 vote288 views1 answer
SQLite insert data in C# (Source:NAYCode.com)
C#
0 vote309 views1 answer
Winforms open multiple forms show one icon in taskabr
C#
0 vote311 views2 answers
Install active directory windows server 2019 powershell
C#
0 vote313 views1 answer
Create dropdown in datatable c# dynamically
C#
0 vote271 views1 answer
Guicontrol text ahk
C#