/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 vote259 views1 answer
C# relative path to project folder
C#
33 votes268 views6 answers
C# object to json string
C#
0 vote270 views4 answers
C# logical operators
C#
-1 vote311 views1 answer
Substring c#
C#
0 vote289 views1 answer
How create two database conction in laravel
C#
1 vote258 views1 answer
How to maximize but show taskbar c#
C#
0 vote294 views1 answer
Log4net.config configuration
C#
0 vote297 views2 answers
Sars
C#
0 vote274 views1 answer
Unpacking c # tuple
C#
0 vote262 views1 answer
C# int.parse input string wasnt in correct format
C#