sqldataadapter. update
-
Hi, I would like to know how i can perform update or delete by using Update method of sql data adapter. I have done the insert operation using update method. The code follows...
public Boolean SetStorageArea(int UID, DataTable dtStorageArea) { string strSql; strSql = "SELECT [Active],[WarehouseID],[StorageAreaID],[StorageAreaShortName],[StorageAreaName], " + " [Alias],[Notes],[CreatedBy],[CreatedOn],[LastModifiedBy],[LastModifiedOn] FROM [StorageArea]"; try { DataSet dsStorageArea = new DataSet(); dsStorageArea.Tables.Add(dtStorageArea); SqlDataAdapter sda = new SqlDataAdapter(strSql, sqlcon); SqlCommandBuilder sqb = new SqlCommandBuilder(sda); sda.Update(dsStorageArea, "StorageArea"); return true; } catch (Exception Ex) { throw new Exception("SetStorageArea: Could not get the records of all Storage Areas.\nOriginal message: " + Ex.Message); } }. awaiting for your valuable suggestions.. Thanks in advance Sebastian -
Hi, I would like to know how i can perform update or delete by using Update method of sql data adapter. I have done the insert operation using update method. The code follows...
public Boolean SetStorageArea(int UID, DataTable dtStorageArea) { string strSql; strSql = "SELECT [Active],[WarehouseID],[StorageAreaID],[StorageAreaShortName],[StorageAreaName], " + " [Alias],[Notes],[CreatedBy],[CreatedOn],[LastModifiedBy],[LastModifiedOn] FROM [StorageArea]"; try { DataSet dsStorageArea = new DataSet(); dsStorageArea.Tables.Add(dtStorageArea); SqlDataAdapter sda = new SqlDataAdapter(strSql, sqlcon); SqlCommandBuilder sqb = new SqlCommandBuilder(sda); sda.Update(dsStorageArea, "StorageArea"); return true; } catch (Exception Ex) { throw new Exception("SetStorageArea: Could not get the records of all Storage Areas.\nOriginal message: " + Ex.Message); } }. awaiting for your valuable suggestions.. Thanks in advance SebastianHi Sebastian , I never used command builder ..i use sqlcommand object..check if it works for u ... SqlCommand updatecmd = new SqlCommand(strSql, sqlcon); SqlCommand deletecmd = new SqlCommand(strSql1, sqlcon); SqlCommand insertcmd = new SqlCommand(strSql2, sqlcon); SqlDataAdapter sda = new SqlDataAdapter(); sda.UpdateCommand = updatecmd; //here cmd generater for update sda.DeleteCommand = deletecmd; //here cmd generater for delete sda.InsertCommand = insertcmd ; //here cmd generater for insert sda.Update(dsStorageArea, "StorageArea");
pallavi
-
Hi Sebastian , I never used command builder ..i use sqlcommand object..check if it works for u ... SqlCommand updatecmd = new SqlCommand(strSql, sqlcon); SqlCommand deletecmd = new SqlCommand(strSql1, sqlcon); SqlCommand insertcmd = new SqlCommand(strSql2, sqlcon); SqlDataAdapter sda = new SqlDataAdapter(); sda.UpdateCommand = updatecmd; //here cmd generater for update sda.DeleteCommand = deletecmd; //here cmd generater for delete sda.InsertCommand = insertcmd ; //here cmd generater for insert sda.Update(dsStorageArea, "StorageArea");
pallavi
Hi Pallavi, Thank you very much. This method will work, the only thing is i have to avoid command builder... Thanks once again Sebastian