/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 vote145 views1 answer
Unity callback
C#
17 votes149 views4 answers
C# remove spaces from string
C#
0 vote144 views1 answer
C# array lenght
C#
0 vote149 views1 answer
WebClient c# with custom user agent
C#
1 vote143 views2 answers
Remove items from one list in another c#
C#
1 vote150 views1 answer
How to find the tag of an objecdt in unity
C#
0 vote158 views2 answers
C# webbrowser write html to text file
C#
-3 votes168 views2 answers
Gmail
C#
2 votes179 views1 answer
C# cancellationtoken example
C#
0 vote166 views1 answer
Bsod screen c#
C#