/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 vote164 views1 answer
.net core executenonqueryasync transaction
C#
0 vote166 views1 answer
Go Statement in CSharp
C#
1 vote169 views1 answer
In Asp.Net Core core how to I get the web site's IP address?
C#
1 vote163 views2 answers
C# set cursor pos
C#
0 vote166 views1 answer
Unity change fixed timestep in code
C#
0 vote170 views1 answer
Alpahbet incremnet in c#
C#
0 vote156 views1 answer
Unity gun clipping through walls
C#
-2 votes166 views2 answers
C# .net core memory cache
C#
10 votes156 views1 answer
Get value after decimal point
C#
0 vote165 views1 answer
C# split on multiple characters
C#