datatable as sqlparameter

See more:

C#

.NET

SQL-Server

C#4.0

DataTable

, +

hi all!

i just want to know if it's possible to pass a datatable as sqlparameter, becasuse I do not want to use a for-each to insert row by row in my database

best regards!!

improving my question

i had not a particular problem, i just want to know if it's possible to do something like this

DataTable dt = new DataTable();
populateTable();
SqlConnection sqlConn = new SqlConnection(
    ConfigurationManager.ConnectionStrings["conString"].ConnectionString.ToString());
SqlCommand sqlCmd = sqlConn.CreateCommand();
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandText = "myStoredProcedure";
sqlCmd.Parameters.Add("@Table", SqlDbType.Table).Value = dt;
sqlCmd.Connection.Open();
sqlCmd.ExecuteNonQuery();
sqlCmd.Connection.Close();