/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 vote316 views1 answer
.net objects
C#
1 vote346 views3 answers
Get key value from object c#
C#
2 votes397 views1 answer
Unity spawn object at position
C#Unity
0 vote349 views1 answer
Mvc remote validation additional table
C#
0 vote322 views1 answer
How to save pdf file in web api asp.net core
C#
0 vote333 views1 answer
Unity Rigidbody how to set zero momentum
C#
0 vote365 views1 answer
'Using a Hub instance not created by the HubPipeline is unsupported.'
C#
0 vote389 views1 answer
Audio source pause unity
C#
6 votes349 views1 answer
C# save bytes array to file
C#
19 votes394 views2 answers
Unity RemoveComponent
C#Unity