/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 vote115 views1 answer
Generate a dropdown list from array data using razor .net mvc
C#
0 vote119 views1 answer
C# array lenght
C#
0 vote133 views1 answer
How to convert int to char in c#
C#
0 vote122 views2 answers
C# check file similarities
C#
0 vote126 views1 answer
Use different database with entitymanagerfactory
C#
1 vote183 views1 answer
Unity custom editor save changes
C#Unity
0 vote172 views1 answer
Unity get camera
C#Unity
10 votes167 views4 answers
Unity array c#
C#Unity
11 votes100 views1 answer
Mouse 2d unity
C#
0 vote129 views1 answer
C# create list with range
C#