/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 vote230 views1 answer
Best way to compare byte array c#
C#
19 votes229 views2 answers
Unity change text
C#Unity
0 vote213 views1 answer
Calculator using single readline c#
C#
0 vote254 views1 answer
C# Loop Example
C#
0 vote260 views1 answer
Keep sprites at fixed transform according to screen resolution unity
C#Unity
32 votes229 views4 answers
Raycasthit unity
C#Unity
0 vote216 views1 answer
C# condition and
C#
0 vote226 views1 answer
C# web scraping get images from specific url
C#
0 vote315 views1 answer
The server requested authentication method unknown to the client
C#
5 votes233 views2 answers
C# how to run external program
C#