C# DataTable.AcceptChanges方法代码示例

		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;
		}

        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;
        }

        /// <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);
        }

    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();
    }

    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);
    }

 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;
 }

 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();
 }

        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;
        }

        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;
        }

	//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;}
			
		
	}

        /// <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();
        }

        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);
            }
        }

        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;
        }

        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;
        }

        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);
              }
        }