private void DeleteButton_Click(object sender, EventArgs e)
{
DialogResult response;
response = MessageBox.Show("Sure ??", "Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2);
if (response == DialogResult.No)
{
return;
}
else
{
//Remove a record from a specified index
TokenWordManager.RemoveAt(TokenWordManager.Position);
builderCommand = new OleDbCommandBuilder(TokenWordAdapter);
TokenWordAdapter.Update(TokenWordTable);
return;
}
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
if (comboBox1.SelectedIndex > -1)
{
try
{
OleDbConnection connection = new OleDbConnection(cs);
set = new DataSet();
da = new OleDbDataAdapter($"SELECT * FROM {comboBox1.Items[comboBox1.SelectedIndex].ToString()}", connection);
dataGridView1.DataSource = null;
cmd = new OleDbCommandBuilder(da);
da.Fill(set, comboBox1.Items[comboBox1.SelectedIndex].ToString());
dataGridView1.DataSource =
set.Tables[comboBox1.Items[comboBox1.SelectedIndex].ToString()];
}
catch (Exception ex)
{
}
finally { }
}
}
/// <summary>
/// 使用数据集更新数据
/// </summary>
/// <param name="selectText">Select Sql</param>
/// <param name="ds">待更新数据集</param>
/// <param name="tableName">数据表名</param>
/// <returns>结果数</returns>
public static int UpdateDate(string selectText, DataSet ds, string tableName)
{
try
{
init();
OleDbDataAdapter adp = new OleDbDataAdapter(selectText, conn);
OleDbCommandBuilder builder = new OleDbCommandBuilder(adp);
builder.QuotePrefix = "[";
builder.QuoteSuffix = "]";
int nRetVal = adp.Update(ds, tableName);
conn.Close();
return(nRetVal);
}
catch (Exception e)
{
throw new Exception(e.Message.ToString());
}
}
public static void InsertClientProtocol(string[] str)
{
string selectCommandText = "SELECT * FROM protocol";
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;
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>
/// Creates a OleDbDataAdpter with the given CommandText and associates it with the site's Live or TestDB as appropriate.
/// </summary>
/// <returns></returns>
/// <remarks></remarks>
public OleDbDataAdapter DataAdapter(string CommandText, bool UseCommandBuilder)
{
OleDbDataAdapter DA = new OleDbDataAdapter(GetCommand(CommandText));
OleDbCommandBuilder cb = default(OleDbCommandBuilder);
if (UseCommandBuilder)
{
cb = new OleDbCommandBuilder(DA);
cb.SetAllValues = false;
DA.DeleteCommand = cb.GetDeleteCommand();
DA.UpdateCommand = cb.GetUpdateCommand();
DA.InsertCommand = cb.GetInsertCommand();
DA.InsertCommand.Connection = DA.SelectCommand.Connection;
DA.UpdateCommand.Connection = DA.SelectCommand.Connection;
DA.DeleteCommand.Connection = DA.SelectCommand.Connection;
}
return(DA);
}
public DataTable GetTimerNames()
{
if (dtTimerNames == null)
{
dtTimerNames = new DataTable();
string query = "SELECT * FROM TimerNames";
using (OleDbDataAdapter dAdapter = new OleDbDataAdapter(query, connString))
{
using (OleDbCommandBuilder cBuilder = new OleDbCommandBuilder(dAdapter))
{
dAdapter.Fill(dtTimerNames);
}
}
dtTimerNames.Columns.Add("Checked", typeof(bool));
foreach (DataRow row in dtTimerNames.Rows)
{
row["Checked"] = false;
}
}
return(dtTimerNames);
}
private void btnSil_Click(object sender, EventArgs e)
{
CurrencyManager sonraki = (CurrencyManager)this.BindingContext[al.Tables["MUSTERI"]];
DialogResult uyar;
uyar = MessageBox.Show(this, txtmusno.Text + " Müşteri No'lu kaydı silmek istiyor musunuz?", "Silme Uyarısı", MessageBoxButtons.YesNo, MessageBoxIcon.Stop, MessageBoxDefaultButton.Button2);
if (uyar == DialogResult.Yes)
{
cb = new OleDbCommandBuilder(verial);
sonraki.RemoveAt(sonraki.Position);
verial.Update(al, "MUSTERI");
al.Clear();
verial.Fill(al.Tables[0]);
grddatalistele.DataSource = al.Tables[0];
MessageBox.Show("Kayıt Silindi!");
}
else
{
MessageBox.Show("Silme işlemi iptal edildi!");
}
}
public void Edit(int RowId)
{
OleDbConnection con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=Diplom2.mdb");
con.Open();
OleDbDataAdapter da = new OleDbDataAdapter("select * from Load", con); //вытаскиваем нагрузку
OleDbCommandBuilder cb = new OleDbCommandBuilder(da);
DataSet ds = new DataSet(); //создаем датасет
da.Fill(ds, "Load"); // работаем с нагрузкой
ds.Tables["Load"].Rows[RowId]["Teacher"] = FIO; //вносим имя в новую строку
ds.Tables["Load"].Rows[RowId]["Subject"] = subject; //вносим предмет в новую строку
ds.Tables["Load"].Rows[RowId]["Groups"] = group; //вносим предмет в новую строку
ds.Tables["Load"].Rows[RowId]["Lecture"] = lec;
ds.Tables["Load"].Rows[RowId]["Practice"] = prac;
ds.Tables["Load"].Rows[RowId]["Hours"] = number; //вносим количество часов
da.Update(ds, "Load"); //закидываем апдейт в бд
con.Close(); //закрываем коннект
}
private void ADForm_Load(object sender, EventArgs e)
{
mConn.ConnectionString = @"Provider= Microsoft.Jet.OLEDB.4.0;Data Source =" + Application.StartupPath + @"\IdList.mdb ";
mConn.Open();
mAdapter = new OleDbDataAdapter("Select*From [IdList] where [mdlname]='K8512'", mConn);
mBuilder = new OleDbCommandBuilder(mAdapter);
mAdapter.Fill(mDatatable);
DataRow mrow;
mrow = mDatatable.Rows[0];
string tmp = Convert.ToString(mrow["mdlid"]);
int id = System.Convert.ToInt32(tmp, 16);
station_no = id;
mConn.Close();
mConn.Dispose();
if (-1 == station_no)
{
MessageBox.Show("未获取到模块地址！"); this.Close();
}
}
private void button8_Click(object sender, EventArgs e)
{
try
{
string instr = "insert into xercler (x_name,x_comment) values ('" + comboBox1.Text + "','" + textBox4.Text + "')";
OleDbCommand oc = new OleDbCommand(instr, con);
con.Open();
oc.ExecuteNonQuery();
con.Close();
oc = new OleDbCommand("select * from xercler", con);
oc.CommandType = CommandType.Text;
oda = new OleDbDataAdapter(oc);
ocb = new OleDbCommandBuilder(oda);
ds = new DataSet();
oda.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
con.Close();
}
catch (Exception ex) { MessageBox.Show("xahiş bütün xanalara məlumat daxil edin"); }
}
public static DbDataAdapter Adapter(string sql)
{
if (!Connected)
{
LastError = "Нет подключения!";
return(null);
}
var com = connection.CreateCommand();
com.CommandText = sql;
var ad = new OleDbDataAdapter(com);
try
{
var b = new OleDbCommandBuilder(ad);
ad.UpdateCommand = b.GetUpdateCommand();
ad.InsertCommand = b.GetInsertCommand();
}
catch { }
return(ad);
}
public override DbDataAdapter CreateAdapter(Table table, TableFilter filter)
{
var accessTable = (AccessTable)table;
var adapter = new OleDbDataAdapter(table.GetBaseSelectCommandText(filter), this.connection);
if (!table.IsReadOnly)
{
var builder = new OleDbCommandBuilder(adapter);
builder.ConflictOption = ConflictOption.OverwriteChanges;
try {
builder.GetUpdateCommand();
} catch (InvalidOperationException) {
accessTable.SetReadOnly(true);
return(adapter);
}
adapter.DeleteCommand = builder.GetDeleteCommand();
adapter.UpdateCommand = builder.GetUpdateCommand();
adapter.InsertCommand = builder.GetInsertCommand();
}
return(adapter);
}
private void button2_Click(object sender, EventArgs e)
{
//送数据入库
string _ID = Convert.ToString(dataGridView1.Rows.Count);
_XM = textBox1.Text.Trim();
_DZ = textBox2.Text.Trim();
_ZH = textBox3.Text.Trim();
comm.CommandText = "Insert Into Person_Tab (id,name,address,idcode) values ('"
+ _ID + "','" + _XM + "','" + _DZ + "','" + _ZH + "')";
comm.ExecuteNonQuery();
//再次查询
comm.CommandText = "select * from Person_Tab";
adapter.SelectCommand = comm;
OleDbCommandBuilder builder = new OleDbCommandBuilder(adapter);
//为表格控件刷新数据源
ds.Clear();
adapter.Fill(ds, "Person_Tab");
dataGridView1.Refresh();
}
// <Snippet1>
public DataSet CreateCmdsAndUpdate(string connectionString,
string queryString)
{
using (OleDbConnection connection = new OleDbConnection(connectionString))
{
OleDbDataAdapter adapter = new OleDbDataAdapter();
adapter.SelectCommand = new OleDbCommand(queryString, connection);
OleDbCommandBuilder builder = new OleDbCommandBuilder(adapter);
connection.Open();
DataSet customers = new DataSet();
adapter.Fill(customers);
//code to modify data in dataset here
adapter.Update(customers);
return(customers);
}
}
private void Audit_add(int number, bool lec, bool prac, string corp) //метод для внесения номеров аудиторий в таблицу
{
OleDbConnection con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=Diplom2.mdb");
con.Open();
OleDbDataAdapter da = new OleDbDataAdapter("select * from Audit", con); //получаем таблицу с номерами аудиторий
OleDbCommandBuilder cb = new OleDbCommandBuilder(da);
DataSet ds = new DataSet(); //создаем датасет
da.Fill(ds, "Audit"); // работаем с таблицей аудиторий
ds.Tables["Audit"].Rows.Add(); //создаем новую строку в таблице
int last = ds.Tables["Audit"].Rows.Count - 1; //берем айди новой строки
ds.Tables["Audit"].Rows[last]["Nomer"] = number; //вносим номер в новую строку
ds.Tables["Audit"].Rows[last]["Lecture"] = lec; //вносим тип заняти в новую строку
ds.Tables["Audit"].Rows[last]["Practice"] = prac; //вносим тип занятия в новую строку
ds.Tables["Audit"].Rows[last]["Corps"] = corp; //вносим корпус в новую строку
da.Update(ds, "Audit"); //закидываем апдейт в бд
con.Close(); //закрываем коннект
}
static public bool Add_Admin(clsAdmin admin)
{
bool job_done = false;
try
{
DataRow myRow = mySet.Tables["Admins"].NewRow();
myRow["UserID"] = admin.UserID;
myRow["AdminName"] = admin.Name;
myRow["PhoneNumber"] = admin.PhoneNumber;
mySet.Tables["Admins"].Rows.Add(myRow);
OleDbCommandBuilder myBuild = new OleDbCommandBuilder(adpAdmin);
adpAdmin.Update(mySet.Tables["Admins"]);
job_done = true;
}
catch
{
job_done = false;
}
return(job_done);
}
static public bool Edit_Sales(clsSales sales)
{
bool job_done = false;
foreach (DataRow myRow in mySet.Tables["Sales"].Rows)
{
if ((int)myRow["RefSales"] == sales.RefSales)
{
myRow["RefHouse"] = sales.RefHouse;
myRow["RefClient"] = sales.RefClient;
myRow["RefAgent"] = sales.RefAgent;
myRow["Description"] = sales.Description;
myRow["SalesDate"] = sales.SalesDate;
OleDbCommandBuilder myBuild = new OleDbCommandBuilder(adpSales);
adpSales.Update(mySet.Tables["Sales"]);
job_done = true;
break;
}
}
return(job_done);
}
//内表读数据，填datatable
private void readInnerData(Int32 ID)
{
if (!mySystem.Parameter.isSqlOk)
{
//读取记录表里的记录
bs记录详情 = new BindingSource();
dt记录详情 = new DataTable(tableInfo);
da记录详情 = new OleDbDataAdapter("select * from " + tableInfo + " where 换模芯ID = " + ID.ToString(), connOle);
cb记录详情 = new OleDbCommandBuilder(da记录详情);
da记录详情.Fill(dt记录详情);
}
else
{
//读取记录表里的记录
bs记录详情 = new BindingSource();
dt记录详情 = new DataTable(tableInfo);
da记录详情sql = new SqlDataAdapter("select * from " + tableInfo + " where 换模芯ID = " + ID.ToString(), mySystem.Parameter.conn);
cb记录详情sql = new SqlCommandBuilder(da记录详情sql);
da记录详情sql.Fill(dt记录详情);
}
}
private void 摄像头地理信息_Load(object sender, EventArgs e)
{
con.Open();
if (con.State == ConnectionState.Open)
{
sql = "select * from Location where 经度 is null";
thisAdapter = new OleDbDataAdapter(sql, con);
thisBuilder = new OleDbCommandBuilder(thisAdapter);
thisDataSet = new DataSet();
thisAdapter.Fill(thisDataSet, "Location");
for (int i = 0; i < thisDataSet.Tables[0].Rows.Count; i++)
{
if (i == 0)
{
comboBox1.Text = thisDataSet.Tables[0].Rows[i][5].ToString();
}
comboBox1.Items.Add(thisDataSet.Tables[0].Rows[i][5].ToString());
}
}
con.Close();
}
public static void AddDataFromDataset(DataSet dsDes, DataTable strTable)
{
OleDbConnection conn = new OleDbConnection(connectionString);
OleDbDataAdapter adapter = new OleDbDataAdapter("select * from " + strTable.TableName + "", conn);
DataSet ds = new DataSet();
adapter.Fill(ds, strTable.TableName);
OleDbCommandBuilder oledbCmdBuilder = new OleDbCommandBuilder(adapter);
adapter.MissingSchemaAction = MissingSchemaAction.Error;
for (int i = 0; i < dsDes.Tables[strTable.TableName].Rows.Count; i++)
{
DataRow dr = ds.Tables[strTable.TableName].NewRow();
for (int j = 0; j < dsDes.Tables[strTable.TableName].Columns.Count; j++)
{
dr[j] = dsDes.Tables[strTable.TableName].Rows[i][j];
}
ds.Tables[0].Rows.Add(dr);
}
adapter.Update(ds, strTable.TableName);
}
private void readOuterBind(int searchId)
{
if (!mySystem.Parameter.isSqlOk)
{
string tablename1 = "吹膜工序物料平衡记录";
bsOuter = new BindingSource();
dtOuter = new DataTable(tablename1);
daOuter = new OleDbDataAdapter("select * from " + tablename1 + " where ID =" + searchId + ";", connOle); // + " where 生产日期 = '" + dtp生产日期.Value.Date+"'", conOle);
cbOuter = new OleDbCommandBuilder(daOuter);
daOuter.Fill(dtOuter);
}
else
{
string tablename1 = "吹膜工序物料平衡记录";
bsOuter = new BindingSource();
dtOuter = new DataTable(tablename1);
daOutersql = new SqlDataAdapter("select * from " + tablename1 + " where ID =" + searchId + ";", mySystem.Parameter.conn); // + " where 生产日期 = '" + dtp生产日期.Value.Date+"'", conOle);
cbOutersql = new SqlCommandBuilder(daOutersql);
daOutersql.Fill(dtOuter);
}
}
public Data(string connectionString, string tableName, string selectQuery)
{
_connectionString = connectionString;
_tableName = tableName;
_selectQuery = selectQuery;
_connection = new OleDbConnection(_connectionString);
_connection.Open();
if (_connection.State == ConnectionState.Open)
{
_adapter = new OleDbDataAdapter(_selectQuery, _connection);
_dataSet = new DataSet();
_adapter.Fill(_dataSet, _tableName);
_commandBuilder = new OleDbCommandBuilder(_adapter);
}
}
public static void SaveOtherData(DataTable dt)
{
if (DatabaseType == "sql")
{
SqlDataAdapter da = new SqlDataAdapter("select * from " + dt.TableName, SqlCnn);
SqlCommandBuilder cb = new SqlCommandBuilder();
cb.QuotePrefix = "[";
cb.QuoteSuffix = "]";
cb.DataAdapter = da;
da.Update(dt);
}
else
{
OleDbDataAdapter da = new OleDbDataAdapter("select * from " + dt.TableName, AccessCnn);
OleDbCommandBuilder cb = new OleDbCommandBuilder();
cb.QuotePrefix = "[";
cb.QuoteSuffix = "]";
cb.DataAdapter = da;
da.Update(dt);
}
}
private void Form3_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'quasarDataSet5.masa3' table. You can move, or remove it, as needed.
this.masa3TableAdapter.Fill(this.quasarDataSet5.masa3);
oc = new OleDbCommand("select qida_id, qida_adi,qiymet from qida_elave_et where alt_qida='true'", con);
con.Open();
odr = oc.ExecuteReader();
while (odr.Read())
{
comboBox1.Items.Add(odr.GetValue(0) + ")" + odr.GetValue(1) + "_" + odr.GetValue(2));
}
oc = new OleDbCommand("select * from masa3", con);
oc.CommandType = CommandType.Text;
oda = new OleDbDataAdapter(oc);
ocb = new OleDbCommandBuilder(oda);
ds = new DataSet();
oda.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
con.Close();
}
public bool ReadImmuHeader(OleDbConnection connect, object p)
{
string sql = "SELECT * FROM IMMUNIZATIONHEADERFILE";
OleDbDataAdapter adapter = new OleDbDataAdapter(sql, connect);
OleDbCommandBuilder builder = new OleDbCommandBuilder(adapter);
DataSet dataset = new DataSet();
adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;
adapter.Fill(dataset, "IMMUNIZATIONHEADERFILE");
DataRow row = dataset.Tables["IMMUNIZATIONHEADERFILE"].Rows.Find(p);
if (row == null)
{
return(true);
}
else
{
return(false);
}
}
public override int BlockCommand(DataTable dt)
{
lock (lockObject)
{
int result = 0;
if (!CheckConn())
{
return(0);
}
if (dt.TableName == "")
{
All.Class.Error.Add("无法完成批量数据更新,数据表名不能为空");
All.Class.Error.Add(Environment.StackTrace);
return(0);
}
try
{
using (OleDbCommand cmd = new OleDbCommand(string.Format("select * from {0}", dt.TableName), conn))
{
using (OleDbDataAdapter ada = new OleDbDataAdapter(cmd))
{
using (OleDbCommandBuilder scb = new OleDbCommandBuilder(ada))
{
ada.InsertCommand = scb.GetInsertCommand();
ada.DeleteCommand = scb.GetDeleteCommand();
ada.UpdateCommand = scb.GetUpdateCommand();
result = ada.Update(dt);
}
}
}
}
catch (Exception e)
{
All.Class.Error.Add(string.Format("出错Table为：{0}", dt.TableName));
All.Class.Error.Add(e);//数据库中一定要有主键，不然当前方法会出错。即没有办法生成删除命令
}
return(result);
}
}
private void btnSearchRecord_Click(object sender, EventArgs e)
{
DateTime dt = dtpDate.Value;
string dtStr = dt.ToString("yyyy-MM-dd");
cmbID.Items.Clear();
try
{
string connectstring = "provider=Microsoft.jet.OLEDB.4.0;Data Source=accountsystem.mdb;Jet OleDb:Database Password=lxw618";
string sqlcommand = "select [ID] as 数据号,[username] as 用户名,[date] as 收支日期,[money] as 金额,[item] as 收支项目,[type] as 收支类型,[memo] as 备注 from [Money] where [username]='" + cmbUsername.Text + "' and [date]=#" + dtStr + "# order by [ID]";
OleDbConnection aConnection = new OleDbConnection(connectstring);
aConnection.Open();
OleDbDataAdapter adp = new OleDbDataAdapter(sqlcommand, connectstring);
DataSet ds = new DataSet();
adp.Fill(ds, "Money");
dgvChangeRecord.DataSource = ds.Tables["Money"];
OleDbCommandBuilder cbMoney = new OleDbCommandBuilder(adp);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "系统错误");
}
try
{
string connectstring = "provider=Microsoft.jet.OLEDB.4.0;Data Source=accountsystem.mdb;Jet OleDb:Database Password=lxw618";
string sqlcommand = "select [ID] from [Money] where [username]='" + cmbUsername.Text + "' and [date]=#" + dtStr + "# order by [ID]";
OleDbConnection aConnection = new OleDbConnection(connectstring);
aConnection.Open();
OleDbCommand aCommand = new OleDbCommand(sqlcommand, aConnection);
OleDbDataReader reader = aCommand.ExecuteReader();
while (reader.Read())
{
cmbID.Items.Add(reader.GetInt32(0));
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "系统错误");
}
}
public void QuoteUnquote_CustomPrefixSuffix_Success()
{
RunTest((command, tableName) => {
command.CommandType = CommandType.StoredProcedure;
command.CommandText = @"SELECT * FROM " + tableName;
using (var adapter = new OleDbDataAdapter(command.CommandText, connection))
using (var builder = new OleDbCommandBuilder(adapter))
{
// Custom prefix & suffix
builder.QuotePrefix = "'";
builder.QuoteSuffix = "'";
Assert.Equal(adapter, builder.DataAdapter);
Assert.Equal("'Test'", builder.QuoteIdentifier("Test", connection));
Assert.Equal("'Te''st'", builder.QuoteIdentifier("Te'st", connection));
Assert.Equal("Test", builder.UnquoteIdentifier("'Test'", connection));
Assert.Equal("Te'st", builder.UnquoteIdentifier("'Te''st'", connection));
// Ensure we don't need active connection:
Assert.Equal("'Test'", builder.QuoteIdentifier("Test", null));
Assert.Equal("Test", builder.UnquoteIdentifier("'Test'", null));
builder.QuotePrefix = string.Empty;
string quoteErrMsg = $"{nameof(builder.QuoteIdentifier)} requires open connection when the quote prefix has not been set.";
string unquoteErrMsg = $"{nameof(builder.UnquoteIdentifier)} requires open connection when the quote prefix has not been set.";
Assert.Equal("`Test`", builder.QuoteIdentifier("Test", connection));
Assert.Equal("Test", builder.UnquoteIdentifier("`Test`", connection));
Assert.NotNull(adapter.SelectCommand.Connection);
Assert.Equal("`Test`", builder.QuoteIdentifier("Test"));
Assert.Equal("Test", builder.UnquoteIdentifier("`Test`"));
adapter.SelectCommand.Connection = null;
AssertExtensions.Throws <InvalidOperationException>(() => builder.QuoteIdentifier("Test"), quoteErrMsg);
AssertExtensions.Throws <InvalidOperationException>(() => builder.UnquoteIdentifier("'Test'"), unquoteErrMsg);
}
command.CommandType = CommandType.Text;
});
}
//utility function to get data from db, according to the select command,
// then populate the gridview with that data, and format the gridview.
private void showPlayerData(string sqlselectcmd)
{
try
{
// Create a new data adapter based on the specified query.
OleDbDataAdapter dataAdapter = new OleDbDataAdapter();
dataAdapter = new OleDbDataAdapter(sqlselectcmd, Globals.g_dbConnection);
OleDbCommandBuilder commandBuilder = new OleDbCommandBuilder(dataAdapter);
// Populate a new data table and bind it to the BindingSource.
DataTable table = new DataTable();
dataAdapter.Fill(table);
dataGridView.DataSource = table;
dataGridView.Columns["playerID"].Visible = false;
dataGridView.Columns["fName"].HeaderText = "First Name";
dataGridView.Columns["lName"].HeaderText = "Last Name";
dataGridView.Columns["phone"].HeaderText = "Phone";
dataGridView.Columns["handicap"].HeaderText = "Handicap";
dataGridView.Columns["fName"].Width = 170;
dataGridView.Columns["lName"].Width = 170;
dataGridView.Columns["phone"].Width = 90;
dataGridView.Columns["handicap"].Width = 80;
dataGridView.Columns["phone"].DefaultCellStyle.Format = "(999) 000-0000";
dataGridView.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
dataGridView.MultiSelect = false;
dataGridView.ReadOnly = true;
dataGridView.ClearSelection();
//Note the last used command. Used later in refreshing the grid.
g_strLastSelectCmd = sqlselectcmd;
//Update total player count
labelTotalMemberCount.Text = "Total Members: " + dataGridView.Rows.Count;
}
catch (OleDbException)
{
MessageBox.Show("ERROR: Could not load players due to an unspecified database error.");
}
}
private void NewDic_Update_Click(object sender, EventArgs e)
{
for (int i = 0; i < NewDicGrid.Rows.Count - 1; i++)
{
if (NewDicGrid.Rows[i].Cells[0].Value == null || NewDicGrid.Rows[i].Cells[0].Value.ToString() == "")
{
MessageBox.Show("Empty key");
NewDicGrid.CurrentCell = NewDicGrid.Rows[i].Cells[1];
return;
}
else
{
NewDicGrid.Rows[i].Cells[0].Value = Regex.Replace(NewDicGrid.Rows[i].Cells[0].Value.ToString(), @"\b\s+\b", " ").Trim(' ');
}
}
NewDicGrid.EndEdit();
string sql = "select OriginalField,TranslationField from NewDictionary order by OriginalField";
OleDbConnection thisConnection = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=dictionary.accdb;Persist Security Info=False");
OleDbDataAdapter da = new OleDbDataAdapter(sql, thisConnection);
OleDbCommandBuilder bld = new OleDbCommandBuilder(da);
thisAdapter.UpdateCommand = bld.GetUpdateCommand();
DataTable dt = (DataTable)NewDicGrid.DataSource;
try
{
da.Update(dt);
}
catch (OleDbException)
{
MessageBox.Show("Duplicate keys");
}
thisConnection.Close();
}
