本文整理汇总了C#中System.Data.DataSet.RejectChanges方法的典型用法代码示例。如果您正苦于以下问题:C# DataSet.RejectChanges方法的具体用法?C# DataSet.RejectChanges怎么用?C# DataSet.RejectChanges使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.DataSet
的用法示例。
在下文中一共展示了DataSet.RejectChanges方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: EditFallidasRemoteServer
public static void EditFallidasRemoteServer(DataSet dt, ref int? codigoError, bool grabarFallidas)
{
MySqlTransaction tr = null;
try
{
MySqlConnection SqlConnection1 = DALBase.GetRemoteConnection();
SqlConnection1.Open();
DAL.FondoCajaDAL.GrabarDB(dt, SqlConnection1);
SqlConnection1.Close();
BL.FallidasBLL.BorrarFondoCajaFallidasByAccion("Modified");
}
catch (MySqlException ex)
{
if (ex.Number == 1042) //no se pudo abrir la conexion por falta de internet
{
dt.RejectChanges();
codigoError = 1042;
}
else
{
dt.RejectChanges();
if (tr != null)
{
tr.Rollback();
}
codigoError = ex.Number;
}
}
catch (TimeoutException)
{
}
}
示例2: InsertRemotos
public static void InsertRemotos(DataSet dt, MySqlConnection conn, MySqlTransaction tr)
{
try
{
MySqlDataAdapter da = AdaptadorInsert(conn, tr);
da.Update(dt, "AlicuotasIva");
}
catch (MySqlException ex)
{
MessageBox.Show(ex.ToString(), "Trend", MessageBoxButtons.OK, MessageBoxIcon.Information);
dt.RejectChanges();
}
}
示例3: GrabarDB
public static void GrabarDB(DataSet dt, MySqlConnection SqlConnection1)
{
try
{
MySqlDataAdapter da = AdaptadorABM(SqlConnection1);
da.Update(dt, "FondoCaja");
}
catch (MySqlException)
{
// MessageBox.Show(ex.ToString(), "Trend", MessageBoxButtons.OK, MessageBoxIcon.Information);
dt.RejectChanges();
}
}
示例4: InsertarRemotos
public static void InsertarRemotos(DataSet dt)
{
MySqlTransaction tr = null;
try
{
MySqlConnection SqlConnection1 = DALBase.GetConnection();
SqlConnection1.Open();
tr = SqlConnection1.BeginTransaction();
DAL.ArticulosDAL.InsertarRemotos(dt, SqlConnection1, tr);
tr.Commit();
SqlConnection1.Close();
}
catch (MySqlException ex)
{
MessageBox.Show(ex.ToString(), "Trend", MessageBoxButtons.OK, MessageBoxIcon.Information);
dt.RejectChanges();
tr.Rollback();
}
}
示例5: GrabarVentasFallidas
public static void GrabarVentasFallidas(DataSet dt, MySqlConnection conn)
{
try
{
MySqlDataAdapter da = AdaptadorVentasFallidas(conn);
da.Update(dt, "VentasFallidas");
}
catch (MySqlException ex)
{
MessageBox.Show(ex.ToString(), "Trend", MessageBoxButtons.OK, MessageBoxIcon.Information);
dt.RejectChanges();
}
}
示例6: NewsEditSet
public string NewsEditSet(string tbl, int wh, string title, byte[] zipContents, string imageMode, byte[] buffer, string ext, string legal)
{
string msg = string.Empty;
if (tLegal == legal.Trim() && isDaysLeft)
{
tbl = tbl.Trim();
title = title.Trim();
string body = Zipper.DecompressToStrng(zipContents).Trim();
ext = ext.Trim();
string sqlStr = "SELECT * FROM " + tbl;
try
{
OleDbConnection cnn = new OleDbConnection(Base.cnnStr);
OleDbDataAdapter oda = new OleDbDataAdapter(sqlStr, cnn);
OleDbCommandBuilder ocb = new OleDbCommandBuilder(oda);
cnn.Open();
OleDbCommand cmd = new OleDbCommand(sqlStr, cnn);
OleDbDataReader drr = cmd.ExecuteReader();
DataSet ds = new DataSet();
DataTable dt = new DataTable();
DataRow dr;
ocb.QuotePrefix = "[";
ocb.QuoteSuffix = "]";
oda.Fill(ds, tbl);
dt = ds.Tables[tbl];
for (int i = 0; i < dt.Rows.Count; i++)
{
dr = dt.Rows[i];
if (Convert.ToInt32(dr["id"]) == wh)
{
dr.BeginEdit();
dr["header"] = EncDec.Encrypt(title.Trim(), Base.hashKey);
dr["body"] = EncDec.Encrypt(body.Trim(), Base.hashKey);
switch (imageMode)
{
case "old":
break;
case "clean":
if (dr["pic"].ToString().Trim() != string.Empty)
{
msg = RemoveImages(new string[] { dr["pic"].ToString().Trim() });
if (msg != "Removed")
return msg;
dr["pic"] = string.Empty;
}
break;
case "new":
if (dr["pic"].ToString().Trim() != string.Empty)
{
msg = RemoveImages(new string[] { dr["pic"].ToString().Trim() });
if (msg != "Removed")
return msg;
dr["pic"] = string.Empty;
}
//msg = CatchImages("{" + tbl + "}/{" + wh + "}", new byte[][] { buffer }, new string[] { ext }, true);
msg = CatchImages(tbl , new byte[][] { buffer }, new string[] { ext }, true);
if (msg != "Created")
return msg;
dr["pic"] = pgImages[0];
break;
default:
break;
}
dr.EndEdit();
break;
}
}
if (oda.Update(ds, tbl) == 1)
{
ds.AcceptChanges();
msg = "Updated";
}
else
{
ds.RejectChanges();
msg = "Rejected";
}
cnn.Close();
drr.Close();
ds.Dispose();
cmd.Dispose();
drr.Dispose();
ocb.Dispose();
oda.Dispose();
cnn.Dispose();
dt.Dispose();
//.........这里部分代码省略.........
示例7: SaveProxy
private void SaveProxy()
{
string tbl = "proxy";
string sqlStr = "SELECT * FROM " + tbl;
try
{
OleDbConnection cnn = new OleDbConnection(Base.cnnStrLocal);
OleDbDataAdapter oda = new OleDbDataAdapter(sqlStr, cnn);
OleDbCommandBuilder ocb = new OleDbCommandBuilder(oda);
cnn.Open();
DataSet ds = new DataSet();
DataTable dt = new DataTable();
DataRow dr;
ocb.QuotePrefix = "[";
ocb.QuoteSuffix = "]";
oda.Fill(ds, tbl);
dt = ds.Tables[tbl];
dr = dt.Rows[0];
dr.BeginEdit();
dr["useie"] = Base.proxyUseDefault;
if (Base.proxyUseDefault)
{
dr["addr"] = "{IE}";
dr["port"] = "{IE}";
}
else
{
dr["addr"] = Base.proxyAddr;
dr["port"] = Base.proxyPort;
}
dr.EndEdit();
oda.UpdateCommand = ocb.GetUpdateCommand();
if (oda.Update(ds, tbl) == 1)
{
ds.AcceptChanges();
MessageBox.Show("تنظیمات پراکسی اعمال شد", Base.msgTitle, MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1);
}
else
{
ds.RejectChanges();
}
cnn.Close();
ds.Dispose();
ocb.Dispose();
oda.Dispose();
cnn.Dispose();
dt.Dispose();
ds = null;
ocb = null;
oda = null;
dr = null;
dt = null;
cnn = null;
}
catch (Exception ex)
{
MessageBox.Show(Base.errPrefix + ex.Message, Base.msgTitle, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
tbl = null;
sqlStr = null;
}
}
示例8: GrabarDB
public static void GrabarDB(DataSet dt, DataTable tblFallidas ,ref int? codigoError, bool grabarFallidas)
{
try
{
if (grabarFallidas == false)
{
DataSet dsRemoto;
dsRemoto = dt.GetChanges();
DAL.ClientesDAL.GrabarDB(dt, grabarFallidas);
lock (_sync)
{
Thread t = new Thread(() => ThreadSaveEnRemoteServer(dsRemoto, tblFallidas));
t.Start();
}
}
else
{
DAL.ClientesDAL.GrabarDB(dt, grabarFallidas);
}
}
catch (MySqlException ex)
{
if (ex.Number == 1042) //no se pudo abrir la conexion por falta de internet
{
dt.RejectChanges(); ;
codigoError = 1042;
}
else
{
dt.RejectChanges();
codigoError = ex.Number;
}
}
}
示例9: RuleTest
public void RuleTest ()
{
DataSet ds = new DataSet ("testds");
DataTable parent = ds.Tables.Add ("parent");
DataTable child = ds.Tables.Add ("child");
parent.Columns.Add ("id", typeof (int));
parent.Columns.Add ("name", typeof (string));
parent.PrimaryKey = new DataColumn [] {parent.Columns ["id"]} ;
child.Columns.Add ("id", typeof (int));
child.Columns.Add ("parent", typeof (int));
child.Columns.Add ("name", typeof (string));
child.PrimaryKey = new DataColumn [] {child.Columns ["id"]} ;
DataRelation relation = ds.Relations.Add ("parent_child",
parent.Columns ["id"],
child.Columns ["parent"]);
parent.Rows.Add (new object [] {1, "mono test 1"});
parent.Rows.Add (new object [] {2, "mono test 2"});
parent.Rows.Add (new object [] {3, "mono test 3"});
child.Rows.Add (new object [] {1, 1, "mono child test 1"});
child.Rows.Add (new object [] {2, 2, "mono child test 2"});
child.Rows.Add (new object [] {3, 3, "mono child test 3"});
ds.AcceptChanges ();
parent.Rows [0] ["name"] = "mono changed test 1";
Assert.AreEqual (DataRowState.Unchanged, parent.Rows [0].GetChildRows (relation) [0].RowState,
"#RT1 child should not be modified");
ds.RejectChanges ();
parent.Rows [0] ["id"] = "4";
DataRow childRow = parent.Rows [0].GetChildRows (relation) [0];
Assert.AreEqual (DataRowState.Modified, childRow.RowState, "#RT2 child should be modified");
Assert.AreEqual (4, (int) childRow ["parent"], "#RT3 child should point to modified row");
}
示例10: InsertFallidasRemoteServer
public static void InsertFallidasRemoteServer(DataSet dt, ref int? codigoError, bool grabarFallidas)
{
try
{
DAL.TesoreriaMovimientosDAL.GrabarDB(dt, grabarFallidas);
DAL.FallidasDAL.BorrarTesoreriaFallidasByAccion("Added");
}
catch (MySqlException ex)
{
if (ex.Number == 1042) //no se pudo abrir la conexion por falta de internet
{
dt.RejectChanges(); ;
codigoError = 1042;
}
else
{
dt.RejectChanges();
codigoError = ex.Number;
}
}
catch (TimeoutException)
{
}
}
示例11: PreferencesSet
public string PreferencesSet(string tag, string val, string legal)
{
string msg = string.Empty;
if (tLegal == legal.Trim() && isDaysLeft)
{
tag = tag.Trim();
val = val.Trim();
string tbl = "preferences";
string sqlStr = "SELECT * FROM " + tbl;
try
{
OleDbConnection cnn = new OleDbConnection(Base.cnnStr);
OleDbDataAdapter oda = new OleDbDataAdapter(sqlStr, cnn);
OleDbCommandBuilder ocb = new OleDbCommandBuilder(oda);
OleDbCommand cmd = new OleDbCommand(sqlStr, cnn);
cnn.Open();
OleDbDataReader drr = cmd.ExecuteReader();
DataSet ds = new DataSet();
DataTable dt = new DataTable();
DataRow dr;
ocb.QuotePrefix = "[";
ocb.QuoteSuffix = "]";
oda.Fill(ds, tbl);
dt = ds.Tables[tbl];
for (int i = 0; i < dt.Rows.Count; i++)
{
dr = dt.Rows[i];
if (dr["tag"].ToString().Trim() == tag)
{
dr.BeginEdit();
dr["val"] = val;
dr.EndEdit();
oda.UpdateCommand = ocb.GetUpdateCommand();
if (oda.Update(ds, tbl) == 1)
{
ds.AcceptChanges();
msg = "OK";
}
else
{
ds.RejectChanges();
msg = "Rejected";
}
break;
}
}
drr.Close();
cnn.Close();
cmd.Dispose();
drr.Dispose();
ds.Dispose();
ocb.Dispose();
oda.Dispose();
cnn.Dispose();
dt.Dispose();
cmd = null;
drr = null;
ds = null;
ocb = null;
oda = null;
dr = null;
dt = null;
cnn = null;
}
catch(Exception ex)
{
msg = ex.Message;
}
finally
{
tbl = null;
sqlStr = null;
}
}
return msg;
}
示例12: CleanTable
private bool CleanTable(string tbl)
{
bool success = true;
try
{
string sqlStr = "SELECT * FROM " + tbl;
OleDbConnection cnn = new OleDbConnection(Base.cnnStr);
OleDbDataAdapter oda = new OleDbDataAdapter(sqlStr, cnn);
OleDbCommandBuilder ocb = new OleDbCommandBuilder(oda);
cnn.Open();
DataSet ds = new DataSet();
DataTable dt = new DataTable();
oda.Fill(ds, tbl);
dt = ds.Tables[tbl];
foreach (DataRow dr in dt.Rows)
dr.Delete();
oda.DeleteCommand = ocb.GetDeleteCommand();
if (oda.Update(ds, tbl) == 1)
ds.AcceptChanges();
else
ds.RejectChanges();
cnn.Close();
dt.Dispose();
ds.Dispose();
ocb.Dispose();
oda.Dispose();
cnn.Dispose();
dt = null;
ds = null;
ocb = null;
oda = null;
cnn = null;
sqlStr = null;
}
catch
{
success = false;
}
finally
{
}
return success;
}
示例13: GoogleErase
public string GoogleErase(string mailbox, string legal)
{
string msg = string.Empty;
if (tLegal == legal.Trim() && isDaysLeft)
{
mailbox = mailbox.Trim();
string tbl = "google";
string sqlStr = "SELECT * FROM " + tbl;
try
{
OleDbConnection cnn = new OleDbConnection(Base.cnnStr);
OleDbDataAdapter oda = new OleDbDataAdapter(sqlStr, cnn);
OleDbCommandBuilder ocb = new OleDbCommandBuilder(oda);
cnn.Open();
DataSet ds = new DataSet();
DataTable dt = new DataTable();
DataRow dr;
ocb.QuotePrefix = "[";
ocb.QuoteSuffix = "]";
oda.Fill(ds, tbl);
bool found = false;
dt = ds.Tables[tbl];
mailbox = EncDec.Encrypt(mailbox, Base.hashKey);
for (int i = 0; i < dt.Rows.Count; i++)
{
dr = dt.Rows[i];
if (dr["mailbox"].ToString().Trim() == mailbox)
{
found = true;
dr.Delete();
oda.DeleteCommand = ocb.GetDeleteCommand();
if (oda.Update(ds, tbl) == 1)
{
msg = CleanPageImages(tbl + "\\" + mailbox);
if (msg != "Cleaned")
return msg;
ds.AcceptChanges();
msg = "Erased";
}
else
{
ds.RejectChanges();
msg = "Rejected";
}
break;
}
}
if (!found)
msg = "Not Found";
cnn.Close();
ds.Dispose();
dt.Dispose();
ocb.Dispose();
oda.Dispose();
cnn.Dispose();
ds = null;
ocb = null;
oda = null;
dr = null;
dt = null;
cnn = null;
}
catch (Exception ex)
{
msg = ex.Message;
}
finally
{
tbl = null;
sqlStr = null;
}
}
else
msg = errInvalidLegal;
return msg;
}
示例14: GoogleEdit
public string GoogleEdit(string mailbox, string newMailbox, string legal)
{
string msg = string.Empty;
if (tLegal == legal.Trim() && isDaysLeft)
{
mailbox = mailbox.Trim();
newMailbox = newMailbox.Trim();
string tbl = "google";
string sqlStr = "SELECT * FROM " + tbl;
try
{
OleDbConnection cnn = new OleDbConnection(Base.cnnStr);
OleDbDataAdapter oda = new OleDbDataAdapter(sqlStr, cnn);
OleDbCommandBuilder ocb = new OleDbCommandBuilder(oda);
cnn.Open();
OleDbCommand cmd = new OleDbCommand(sqlStr, cnn);
OleDbDataReader drr = cmd.ExecuteReader();
DataSet ds = new DataSet();
DataTable dt = new DataTable();
DataRow dr;
ocb.QuotePrefix = "[";
ocb.QuoteSuffix = "]";
oda.Fill(ds, tbl);
bool found = false;
bool duplicate = false;
mailbox = EncDec.Encrypt(mailbox, Base.hashKey);
newMailbox = EncDec.Encrypt(newMailbox, Base.hashKey);
while (drr.Read())
{
if (drr["mailbox"].ToString().Trim() == mailbox)
found = true;
else if (drr["mailbox"].ToString().Trim() == newMailbox)
duplicate = true;
}
if (found && !duplicate)
{
dt = ds.Tables[tbl];
for (int i = 0; i < dt.Rows.Count; i++)
{
dr = dt.Rows[i];
if (dr["mailbox"].ToString().Trim() == mailbox)
{
dr.BeginEdit();
dr["mailbox"] = newMailbox;
dr.EndEdit();
oda.UpdateCommand = ocb.GetUpdateCommand();
if (oda.Update(ds, tbl) == 1)
{
msg = ReNewPageImages(tbl + "\\" + mailbox, tbl + "\\" + newMailbox);
if (msg != "ReNewed")
return msg;
ds.AcceptChanges();
msg = "Updated";
}
else
{
ds.RejectChanges();
msg = "Rejected";
}
break;
}
}
}
else if (duplicate)
msg = "Duplicate Error";
else
msg = "Not Found";
cnn.Close();
drr.Close();
ds.Dispose();
cmd.Dispose();
drr.Dispose();
ocb.Dispose();
oda.Dispose();
cnn.Dispose();
dt.Dispose();
ds = null;
ocb = null;
//.........这里部分代码省略.........
示例15: GoogleAdd
public string GoogleAdd(string mailbox, string legal)
{
string msg = string.Empty;
if (tLegal == legal.Trim() && isDaysLeft)
{
mailbox = mailbox.Trim();
string tbl = "google";
string sqlStr = "SELECT * FROM " + tbl;
try
{
OleDbConnection cnn = new OleDbConnection(Base.cnnStr);
OleDbDataAdapter oda = new OleDbDataAdapter(sqlStr, cnn);
OleDbCommandBuilder ocb = new OleDbCommandBuilder(oda);
cnn.Open();
OleDbCommand cmd = new OleDbCommand(sqlStr, cnn);
OleDbDataReader drr = cmd.ExecuteReader();
DataSet ds = new DataSet();
DataTable dt = new DataTable();
DataRow dr;
ocb.QuotePrefix = "[";
ocb.QuoteSuffix = "]";
oda.Fill(ds, tbl);
bool found = false;
mailbox = EncDec.Encrypt(mailbox, Base.hashKey);
while (drr.Read())
{
if (drr["mailbox"].ToString().Trim() == mailbox)
{
found = true;
break;
}
}
if (!found)
{
dt = ds.Tables[tbl];
dr = dt.NewRow();
dr["mailbox"] = mailbox;
dt.Rows.Add(dr);
oda.InsertCommand = ocb.GetInsertCommand();
if (oda.Update(ds, tbl) == 1)
{
ds.AcceptChanges();
msg = "Added";
}
else
{
ds.RejectChanges();
msg = "Rejected";
}
}
else
msg = "Already Exist";
cnn.Close();
drr.Close();
ds.Dispose();
dt.Dispose();
cmd.Dispose();
drr.Dispose();
ocb.Dispose();
oda.Dispose();
cnn.Dispose();
ds = null;
ocb = null;
oda = null;
dr = null;
dt = null;
cmd = null;
drr = null;
cnn = null;
}
catch (Exception ex)
{
msg = ex.Message;
}
finally
{
tbl = null;
sqlStr = null;
}
}
else
//.........这里部分代码省略.........