本文整理汇总了C#中System.Data.DataTable.AcceptChanges方法的典型用法代码示例。如果您正苦于以下问题:C# DataTable.AcceptChanges方法的具体用法?C# DataTable.AcceptChanges怎么用?C# DataTable.AcceptChanges使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.DataTable
的用法示例。
在下文中一共展示了DataTable.AcceptChanges方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: GetReady
public void GetReady ()
{
dataTable = new DataTable ("itemTable");
dc1 = new DataColumn ("itemId");
dc2 = new DataColumn ("itemName");
dc3 = new DataColumn ("itemPrice");
dc4 = new DataColumn ("itemCategory");
dataTable.Columns.Add (dc1);
dataTable.Columns.Add (dc2);
dataTable.Columns.Add (dc3);
dataTable.Columns.Add (dc4);
DataRow dr;
seed = 123;
rowCount = 5;
rndm = new Random (seed);
for (int i = 1; i <= rowCount; i++) {
dr = dataTable.NewRow ();
dr["itemId"] = "item " + i;
dr["itemName"] = "name " + rndm.Next ();
dr["itemPrice"] = "Rs. " + (rndm.Next () % 1000);
dr["itemCategory"] = "Cat " + ((rndm.Next () % 10) + 1);
dataTable.Rows.Add (dr);
}
dataTable.AcceptChanges ();
dataView = new DataView (dataTable);
dataView.ListChanged += new ListChangedEventHandler (OnListChanged);
listChangedArgs = null;
}
示例2: ParseToDataTable
public static DataTable ParseToDataTable(IList<Data.PemeriksaanDetail> srs)
{
DataTable deta = new DataTable();
foreach (PropertyInfo info in typeof(Data.PemeriksaanDetail).GetProperties())
{
deta.Columns.Add(info.Name, info.PropertyType);
}
deta.AcceptChanges();
foreach (var i in srs)
{
Data.PemeriksaanDetail sr = new Data.PemeriksaanDetail();
sr = i;
DataRow row = deta.NewRow();
foreach (var property in sr.GetType().GetProperties())
{
row[property.Name] = property.GetValue(sr, null);
}
deta.Rows.Add(row);
}
deta.AcceptChanges();
return deta;
}
示例3: ProcessSubmitChangesResultOK
/// <summary>
/// Processes the result of a data submission to the Server where the result of that operation is
/// <see cref="TSubmitChangesResult.scrOK" />. (Overload for DataTables.)
/// </summary>
/// <param name="ACallingFormOrUserControl"></param>
/// <param name="ALocalDT"></param>
/// <param name="ASubmitDT"></param>
/// <param name="APetraUtilsObject"></param>
/// <param name="AVerificationResults"></param>
/// <param name="ASetPrimaryKeyOnlyMethod"></param>
/// <param name="AMasterDataTableSaveCall"></param>
/// <param name="ACalledFromUserControl"></param>
/// <param name="ACallAcceptChangesOnReturnedDataBeforeMerge"></param>
public static void ProcessSubmitChangesResultOK(IFrmPetra ACallingFormOrUserControl, DataTable ALocalDT,
DataTable ASubmitDT, TFrmPetraEditUtils APetraUtilsObject, TVerificationResultCollection AVerificationResults,
Action <bool>ASetPrimaryKeyOnlyMethod, bool AMasterDataTableSaveCall, bool ACalledFromUserControl,
bool ACallAcceptChangesOnReturnedDataBeforeMerge = false)
{
if (AMasterDataTableSaveCall)
{
// Call AcceptChanges to get rid now of any deleted columns before we Merge with the result from the Server
ALocalDT.AcceptChanges();
// Merge back with data from the Server (eg. for getting Sequence values)
if (ACallAcceptChangesOnReturnedDataBeforeMerge)
{
ASubmitDT.AcceptChanges();
}
ALocalDT.Merge(ASubmitDT, false);
// Need to accept any new modification ID's
ALocalDT.AcceptChanges();
if (ASetPrimaryKeyOnlyMethod != null)
{
// Ensure the Primary-Key(s)-containing Controls are disabled to prevent further modification of Primary Key values
ASetPrimaryKeyOnlyMethod(true);
}
}
CommonPostMergeOperations(ACallingFormOrUserControl, APetraUtilsObject,
AVerificationResults, ACalledFromUserControl);
}
示例4: LoadImgs
public void LoadImgs()
{
LoadSelect();
System.IO.DirectoryInfo dir = new System.IO.DirectoryInfo(Request.PhysicalApplicationPath + "\\Images\\avatar");
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("ID"));
dt.Columns.Add(new DataColumn("Name"));
dt.AcceptChanges();
foreach (System.IO.FileInfo file in dir.GetFiles())
{
string ID = file.Name.Replace(file.Extension, "");
try
{
int i = int.Parse(ID);
DataRow dr = dt.NewRow();
dr["ID"] = file.Name.Replace(file.Extension, "");
dr["Name"] = "../../Images/avatar/" + file.Name;
dt.Rows.Add(dr);
}
catch
{
continue;
}
}
dt.AcceptChanges();
dlstImg.DataSource = dt;
dlstImg.DataBind();
}
示例5: Page_Load
protected void Page_Load(object sender, EventArgs e)
{
DataTable myTable = new DataTable("myTable");
DataColumn colItem = new DataColumn("item", Type.GetType("System.String"));
DataColumn colItem1 = new DataColumn("item1", Type.GetType("System.Int32"));
myTable.Columns.Add(colItem);
myTable.Columns.Add(colItem1);
// Add five items.
DataRow NewRow;
for (int i = 0; i < 2; i++)
{
NewRow = myTable.NewRow();
NewRow["item"] = i;
myTable.Rows.Add(NewRow);
}
myTable.Rows[0]["item"] = "Juan";
myTable.Rows[0]["item1"] = "60";
myTable.Rows[1]["item"] = "Diego";
myTable.Rows[1]["item1"] = "40";
myTable.AcceptChanges();
//DataView custDV = new DataView(custDS.Tables["Customers"], "Country = 'USA'", "ContactName", DataViewRowState.CurrentRows);
DataView custDV = new DataView(myTable);
//Display(custDV);
}
示例6: CreateTicketDt
public static DataTable CreateTicketDt()
{
DataTable dt = new DataTable();
dt.Columns.Add("TrainCode");
dt.Columns.Add("TrainCodeKey");
dt.Columns.Add("StartStation");
dt.Columns.Add("AimStation");
dt.Columns.Add("TakeTime");
dt.Columns.Add("ShangWu");
dt.Columns.Add("TeDeng");
dt.Columns.Add("YiDeng");
dt.Columns.Add("ErDeng");
dt.Columns.Add("GaoJiRuanWo");
dt.Columns.Add("RuanWo");
dt.Columns.Add("YingWo");
dt.Columns.Add("RuanZuo");
dt.Columns.Add("YingZuo");
dt.Columns.Add("WuZuo");
dt.Columns.Add("QiTa");
dt.Columns.Add("OrderKey");
dt.Columns.Add("CanOrder");
dt.Columns.Add("Order", typeof(Image));
dt.Columns.Add("First");
dt.Columns.Add("Last");
dt.AcceptChanges();
return dt;
}
示例7: FormDetailTVP
void FormDetailTVP(ref DataTable Dt)
{
DataColumn CHKD_ProcessId = Dt.Columns.Add("CHKD_ProcessId", typeof(String));
DataColumn CHKD_RowId = Dt.Columns.Add("CHKD_RowId", typeof(Int32));
DataColumn CHKD_Checked = Dt.Columns.Add("CHKD_Checked", typeof(Boolean));
Dt.AcceptChanges();
}
示例8: Load_ListDS
public static void Load_ListDS()
{
if (File.Exists(m_MySensors_FilePath))
{
SensorDS = new DataSet("SensorDS");
SensorDS.ReadXml(m_MySensors_FilePath, XmlReadMode.ReadSchema);
}
else
{
if (SensorDS != null)
{
SensorDS.Dispose();
GC.Collect();
}
DataTable dt0 = new DataTable("SensorTBL");
dt0.Columns.Add(new DataColumn(Cfg.C_IS_PICK, Type.GetType(Cfg.SYS_INT32)));
dt0.Columns[Cfg.C_IS_PICK].DefaultValue = 1;
dt0.Columns.Add(new DataColumn(Sensor.C_SENSOR_ID, Type.GetType(Cfg.SYS_INT64)));
dt0.Columns[Sensor.C_SENSOR_ID].DefaultValue = Sensor.Sensor_ID;
dt0.Columns.Add(new DataColumn(Sensor.C_LOCATION_NAME, Type.GetType(Cfg.SYS_STRING)));
dt0.Columns[Sensor.C_LOCATION_NAME].DefaultValue = Sensor.Location_Name;
dt0.Rows.Add(dt0.NewRow());
dt0.AcceptChanges();
SensorDS = new DataSet("SensorDS");
SensorDS.Tables.Add(dt0);
SensorDS.AcceptChanges();
}
SensorDS.Tables[0].DefaultView.Sort = Sensor.C_SENSOR_ID;
}
示例9: ToDataTable
public DataTable ToDataTable(INetwork network)
{
if (network == null)
throw new ArgumentNullException("network", "The input network must not be null.");
if (!(network is IEdgeAttributes))
throw new ArgumentException(string.Format("The input network must implement {0}.", typeof(IEdgeAttributes).Name), "network");
IEdgeAttributes src = network as IEdgeAttributes;
DataTable table = new DataTable("Edge data");
AttributeListMgr mgr = src.EdgeAttributeMgr as AttributeListMgr;
if (mgr == null)
throw new ArgumentException("The EdgeAttributeMgr of the input network must not be null.", "network");
string[] colNames = EnsureUniqueColNames(mgr);
int ctr = 0;
foreach (IAttributeList list in mgr.Lists)
{
table.Columns.Add(new DataColumn(colNames[ctr++], list.DataType));
}
if (table.Columns.Count>0)
for (int i = 0; i < mgr.Depth; i++)
{
table.Rows.Add(mgr.GetRow(i));
}
table.AcceptChanges();
return table;
}
示例10: run
//Activate This Construntor to log All To Standard output
//public TestClass():base(true){}
//Activate this constructor to log Failures to a log file
//public TestClass(System.IO.TextWriter tw):base(tw, false){}
//Activate this constructor to log All to a log file
//public TestClass(System.IO.TextWriter tw):base(tw, true){}
//BY DEFAULT LOGGING IS DONE TO THE STANDARD OUTPUT ONLY FOR FAILURES
public void run()
{
Exception exp = null;
DataTable myTable = new DataTable("myTable");
DataColumn dc = new DataColumn("Id",typeof(int));
dc.Unique=true;
myTable.Columns.Add(dc);
myTable.Rows.Add(new object[] {1});
myTable.Rows.Add(new object[] {2});
myTable.Rows.Add(new object[] {3});
myTable.AcceptChanges();
DataRow myRow = myTable.Rows[0];
myRow.Delete();
try
{
BeginCase("Delete1");
Compare( myRow.RowState , DataRowState.Deleted );
}
catch(Exception ex) {exp = ex;}
finally {EndCase(exp); exp = null;}
try
{
BeginCase("Delete2");
myTable.AcceptChanges();
Compare( myRow.RowState , DataRowState.Detached );
}
catch(Exception ex) {exp = ex;}
finally {EndCase(exp); exp = null;}
}
示例11: TextBoxDataGridValidationBindingGroupWindow2
/// <summary>コンストラクタ</summary>
public TextBoxDataGridValidationBindingGroupWindow2()
{
InitializeComponent();
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("count", typeof(Int32)));
dt.Columns.Add(new DataColumn("name", typeof(System.String)));
DataRow dr=null;
dr = dt.NewRow();
dr["count"] = 100;
dr["name"] = "あああ";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["count"] = 200;
dr["name"] = "いいい";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["count"] = 300;
dr["name"] = "ううう";
dt.Rows.Add(dr);
// ここまでの変更をコミット
dt.AcceptChanges();
this.dataGrid1.DataContext = dt;
// ソースクラスをバインド
this.DataContext = new SourceClass();
}
示例12: MedStoreLoad
void MedStoreLoad()
{
try
{
conn.Open();
string sqlquery = "SELECT * FROM MED_STORE";
//string sqlquery = "SELECT * FROM MED_INFO";
OracleCommand cmd = new OracleCommand(sqlquery, conn);
OracleDataAdapter oda = new OracleDataAdapter();
oda.SelectCommand = cmd;
dt = new DataTable();
// dt.Columns["MED_NAME"].ColumnName = "Name";
oda.Fill(dt);
BindingSource bsource = new BindingSource();
bsource.DataSource = dt;
dataGridView1.DataSource = bsource;
oda.Update(dt);
dt.Columns[0].ColumnName = "ID";
dt.Columns[1].ColumnName = "Name";
dt.Columns[2].ColumnName = "Quantity";
dt.Columns[3].ColumnName = "Damage Qty";
dt.Columns[4].ColumnName = "Reorder Level";
dt.AcceptChanges();
conn.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
示例13: ExpandoToDataTable
public static DataTable ExpandoToDataTable(List<dynamic> data)
{
int counter = 0;
DataTable dt = new DataTable("data");
//generate columns
foreach (dynamic item in data)
{
if (item is ExpandoObject)
{
if (counter <= 0)
{
foreach (var dataitem in (IDictionary<string, object>)item)
{
dt.Columns.Add(dataitem.Key);
}
}
{
var NewItem = dt.NewRow();
foreach (var dataitem in (IDictionary<string, object>)item)
{
NewItem[dataitem.Key] = dataitem.Value;
}
dt.Rows.Add(NewItem);
}
counter++;
}
}
dt.AcceptChanges();
return dt;
}
示例14: ListToTable
public static DataTable ListToTable(this List<Dictionary<string, string>> dic)
{
var dt = new DataTable("Results");
dic.ForEach(props =>
{
props.ToList().ForEach(i =>
{
if (!dt.Columns.Contains(i.Key))
{
dt.Columns.Add(new DataColumn(i.Key));
}
});
var dr = dt.NewRow();
props.ToList().ForEach(i => dr[i.Key] = i.Value);
dt.Rows.Add(dr);
});
dt.AcceptChanges();
return dt;
}
示例15: Baocaohuychot
public static void Baocaohuychot(DataTable m_dtReport, string kieuthuoc_vt, string sTitleReport, string dieukienbaocao, bool theonhom)
{
string tieude = "", reportname = "", reportcode = "thuoc_baocao_huychot_theonhom";
ReportDocument crpt = null;
if (kieuthuoc_vt .Contains("THUOC"))
{
if (theonhom)
{
reportcode = "thuoc_baocao_huychot_theonhom";
}
else
{
reportcode = "thuoc_baocao_huychot";
}
}
else//VTTH
{
if (theonhom)
{
reportcode = "vt_baocao_huychot_theonhom";
}
else
{
reportcode = "vt_baocao_huychot";
}
}
crpt = Utility.GetReport(reportcode, ref tieude, ref reportname);
if (crpt == null) return;
MoneyByLetter _moneyByLetter = new MoneyByLetter();
var objForm = new frmPrintPreview(sTitleReport, crpt, true, m_dtReport.Rows.Count <= 0 ? false : true);
objForm.mv_sReportFileName = Path.GetFileName(reportname);
objForm.mv_sReportCode = reportcode;
Utility.UpdateLogotoDatatable(ref m_dtReport);
try
{
if (theonhom)
m_dtReport.DefaultView.Sort = "stt_hthi_nhom,tenbietduoc";
else
m_dtReport.DefaultView.Sort = "tenbietduoc";
m_dtReport.AcceptChanges();
crpt.SetDataSource(m_dtReport.DefaultView);
Utility.SetParameterValue(crpt, "BranchName", globalVariables.Branch_Name);
Utility.SetParameterValue(crpt, "Address", globalVariables.Branch_Address);
Utility.SetParameterValue(crpt, "Phone", globalVariables.Branch_Phone);
Utility.SetParameterValue(crpt, "ParentBranchName", globalVariables.ParentBranch_Name);
Utility.SetParameterValue(crpt, "dieukienbaocao", dieukienbaocao);
Utility.SetParameterValue(crpt, "sTitleReport", tieude);
Utility.SetParameterValue(crpt, "BottomCondition", THU_VIEN_CHUNG.BottomCondition());
Utility.SetParameterValue(crpt, "txttrinhky","");
objForm.crptViewer.ReportSource = crpt;
objForm.ShowDialog();
// Utility.DefaultNow(this);
}
catch (Exception ex)
{
Utility.CatchException(ex);
}
}