/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 vote200 views3 answers
C# encrypt folder SHA512
C#
1 vote220 views1 answer
Get dropdown selected value unity
C#
0 vote205 views1 answer
How to verify the scene unity
C#
0 vote215 views1 answer
C# Get type with namespace
C#
1 vote203 views1 answer
Remove session in dotnet core
C#
0 vote209 views1 answer
C# read huge file
C#
10 votes210 views3 answers
How to make a quit button in unity
C#
2 votes234 views1 answer
Hide console window c#
C#
1 vote258 views1 answer
C# how to output in between 0 - 100 in an int array
C#
0 vote201 views1 answer
How to select time and date in datetimepicker in c#
C#