/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 vote149 views2 answers
Get hwid c#
C#
0 vote140 views1 answer
C# remove exit icon
C#
0 vote151 views1 answer
Como ordenar dados na gridview c#
C#
1 vote152 views1 answer
Unity normalize float
C#
15 votes244 views5 answers
Call function from another script unity
C#Unity
0 vote150 views1 answer
.net core Enable-Migrations' is not recognized as the name of a cmdlet
C#
11 votes151 views1 answer
Hello world program in c#
C#
0 vote178 views1 answer
Unity animation length
C#Unity
0 vote147 views1 answer
C# check if file hast content
C#
0 vote136 views1 answer
Unity 3d animator live link
C#