public void TestSerializeDataSet() { DataSet ds = new DataSet("DataSet"); //Table 1 ds.Tables.Add(new DataTable("Table")); ds.Tables[0].Columns.Add("col1", typeof(int)); ds.Tables[0].Columns.Add("col2", typeof(int)); DataRow dr = ds.Tables[0].NewRow(); dr["col1"] = 1; dr["col2"] = 2; ds.Tables[0].Rows.Add(dr); //Table 2 ds.Tables.Add(new DataTable("Table1")); ds.Tables[1].Columns.Add("col1_col1", typeof(int)); ds.Tables[1].Columns.Add("col2", typeof(int)); dr = ds.Tables[1].NewRow(); dr["col1_col1"] = 1; ds.Tables[1].Rows.Add(dr); ds.Relations.Add(new DataRelation("table_table1", ds.Tables[0].Columns[0], ds.Tables[1].Columns[0], true)); ds.AcceptChanges(); string actualXml = XmlSerializationHelper.SerializeDataTable(ds.Tables[0], true); string expectedXml = "<DataSet><Table><col1>1</col1><col2>2</col2></Table><Table1><col1_col1>1</col1_col1></Table1></DataSet>"; Trace.Write(actualXml); Assert.AreEqual(actualXml, expectedXml); }
/// <summary> /// 删除 /// </summary> private void Delete() { if (this.ds.Tables.Count == 0 && this.ds.Tables[0].Rows.Count == 0) { return; } if (MessageBox.Show("删除文件" + lbFileName.Text + ",此操作不可恢复,是否继续", "警告", System.Windows.Forms.MessageBoxButtons.YesNo, System.Windows.Forms.MessageBoxIcon.Warning) == DialogResult.No) { return; } string ID = this.lbPrimaryID.Text; string strSql = "delete from com_downloadfile t where t.primary_id = '{0}'"; strSql = string.Format(strSql, ID); OracleTransaction trans = this.con.BeginTransaction(System.Data.IsolationLevel.ReadCommitted); mgr.SetTrans(trans); int i = mgr.ExeNoQuery(this.con, strSql); if (i <= 0) { trans.Rollback(); MessageBox.Show("删除数据失败" + mgr.Err); } else { trans.Commit(); object[] keys = new object[] { this.lbPrimaryID.Text }; DataRow row = ds.Tables[0].Rows.Find(keys); this.ds.Tables[0].Rows.Remove(row); ds.AcceptChanges(); MessageBox.Show("删除成功"); } }
private void btnShto_Click(object sender, System.EventArgs e) { try { // Nese data qe eshte e futur eshte me e vogel ose e barabarte me daten e tanishme te // sistemi atehere jep mesazh qe te nderroje daten dhe dil if (Convert.ToDateTime(this.dtpShtoMesazh.Value) <= DateTime.Now) { MessageBox.Show("Koha e mesazhit te alarmit duhet te jete me e madhe se koha qe ka sistemi juaj", "Perkujtese", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } // Nese nuk eshte konfiguruar akoma dataseti dsMesazhe atehere duhet krijuar struktura per te. // Ky dataset do te kete 2 kolona: njera do te jete data dhe ora e alarmit dhe tjetra do // mbaje mesazhin e alarmit if (dsMesazhe.Tables.Count == 0) { DataTable dtMesazhet = new DataTable("Mesazhet"); dtMesazhet.Columns.Add("Data", typeof(String)); dtMesazhet.Columns.Add("Mesazhi", typeof(String)); dsMesazhe.Tables.Add(dtMesazhet); dsMesazhe.AcceptChanges(); } // Hedhim nje rresht te ri ne dsMesazhe DataRow dr = dsMesazhe.Tables[0].NewRow(); dr["Data"] = Convert.ToDateTime(this.dtpShtoMesazh.Value).ToString("dd/MM/yyyy HH:mm"); dr["Mesazhi"] = this.txtShtoMesazh.Text; dsMesazhe.Tables[0].Rows.Add(dr); dsMesazhe.AcceptChanges(); // Bejme renditjen e rreshtave te datasetit sipas kohes se mesazhit DataTable dt1 = dsMesazhe.Tables[0].Copy(); dt1.Rows.Clear(); DataRow[] drMesazhe = dsMesazhe.Tables[0].Select("", "Data"); for (int i = 0; i < drMesazhe.Length; i++) { DataRow dr1 = dt1.NewRow(); dr1["Data"] = drMesazhe[i]["Data"]; dr1["Mesazhi"] = drMesazhe[i]["Mesazhi"]; dt1.Rows.Add(dr1); } dsMesazhe.Tables.Clear(); dsMesazhe.Tables.Add(dt1); // Hedhim datasetin ne Xml dsMesazhe.WriteXml(Application.StartupPath + "\\MesazheAlarmi.xml", XmlWriteMode.WriteSchema); MainForm main = this.Main as MainForm; main.StartTimer1(); this.dgMesazhe.DataSource = dsMesazhe.Tables[0]; this.dgMesazhe.RootTable.DataMember = this.dsMesazhe.Tables[0].TableName; } catch (Exception ex) { return; } }
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; }
private DataSet importExcelFile(string fileName) { Microsoft.Office.Interop.Excel.Application excelApp = new Microsoft.Office.Interop.Excel.Application(); System.Data.DataSet ds = new System.Data.DataSet(); Workbook wkBook = excelApp.Workbooks.Open(fileName, 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0); ds.DataSetName = wkBook.Name; foreach (Worksheet ws in wkBook.Worksheets) { ds.Merge(importExcelSheet(ws)); ds.AcceptChanges(); } System.Windows.Forms.DataGridTableStyle tstyle = new System.Windows.Forms.DataGridTableStyle(); tstyle.AllowSorting = true; tstyle.RowHeaderWidth = 0; DG.TableStyles.Add(tstyle); DG.NavigateBack(); DG.NavigateBack(); DG.DataSource = ds; excelApp.Quit(); releaseObject(excelApp); releaseObject(wkBook); return(ds); }
static void Main(string[] args) { // string connectionString = @"data source=(localDB)\v11.0; Initial catalog=TrainingDB; integrated security=SSPI"; //string connectionString = "data source=192.168.20.125;database=SMSDB;Integrated Security=false; user id=sa; password=leads@123"; string connectionString = @"Data Source=(LocalDb)\v11.0;AttachDbFilename=|DataDirectory|\TrainingDB.mdf;Initial Catalog=TrainingDB;Integrated Security=True"; string commandString = @"SELECT * FROM Shippers"; SqlDataAdapter dataAdapter = new SqlDataAdapter(commandString, connectionString); SqlCommandBuilder scb = new SqlCommandBuilder(dataAdapter); DataSet myDataSet = new DataSet(); dataAdapter.Fill(myDataSet, "Shippers"); DataTable sTable = myDataSet.Tables["Shippers"]; // add data object[] o = { 1, "General", "555-1212" }; sTable.Rows.Add(o); dataAdapter.Update(myDataSet, "Shippers"); myDataSet.AcceptChanges(); Console.ReadKey(); }
public Task UpdateCustomerData(DataSet updatedCustomerData) { // simulate save to database and store in memory updatedCustomerData.AcceptChanges(); customerData = updatedCustomerData; return(Task.CompletedTask); }
/// <summary> /// /// </summary> /// <param name="serverAPI"></param> public wfrm_System_Frame(ServerAPI serverAPI) { // // Required for Windows Form Designer support // InitializeComponent(); // // TODO: Add any constructor code after InitializeComponent call // try { m_ServerAPI = serverAPI; dsSettings = m_ServerAPI.GetSettings(); dsSettings.AcceptChanges(); } catch(Exception x){ wfrm_Error frm = new wfrm_Error(x,new System.Diagnostics.StackTrace()); frm.ShowDialog(this); } InitTab(); }
public void TestMethod1() { DataSet dataSet = new DataSet("dataSet"); dataSet.Namespace = "NetFrameWork"; DataTable table = new DataTable(); DataColumn idColumn = new DataColumn("id", typeof(int)); idColumn.AutoIncrement = true; DataColumn itemColumn = new DataColumn("item"); table.Columns.Add(idColumn); table.Columns.Add(itemColumn); dataSet.Tables.Add(table); for (int i = 0; i < 2; i++) { DataRow newRow = table.NewRow(); newRow["item"] = "item " + i; table.Rows.Add(newRow); } dataSet.AcceptChanges(); var jsonResult = OrbCore.toJson(dataSet); Console.WriteLine(jsonResult); }
public DataSet GetReleaseFileInfo(string componentCode, string version) { // get XML doc XDocument xml = GetReleasesFeed(); // get current release var release = (from r in xml.Descendants("release") where r.Parent.Parent.Attribute("code").Value == componentCode && r.Attribute("version").Value == version select r).FirstOrDefault(); if (release == null) return null; // requested release was not found DataSet ds = new DataSet(); DataTable dt = ds.Tables.Add(); dt.Columns.Add("ReleaseFileID", typeof(int)); dt.Columns.Add("FullFilePath", typeof(string)); dt.Columns.Add("UpgradeFilePath", typeof(string)); dt.Columns.Add("InstallerPath", typeof(string)); dt.Columns.Add("InstallerType", typeof(string)); dt.Rows.Add( Int32.Parse(release.Element("releaseFileID").Value), release.Element("fullFilePath").Value, release.Element("upgradeFilePath").Value, release.Element("installerPath").Value, release.Element("installerType").Value); ds.AcceptChanges(); // save return ds; }
/// <summary> /// Retrieve excel data and convert it to dataset /// </summary> /// <param name="file">Excel binary file.</param> /// <returns>Dataset containing the data of the sheet pertaining to the position specified</returns> public DataSet GetDataSet(byte[] file) { try { //try to create an excel application CreateExcelApplication(); KeepFiles = false; OpenWorkbook(file); List<string> sheets = new List<string>(); foreach (Worksheet s in Application.Worksheets) { //ignore hidden sheets if (s.Visible != XlSheetVisibility.xlSheetVisible) { continue; } sheets.Add(s.Name); //release com obj ReleaseComObject(s); } //read respective sheets DataSet ds = new DataSet(); foreach (string s in sheets) { ds.Tables.Add(GetExcelData(s)); } ds.AcceptChanges(); return ds; } finally { this.Dispose(); } }
public DataSet getmenu(string department) { EmployeeDao employeedao = new EmployeeDao(); Employee employee = employeedao.getempdepartment(department); ConnectionDao ConnectionDao = new ConnectionDao(); SqlDataAdapter adp = new SqlDataAdapter("select department_name,weburl from Department where Department_Name='" + employee.department + "'", ConnectionDao.getConnection()); DataSet ds4 = new DataSet(); adp.Fill(ds4); string Department = ds4.Tables[0].Rows[0]["department_name"].ToString(); if (Department == "Sales") { ds4 = addMenu(ds4, "Email"); } if (Department == "Corporate") { ds4.Tables[0].Rows.RemoveAt (0); ds4.AcceptChanges(); ds4 = addMenu(ds4, "Customer"); ds4 = addMenu(ds4, "Email"); ds4 = addMenu(ds4, "Ticketing"); ds4 = addMenu(ds4, "Dashboard"); ds4 = addMenu(ds4, "Reports"); } return ds4; }
public static NavisionDBUser Abrir_Login(string UserId, string Password, ref DataSet DsRes, NavisionDBConnection DBConn) { NavisionDBUser DBUser = null; DsRes = Utilidades.GenerarResultado("No conectado"); DsRes.Tables[0].Columns.Add("Connected", Type.GetType("System.Boolean"), "false"); DsRes.Tables[0].AcceptChanges(); try { DBUser = DBConn.DoLogin(UserId, Password, ref DsRes); //Obtengo los roles if ((DsRes.Tables.Count > 0) && (DsRes.Tables[0].Columns.Count > 0) && (!DsRes.Tables[0].Columns.Contains("Error"))) if (Convert.ToBoolean(DsRes.Tables[0].Rows[0]["Connected"]) == true) { DsRes.Tables[0].Columns.Add("Administracion", System.Type.GetType("System.Boolean")); DsRes.Tables[0].Columns.Add("Gestion", System.Type.GetType("System.Boolean")); DsRes.Tables[0].Columns.Add("Compras", System.Type.GetType("System.Boolean")); DsRes.Tables[0].Columns.Add("Mensajería", System.Type.GetType("System.Boolean")); DsRes.Tables[0].Columns.Add("Comercial", System.Type.GetType("System.Boolean")); NavisionDBTable dt = new NavisionDBTable(DBConn, DBUser); NavisionDBCommand cmd = new NavisionDBCommand(DBConn); NavisionDBDataReader rd; dt.TableName = "Mobile Users"; dt.AddColumn("Administracion"); dt.AddColumn("Gestion"); dt.AddColumn("Compras"); dt.AddColumn("Mensajería"); dt.AddColumn("Comercial"); dt.AddFilter("User ID", UserId); dt.AddFilter("Password", Password); cmd.Table = dt; rd = cmd.ExecuteReader(false); if (rd.RecordsAffected > 0) { DsRes.Tables[0].Rows[0]["Administracion"] = rd.GetBoolean(0); DsRes.Tables[0].Rows[0]["Gestion"] = rd.GetBoolean(1); DsRes.Tables[0].Rows[0]["Compras"] = rd.GetBoolean(2); DsRes.Tables[0].Rows[0]["Mensajería"] = rd.GetBoolean(3); DsRes.Tables[0].Rows[0]["Comercial"] = rd.GetBoolean(4); } DsRes.Tables[0].AcceptChanges(); DsRes.AcceptChanges(); } return DBUser; } catch (Exception ex) { Utilidades.GenerarError(UserId, "Abrir_Login()", ex.Message); return null; } }
private static DataSet getDataSet() { DataSet op_ds=new DataSet(); DataTable v_dt=new DataTable(); op_ds.Tables.Add(v_dt); op_ds.AcceptChanges(); return op_ds; }
void MainForm_Load (object sender, EventArgs e) { _dataSet = new DataSet (); _dataSet.ReadXml ("test.xml"); _dataGrid.DataSource = _dataSet; _dataGrid.DataMember = "Table"; _dataSet.AcceptChanges (); }
private void readDictionaryFile(string filename) { try { // Read the XML document back in. System.IO.FileStream fsReadXml = new System.IO.FileStream(filename, System.IO.FileMode.Open); System.Xml.XmlTextReader myXmlReader = new System.Xml.XmlTextReader(fsReadXml); dictionaryDataSet.ReadXml(myXmlReader, XmlReadMode.IgnoreSchema); // we already have schema myXmlReader.Close(); dictionaryDataSet.AcceptChanges(); } catch { LibSys.StatusBar.Error("bad dictionary at " + filename); } }
protected void btnAddRcd_Click(object sender, EventArgs e) { this.txtSN.Focus(); if (this.txtSN.Text.Trim() == "") { Methods.AjaxMessageBox(this, "物料序列号不能为空!"); return; } int rc = Methods.getMatierialIDCount(this.txtSN.Text.Trim()); if (rc > 0) { Methods.AjaxMessageBox(this, "此物料序列号已经存在!"); return; } else if (rc < 0) { Methods.AjaxMessageBox(this, "查询部件序列号时出现异常,详情请查看日志!"); return; } ds = (DataSet)ViewState["tmpds"]; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { if (this.txtSN.Text.Trim() == ds.Tables[0].Rows[i]["ID"].ToString()) { Methods.AjaxMessageBox(this, "此物料序列号已经存在!"); return; } } int Len = Convert.ToInt32(System.Configuration.ConfigurationManager.AppSettings["MIDLenInSN"]); if (this.txtSN.Text.Trim().Length <= Len) { Methods.AjaxMessageBox(this, "此部件序列号长度必须" + Len + "位以上!"); return; } DataRow r = ds.Tables[0].NewRow();//将数据源添加一新行 string mid = this.txtSN.Text.Trim().Substring(0, Len); //if(mid!=ModelID) //{ // Methods.AjaxMessageBox(this,"序列号对应的品号与计划中的品号不一致!"); return; //} //WSProcedureCtrl.ProcedureCtrl pctrl = new ProcedureCtrl(); //if (!pctrl.CheckModel(mid, SessionUser.ID)) //{ // Methods.AjaxMessageBox(this, "序列号对应的品号与计划中的品号不一致!"); return; //} r["ID"] = this.txtSN.Text.Trim(); r["ModelID"] = mid; r["Batch"] = ""; r["Vendor"] = ""; r["EmployeeID"] = ""; r["FoundTime"] = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:dd"); r["Remark"] = ""; ds.Tables[0].Rows.InsertAt(r, 0); ds.AcceptChanges(); this.GridView1.DataSource = ds; this.GridView1.DataBind(); }
public void MyTestInitialize() { dataSet = new DataSet("TestSet"); dataSet.Tables.Add("Property"); dataSet.Tables["Property"].Columns.Add("Property", typeof (string)); dataSet.Tables["Property"].Columns.Add("Value", typeof(string)); dataSet.Tables["Property"].Rows.Add(new object[] {"MyName", "Put Stuff Here" }); dataSet.AcceptChanges(); }
public byte[] Get_Restore_Files() { DataSet DataSet = new System.Data.DataSet(); DataSet.Tables.Add("RestoreFiles"); DataSet.Tables["RestoreFiles"].Columns.Add("RESTORE_DATETIME", typeof(DateTime)); DataSet.Tables["RestoreFiles"].Columns.Add("RESTORE_FILE", typeof(String)); StringBuilder strQry = new StringBuilder(); string strFileDirectory = AppDomain.CurrentDomain.BaseDirectory + "Backup"; if (Directory.Exists(strFileDirectory)) { string strDataBaseName = "InteractPayrollClient_"; #if (DEBUG) strDataBaseName = "InteractPayrollClient_Debug_"; #endif string[] filePaths = Directory.GetFiles(@strFileDirectory, strDataBaseName + @"*.bak"); if (filePaths.Length > 0) { for (int intRow = 0; intRow < filePaths.Length; intRow++) { int intDateTimeOffset = filePaths[intRow].IndexOf(strDataBaseName) + strDataBaseName.Length; if (intDateTimeOffset + 19 <= filePaths[intRow].Length) { DataRow drDataRow = DataSet.Tables["RestoreFiles"].NewRow(); drDataRow["RESTORE_FILE"] = filePaths[intRow]; try { DateTime myFileDateTime = DateTime.ParseExact(filePaths[intRow].Substring(intDateTimeOffset, 15), "yyyyMMdd_HHmmss", null); drDataRow["RESTORE_DATETIME"] = myFileDateTime; } catch { } DataSet.Tables["RestoreFiles"].Rows.Add(drDataRow); } } } } DataSet.AcceptChanges(); byte[] bytCompress = clsDBConnectionObjects.Compress_DataSet(DataSet); DataSet.Dispose(); DataSet = null; return(bytCompress); }
/// <summary> /// it saves the data edited in the same file and gives a message box that its done.. and also can be done for multiple nodes /// </summary> /// <param name="sender"></param> /// <param name="e"></param> public void btnsave_Click(object sender, EventArgs e) { DataSet ds = new DataSet(); ds.ReadXml("BasicInfo.xml"); //taking new file and saving in it.... ds.Tables[0].Rows[0]["name"] = "hi";// rtxtshow.Text; //taking node and saving it ds.AcceptChanges(); ds.WriteXml("BasicInfo.xml"); MessageBox.Show("FILE UPDATED...."); }
//修改默认语言 public static void WriteDefaultLanguage(string lang) { DataSet ds = new DataSet(); ds.ReadXml("LanguageDefine.xml"); DataTable dt = ds.Tables["Language"]; dt.Rows[0]["DefaultLanguage"] = lang; ds.AcceptChanges(); ds.WriteXml("LanguageDefine.xml"); }
//public static string GetFilePath(string fileName) //{ // int index = fileName.IndexOf("/M00/"); // return index > -1 ? fileName.Remove(0, index + 4) : fileName; //} //public static void SaveData(string id, string path) //{ // DataTable dt; // if (0 == Global.Dataset.Tables.Count) // { // dt = new DataTable("FastDFS"); // dt.Columns.Add("ID", typeof(string)); // dt.Columns.Add("Path", typeof(string)); // } // else // { // dt = Global.Dataset.Tables["FastDFS"]; // } // DataRow dr = dt.NewRow(); // dr["ID"] = id; // dr["Path"] = path; // dt.Rows.Add(dr); // dt.AcceptChanges(); // if (0 == Global.Dataset.Tables.Count) // { // Global.Dataset.Tables.Add(dt); // } // Global.Dataset.AcceptChanges(); //} public static string GetPath(string id) { DataSet ds = new DataSet("FastDFSData"); string physicsPath = HttpContext.Current.Server.MapPath(@"~/data/FastDFS.xml"); ds.ReadXml(physicsPath); ds.AcceptChanges(); DataTable dt = ds.Tables["FastDFS"]; DataRow[] dr = dt.Select("ID = '" + id.Replace("'","''") + "'"); return 0 == dr.Length ? string.Empty : dr[0]["Path"].ToString(); }
void MainForm_Load (object sender, EventArgs e) { _dataSet = new DataSet (); _dataSet.ReadXml ("test.xml"); _dataGrid.DataSource = _dataSet; _dataGrid.DataMember = _dataSet.Tables [0].TableName; _dataSet.AcceptChanges (); InstructionsForm instructionsForm = new InstructionsForm (); instructionsForm.Show (); }
public void Example() { #region Usage DataSet dataSet = new DataSet("dataSet"); dataSet.Namespace = "NetFrameWork"; DataTable table = new DataTable(); DataColumn idColumn = new DataColumn("id", typeof(int)); idColumn.AutoIncrement = true; DataColumn itemColumn = new DataColumn("item"); table.Columns.Add(idColumn); table.Columns.Add(itemColumn); dataSet.Tables.Add(table); for (int i = 0; i < 2; i++) { DataRow newRow = table.NewRow(); newRow["item"] = "item " + i; table.Rows.Add(newRow); } dataSet.AcceptChanges(); string json = JsonConvert.SerializeObject(dataSet, Formatting.Indented); Console.WriteLine(json); // { // "Table1": [ // { // "id": 0, // "item": "item 0" // }, // { // "id": 1, // "item": "item 1" // } // ] // } #endregion Assert.AreEqual(@"{ ""Table1"": [ { ""id"": 0, ""item"": ""item 0"" }, { ""id"": 1, ""item"": ""item 1"" } ] }", json); }
public void SerializeAndDeserialize() { DataSet dataSet = new DataSet("dataSet"); dataSet.Namespace = "NetFrameWork"; DataTable table = new DataTable(); DataColumn idColumn = new DataColumn("id", typeof(int)); idColumn.AutoIncrement = true; DataColumn itemColumn = new DataColumn("item"); table.Columns.Add(idColumn); table.Columns.Add(itemColumn); dataSet.Tables.Add(table); for (int i = 0; i < 2; i++) { DataRow newRow = table.NewRow(); newRow["item"] = "item " + i; table.Rows.Add(newRow); } dataSet.AcceptChanges(); string json = JsonConvert.SerializeObject(dataSet, Formatting.Indented); Assert.AreEqual(@"{ ""Table1"": [ { ""id"": 0, ""item"": ""item 0"" }, { ""id"": 1, ""item"": ""item 1"" } ] }", json); DataSet deserializedDataSet = JsonConvert.DeserializeObject<DataSet>(json); Assert.IsNotNull(deserializedDataSet); Assert.AreEqual(1, deserializedDataSet.Tables.Count); DataTable dt = deserializedDataSet.Tables[0]; Assert.AreEqual("Table1", dt.TableName); Assert.AreEqual(2, dt.Columns.Count); Assert.AreEqual("id", dt.Columns[0].ColumnName); Assert.AreEqual(typeof(long), dt.Columns[0].DataType); Assert.AreEqual("item", dt.Columns[1].ColumnName); Assert.AreEqual(typeof(string), dt.Columns[1].DataType); Assert.AreEqual(2, dt.Rows.Count); }
public static DataSet ConcatDataTables(DataTable p_dt, DataTable p_dt2) { DataSet ds = new DataSet(); ds.Tables.Add(p_dt.Copy()); foreach (DataRow dr in p_dt2.Rows) { ds.Tables[0].Rows.Add(dr.ItemArray); } ds.AcceptChanges(); return ds; }
/// <summary> /// Updates the DataGridView (Users) with any new information in the DB, as /// the DataGridView does not do so automatically /// </summary> public void SetView () { System.Data.SQLite.SQLiteConnection con = new System.Data.SQLite.SQLiteConnection("Data Source=" + DB_Connection + ";Version=3;"); DataSet = new DataSet(); SQLiteDataAdapter dataAdapter = new SQLiteDataAdapter("SELECT * FROM Members", con); dataAdapter.AcceptChangesDuringFill = false; dataAdapter.Fill(DataSet); DataSet.AcceptChanges(); Users.DataContext = DataSet.Tables[0].DefaultView; con.Close(); GC.Collect(); }
/// <summary> /// Returns dataset with configuration table. /// </summary> /// <returns>Dataset with configuration table.</returns> public static DataSet CreateDataSet() { DataSet dataSet = null; try { dataSet = new DataSet(); dataSet.Locale = CultureInfo.InvariantCulture; dataSet.DataSetName = Resources.DatasetName; dataSet.Tables.Add(Resources.TableName); // Set dataset columns. dataSet.Tables[Resources.TableName].Columns.Add(Resources.ColumnAutoStartup, typeof(Boolean)); dataSet.Tables[Resources.TableName].Columns.Add(Resources.ColumnLogMessages, typeof(Int32)); dataSet.Tables[Resources.TableName].Columns.Add(Resources.ColumnProcessBatchSize, typeof(Int32)); dataSet.Tables[Resources.TableName].Columns.Add(Resources.ColumnRunQueuedProcesses, typeof(Boolean)); dataSet.Tables[Resources.TableName].Columns.Add(Resources.ColumnSynchronousExecution, typeof(Boolean)); // Set all values to NOT NULL. foreach (DataColumn dataColumn in dataSet.Tables[Resources.TableName].Columns) { dataColumn.AllowDBNull = false; } // Accept changes. dataSet.AcceptChanges(); return dataSet; } catch { if (dataSet != null) { dataSet.Dispose(); } throw; } }
private void btnAddManual_Click(object sender, EventArgs e) { if (!NP.ReqField(this.txtBatchNumber, "Please enter Batch Number !!")) { return; } if (!NP.ReqField(this.txtQuantity, "Please enter Quantity !!")) { return; } //for (int lm = 0; lm < this.dataGridView1.RowCount; lm++) //{ // if (this.dataGridView1["clnBatchNumber", lm].Value.ToString().Contains(this.txtBatchNumber.Text.Trim())) // { // LimitQty -= decimal.Parse(this.dataGridView1["clnQty", lm].Value.ToString()); // } //} //if (LimitQty < Convert.ToDecimal(txtQuantity.Text.Trim())) //{ // txtQuantity.Select(); // txtQuantity.SelectAll(); // NP.MSGB(NP_Cls.NPMgsStyle.WarningType, "Quantity Over Limit !!"); // return; //} if (this.dsOverview.Tables[0].Rows.Count == 0) { NP_Cls.SqlSelect = "SELECT BatchNumber, UR AS Qty, '" + NP_Cls.autoIDDO + "' as SOAutoID, '" + NP_Cls.SONumberForDO + "' AS SONumber FROM t_StockOverview WHERE (BatchNumber = N'" + this.txtBatchNumber.Text.Trim() + "')"; dsOverview = NP.GetClientDataSet(NP_Cls.SqlSelect); dsOverview.Tables[0].Rows[0]["Qty"] = txtQuantity.Text.Trim(); dsOverview.Tables[0].Rows[0]["SOAutoID"] = NP_Cls.autoIDDO; dsOverview.Tables[0].Rows[0]["SONumber"] = NP_Cls.SONumberForDO; dsOverview.Tables[0].Rows[0]["BatchNumber"] = this.txtBatchNumber.Text.Trim(); dsOverview.AcceptChanges(); } else { NP_Cls.SqlSelect = "SELECT BatchNumber, UR AS Qty, '" + NP_Cls.autoIDDO + "' as SOAutoID, '" + NP_Cls.SONumberForDO + "' AS SONumber FROM t_StockOverview WHERE (BatchNumber = N'" + this.txtBatchNumber.Text.Trim() + "')"; DataSet ds2 = new DataSet(); ds2 = NP.GetClientDataSet(NP_Cls.SqlSelect); ds2.Tables[0].Rows[0]["Qty"] = txtQuantity.Text.Trim(); ds2.Tables[0].Rows[0]["SOAutoID"] = NP_Cls.autoIDDO; ds2.Tables[0].Rows[0]["SONumber"] = NP_Cls.SONumberForDO; ds2.Tables[0].Rows[0]["BatchNumber"] = this.txtBatchNumber.Text.Trim(); ds2.AcceptChanges(); foreach (DataRow item in ds2.Tables[0].Rows) { this.dsOverview.Tables[0].ImportRow(item); } dsOverview.AcceptChanges(); } DGV(); }
public void SaveChanges(DataSet target, object tag = null) { try { string ReturnMessage = _wcfStandard.SetCommonDataSet(DataFilter.GetChangesAndRemoveBlobColums(target, tag == null)); if (!string.IsNullOrEmpty(ReturnMessage)) { throw new Exception("Save Changes " + ReturnMessage); } } finally { target.AcceptChanges(); } }
public void Delete(string XMLfile, string OrderNumber) { DataSet dsResult = new DataSet(); dsResult.ReadXml(XMLfile); DataRow[] dr = dsResult.Tables[0].Select("OrderNumber = '" + OrderNumber + "'"); if (dr != null && dr.Length > 0) { //-- Remove the matched row from dataset dsResult.Tables[0].Rows.Remove(dr[0]); } //-- Accept the dataset changes dsResult.AcceptChanges(); dsResult.WriteXml(XMLfile); }
[Test] public void AcceptChanges() { DataSet ds = new DataSet(); DataTable dtP = DataProvider.CreateParentDataTable(); DataTable dtC = DataProvider.CreateChildDataTable(); ds.Tables.Add(dtP); ds.Tables.Add(dtC); ds.Relations.Add(new DataRelation("myRelation",dtP.Columns[0],dtC.Columns[0])); //create changes dtP.Rows[0][0] = "70"; dtP.Rows[1].Delete(); dtP.Rows.Add(new object[] {9,"string1","string2"}); // AcceptChanges ds.AcceptChanges(); Assert.AreEqual(null, dtP.GetChanges(), "DS1"); //read only exception dtP.Columns[0].ReadOnly = true; // check ReadOnlyException try { dtP.Rows[0][0] = 99; Assert.Fail("DS2: Indexer Failed to throw ReadOnlyException"); } catch (ReadOnlyException) {} catch (AssertionException exc) {throw exc;} catch (Exception exc) { Assert.Fail("DS3: Indexer. Wrong exception type. Got:" + exc); } // check invoke AcceptChanges ds.AcceptChanges(); }
public void TestMethod2() { var dataSet = new DataSet("dataSet"); dataSet.Namespace = "NetFrameWork"; var table = new DataTable(); var idColumn = new DataColumn("id", typeof(int)); idColumn.AutoIncrement = true; var itemColumn = new DataColumn("item"); table.Columns.Add(idColumn); table.Columns.Add(itemColumn); dataSet.Tables.Add(table); for (int i = 0; i < 2; i++) { var newRow = table.NewRow(); newRow["item"] = "item " + i; table.Rows.Add(newRow); } var ctable = new DataTable(); var cidColumn = new DataColumn("id", typeof(int)); cidColumn.AutoIncrement = true; var cpidColumn = new DataColumn("pid", typeof(int)); var citemColumn = new DataColumn("item"); ctable.Columns.Add(cidColumn); ctable.Columns.Add(cpidColumn); ctable.Columns.Add(citemColumn); dataSet.Tables.Add(ctable); var relation = dataSet.Relations.Add(idColumn, cpidColumn); relation.Nested = true; for (int i = 0; i < 4; i++) { var newRow = ctable.NewRow(); newRow["item"] = "item " + i; newRow["pid"] = i % 2; ctable.Rows.Add(newRow); } dataSet.AcceptChanges(); var jsonResult = OrbCore.toJson(dataSet); // doesn't return the results nested together Console.WriteLine(jsonResult); }
private static void SetFirstRowAsHeader(DataSet ds) { foreach (DataTable table in ds.Tables) { if (table.Rows.Count == 0) continue; foreach (DataColumn dc in table.Columns) { string colName = table.Rows[0][dc.Ordinal].ToString().Trim(); if (!string.IsNullOrEmpty(colName) && !table.Columns.Contains(colName)) { table.Columns[dc.Ordinal].ColumnName = colName; } } table.Rows[0].Delete(); } ds.AcceptChanges(); }
public DataSet fnGetBenhNhanList(string _strConn) { var conn = new ConnectionDB(_strConn); try { conn.CallStoredProcedureFromDB("spGetBenhNhanList"); conn.Reader = conn.Command.ExecuteReader(); var myTable = new DataTable("GetBenhNhanListTable"); myTable.Columns.Add("MaBenhNhan", typeof(string)); myTable.Columns.Add("TenBenhNhan", typeof(string)); myTable.Columns.Add("CMND", typeof(string)); myTable.Columns.Add("NgaySinh", typeof(string)); myTable.Columns.Add("DiaChi", typeof(string)); myTable.Columns.Add("SDT", typeof(string)); myTable.Columns.Add("MaPhongKham", typeof(string)); while (conn.Reader.Read()) { myTable.Rows.Add(new[] { conn.Reader["MaBenhNhan"].ToString(), conn.Reader["TenBenhNhan"].ToString(), conn.Reader["CMND"].ToString(), conn.Reader["NgaySinh"].ToString(), conn.Reader["DiaChi"].ToString(), conn.Reader["SDT"].ToString(), conn.Reader["MaPhongKham"].ToString() }); } myTable.AcceptChanges(); var ds = new DataSet(); ds.Tables.Add(myTable); ds.AcceptChanges(); return ds; } catch { return null; throw; } finally { conn.Connection.Close(); } }
private DataSet BuildInitialDataSet() { DataSet initialDataSet = new DataSet(); DataTable customerTable = new DataTable("Customer"); customerTable.Columns.Add(new DataColumn("Id") { AllowDBNull = false, AutoIncrement = true, DataType = typeof(int) }); customerTable.Columns.Add("FirstName", typeof(string)); customerTable.Columns.Add("LastName", typeof(string)); AddCustomerData(customerTable); initialDataSet.Tables.Add(customerTable); initialDataSet.AcceptChanges(); return(initialDataSet); }
private void BtnActualizar_Click(object sender, EventArgs e) { try { //creo commnad builder para generar automaticamente comandos de actualizacion System.Data.SqlClient.SqlCommandBuilder _comando = new System.Data.SqlClient.SqlCommandBuilder(_DAautor); //actualizar informacion _DAautor.Update(_DS.Tables["Autor"]); _DS.AcceptChanges(); //si llego aca, todo ok LblError.Text = "Actualizacion Exitosa"; } catch (Exception ex) { LblError.Text = ex.Message; } }
public void MakeFirstTable(long TransCode) { DataTable table = new DataTable(tablename); table.Columns.Add("v1", typeof(int)); table.Columns.Add("v2", typeof(long)); table.Columns.Add("v3", typeof(DateTime)); table.Columns.Add("v4", typeof(string)); table.Columns.Add("v5", typeof(string)); table.Columns.Add("v6", typeof(string)); table.Columns.Add("v7", typeof(string)); table.Columns.Add("v8", typeof(string)); table.Columns.Add("v9", typeof(string)); table.Columns.Add("v10", typeof(string)); foreach (TransactionLines item in GetAll().Where(line => line.transCode == TransCode)) { table.Rows.Add(item.LineCode, item.transCode, item.LineDate.Value, item.MainType, item.accCode, item.DebitAmount, item.CreditAmount, item.Discription, item.offsetMainType, item.offsetAccCode); } DataSet = new System.Data.DataSet(); DataSet.Tables.Add(table); DataSet.AcceptChanges(); }
public int Update(System.Data.DataSet dataSet, string srcTable, bool inclHeader) { if (inclHeader) { m_hasheader = true; } if (dataSet.HasChanges()) { DataTable table; try { table = dataSet.Tables[srcTable]; } catch { //could not find the table specified throw new ArgumentException("srcTable does not exist in specified dataSet"); } //open filestream (overwrite previous file) m_writer = new StreamWriter(m_filename, false); if (m_hasheader) { string columnrow = ""; //write header row foreach (DataColumn dc in table.Columns) { //write column name columnrow += dc.ColumnName + m_DelimiterString; } //write assembled column names minus the trailing comma m_writer.WriteLine(columnrow.TrimEnd(m_DelimiterString.ToCharArray())); } //count the number of rows written int rowsaffected = 0; //write out all the rows (unless they were deleted) foreach (DataRow thisrow in table.Rows) { //write all except deleted rows if (thisrow.RowState != DataRowState.Deleted) { //write assembled row minus the trailing comma m_writer.WriteLine(BuildRow(thisrow.ItemArray, m_DelimiterString, m_RemoveDelimiterString)); rowsaffected++; } } //close filestream m_writer.Close(); //mark dataset as up-to-date try { dataSet.AcceptChanges(); } catch { } //return number of rows written return(rowsaffected); } else { //no changes - ignore return(0); } }
///<summary> /// using the DataSet and DataTable names. ///</summary> ///<param name=”dataSet”>A DataSet to fill with records and, if necessary, schema.</param> ///<param name=”tableName”>The name of the source table to use for table mapping.</param> ///<returns>The number of rows successfully added to or refreshed in the DataSet. ///This does not include rows affected by statements that do not return rows.</returns> public int Fill(System.Data.DataSet dataSet, string tableName) { //table within the dataset DataTable dt = dataSet.Tables.Add(tableName); //store records affected int records = 0; //raw row string rawrow; //store the current row string[] rowbuffer = new string[0]; //more records bool morerecords = true; //open stream to read from file m_reader = new StreamReader(m_filename); if (m_hasheader) { //read header row and construct schema m_headers = SplitRow(m_reader.ReadLine(), m_DelimiterString); foreach (string column in m_headers) { //add to columns collection DataColumn dc = dt.Columns.Add(column); dc.DataType = typeof(string); dc.AllowDBNull = true; } //read first data row rawrow = m_reader.ReadLine(); //check for null first - avoid throwing exception if (rawrow == null | rawrow == String.Empty) { morerecords = false; } else { rowbuffer = SplitRow(rawrow, m_DelimiterString); } } else { //read line rawrow = m_reader.ReadLine(); if (rawrow == null | rawrow == String.Empty) { morerecords = false; } else { //read the first row and get the length rowbuffer = SplitRow(rawrow, m_DelimiterString); } for (int iColumn = 0; iColumn < rowbuffer.Length; iColumn++) { //add to columns collection DataColumn dc = dt.Columns.Add("Column" + iColumn.ToString()); dc.DataType = typeof(string); dc.AllowDBNull = true; } } //processing of further rows goes here while (morerecords) { //increment rows affected records++; //add values to row and insert into table dt.Rows.Add(rowbuffer); //read the next row rawrow = m_reader.ReadLine(); if (rawrow == null | rawrow == String.Empty) { morerecords = false; } else { //read the first row and get the length rowbuffer = SplitRow(rawrow, m_DelimiterString); } } //close stream m_reader.Close(); //mark dataset as up-to-date dataSet.AcceptChanges(); return(records); }
/// <summary> /// using the DataSet and DataTable names. /// </summary> /// <param name="dataSet">A DataSet to fill with records and, if necessary, schema.</param> /// <param name="tableName">The name of the source table to use for table mapping.</param> /// <returns>The number of rows successfully added to or refreshed in the DataSet. This does not include rows affected by statements that do not return rows.</returns> public int Fill(System.Data.DataSet dataSet, string tableName) { //table within the dataset DataTable dt; if (dataSet.Tables.Contains(tableName)) { dt = dataSet.Tables[tableName]; } else { dt = dataSet.Tables.Add(tableName); } //store records affected int records = 0; //raw row string rawrow; //store the current row string[] rowbuffer = new string[0]; //more records bool morerecords = true; //open stream to read from file m_reader = new StreamReader(m_filename); if (m_hasheader) { rawrow = m_reader.ReadLine(); if (rawrow == null) { // no data return(0); } //read header row and construct schema m_headers = SplitRow(rawrow); foreach (string column in m_headers) { string columnName = column; //add to columns collection if (dt.Columns.Contains(columnName)) { int index = 1; do { columnName = column + index.ToString(); index++; } while (dt.Columns.Contains(columnName)); } DataColumn dc = dt.Columns.Add(columnName); dc.DataType = typeof(string); dc.AllowDBNull = true; } //read first data row //Updated (Bug# 000091) Failure if only header row present rawrow = m_reader.ReadLine(); //check for null first - avoid throwing exception if (rawrow == null | rawrow == String.Empty) { morerecords = false; } else { rowbuffer = SplitRow(rawrow); } } else { //read line rawrow = m_reader.ReadLine(); if (rawrow == null | rawrow == String.Empty) { morerecords = false; } else { //read the first row and get the length rowbuffer = SplitRow(rawrow); } for (int iColumn = 0; iColumn < rowbuffer.Length; iColumn++) { //add to columns collection DataColumn dc = dt.Columns.Add("Column " + iColumn.ToString()); dc.DataType = typeof(string); dc.AllowDBNull = true; } } //processing of further rows goes here int newColNum = 0; bool addRow = true; while (morerecords) { //increment rows affected if (addRow) { records++; } addRow = true; if (rowbuffer.Length != dt.Columns.Count) { // support adding new columns at the very end if ((HasHeaderRow) && (string.Compare(rowbuffer[0], dt.Columns[0].ColumnName) == 0)) { addRow = false; newColNum = dt.Columns.Count; while (rowbuffer.Length > dt.Columns.Count) { dt.Columns.Add(rowbuffer[newColNum++]); } } else { // if the column count expanded mid-data, account for it while (rowbuffer.Length > dt.Columns.Count) { dt.Columns.Add(string.Format("New column {0}", ++newColNum)); } } } //add values to row and insert into table if (addRow) { dt.Rows.Add(rowbuffer); } //read the next row rawrow = m_reader.ReadLine(); if (rawrow == null | rawrow == String.Empty) { morerecords = false; } else { //read the first row and get the length rowbuffer = SplitRow(rawrow); } } //close stream m_reader.Close(); //mark dataset as up-to-date dataSet.AcceptChanges(); return(records); }
private void _Toolbar1_Guardar_Click(System.Object sender, System.EventArgs e) { OleDbDataAdapter dbClientes = new OleDbDataAdapter(); System.Data.DataSet dbRegistros = null; System.Data.DataRow fila = null; string NombreTabla = "tblFactura"; //Antes de cargar nada fijamos si puede guardarlo en la AFIP sino no sigue con el guardado de la factura //ESP La funcion EnviarFacturaAFIP esta en el modulo de AFIP. bool bolFactEnAFIP = AFIP.EnviarFacturaAFIP(Imprimir.CargarFactura(gridDatos.Rows.Count - 1), lblToken.Text, lblSign.Text); if (bolFactEnAFIP != true) { Interaction.MsgBox("NO se pudo cargar la factura en AFIP. Intentelo nuevamente", MsgBoxStyle.Information); return; } //Cargo la tabla en la base //Facturas A if (lblCod_cbe.Text == "01") { dbClientes = BaseDeDatos.rstTabla("Facturas", "Fecha", ""); //Facturas B } else if (lblCod_cbe.Text == "06") { dbClientes = BaseDeDatos.rstTabla("FacturasB", "Fecha", ""); //Notas de Credito } else if (lblCod_cbe.Text == "03") { dbClientes = BaseDeDatos.rstTabla("NotaCredito", "Fecha", ""); //Notas de Debito } else if (lblCod_cbe.Text == "02") { dbClientes = BaseDeDatos.rstTabla("NotaDebito", "Fecha", ""); } //Asigno un nuevo Data Set dbRegistros = new System.Data.DataSet(); try { dbClientes.Fill(dbRegistros, NombreTabla); } catch (Exception ex) { MessageBox.Show("Error en el llenado:" + Constants.vbCrLf + ex.Message); } OleDbCommandBuilder cb = new OleDbCommandBuilder(dbClientes); miFactura = Imprimir.CargarFactura(gridDatos.Rows.Count - 1); fila = dbRegistros.Tables[NombreTabla].NewRow(); fila.BeginEdit(); //Cargo el valor del "DOCUMENTO" //Facturas A if (lblCod_cbe.Text == "01") { fila["Documento"] = "FC A " + Strings.Format(miFactura.intSucursal, "0000") + "-" + Strings.Format(miFactura.dblNumFact, "00000000"); //Facturas B } else if (lblCod_cbe.Text == "06") { fila["Documento"] = "FC B " + Strings.Format(miFactura.intSucursal, "0000") + "-" + Strings.Format(miFactura.dblNumFact, "00000000"); //Notas de Credito } else if (lblCod_cbe.Text == "03") { fila["Documento"] = "NC " + Strings.Format(miFactura.intSucursal, "0000") + "-" + Strings.Format(miFactura.dblNumFact, "00000000"); //Notas de Debito } else if (lblCod_cbe.Text == "02") { fila["Documento"] = "ND " + Strings.Format(miFactura.intSucursal, "0000") + "-" + Strings.Format(miFactura.dblNumFact, "00000000"); } fila["Sucursal"] = miFactura.intSucursal; fila["NumFact"] = miFactura.dblNumFact; fila["Fecha"] = miFactura.dtFecha; // fila["IDCliente"] = miFactura.Cliente.strid; fila["Nombre"] = miFactura.Cliente.strNombre; fila["Direccion"] = miFactura.Cliente.strDireccion; fila["Localidad"] = miFactura.Cliente.strLocalidad; fila["Provincia"] = miFactura.Cliente.strProvincia; fila["Tipodecambio"] = miFactura.dblTipoCambio; fila["Descuento"] = Conversion.Str(miFactura.Cliente.dblDescuento); fila["Cant1"] = miFactura.Producto1.intCantidad; fila["Detalle1"] = miFactura.Producto1.strDescripcion; fila["PrecioUnitario1"] = miFactura.Producto1.curPrecioNeto; fila["PrecioFinal1"] = miFactura.Producto1.curPrecioTotal; fila["Cant2"] = miFactura.Producto2.intCantidad; fila["Detalle2"] = miFactura.Producto2.strDescripcion; fila["PrecioUnitario2"] = miFactura.Producto2.curPrecioNeto; fila["PrecioFinal2"] = miFactura.Producto2.curPrecioTotal; fila["Cant3"] = miFactura.Producto3.intCantidad; fila["Detalle3"] = miFactura.Producto3.strDescripcion; fila["PrecioUnitario3"] = miFactura.Producto3.curPrecioNeto; fila["PrecioFinal3"] = miFactura.Producto3.curPrecioTotal; fila["Cant4"] = miFactura.Producto4.intCantidad; fila["Detalle4"] = miFactura.Producto4.strDescripcion; fila["PrecioUnitario4"] = miFactura.Producto4.curPrecioNeto; fila["PrecioFinal4"] = miFactura.Producto4.curPrecioTotal; fila["Cant5"] = miFactura.Producto5.intCantidad; //Cantidad 5 fila["Detalle5"] = miFactura.Producto5.strDescripcion; //Detalle5 fila["PrecioUnitario5"] = miFactura.Producto5.curPrecioNeto; //Precio Unitario 5 fila["PrecioFinal5"] = miFactura.Producto5.curPrecioTotal; //Precio Final 5 fila["Cant6"] = 0; //Cantidad 6 fila["Detalle6"] = " "; //Detalle6 fila["PrecioUnitario6"] = 0; //Precio Unitario 6 fila["PrecioFinal6"] = 0; //Precio Final 6 fila["SubTotal"] = miFactura.curSubTotal; //Sub Total $ fila["IVA"] = miFactura.curIVA; //IVA $ fila["ImporteFinal"] = miFactura.curTotal; //Importe Final $ fila["Recibo1"] = 0; fila["Recibo2"] = 0; //Recibo2 fila["Recibo3"] = 0; //Recibo3 fila["Recibo4"] = 0; //Recibo4 fila["Recibo5"] = 0; //Recibo5 fila["ClienteDe"] = " "; //Cliente De fila["Remito1"] = miFactura.intRemito1; // fila["Remito2"] = miFactura.intRemito2; //Remito2 fila["Remito3"] = miFactura.intRemito3; //Remito3 fila["Remito4"] = miFactura.intRemito4; //Remito4 fila["Remito5"] = 0; //Remito5 fila["Observaciones"] = " "; //Observaciones fila["SubTotalUSS"] = miFactura.curSubTotalUSD; //Sub Total USS fila["IVAUSS"] = miFactura.curIVAUSD; //IVA USS fila["ImporteFinalUSS"] = miFactura.curTotalUSD; //Importe Final USS fila["EnDolar"] = 0.0; //En Dolar fila["Saldo"] = Strings.Replace(Conversion.Str(miFactura.curTotal), ".", ","); //Saldo fila["SaldoUSS"] = miFactura.curTotalUSD; //SaldoUSS fila["Pagado"] = false; fila["Dólar"] = true; fila["Peso"] = false; fila["Promocion"] = 0; fila["CAE"] = miFactura.strCAE; fila["FechaVencCAE"] = miFactura.strFechVtoCAE; //Finaliza la edicion fila.EndEdit(); //Añade la fila a la tabla dbRegistros.Tables[NombreTabla].Rows.Add(fila); //Actualiza la base de datos dbClientes.Update(dbRegistros, NombreTabla); //acepta los cambios dbRegistros.AcceptChanges(); //MsgBox(miFactura.strTipoFc) //MsgBox(miFactura.intSucursal) //MsgBox(miFactura.dtFecha) Interaction.MsgBox("Factura Cargada"); //Este modulo edita la tabla de remitos y asigna el valor de la factura y su respectiva //sucursal al remito en cuestion //eso lo saca de los desplegables de remitos ModDocFiscales.EditarRemitos((cmbSucursal.Text), Convert.ToDouble(txtNumFact.Text), Convert.ToDouble(cmbRemito1.Text)); Interaction.MsgBox("Remito: " + cmbRemito1.Text + ". Modificado"); //Esto permite que se pueda imprimir _Toolbar1_Imprimir.Enabled = true; //Esto impide que se vuelva a guardar _Toolbar1_Guardar.Enabled = false; }
public void CountDeceasedNameRepeatency() { DataSet dataSet = new DataSet(); dataSet.ReadXml("jawiname.xml"); DataTable original = dataSet.Tables[0]; DataTable result = new DataTable("jawiname"); Dictionary<string, character> characters = new Dictionary<string, character>(); //mount to a relative path DirectoryInfo directoryInfo = new DirectoryInfo("..\\..\\..\\..\\..\\JawiName"); FileInfo[] filesInfo = directoryInfo.GetFiles(); foreach (FileInfo info in filesInfo) { string[] rootNames = info.FullName.ToLower() .TrimEnd(new char[] { 's', 'f', '.' }) .Split(new char[] { ' ' }); foreach (string s in rootNames) { if (!characters.ContainsKey(s)) characters.Add(s, new character(s, GetArabicString(original, s))); else characters[s].counter += 1; } } dataSet.Tables.Add(result); dataSet.AcceptChanges(); dataSet.WriteXml("result.xml"); }