/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

1 vote263 views1 answer
Public vs internal c#
C#
112 votes345 views7 answers
Object length javascript
C#
1 vote299 views1 answer
How to cast list to observablecollection c#
C#
0 vote293 views1 answer
C# calculate sum of list
C#
1 vote241 views1 answer
C# reflection resize array
C#
0 vote280 views1 answer
C# standard microphone decibels
C#
2 votes254 views1 answer
C# access session in class
C#
0 vote253 views1 answer
C# get custom attribute from property
C#
0 vote245 views1 answer
C# Arithmetic operators
C#
1 vote247 views1 answer
Compare trees
C#