/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 vote185 views1 answer
How to change samesite=lax to samesite=none in asp.net
C#
2 votes189 views1 answer
Usermanager change password without current password
C#
1 vote235 views1 answer
C# countdown timer menutes
C#
0 vote192 views1 answer
C# random.Next error
C#
0 vote184 views1 answer
C# Convert range
C#
0 vote191 views1 answer
Vb.net read registry key as string
C#
0 vote221 views2 answers
Int array to frequency dictionary c#
C#
0 vote216 views1 answer
How to clear datagridview c#
C#
0 vote190 views1 answer
How to destroy bridges animal crossing
C#
0 vote221 views1 answer
Unity draw waypoins path
C#