/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 vote225 views1 answer
My context class is in different project and i want migration in different project in asp.net mvc
C#
0 vote233 views1 answer
Find ip domain linux
C#
0 vote244 views1 answer
Binaural generator
C#
8 votes240 views3 answers
List of list of string to list of string c#
C#
0 vote222 views1 answer
Unity c# hooke's law suspension
C#
0 vote238 views1 answer
Exception handling c# stack overflow
C#
1 vote255 views1 answer
Vscode not showing errors c#
C#
0 vote245 views1 answer
C# sprintf equivalent
C#
0 vote221 views1 answer
How to get mouse position c#
C#
1 vote189 views1 answer
Create iis pool programmatically c#
C#