/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 vote172 views1 answer
Check shell command success
C#
0 vote162 views1 answer
Add getenumerator to class c#
C#
4 votes156 views1 answer
Gameobject in unity c#
C#
0 vote178 views1 answer
Flip Vector3 Unity
C#Unity
0 vote183 views1 answer
Wpf richtextbox clear text
C#
21 votes174 views2 answers
Random.range unity
C#
1 vote192 views1 answer
Unity c# how to restart the level
C#Unity
0 vote169 views1 answer
How Many Vowels
C#
3 votes158 views2 answers
Unity mouse click m
C#
3 votes196 views1 answer
Unity Exit application
C#Unity