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 SaveEnrolls(DataSet ds)
{
OleDbConnection conn = GetConnection();
try
{
string sql = "select * from tblEnroll";
OleDbDataAdapter da = new OleDbDataAdapter(sql, conn);
OleDbCommandBuilder cb = new OleDbCommandBuilder(da);
try
{
da.InsertCommand = cb.GetInsertCommand(true);
if (ds.HasChanges())
{
da.Update(ds, "tblEnroll");
ds.AcceptChanges();
}
}
finally
{
cb.Dispose();
da.Dispose();
}
}
finally
{
conn.Close();
conn.Dispose();
}
}
public void SetData()
{
string MdbFilePath = @"C:\Users\MSI-NB\Desktop\新建文件夹 (2)\剑圣60-img数据库2020年02月11日11点51分50秒.mdb";
OleDbConnection conn = new OleDbConnection($"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={MdbFilePath}");
OleDbCommand oleDbCommand = new OleDbCommand("select * from ImagePacks2", conn);
OleDbDataAdapter oleDbData = new OleDbDataAdapter(oleDbCommand);
OleDbCommandBuilder oleDbCommandBuilder = new OleDbCommandBuilder(oleDbData);
DataTable dataTable = new DataTable();
oleDbData.Fill(dataTable);
//DataTable dataTable2 = new DataTable("ImagePacks2");
//dataTable2.TableName = "ImagePacks2";
object[] vs = new object [4];
vs[0] = 68001;
vs[1] = "999";
vs[2] = "999";
vs[3] = "999";
dataTable.Rows.Add(vs);
oleDbData.Update(dataTable);
oleDbCommandBuilder.Dispose();
}
protected void move(int i_RowNum, string str_Direct, string as_Sql)
{
OleDbDataAdapter OleAdp = DBFun.UpdateDataSet(as_Sql);
DataSet Ds = new DataSet();
OleAdp.Fill(Ds, "t1");
if (i_RowNum >= 0 && i_RowNum < Ds.Tables[0].Rows.Count)
{
if (str_Direct.ToUpper() == "UP")
{
if (i_RowNum == 0)
{
Response.Write("<script>alert('已经是第一行，不能再上移了！');</script>");
return;
}
Ds.Tables[0].Rows[i_RowNum]["orderID"] = i_RowNum;
Ds.Tables[0].Rows[i_RowNum - 1]["orderID"] = i_RowNum + 1;
}
else
{
if (i_RowNum == Ds.Tables[0].Rows.Count - 1)
{
Response.Write("<script>alert('已经是最后一行，不能再下移了！');</script>");
return;
}
Ds.Tables[0].Rows[i_RowNum]["orderID"] = i_RowNum + 2;
Ds.Tables[0].Rows[i_RowNum + 1]["orderID"] = i_RowNum + 1;
}
}
//Ds.AcceptChanges();
OleDbCommandBuilder odcb = new OleDbCommandBuilder(OleAdp);
Ds.Tables[0].GetChanges();
int i_return = OleAdp.Update(Ds, "t1");
Ds.Tables[0].AcceptChanges();
//DataView dv = new DataView();
//dv.Table = Ds.Tables[0];
//dv.Sort = "orderid asc";
//gv_jxgzjl.DataSource = dv;
//gv_jxgzjl.DataBind();
//if (i_return != 0)
// Response.Write("<script>alert('成功！');</script>");
//else
// Response.Write("<script>alert('失败！');</script>");
odcb.Dispose();
OleAdp.Dispose();
Ds.Dispose();
bindData();
}
private void btnInserir_Click(object sender, EventArgs e)
{
// definir a string de conexão
string sDBstr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=dados\Teste.mdb";
//definir a string SQL
string sSQL = "SELECT * from Clientes";
//criar o objeto connection
OleDbConnection oCn = new OleDbConnection(sDBstr);
//abrir a conexão
oCn.Open();
//criar o data adapter e executar a consulta
OleDbDataAdapter oDA = new OleDbDataAdapter(sSQL, oCn);
//criar o DataSet
DataSet oDs = new DataSet();
//Preencher o dataset coom o data adapter
oDA.Fill(oDs, "Clientes");
//criar um objeto Data Row
DataRow oDR = oDs.Tables["Clientes"].NewRow();
//Preencher o datarow com valores
oDR["Nome"] = "Testolino";
oDR["Email"] = "*****@*****.**";
//Incluir um datarow ao dataset
oDs.Tables["Clientes"].Rows.Add(oDR);
//Usar o objeto Command Bulder para gerar o Comandop Insert
OleDbCommandBuilder oCB = new OleDbCommandBuilder(oDA);
//Atualizar o BD com valores do Dataset
oDA.Update(oDs, "Clientes");
//liberar o data adapter , o dataset , o comandbuilder e a conexao
oDA.Dispose();
oDs.Dispose();
oCB.Dispose();
oCn.Dispose();
//exibir o resultado
ExibirDados();
}
private void btnAtualizar_Click(object sender, EventArgs e)
{
// definir a string de conexão
string sDBstr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=dados\Teste.mdb";
//definir a string SQL
string sSQL = "SELECT * from Clientes";
//criar o objeto connection
OleDbConnection oCn = new OleDbConnection(sDBstr);
//abrir a conexão
oCn.Open();
//criar o data adapter e executar a consulta
OleDbDataAdapter oDA = new OleDbDataAdapter(sSQL, oCn);
//criar o DataSet
DataSet oDs = new DataSet();
//Preencher o dataset coom o data adapter
oDA.Fill(oDs, "Clientes");
//cria o DataSet atribuindo ao DataRow o valor da linha que desejamos atualizar
DataRow oDR = oDs.Tables["Clientes"].Rows[5];
//Preenche o datarow with valores
oDR["Nome"] = "Maria";
oDR["Email"] = "*****@*****.**";
//Usar o objeto Command Bulder para gerar o Comando Update
OleDbCommandBuilder oCB = new OleDbCommandBuilder(oDA);
//Atualizar o BD com valores do Dataset
oDA.Update(oDs, "Clientes");
//liberar o data adapter , o dataset , o comandbuilder e a conexao
oDA.Dispose();
oDs.Dispose();
oCB.Dispose();
oCn.Dispose();
//exibir o resultado
ExibirDados();
}
public static void UpdatetableOLE(OleDbDataAdapter dax, DataTable dtx, BindingSource bsx)
{
var ci = bsx.Position;
if (ci > 0)
{
bsx.MovePrevious(); bsx.MoveNext();
}
else
{
bsx.MovePrevious();
}
OleDbCommandBuilder cb1 = new OleDbCommandBuilder(dax);
cb1.GetUpdateCommand();
dax.Update(dtx);
dax.SelectCommand.CommandTimeout = 300;
dtx.AcceptChanges();
cb1.Dispose();
}
private void btnExcluir_Click(object sender, EventArgs e)
{
// definir a string de conexão
string sDBstr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=dados\Teste.mdb";
//definir a string SQL
string sSQL = "SELECT * from Clientes";
//criar o objeto connection
OleDbConnection oCn = new OleDbConnection(sDBstr);
//abrir a conexão
oCn.Open();
//criar o data adapter e executar a consulta
OleDbDataAdapter oDA = new OleDbDataAdapter(sSQL, oCn);
//criar o DataSet
DataSet oDs = new DataSet();
//Preencher o dataset coom o data adapter
oDA.Fill(oDs, "Clientes");
//Exclui a linha desejada
oDs.Tables["Clientes"].Rows[5].Delete();
// Usar o objeto Command Bulder para gerar o Comandop Delete
OleDbCommandBuilder oCB = new OleDbCommandBuilder(oDA);
//Atualizar o BD com valores do Dataset
oDA.Update(oDs, "Clientes");
//liberar o data adapter , o dataset , o comandbuilder e a conexao
oDA.Dispose();
oDs.Dispose();
oCB.Dispose();
oCn.Dispose();
//exibir o resultado
ExibirDados();
}
private void SaveRegisto(Registos reg)
{
try
{
var da = new OleDbDataAdapter("select * from tbl_registos", _cnn);
var cmdb = new OleDbCommandBuilder(da);
OleDbCommand cmd = cmdb.GetInsertCommand();
cmd.Parameters[0].Value = reg.IdColaborador;
cmd.Parameters[1].Value = reg.Data;
cmd.Parameters[2].Value = reg.Tipo;
cmd.Parameters[3].Value = reg.Observações ?? "";
cmd.ExecuteNonQuery();
cmd.Dispose();
cmdb.Dispose();
da.Dispose();
}
catch (Exception ex)
{
throw ex;
}
}
public static void UpdateOle(OleDbDataAdapter dax, DataSet dsx, BindingSource bsx)
{
var ci = bsx.Position;
if (ci > 0)
{
bsx.MovePrevious();
bsx.MoveNext();
}
else
{
bsx.MovePrevious();
}
try
{
OleDbCommandBuilder cb = new OleDbCommandBuilder(dax);
cb.GetUpdateCommand();
dax.Update(dsx.Tables[0]);
dax.SelectCommand.CommandTimeout = 300;
dsx.AcceptChanges();
cb.Dispose();
}
catch { MessageBox.Show("Can not Save! Please check again"); }
}
public void Clear()
{
_adapter?.Dispose();
_builder?.Dispose();
_currentTable?.Clear();
}
