/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

2 votes123 views2 answers
How to convert a 2d coordinate to an index
C#
0 vote127 views1 answer
KeyValuePair is default
C#
10 votes122 views2 answers
How to solve error CS0619: 'GUIText' is obsolete: 'GUIText has been removed. Use UI.Text instead.'
C#
0 vote116 views1 answer
Coda2
C#
-1 vote117 views1 answer
What does -> in f#?
C#
0 vote115 views1 answer
C# decimal with two places store as string with two places
C#
0 vote122 views1 answer
Formatting binary numbers in c#
C#
1 vote132 views1 answer
How to open new form on button click in c# xamarin
C#
0 vote156 views1 answer
Unity android plugin callback
C#Unity
4 votes114 views1 answer
Unity round float to nearest 10
C#