/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 vote118 views1 answer
C# two different random numbers
C#
2 votes107 views1 answer
C# actions
C#
2 votes108 views2 answers
Unity animator check if animation is playing
C#
0 vote106 views1 answer
Sqlsinifi.baglanti.open()
C#
1 vote153 views1 answer
Oculus Unity add haptics
C#Unity
1 vote134 views2 answers
Unity create random string
C#Unity
0 vote128 views1 answer
C# asp.net only displays name of property
C#
0 vote142 views1 answer
"??" in C#
C#
2 votes122 views1 answer
Delete null elements array c#
C#
0 vote114 views1 answer
Top down movement unity
C#