Update bulk of data in table from single query.

See more:

SQL-Server-2005

ASP.NET

, +

Hello Guys !

My Scenario Is

i am uploading ExcelSheet Which Contain id and Name in that excel sheet.

then that contain convert into table on server side using reading excelsheet.

now i want to update a status column against each and every row present in that table to sql server.


now i am using following code :

foreach (DataRow row in dt.Rows)
                 {
                     Database database = DatabaseFactory.CreateDatabase(DALConstants.ConstantsBase.MIS);
                     string sqlcommand = "[PRDMIS_ExcelDeletion]";
                     DbCommand databasecommand =
                     database.AddInParameter(databasecommand, "ClientCode", DbType.String, row["id "].ToString());
                     database.AddInParameter(databasecommand, "Name", DbType.String, row["Name"].ToString());

                     int i = database.ExecuteNonQuery(databasecommand);
                 }

but it will hit server every time.
that i dont want it?


therefore

Is there any solution for that.

thanks
@ChetanV@