/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 vote167 views3 answers
How to fill model enum with bradio button asp razor
C#
1 vote251 views1 answer
Unity click on 2d object
C#Unity
0 vote174 views1 answer
Csharp declare constan
C#
1 vote175 views1 answer
C# what is a question mark after a data type
C#
11 votes191 views4 answers
C# remove all whitespaces from string
C#
7 votes226 views2 answers
How to reference text mesh pro unity
C#
-1 vote176 views1 answer
How to check if a string contains a capital letter c#
C#
0 vote182 views1 answer
Redirect to another controller page in asp.net core
C#
8 votes254 views2 answers
How to get parent gameobject in unity
C#Unity
1 vote182 views1 answer
Get 2d rotation from 2 position math
C#