private void btnSave_Click(object sender, RoutedEventArgs e)
{
if (isNewRow)
{
DataRow newRow = dsSample.Tables["Book"].NewRow();
newRow["BookCode"] = txtBookCode.Text;
newRow["Title"] = txtTitle.Text;
newRow["PublisherCode"] = txtPubCode.Text;
newRow["Type"] = txtType.Text;
newRow["Price"] = Convert.ToDouble(txtPrice.Text);
newRow["Paperback"] = chkPaperback.IsChecked;
dsSample.Tables["Book"].Rows.Add(newRow);
rowIndex = dsSample.Tables["Book"].Rows.Count - 1;
}
else
{
dsSample.Tables["Book"].Rows[rowIndex].BeginEdit();
dsSample.Tables["Book"].Rows[rowIndex]["BookCode"] = txtBookCode.Text;
dsSample.Tables["Book"].Rows[rowIndex]["Title"] = txtTitle.Text;
dsSample.Tables["Book"].Rows[rowIndex]["PublisherCode"] = txtPubCode.Text;
dsSample.Tables["Book"].Rows[rowIndex]["Type"] = txtType.Text;
dsSample.Tables["Book"].Rows[rowIndex]["Price"] = Convert.ToDouble(txtPrice.Text);
dsSample.Tables["Book"].Rows[rowIndex]["Paperback"] = chkPaperback.IsChecked;;
dsSample.Tables["Book"].Rows[rowIndex].EndEdit();
}
daBooks.UpdateCommand = builder.GetUpdateCommand();
daBooks.Update(dsSample, "Book");
viewMode();
}
/// <summary>
/// Pre-Condition: The parameters will be in the order of passing the dataset,
/// and the string table name.
/// Post-Condition: The update dataset will be persisted in the database.
/// Description: This method will update the database based on the updated
/// records in the dataset for a given table.
/// </summary>
/// <param name="pDataSet">The dataset that contains the updated records.</param>
/// <param name="pStrTableName">The table name that will be updated in the
/// database.</param>
public void SaveData(DataSet pDataSet, string pStrTableName)
{
string strQuery = "SELECT * FROM " + pStrTableName;
OleDbDataAdapter dbDA = new OleDbDataAdapter(strQuery, _dbConn);
try
{
// setup Command Builders
OleDbCommandBuilder dbBLD = new OleDbCommandBuilder(dbDA);
dbDA.InsertCommand = dbBLD.GetInsertCommand();
dbDA.UpdateCommand = dbBLD.GetUpdateCommand();
dbDA.DeleteCommand = dbBLD.GetDeleteCommand();
// subscribe to the OleDbRowUpdateEventHandler
dbDA.RowUpdated += new OleDbRowUpdatedEventHandler(OnRowUpdated);
_dbConn.Open();
dbDA.Update(pDataSet, pStrTableName);
pDataSet.Tables[pStrTableName].AcceptChanges();
_dbConn.Close();
pStrTableName = null;
}
catch (Exception e)
{
MessageBox.Show(e.ToString());
}
finally
{
_dbConn.Close();
}
}
// <Snippet1>
static private DataSet CreateCommandAndUpdate(
string connectionString,
string queryString)
{
DataSet dataSet = new DataSet();
using (OleDbConnection connection =
new OleDbConnection(connectionString))
{
connection.Open();
OleDbDataAdapter adapter =
new OleDbDataAdapter();
adapter.SelectCommand =
new OleDbCommand(queryString, connection);
OleDbCommandBuilder builder =
new OleDbCommandBuilder(adapter);
adapter.Fill(dataSet);
// Code to modify data in the DataSet here.
// Without the OleDbCommandBuilder, this line would fail.
adapter.UpdateCommand = builder.GetUpdateCommand();
adapter.Update(dataSet);
}
return(dataSet);
}
public void Upload_table(DataTable D_table, string table_str, Dictionary <string, string> dic_where)
{
string select_str;
//create select statment to use in build
select_str = dic_to_string_Read(dic_where, table_str, "*");
//start build commands
OleDbConnection con = new OleDbConnection(connectionStringW);
OleDbDataAdapter da = new OleDbDataAdapter(select_str, con);
OleDbCommandBuilder builder = new OleDbCommandBuilder(da);
builder.QuotePrefix = "[";
builder.QuoteSuffix = "]";
da.UpdateCommand = builder.GetUpdateCommand();
da.InsertCommand = builder.GetInsertCommand();
//builder.GetDeleteCommand();
//builder.GetInsertCommand();
//builder.GetUpdateCommand();
//think of how to force update statment to update specific colomns only
try
{
da.Update(D_table);
}
catch (Exception exp)
{
MessageBox.Show(exp.Message);
con.Close();
throw;
}
}
// Disconnected
//פעולה המעדכנת את הדטהבייס בהתאם לדטהסט
public static void Update(DataSet ds, string com, string name)
{
OleDbConnection cn = new OleDbConnection(Connect.GetConnectionString());
OleDbCommand command = new OleDbCommand();
command.Connection = cn;
command.CommandText = com;
OleDbDataAdapter adapter = new OleDbDataAdapter(command);
OleDbCommandBuilder builder = new OleDbCommandBuilder(adapter);
adapter.InsertCommand = builder.GetInsertCommand();
adapter.DeleteCommand = builder.GetDeleteCommand();
adapter.UpdateCommand = builder.GetUpdateCommand();
try
{
cn.Open();
adapter.Update(ds, name);
}
catch (Exception e)
{
throw e;
}
finally
{
cn.Close();
}
}
public bool TryFillAndUpdate(GasMeter gasValues)
{
var select = "SELECT * FROM GAS_VALUES";
_adapter.SelectCommand = new OleDbCommand(select, MyConnection);
try
{
_adapter.Fill(_currentTable);
var tmpGasValues = new object[5];
_keyCounter = GetLastKey();
tmpGasValues[0] = ++_keyCounter;
tmpGasValues[1] = gasValues.Number;
tmpGasValues[2] = DateTime.Now;
tmpGasValues[3] = gasValues.Hydrogen;
tmpGasValues[4] = gasValues.Oxygen;
_currentTable.Rows.Add(tmpGasValues);
_adapter.UpdateCommand = _builder.GetUpdateCommand();
_adapter.Update(_currentTable);
}
catch
{
return(false);
}
return(true);
}
private int SaveData(string SQL, DataTable dt)
{
int result;
if (dt == null)
{
return(-1);
}
if (dt.DataSet != null && !dt.DataSet.HasChanges())
{
Helper.ShowMessage(true);
}
OleDbDataAdapter da = GetDataAdapter(SQL);
OleDbCommandBuilder cb = GetCommandBuilder(da);
OpenConnection();
da.InsertCommand = cb.GetInsertCommand();
da.UpdateCommand = cb.GetUpdateCommand();
da.DeleteCommand = cb.GetDeleteCommand();
result = da.Update(dt);
CloseConnection();
return(result);
}
public Form1()
{
InitializeComponent();
adapter_grupa = new OleDbDataAdapter("select * from Grupa", @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Users\petar\Documents\SKOLA\Treca godina\TVP\Projekat_septembar\Prodavnica\Prodavnica.mdb");
adapter_artikal = new OleDbDataAdapter("select * from Artikal", @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Users\petar\Documents\SKOLA\Treca godina\TVP\Projekat_septembar\Prodavnica\Prodavnica.mdb");
adapter_racun = new OleDbDataAdapter("select * from Racun", @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Users\petar\Documents\SKOLA\Treca godina\TVP\Projekat_septembar\Prodavnica\Prodavnica.mdb");
OleDbCommandBuilder cmdBuild = new OleDbCommandBuilder(adapter_artikal);
adapter_artikal.InsertCommand = cmdBuild.GetInsertCommand();
adapter_artikal.UpdateCommand = cmdBuild.GetUpdateCommand();
adapter_artikal.DeleteCommand = cmdBuild.GetDeleteCommand();
cmdBuild = new OleDbCommandBuilder(adapter_racun);
adapter_racun.InsertCommand = cmdBuild.GetInsertCommand();
adapter_racun.UpdateCommand = cmdBuild.GetUpdateCommand();
adapter_racun.DeleteCommand = cmdBuild.GetDeleteCommand();
OleDbDataAdapter da = new OleDbDataAdapter("select * from Grupa ;select * from Artikal; select * from Racun", @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Users\petar\Documents\SKOLA\Treca godina\TVP\Projekat_septembar\Prodavnica\Prodavnica.mdb");
ds = new DataSet();
adapter_grupa.Fill(ds, "Grupa");
adapter_artikal.Fill(ds, "Artikal");
adapter_racun.Fill(ds, "Racun");
cbKategorija.DataSource = ds.Tables["Grupa"];
cbKategorija.DisplayMember = "Naziv";
cbKategorija.ValueMember = "id_grupa";
PopuniRacun();
}
public void modify(Form3 f, int found)
{
OleDbConnection conn = new OleDbConnection();
String s = System.Environment.CurrentDirectory;
string connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=";
connStr += @s + @"//StudentManager.mdb";
// Console.WriteLine("当前连接字符串为:\n" + connStr + "\n");
conn.ConnectionString = connStr;
string strSelectQuery = "select * from students";
OleDbCommand cmd = new OleDbCommand(strSelectQuery, conn);
OleDbDataAdapter da = new OleDbDataAdapter();
OleDbCommandBuilder cb = new OleDbCommandBuilder(da);
da.SelectCommand = cmd;
da.UpdateCommand = cb.GetUpdateCommand();
DataSet result = new DataSet();
da.Fill(result, "students");
result.Tables[0].Rows[found]["Name"] = f.textBox1.Text;
result.Tables[0].Rows[found]["ID"] = f.textBox2.Text;
result.Tables[0].Rows[found]["Sex"] = f.textBox3.Text;
result.Tables[0].Rows[found]["Class"] = f.textBox4.Text;
result.Tables[0].Rows[found]["Email"] = f.textBox5.Text;
result.Tables[0].Rows[found]["Chinese"] = f.textBox6.Text;
result.Tables[0].Rows[found]["Math"] = f.textBox7.Text;
result.Tables[0].Rows[found]["English"] = f.textBox8.Text;
da.Update(result, "students");
conn.Close();
}
/// <summary>
/// Queries the database and populates a dataset.
/// </summary>
private void RetrieveDataFromTheDatabase()
{
try
{
string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source='AMDatabase.mdb'";
this.connection = new OleDbConnection();
this.connection.ConnectionString = connectionString;
this.connection.Open();
OleDbCommand selectCommand = new OleDbCommand();
selectCommand.CommandText = "SELECT * FROM VehicleStock";
selectCommand.Connection = this.connection;
this.adapter = new OleDbDataAdapter();
this.adapter.SelectCommand = selectCommand;
OleDbCommandBuilder builder = new OleDbCommandBuilder();
builder.DataAdapter = this.adapter;
this.adapter.UpdateCommand = builder.GetUpdateCommand();
this.adapter.DeleteCommand = builder.GetDeleteCommand();
this.adapter.InsertCommand = builder.GetInsertCommand();
this.dataset = new DataSet();
this.adapter.Fill(this.dataset, "VehicleStock");
}
catch (Exception e)
{
this.connection.Close();
this.connection.Dispose();
}
}
private void button2_Click(object sender, EventArgs e)
{
dataGridView1.EndEdit();
姓名.Text = myDataSet.Tables[0].Rows[dataGridView1.CurrentRow.Index][0].ToString(); //显示第1行第1列的一个值
密码.Text = myDataSet.Tables[0].Rows[dataGridView1.CurrentRow.Index][1].ToString(); //显示第1行第2列的一个值
部职别.Text = myDataSet.Tables[0].Rows[dataGridView1.CurrentRow.Index][2].ToString(); //显示第1行第3列的一个值
textBox4.Text = myDataSet.Tables[0].Rows[dataGridView1.CurrentRow.Index][3].ToString(); //显示第1行第4列的一个值
string sql = "select * from dlxxb";
OleDbDataAdapter da = new OleDbDataAdapter(sql, myConnection);
OleDbCommandBuilder bld = new OleDbCommandBuilder(da);
da.UpdateCommand = bld.GetUpdateCommand();
//把DataGridView赋值给dataTable。(DataTable)的意思是类型转换，前提是后面紧跟着的东西要能转换成dataTable类型
DataTable dt = (DataTable)dataGridView1.DataSource;
da.Update(dt);
dt.AcceptChanges();
string strData = "SELECT * from dlxxb";
OleDbDataAdapter myData = new OleDbDataAdapter(strData, myConnection);
DataSet myDataSet1 = new DataSet();
myData.Fill(myDataSet1, "dlxxb");
dataGridView1.DataSource = myDataSet1.Tables["dlxxb"];
}
/// <summary>
/// Updates the data source with any changes made to the dataset
/// </summary>
/// <param name="passedDataset">The dataset that contains the changes</param>
/// <example>To store any changes made to the dataset you simply need to pass the dataset to the method. Any entries that are
/// flagged as having been changed will be committed to the datasource (this includes, additions, edits and deletions)
/// <code>
/// //Your code to update the dataset
/// myDataHandler.UpdateDataset(myDataset);
/// </code>
/// Note - the dataset being updated must be the one created from this particular instance of the datahandler - trying to pass a
/// dataset not generated by the specific instance of the class will result in a data exception
/// </example>
public void UpdateDataset(DataSet passedDataset)
{
OleDbCommandBuilder builder = new OleDbCommandBuilder(m_localAdapter);
m_localAdapter.UpdateCommand = builder.GetUpdateCommand();
m_localAdapter.Update(passedDataset, passedDataset.Tables[0].TableName);
}
// Otvara tablicu Odgovori iz baze podataka Ankete
public DataTable OpenOdgovori(int id)
{
// create the adapter and fill the DataSet
String sql = "SELECT RBR,ODGOVOR,GLASOVI,ID_ANKETE,ID_ODGOVORA FROM ODGOVORI WHERE ID_ANKETE=" + id.ToString() + " ORDER BY RBR";
DataTable dtOdgovori = null;
try
{
adOdgovori = new OleDbDataAdapter();
adOdgovori.SelectCommand = new OleDbCommand(sql, conn);
OleDbCommandBuilder cb = new OleDbCommandBuilder(adOdgovori);
openDB();
dsOdgovori = new DataSet("ODGOVORI");
adOdgovori.Fill(dsOdgovori, "ODGOVORI");
adOdgovori.UpdateCommand = cb.GetUpdateCommand();
adOdgovori.InsertCommand = cb.GetInsertCommand();
dtOdgovori = dsOdgovori.Tables[0];
bindOdgovori = new BindingSource();
bindOdgovori.DataSource = dtOdgovori;
closeDB();
}
catch (Exception ex) { MessageBox.Show(ex.Message); };
return(dtOdgovori);
}
//void CopySqlTable(string name,SqlConnection sourceConn,SqlConnection destConn)
//{
// Message("拷貝" + name);
// DataTable table = new DataTable(name);
// string SelectStr = "Select * From " + name;
// var sourceAdapter = new SqlDataAdapter(SelectStr, sourceConn);
// try
// {
// int sourceNo = sourceAdapter.Fill(table);
// foreach (DataRow row in table.Rows) row.SetAdded();
// var destAdapter = new SqlDataAdapter(SelectStr, destConn);
// var builder = new SqlCommandBuilder(destAdapter);
// builder.QuotePrefix = "["; // 因為有些ColumnName是保留字,如Password
// builder.QuoteSuffix = "]";
// destAdapter.UpdateCommand = builder.GetUpdateCommand();
// destAdapter.InsertCommand = builder.GetInsertCommand();
// destAdapter.DeleteCommand = builder.GetDeleteCommand();
// int no = destAdapter.Update(table);
// MessageBox.Show(name + "來源共" + sourceNo.ToString() + "筆,寫出成功" + no.ToString() + "筆");
// }
// catch (Exception ex)
// {
// MessageBox.Show("寫出[" + name + "]時出錯:" + ex.Message);
// }
//}
void CopyOldDbTable(string name, OleDbConnection sourceConn, OleDbConnection destConn)
{
Message("拷貝" + name);
DataTable table = new DataTable(name);
string SelectStr = "Select * From " + name;
var sourceAdapter = new OleDbDataAdapter(SelectStr, sourceConn);
try
{
int sourceNo = sourceAdapter.Fill(table);
foreach (DataRow row in table.Rows)
{
row.SetAdded();
}
var destAdapter = new OleDbDataAdapter(SelectStr, destConn);
var builder = new OleDbCommandBuilder(destAdapter);
builder.QuotePrefix = "["; // 因為有些ColumnName是保留字,如Password
builder.QuoteSuffix = "]";
destAdapter.UpdateCommand = builder.GetUpdateCommand();
destAdapter.InsertCommand = builder.GetInsertCommand();
destAdapter.DeleteCommand = builder.GetDeleteCommand();
int no = destAdapter.Update(table);
MessageBox.Show(name + "來源共" + sourceNo.ToString() + "筆,寫出成功" + no.ToString() + "筆");
}
catch (Exception ex)
{
MessageBox.Show("寫出[" + name + "]時出錯:" + ex.Message);
}
}
//-----------------------------
//DataGridView에 데이터 채우기
//-----------------------------
private void LoadData()
{
try
{
string sql = "select * from addrbook";
LocalConn = Common_DB.DBConnection();
LocalConn.Open();
adapter = new OleDbDataAdapter(sql, LocalConn);
cb = new OleDbCommandBuilder(adapter);
adapter.DeleteCommand = cb.GetDeleteCommand();
adapter.InsertCommand = cb.GetInsertCommand();
adapter.UpdateCommand = cb.GetUpdateCommand();
ds = new DataSet();
adapter.Fill(ds, "ADDRBOOK");
dataGrid1.DataSource = ds.Tables["ADDRBOOK"];
}
catch (Exception e1)
{
MessageBox.Show("주소록 저장 오류~" + e1.ToString());
Log.WriteLine("FrmDataGridView", e1.ToString());
}
finally
{
LocalConn.Close();
}
}
public void updateDatabase()
{
using (OleDbConnection connec = new OleDbConnection())
{
OleDbCommand commande = new OleDbCommand();
try
{
connec.ConnectionString = chcon;
connec.Open();
using (OleDbDataAdapter da =
new OleDbDataAdapter())
{
da.SelectCommand = new OleDbCommand("Select * from Utilisateurs", connec);
OleDbCommandBuilder builder = new OleDbCommandBuilder(da);
da.UpdateCommand = builder.GetUpdateCommand();
da.Update(dsEsp, "Utilisateurs");
}
}
catch (Exception x)
{
MessageBox.Show(x.Message);
}
finally
{
connec.Close();
}
}
}
public static bool AzurirajPodatke(DataSet ds)
{
try
{
try
{
OleDbDataAdapter da = new OleDbDataAdapter("select * from Artikal", konekcijaString);
OleDbCommandBuilder cb = new OleDbCommandBuilder(da);
da.UpdateCommand = cb.GetUpdateCommand();
da.Update(ds.Tables["Artikal"]);
}
catch
{
MessageBox.Show("Ukoliko brišete neki zapis ponovite čuvanje još jednom");
}
OleDbDataAdapter da2 = new OleDbDataAdapter("select * from Grupisanje", konekcijaString);
OleDbCommandBuilder cb2 = new OleDbCommandBuilder(da2);
da2.UpdateCommand = cb2.GetUpdateCommand();
da2.Update(ds.Tables["Grupisanje"]);
return(true);
}
catch (Exception e)
{
MessageBox.Show("Doslo je do greške" + Environment.NewLine + e.Message);
return(false);
}
}
public static void InsertClientProtocol(string[] str, string tablename)
{
string selectCommandText = "SELECT * FROM " + tablename;
OleDbDataAdapter oleDbDataAdapter = new OleDbDataAdapter(selectCommandText, AccessFunction.dbConnection);
OleDbCommandBuilder oleDbCommandBuilder = new OleDbCommandBuilder(oleDbDataAdapter);
DataSet dataSet = new DataSet();
oleDbDataAdapter.Fill(dataSet);
OleDbCommandBuilder oleDbCommandBuilder2 = new OleDbCommandBuilder(oleDbDataAdapter);
oleDbDataAdapter.UpdateCommand = oleDbCommandBuilder2.GetUpdateCommand();
int count = dataSet.Tables[0].Columns.Count;
if (tablename != "Table_room")
{
count = count - 1;
}
DataRow dataRow = dataSet.Tables[0].NewRow();
for (int i = 0; i < count; i++)
{
dataRow[i] = str[i];
}
dataSet.Tables[0].Rows.Add(dataRow);
oleDbDataAdapter.Update(dataSet);
}
/// <summary>
/// Initializes an instance of VehicelData form.
/// </summary>
public VehicelData()
{
InitializeComponent();
//Construct an instance of a connection object
OleDbConnection oleDbConnection = new OleDbConnection();
//Setup the ConnectionString
oleDbConnection.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=AMDatabase.mdb";
//Open the database file
oleDbConnection.Open();
//Selection query
string SqlQuery = "SELECT * FROM VehicleStock";
//Construct an instance of a command object
//SqlQuery is the selection
//oleDbConnection reference to the connection
OleDbCommand dbCommand = new OleDbCommand(SqlQuery, oleDbConnection);
//Create an data adapter object
_dataAdapter = new OleDbDataAdapter();
//Set the data adapter object's select command to the command object
_dataAdapter.SelectCommand = dbCommand;
//Create an data set object
_dataSet = new DataSet();
//Using the data adapter object, fill the data set
//"VehicleStock" is the table name
_dataAdapter.Fill(_dataSet, "VehicleStock");
//Create the binding source object
_bindingSource = new BindingSource();
//Create the command builder object
OleDbCommandBuilder oleDbCommandBuilder = new OleDbCommandBuilder();
//Set the command builder object's data adapter to _dataAdapter
oleDbCommandBuilder.DataAdapter = _dataAdapter;
//Use command builder to get required SQL
_dataAdapter.UpdateCommand = oleDbCommandBuilder.GetUpdateCommand();
_dataAdapter.InsertCommand = oleDbCommandBuilder.GetInsertCommand();
_dataAdapter.DeleteCommand = oleDbCommandBuilder.GetDeleteCommand();
//Resolve the primary key conflict when Adding and Deleting new row
oleDbCommandBuilder.ConflictOption = ConflictOption.OverwriteChanges;
//EventHandlers
_dataAdapter.RowUpdated += new OleDbRowUpdatedEventHandler(dataAdapter_RowUpdated);
dgvVehicelData.SelectionChanged += new EventHandler(dgvVehicelData_SelectionChanged);
dgvVehicelData.CellValueChanged += new DataGridViewCellEventHandler(dgvVehicelData_CellValueChanged);
this.FormClosing += FormClosingEvent;
mnuClose.Click += closeToolStripMenuItem_Click;
this.Load += new EventHandler(Form_load);
}
//public bool UpdateDbData(string command, DataSet ds)
//{
// if (UpdateDbData(ds.Tables[0], "SystemOption") >= 0)
// return true;
// else
// return false;
//}
public bool UpdateDbData(string commandText, DataTable table)
{
int affect = -1;
try
{
OleDbConnection connection = new OleDbConnection(Url);
using (connection)
{
// Create the select command.
OleDbCommand command = new OleDbCommand(commandText, connection);
// Create the DbDataAdapter.
OleDbDataAdapter adapter = new OleDbDataAdapter(command);
// Create the DbCommandBuilder.
OleDbCommandBuilder builder = new OleDbCommandBuilder(adapter);
builder.RefreshSchema();
// Get the insert, update and delete commands.
adapter.InsertCommand = builder.GetInsertCommand();
adapter.UpdateCommand = builder.GetUpdateCommand();
adapter.DeleteCommand = builder.GetDeleteCommand();
var dd = table.GetChanges();
affect = adapter.Update(table);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(affect > 0 ? true : false);
}
public void Update(string strSelectSQL, DataTable objTable)
{
OleDbDataAdapter adapter1;
OleDbCommandBuilder builder1;
if (!this.m_bIsInTransaction)
{
OleDbCommand command1 = new OleDbCommand(strSelectSQL, this.m_objConn);
if (this.m_Timeout >= 30)
{
command1.CommandTimeout = this.m_Timeout;
}
adapter1 = new OleDbDataAdapter(command1);
builder1 = new OleDbCommandBuilder(adapter1);
adapter1.InsertCommand = builder1.GetInsertCommand();
adapter1.DeleteCommand = builder1.GetDeleteCommand();
adapter1.UpdateCommand = builder1.GetUpdateCommand();
adapter1.Update(objTable);
builder1.Dispose();
command1.Dispose();
adapter1.Dispose();
}
else
{
adapter1 = new OleDbDataAdapter(this.m_objCommand);
builder1 = new OleDbCommandBuilder(adapter1);
adapter1.InsertCommand = builder1.GetInsertCommand();
adapter1.DeleteCommand = builder1.GetDeleteCommand();
adapter1.UpdateCommand = builder1.GetUpdateCommand();
adapter1.Update(objTable);
builder1.Dispose();
adapter1.Dispose();
}
}
public void UpdateUserServer(UserDetail User, DataSet DS) //פעולה מקבלת טבלה ופרטי משתמש
{
foreach (DataRow Row in DS.Tables["Users"].Rows)
{
if (User.UserId == int.Parse(Row["UserId"].ToString()))
{
Row["State"] = User.State;
Row["FirstName"] = User.FirstName;
Row["Email"] = User.Email;
Row["KindUser"] = User.KindUser;
Row["Description"] = User.Description;
Row["Status"] = User.Status;
Row["LastName"] = User.LastName;
Row["CardID"] = User.CardID;
Row["dateCard"] = User.dateCard;
Row["SecurityCode"] = User.SecurityCode;
Row["DateAdd"] = User.DateAdd;
Row["birthday"] = User.birthday;
}
}
try
{
MyConnction.Open();
OleDbCommandBuilder builder = new OleDbCommandBuilder(adapter);
adapter.UpdateCommand = builder.GetUpdateCommand();
adapter.Update(DS, "Users");
}
catch (Exception err)
{ throw err; }
finally { MyConnction.Close(); }
}
public void insertInfo(string input)//插入信息
{
dataAdapter.InsertCommand = command.GetInsertCommand();
dataAdapter.UpdateCommand = command.GetUpdateCommand();
string[] inputs = Regex.Split(input, " ");
if (inputs.Length != 8)
{
Console.WriteLine("错误的输入格式");
}
else
{
DataRow dr = dataTable.NewRow();
dr["学号"] = int.Parse(inputs[0]);
dr["姓名"] = inputs[1];
dr["性别"] = inputs[2];
dr["班级"] = int.Parse(inputs[3]);
dr["邮箱"] = inputs[4];
dr["成绩1"] = int.Parse(inputs[5]);
dr["成绩2"] = int.Parse(inputs[6]);
dr["成绩3"] = int.Parse(inputs[7]);
dataTable.Rows.Add(dr);
dataAdapter.Update(dataTable);
Console.WriteLine("输入成功");
}
}
/// <summary>
/// 通过 OleDbDataAdapter 更新 DataSet 中变化的数据
/// </summary>
/// <param name="sqlstr">OleDbDataAdapter</param>
/// <param name="sqlstr">OleDbCommandBuilder</param>
/// <param name="sqlstr">DataSet</param>
/// <returns>布尔值</returns>
public static bool ExecuteUpdate(OleDbDataAdapter myAdapter, OleDbCommandBuilder myCommandBuilder, DataSet ds)
{
int i_return;
try
{
myAdapter.UpdateCommand = myCommandBuilder.GetUpdateCommand();
i_return = myAdapter.Update(ds);
ds.Dispose();
myAdapter.Dispose();
}
catch (Exception e)
{
throw new Exception(e.Message);
}
finally
{
closeConnection();
}
if (i_return > 0)
{
return(true);
}
else
{
return(false);
}
}
/*public static iDB2DataAdapter getiDB2DataAdapter(String DBType, String Sql, String sqlType)
* {
* iDB2DataAdapter da;
* iDB2Connection dbConn = new iDB2Connection();
* dbConn.ConnectionString = getConnStr(DBType);
* //dbConn.ConnectionString = "Provider=IBMDA400;Database=R21AFLBZ;Hostname=172.31.71.37;Uid=ITSDTS;Pwd=STD008;";
* if (dbConn.State != System.Data.ConnectionState.Open)
* dbConn.Open();
* da = new iDB2DataAdapter(Sql, dbConn);
* if (sqlType.ToUpper() == "PROCEDURE")
* {
* da.SelectCommand.CommandType = CommandType.StoredProcedure;
* }
* else
* {
* iDB2CommandBuilder builder = new iDB2CommandBuilder(da);
* try
* {
* da.DeleteCommand = builder.GetDeleteCommand();
* da.UpdateCommand = builder.GetUpdateCommand();
* da.InsertCommand = builder.GetInsertCommand();
* }
* catch (Exception e)
* {
* Console.WriteLine(e.ToString());
* }
* }
* return da;
* }
*/
public static OleDbDataAdapter getOleDbDataAdapter(DbConnection Conn, String Sql, String SqlType)
{
OleDbDataAdapter da;
OleDbConnection dbConn = (OleDbConnection)Conn;
//dbConn.ConnectionString = "Provider=IBMDA400;Database=R21AFLBZ;Hostname=172.31.71.37;Uid=ITSDTS;Pwd=STD008;";
if (dbConn.State != ConnectionState.Open)
{
dbConn.Open();
}
da = new OleDbDataAdapter(Sql, dbConn);
if (SqlType.ToUpper() == "PROCEDURE")
{
da.SelectCommand.CommandType = CommandType.StoredProcedure;
}
else
{
try
{
OleDbCommandBuilder builder = new OleDbCommandBuilder(da);
da.DeleteCommand = builder.GetDeleteCommand();
da.UpdateCommand = builder.GetUpdateCommand();
da.InsertCommand = builder.GetInsertCommand();
}
catch (Exception e)
{
Console.WriteLine(e.ToString());
}
}
return(da);
}
private void button_showTable_Click(object sender, EventArgs e)
{
BindingSource bs1 = new BindingSource();
// создаем экземпляр класса OleDbConnection
myConnection = new OleDbConnection(connectString.ConnectionString);
// открываем соединение с БД
myConnection.Open();
var changeTable = comboBox1.SelectedItem.ToString();
string sqlCommand = String.Format("SELECT * FROM {0}", changeTable);
da = new OleDbDataAdapter(sqlCommand, myConnection);
dt = new DataTable();
//фиксирование изменений
OleDbCommandBuilder bulder = new OleDbCommandBuilder(da);
da.UpdateCommand = bulder.GetUpdateCommand();
da.InsertCommand = bulder.GetInsertCommand();
da.DeleteCommand = bulder.GetDeleteCommand();
da.Fill(dt);
bs1.DataSource = dt;
//dataGridView1.DataSource = dt; //выводим в грид
bindingNavigator1.BindingSource = bs1;
dataGridView1.DataSource = bs1;
myConnection.Close();
}
private void button4_Click(object sender, EventArgs e)
{
OleDbCommandBuilder cb = new OleDbCommandBuilder(da);
bs.EndEdit();
da.UpdateCommand = cb.GetUpdateCommand();
da.Update(ds, "mor");
}
//--------------------------------------------------------
/// <summary>Creates a OleDbCommand object for the update stored procedure</summary>
/// <returns>Initalized OleDbCommand object</returns>
public virtual OleDbCommand GetUpdateCmd()
{
_da.SelectCommand = GetSelectCmd(0); //GetListCmd();
OleDbCommandBuilder builder = new OleDbCommandBuilder(_da);
builder.QuotePrefix = "[";
builder.QuoteSuffix = "]";
return(builder.GetUpdateCommand());
}
private void buttonDBSync_Click(object sender, EventArgs e)
{
OleDbCommandBuilder builder = new OleDbCommandBuilder(adapterArtikel);
adapterArtikel.DeleteCommand = builder.GetDeleteCommand();
adapterArtikel.InsertCommand = builder.GetInsertCommand();
adapterArtikel.UpdateCommand = builder.GetUpdateCommand();
adapterArtikel.Update(ds.Tables["Artikel"]);
}
void button1_Click(object sender, EventArgs e)
{
var cb = new OleDbCommandBuilder(adapter);
//cb.QuotePrefix = "["; cb.QuoteSuffix = "]";
adapter.UpdateCommand = cb.GetUpdateCommand();
adapter.InsertCommand = cb.GetInsertCommand();
adapter.Update(ds);
}
