about Dataset?

Question

Someone can tell me there is a way to update (insertdelete) my Databsae (SQl Server 2000) after I update my Dataset object ? I know that Dataset is disconnected from Database so i just know there is only way to update database by using SQLCommand object ( use SQL query or Stored procedures). Thnx for your answers.

tungqt · Answer

Thanks for ypur help. These codes are useful for me.

luoeagle · Answer

Do you have a MSN? (mine is luoeagle@hotmail.com) I can talk this with u through the MSN. the codes like this (most of the code is generated by Visual studio tools): using System; using System.ComponentModel; using System.Collections; using System.Diagnostics; using DataModel; using System.Data; namespace DataAccess { /// /// DPartPurchase ?????? /// public class DPartPurchase : System.ComponentModel.Component { private System.Data.SqlClient.SqlDataAdapter sqlDataAdapterItems; private System.Data.SqlClient.SqlCommand sqlSelectCommandItems; private System.Data.SqlClient.SqlCommand sqlInsertCommandItems; private System.Data.SqlClient.SqlCommand sqlUpdateCommandItems; private System.Data.SqlClient.SqlCommand sqlDeleteCommandItems; private System.Data.SqlClient.SqlCommand sqlCommandGetById; private System.Data.SqlClient.SqlDataAdapter sqlDataAdapterMain; private System.Data.SqlClient.SqlCommand sqlSelectCommandMain; private System.Data.SqlClient.SqlCommand sqlInsertCommandMain; private System.Data.SqlClient.SqlCommand sqlUpdateCommandMain; private System.Data.SqlClient.SqlCommand sqlDeleteCommandMain; private System.Data.SqlClient.SqlConnection sqlConnection; /// /// ????????? /// private System.ComponentModel.Container components = null; public DPartPurchase(System.ComponentModel.IContainer container) { /// /// Windows.Forms ???????????? /// container.Add(this); InitializeComponent(); this.sqlConnection.ConnectionString = Common.Const.ConnectionString; // // TODO: ? InitializeComponent ????????????? // } public DPartPurchase() { /// /// Windows.Forms ???????????? /// InitializeComponent(); this.sqlConnection.ConnectionString = Common.Const.ConnectionString; // // TODO: ? InitializeComponent ????????????? // } /// /// ???????????? /// protected override void Dispose( bool disposing ) { if( disposing ) { if(components != null) { components.Dispose(); } } base.Dispose( disposing ); } #region ?????????? /// /// ?????????? - ??????????? /// ??????? /// private void InitializeComponent() { this.sqlDataAdapterItems = new System.Data.SqlClient.SqlDataAdapter(); this.sqlDeleteCommandItems = new System.Data.SqlClient.SqlCommand(); this.sqlInsertCommandItems = new System.Data.SqlClient.SqlCommand(); this.sqlSelectCommandItems = new System.Data.SqlClient.SqlCommand(); this.sqlUpdateCommandItems = new System.Data.SqlClient.SqlCommand(); this.sqlCommandGetById = new System.Data.SqlClient.SqlCommand(); this.sqlDataAdapterMain = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommandMain = new System.Data.SqlClient.SqlCommand(); this.sqlInsertCommandMain = new System.Data.SqlClient.SqlCommand(); this.sqlUpdateCommandMain = new System.Data.SqlClient.SqlCommand(); this.sqlDeleteCommandMain = new System.Data.SqlClient.SqlCommand(); this.sqlConnection = new System.Data.SqlClient.SqlConnection(); // // sqlDataAdapterItems // this.sqlDataAdapterItems.DeleteCommand = this.sqlDeleteCommandItems; this.sqlDataAdapterItems.InsertCommand = this.sqlInsertCommandItems; this.sqlDataAdapterItems.SelectCommand = this.sqlSelectCommandItems; this.sqlDataAdapterItems.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping(Table PartPurchaseItems new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping(purItemID purItemID) new System.Data.Common.DataColumnMapping(purID purID) new System.Data.Common.DataColumnMapping(partID partID) new System.Data.Common.DataColumnMapping(purCount purCount) new System.Data.Common.DataColumnMapping(purUnitPrice purUnitPrice) new System.Data.Common.DataColumnMapping(partSN partSN) new System.Data.Common.DataColumnMapping(partName partName) new System.Data.Common.DataColumnMapping(partSpec partSpec) new System.Data.Common.DataColumnMapping(partUnit partUnit) new System.Data.Common.DataColumnMapping(partPosition partPosition) new System.Data.Common.DataColumnMapping(partWarehouse partWarehouse)})}); this.sqlDataAdapterItems.UpdateCommand = this.sqlUpdateCommandItems; // // sqlDeleteCommandItems // this.sqlDeleteCommandItems.CommandText = [mt_Part_DeletePartPurchaseItem]; this.sqlDeleteCommandItems.CommandType = System.Data.CommandType.StoredProcedure; this.sqlDeleteCommandItems.Connection = this.sqlConnection; this.sqlDeleteCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter(@RETURN_VALUE System.Data.SqlDbType.Int 4 System.Data.ParameterDirection.ReturnValue false ((System.Byte)(0)) ((System.Byte)(0))  System.Data.DataRowVersion.Current null)); this.sqlDeleteCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter(@Original_purItemID System.Data.SqlDbType.Int 4 System.Data.ParameterDirection.Input false ((System.Byte)(0)) ((System.Byte)(0)) purItemID System.Data.DataRowVersion.Original null)); this.sqlDeleteCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter(@Original_partID System.Data.SqlDbType.Int 4 System.Data.ParameterDirection.Input false ((System.Byte)(0)) ((System.Byte)(0)) partID System.Data.DataRowVersion.Original null)); this.sqlDeleteCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter(@Original_partName System.Data.SqlDbType.NVarChar 128 System.Data.ParameterDirection.Input false ((System.Byte)(0)) ((System.Byte)(0)) partName System.Data.DataRowVersion.Original null)); this.sqlDeleteCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter(@Original_partPosition System.Data.SqlDbType.NVarChar 50 System.Data.ParameterDirection.Input false ((System.Byte)(0)) ((System.Byte)(0)) partPosition System.Data.DataRowVersion.Original null)); this.sqlDeleteCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter(@Original_partSN System.Data.SqlDbType.NVarChar 128 System.Data.ParameterDirection.Input false ((System.Byte)(0)) ((System.Byte)(0)) partSN System.Data.DataRowVersion.Original null)); this.sqlDeleteCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter(@Original_partSpec System.Data.SqlDbType.NVarChar 128 System.Data.ParameterDirection.Input false ((System.Byte)(0)) ((System.Byte)(0)) partSpec System.Data.DataRowVersion.Original null)); this.sqlDeleteCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter(@Original_partUnit System.Data.SqlDbType.NVarChar 20 System.Data.ParameterDirection.Input false ((System.Byte)(0)) ((System.Byte)(0)) partUnit System.Data.DataRowVersion.Original null)); this.sqlDeleteCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter(@Original_partWarehouse System.Data.SqlDbType.NVarChar 50 System.Data.ParameterDirection.Input false ((System.Byte)(0)) ((System.Byte)(0)) partWarehouse System.Data.DataRowVersion.Original null)); this.sqlDeleteCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter(@Original_purCount System.Data.SqlDbType.Int 4 System.Data.ParameterDirection.Input false ((System.Byte)(0)) ((System.Byte)(0)) purCount System.Data.DataRowVersion.Original null)); this.sqlDeleteCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter(@Original_purID System.Data.SqlDbType.VarChar 16 System.Data.ParameterDirection.Input false ((System.Byte)(0)) ((System.Byte)(0)) purID System.Data.DataRowVersion.Original null)); this.sqlDeleteCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter(@Original_purUnitPrice System.Data.SqlDbType.Money 8 System.Data.ParameterDirection.Input false ((System.Byte)(0)) ((System.Byte)(0)) purUnitPrice System.Data.DataRowVersion.Original null)); // // sqlInsertCommandItems // this.sqlInsertCommandItems.CommandText = [mt_Part_InsertPartPurchaseItem]; this.sqlInsertCommandItems.CommandType = System.Data.CommandType.StoredProcedure; this.sqlInsertCommandItems.Connection = this.sqlConnection; this.sqlInsertCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter(@RETURN_VALUE System.Data.SqlDbType.Int 4 System.Data.ParameterDirection.ReturnValue false ((System.Byte)(0)) ((System.Byte)(0))  System.Data.DataRowVersion.Current null)); this.sqlInsertCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter(@purID System.Data.SqlDbType.VarChar 16 purID)); this.sqlInsertCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter(@partID System.Data.SqlDbType.Int 4 partID)); this.sqlInsertCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter(@purCount System.Data.SqlDbType.Int 4 purCount)); this.sqlInsertCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter(@purUnitPrice System.Data.SqlDbType.Money 8 purUnitPrice)); this.sqlInsertCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter(@partSN System.Data.SqlDbType.NVarChar 128 partSN)); this.sqlInsertCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter(@partName System.Data.SqlDbType.NVarChar 128 partName)); this.sqlInsertCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter(@partSpec System.Data.SqlDbType.NVarChar 128 partSpec)); this.sqlInsertCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter(@partUnit System.Data.SqlDbType.NVarChar 20 partUnit)); this.sqlInsertCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter(@partPosition System.Data.SqlDbType.NVarChar 50 partPosition)); this.sqlInsertCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter(@partWarehouse System.Data.SqlDbType.NVarChar 50 partWarehouse)); // // sqlSelectCommandItems // this.sqlSelectCommandItems.CommandText = [mt_Part_GetPartPurchaseItem]; this.sqlSelectCommandItems.CommandType = System.Data.CommandType.StoredProcedure; this.sqlSelectCommandItems.Connection = this.sqlConnection; this.sqlSelectCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter(@RETURN_VALUE System.Data.SqlDbType.Int 4 System.Data.ParameterDirection.ReturnValue false ((System.Byte)(0)) ((System.Byte)(0))  System.Data.DataRowVersion.Current null)); this.sqlSelectCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter(@purID System.Data.SqlDbType.Char 16)); // // sqlUpdateCommandItems // this.sqlUpdateCommandItems.CommandText = [mt_Part_UpdatePartPurchaseItem]; this.sqlUpdateCommandItems.CommandType = System.Data.CommandType.StoredProcedure; this.sqlUpdateCommandItems.Connection = this.sqlConnection; this.sqlUpdateCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter(@RETURN_VALUE System.Data.SqlDbType.Int 4 System.Data.ParameterDirection.ReturnValue false ((System.Byte)(0)) ((System.Byte)(0))  System.Data.DataRowVersion.Current null)); this.sqlUpdateCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter(@purID System.Data.SqlDbType.VarChar 16 purID)); this.sqlUpdateCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter(@partID System.Data.SqlDbType.Int 4 partID)); this.sqlUpdateCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter(@purCount System.Data.SqlDbType.Int 4 purCount)); this.sqlUpdateCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter(@purUnitPrice System.Data.SqlDbType.Money 8 purUnitPrice)); this.sqlUpdateCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter(@partSN System.Data.SqlDbType.NVarChar 128 partSN)); this.sqlUpdateCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter(@partName System.Data.SqlDbType.NVarChar 128 partName)); this.sqlUpdateCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter(@partSpec System.Data.SqlDbType.NVarChar 128 partSpec)); this.sqlUpdateCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter(@partUnit System.Data.SqlDbType.NVarChar 20 partUnit)); this.sqlUpdateCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter(@partPosition System.Data.SqlDbType.NVarChar 50 partPosition)); this.sqlUpdateCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter(@partWarehouse System.Data.SqlDbType.NVarChar 50 partWarehouse)); this.sqlUpdateCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter(@Original_purItemID System.Data.SqlDbType.Int 4 System.Data.ParameterDirection.Input false ((System.Byte)(0)) ((System.Byte)(0)) purItemID System.Data.DataRowVersion.Original null)); this.sqlUpdateCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter(@Original_partID System.Data.SqlDbType.Int 4 System.Data.ParameterDirection.Input false ((System.Byte)(0)) ((System.Byte)(0)) partID System.Data.DataRowVersion.Original null)); this.sqlUpdateCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter(@Original_partName System.Data.SqlDbType.NVarChar 128 System.Data.ParameterDirection.Input false ((System.Byte)(0)) ((System.Byte)(0)) partName System.Data.DataRowVersion.Original null)); this.sqlUpdateCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter(@Original_partPosition System.Data.SqlDbType.NVarChar 50 System.Data.ParameterDirection.Input false ((System.Byte)(0)) ((System.Byte)(0)) partPosition System.Data.DataRowVersion.Original null)); this.sqlUpdateCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter(@Original_partSN System.Data.SqlDbType.NVarChar 128 System.Data.ParameterDirection.Input false ((System.Byte)(0)) ((System.Byte)(0)) partSN System.Data.DataRowVersion.Original null)); this.sqlUpdateCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter(@Original_partSpec System.Data.SqlDbType.NVarChar 128 System.Data.ParameterDirection.Input false ((System.Byte)(0)) ((System.Byte)(0)) partSpec System.Data.DataRowVersion.Original null)); this.sqlUpdateCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter(@Original_partUnit System.Data.SqlDbType.NVarChar 20 System.Data.ParameterDirection.Input false ((System.Byte)(0)) ((System.Byte)(0)) partUnit System.Data.DataRowVersion.Original null)); this.sqlUpdateCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter(@Original_partWarehouse System.Data.SqlDbType.NVarChar 50 System.Data.ParameterDirection.Input false ((System.Byte)(0)) ((System.Byte)(0)) partWarehouse System.Data.DataRowVersion.Original null)); this.sqlUpdateCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter(@Original_purCount System.Data.SqlDbType.Int 4 System.Data.ParameterDirection.Input false ((System.Byte)(0)) ((System.Byte)(0)) purCount System.Data.DataRowVersion.Original null)); this.sqlUpdateCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter(@Original_purID System.Data.SqlDbType.VarChar 16 System.Data.ParameterDirection.Input false ((System.Byte)(0)) ((System.Byte)(0)) purID System.Data.DataRowVersion.Original null)); this.sqlUpdateCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter(@Original_purUnitPrice System.Data.SqlDbType.Money 8 System.Data.ParameterDirection.Input false ((System.Byte)(0)) ((System.Byte)(0)) purUnitPrice System.Data.DataRowVersion.Original null)); this.sqlUpdateCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter(@purItemID System.Data.SqlDbType.Int 4 purItemID)); // // sqlCommandGetById // this.sqlCommandGetById.CommandText = [mt_Part_GetPartPurchaseByID]; this.sqlCommandGetById.CommandType = System.Data.CommandType.StoredProcedure; this.sqlCommandGetById.Connection = this.sqlConnection; this.sqlCommandGetById.Parameters.Add(new System.Data.SqlClient.SqlParameter(@RETURN_VALUE System.Data.SqlDbType.Int 4 System.Data.ParameterDirection.ReturnValue false ((System.Byte)(0)) ((System.Byte)(0))  System.Data.DataRowVersion.Current null)); this.sqlCommandGetById.Parameters.Add(new System.Data.SqlClient.SqlParameter(@PurID System.Data.SqlDbType.VarChar 16)); // // sqlDataAdapterMain // this.sqlDataAdapterMain.DeleteCommand = this.sqlDeleteCommandMain; this.sqlDataAdapterMain.InsertCommand = this.sqlInsertCommandMain; this.sqlDataAdapterMain.SelectCommand = this.sqlSelectCommandMain; this.sqlDataAdapterMain.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping(Table PartPurchase new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping(purID purID) new System.Data.Common.DataColumnMapping(custCustomerID custCustomerID) new System.Data.Common.DataColumnMapping(purWarehouse purWarehouse) new System.Data.Common.DataColumnMapping(purApplicant purApplicant) new System.Data.Common.DataColumnMapping(purApprover purApprover) new System.Data.Common.DataColumnMapping(purReceiveDate purReceiveDate) new System.Data.Common.DataColumnMapping(purInputDate purInputDate) new System.Data.Common.DataColumnMapping(purOperator purOperator) new System.Data.Common.DataColumnMapping(purFlag purFlag) new System.Data.Common.DataColumnMapping(custNumber custNumber) new System.Data.Common.DataColumnMapping(custName custName) new System.Data.Common.DataColumnMapping(conName conName) new System.Data.Common.DataColumnMapping(conOfficeTel conOfficeTel)})}); this.sqlDataAdapterMain.UpdateCommand = this.sqlUpdateCommandMain; // // sqlSelectCommandMain // this.sqlSelectCommandMain.CommandText = [mt_Part_GetPartPurchase]; this.sqlSelectCommandMain.CommandType = System.Data.CommandType.StoredProcedure; this.sqlSelectCommandMain.Connection = this.sqlConnection; this.sqlSelectCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@RETURN_VALUE System.Data.SqlDbType.Int 4 System.Data.ParameterDirection.ReturnValue false ((System.Byte)(0)) ((System.Byte)(0))  System.Data.DataRowVersion.Current null)); // // sqlInsertCommandMain // this.sqlInsertCommandMain.CommandText = [mt_Part_InsertPartPurchase]; this.sqlInsertCommandMain.CommandType = System.Data.CommandType.StoredProcedure; this.sqlInsertCommandMain.Connection = this.sqlConnection; this.sqlInsertCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@RETURN_VALUE System.Data.SqlDbType.Int 4 System.Data.ParameterDirection.ReturnValue false ((System.Byte)(0)) ((System.Byte)(0))  System.Data.DataRowVersion.Current null)); this.sqlInsertCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@purID System.Data.SqlDbType.VarChar 16 System.Data.ParameterDirection.Output false ((System.Byte)(0)) ((System.Byte)(0)) purID System.Data.DataRowVersion.Current null)); this.sqlInsertCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@custCustomerID System.Data.SqlDbType.Int 4 custCustomerID)); this.sqlInsertCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@purWarehouse System.Data.SqlDbType.NVarChar 50 purWarehouse)); this.sqlInsertCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@purApplicant System.Data.SqlDbType.NVarChar 20 purApplicant)); this.sqlInsertCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@purApprover System.Data.SqlDbType.NVarChar 20 purApprover)); this.sqlInsertCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@purReceiveDate System.Data.SqlDbType.DateTime 8 purReceiveDate)); this.sqlInsertCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@purInputDate System.Data.SqlDbType.DateTime 8 purInputDate)); this.sqlInsertCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@purOperator System.Data.SqlDbType.NVarChar 20 purOperator)); this.sqlInsertCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@purFlag System.Data.SqlDbType.Int 4 purFlag)); this.sqlInsertCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@custNumber System.Data.SqlDbType.NVarChar 128 custNumber)); this.sqlInsertCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@custName System.Data.SqlDbType.NVarChar 128 custName)); this.sqlInsertCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@conName System.Data.SqlDbType.NVarChar 128 conName)); this.sqlInsertCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@conOfficeTel System.Data.SqlDbType.NVarChar 30 conOfficeTel)); // // sqlUpdateCommandMain // this.sqlUpdateCommandMain.CommandText = [mt_Part_UpdatePartPurchase]; this.sqlUpdateCommandMain.CommandType = System.Data.CommandType.StoredProcedure; this.sqlUpdateCommandMain.Connection = this.sqlConnection; this.sqlUpdateCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@RETURN_VALUE System.Data.SqlDbType.Int 4 System.Data.ParameterDirection.ReturnValue false ((System.Byte)(0)) ((System.Byte)(0))  System.Data.DataRowVersion.Current null)); this.sqlUpdateCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@purID System.Data.SqlDbType.VarChar 16 purID)); this.sqlUpdateCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@custCustomerID System.Data.SqlDbType.Int 4 custCustomerID)); this.sqlUpdateCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@purWarehouse System.Data.SqlDbType.NVarChar 50 purWarehouse)); this.sqlUpdateCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@purApplicant System.Data.SqlDbType.NVarChar 20 purApplicant)); this.sqlUpdateCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@purApprover System.Data.SqlDbType.NVarChar 20 purApprover)); this.sqlUpdateCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@purReceiveDate System.Data.SqlDbType.DateTime 8 purReceiveDate)); this.sqlUpdateCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@purInputDate System.Data.SqlDbType.DateTime 8 purInputDate)); this.sqlUpdateCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@purOperator System.Data.SqlDbType.NVarChar 20 purOperator)); this.sqlUpdateCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@purFlag System.Data.SqlDbType.Int 4 purFlag)); this.sqlUpdateCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@custNumber System.Data.SqlDbType.NVarChar 128 custNumber)); this.sqlUpdateCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@custName System.Data.SqlDbType.NVarChar 128 custName)); this.sqlUpdateCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@conName System.Data.SqlDbType.NVarChar 128 conName)); this.sqlUpdateCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@conOfficeTel System.Data.SqlDbType.NVarChar 30 conOfficeTel)); this.sqlUpdateCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@Original_purID System.Data.SqlDbType.VarChar 16 System.Data.ParameterDirection.Input false ((System.Byte)(0)) ((System.Byte)(0)) purID System.Data.DataRowVersion.Original null)); this.sqlUpdateCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@Original_conName System.Data.SqlDbType.NVarChar 128 System.Data.ParameterDirection.Input false ((System.Byte)(0)) ((System.Byte)(0)) conName System.Data.DataRowVersion.Original null)); this.sqlUpdateCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@Original_conOfficeTel System.Data.SqlDbType.NVarChar 30 System.Data.ParameterDirection.Input false ((System.Byte)(0)) ((System.Byte)(0)) conOfficeTel System.Data.DataRowVersion.Original null)); this.sqlUpdateCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@Original_custCustomerID System.Data.SqlDbType.Int 4 System.Data.ParameterDirection.Input false ((System.Byte)(0)) ((System.Byte)(0)) custCustomerID System.Data.DataRowVersion.Original null)); this.sqlUpdateCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@Original_custName System.Data.SqlDbType.NVarChar 128 System.Data.ParameterDirection.Input false ((System.Byte)(0)) ((System.Byte)(0)) custName System.Data.DataRowVersion.Original null)); this.sqlUpdateCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@Original_custNumber System.Data.SqlDbType.NVarChar 128 System.Data.ParameterDirection.Input false ((System.Byte)(0)) ((System.Byte)(0)) custNumber System.Data.DataRowVersion.Original null)); this.sqlUpdateCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@Original_purApplicant System.Data.SqlDbType.NVarChar 20 System.Data.ParameterDirection.Input false ((System.Byte)(0)) ((System.Byte)(0)) purApplicant System.Data.DataRowVersion.Original null)); this.sqlUpdateCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@Original_purApprover System.Data.SqlDbType.NVarChar 20 System.Data.ParameterDirection.Input false ((System.Byte)(0)) ((System.Byte)(0)) purApprover System.Data.DataRowVersion.Original null)); this.sqlUpdateCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@Original_purFlag System.Data.SqlDbType.Int 4 System.Data.ParameterDirection.Input false ((System.Byte)(0)) ((System.Byte)(0)) purFlag System.Data.DataRowVersion.Original null)); this.sqlUpdateCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@Original_purInputDate System.Data.SqlDbType.DateTime 8 System.Data.ParameterDirection.Input false ((System.Byte)(0)) ((System.Byte)(0)) purInputDate System.Data.DataRowVersion.Original null)); this.sqlUpdateCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@Original_purOperator System.Data.SqlDbType.NVarChar 20 System.Data.ParameterDirection.Input false ((System.Byte)(0)) ((System.Byte)(0)) purOperator System.Data.DataRowVersion.Original null)); this.sqlUpdateCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@Original_purReceiveDate System.Data.SqlDbType.DateTime 8 System.Data.ParameterDirection.Input false ((System.Byte)(0)) ((System.Byte)(0)) purReceiveDate System.Data.DataRowVersion.Original null)); this.sqlUpdateCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@Original_purWarehouse System.Data.SqlDbType.NVarChar 50 System.Data.ParameterDirection.Input false ((System.Byte)(0)) ((System.Byte)(0)) purWarehouse System.Data.DataRowVersion.Original null)); // // sqlDeleteCommandMain // this.sqlDeleteCommandMain.CommandText = [mt_Part_DeletePartPurchase]; this.sqlDeleteCommandMain.CommandType = System.Data.CommandType.StoredProcedure; this.sqlDeleteCommandMain.Connection = this.sqlConnection; this.sqlDeleteCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@RETURN_VALUE System.Data.SqlDbType.Int 4 System.Data.ParameterDirection.ReturnValue false ((System.Byte)(0)) ((System.Byte)(0))  System.Data.DataRowVersion.Current null)); this.sqlDeleteCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@Original_purID System.Data.SqlDbType.VarChar 16 System.Data.ParameterDirection.Input false ((System.Byte)(0)) ((System.Byte)(0)) purID System.Data.DataRowVersion.Original null)); this.sqlDeleteCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@Original_conName System.Data.SqlDbType.NVarChar 128 System.Data.ParameterDirection.Input false ((System.Byte)(0)) ((System.Byte)(0)) conName System.Data.DataRowVersion.Original null)); this.sqlDeleteCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@Original_conOfficeTel System.Data.SqlDbType.NVarChar 30 System.Data.ParameterDirection.Input false ((System.Byte)(0)) ((System.Byte)(0)) conOfficeTel System.Data.DataRowVersion.Original null)); this.sqlDeleteCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@Original_custCustomerID System.Data.SqlDbType.Int 4 System.Data.ParameterDirection.Input false ((System.Byte)(0)) ((System.Byte)(0)) custCustomerID System.Data.DataRowVersion.Original null)); this.sqlDeleteCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@Original_custName System.Data.SqlDbType.NVarChar 128 System.Data.ParameterDirection.Input false ((System.Byte)(0)) ((System.Byte)(0)) custName System.Data.DataRowVersion.Original null)); this.sqlDeleteCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@Original_custNumber System.Data.SqlDbType.NVarChar 128 System.Data.ParameterDirection.Input false ((System.Byte)(0)) ((System.Byte)(0)) custNumber System.Data.DataRowVersion.Original null)); this.sqlDeleteCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@Original_purApplicant System.Data.SqlDbType.NVarChar 20 System.Data.ParameterDirection.Input false ((System.Byte)(0)) ((System.Byte)(0)) purApplicant System.Data.DataRowVersion.Original null)); this.sqlDeleteCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@Original_purApprover System.Data.SqlDbType.NVarChar 20 System.Data.ParameterDirection.Input false ((System.Byte)(0)) ((System.Byte)(0)) purApprover System.Data.DataRowVersion.Original null)); this.sqlDeleteCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@Original_purFlag System.Data.SqlDbType.Int 4 System.Data.ParameterDirection.Input false ((System.Byte)(0)) ((System.Byte)(0)) purFlag System.Data.DataRowVersion.Original null)); this.sqlDeleteCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@Original_purInputDate System.Data.SqlDbType.DateTime 8 System.Data.ParameterDirection.Input false ((System.Byte)(0)) ((System.Byte)(0)) purInputDate System.Data.DataRowVersion.Original null)); this.sqlDeleteCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@Original_purOperator System.Data.SqlDbType.NVarChar 20 System.Data.ParameterDirection.Input false ((System.Byte)(0)) ((System.Byte)(0)) purOperator System.Data.DataRowVersion.Original null)); this.sqlDeleteCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@Original_purReceiveDate System.Data.SqlDbType.DateTime 8 System.Data.ParameterDirection.Input false ((System.Byte)(0)) ((System.Byte)(0)) purReceiveDate System.Data.DataRowVersion.Original null)); this.sqlDeleteCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter(@Original_purWarehouse System.Data.SqlDbType.NVarChar 50 System.Data.ParameterDirection.Input false ((System.Byte)(0)) ((System.Byte)(0)) purWarehouse System.Data.DataRowVersion.Original null)); // // sqlConnection // this.sqlConnection.ConnectionString = workstation id=DNB;packet size=4096;user id=sa;data source=\.\;persist security i + nfo=False;initial catalog=BPMIS; } #endregion public DataModel.PartPurchaseData GetPartPurchase() { DataModel.PartPurchaseData purchase=new DataModel.PartPurchaseData(); try { this.sqlDataAdapterMain.Fill(purchasepurchase.PartPurchase.TableName); /// ///fill the main info listall the part purchase info. /// } catch { return null; } return purchase; } public DataModel.PartPurchaseData GetPartPurchaseById(string purID) { DataModel.PartPurchaseData purchase=new DataModel.PartPurchaseData(); this.sqlDataAdapterMain.SelectCommand=this.sqlCommandGetById; this.sqlDataAdapterMain.SelectCommand.Parameters[@purID].Value=purID; //try //{ this.sqlDataAdapterMain.Fill(purchasepurchase.PartPurchase.TableName); /// ///fill the main infoa part purchase info /// this.sqlDataAdapterItems.SelectCommand.Parameters[@purID].Value=purID; this.sqlDataAdapterItems.Fill(purchasepurchase.PartPurchaseItems.TableName); /// ///fill the items info /// //} //catch //{ // return null; //} return purchase; } public bool UpdatePartPurchase(DataModel.PartPurchaseData purchase) { try { /// ///Insert and Update the main table /// this.sqlDataAdapterMain.Update(purchasepurchase.PartPurchase.TableName ); purchase.PartPurchase.AcceptChanges(); /// ///Insert and Update the items table /// String tempID=purchase.PartPurchase.Rows[0][purID].ToString(); foreach(DataRow row in purchase.PartPurchaseItems.Rows) { if(row.RowState==DataRowState.Added ) { row.BeginEdit(); row[purID]=tempID; row.EndEdit(); } } this.sqlDataAdapterItems.Update(purchasepurchase.PartPurchaseItems.TableName); purchase.PartPurchaseItems.AcceptChanges(); } catch { return false; } return true; } public bool DeletePartPurchase(PartPurchaseData purchase) { try { // //Delete a PartPurchase this.sqlDataAdapterMain.Update(purchase.PartPurchase); purchase.AcceptChanges(); } catch { return false; } return true; } } }

tungqt · Answer

that's exactly what i need to know. Can you show me some codes example ?

luoeagle · Answer

If you modified the DataSet objectyou can use the DataAdapter to decide which to do with the database(insertdeletemodifieddelete)but you should use the DataAdapter tools to create procedures first.