public static void SaveDataSetAsXml(DataSet set, string fileName) { string file = Regex.Replace( fileName, extPattern, fileName ); fileName = VerifyFileExt( fileName, ".xml" ); set.WriteXml( fileName ); set.WriteXmlSchema( file + ".xsd" ); }
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 void EliminarConfiguracion(XML_Config config) { try { //leemos nuevamente las configuraciones en un dataset, y agregamos DataSet ds = new DataSet(); ds.ReadXml(this.filePath); DataTable dt = ds.Tables["configuracion"]; //buscamos la configuracion a borrar DataRow dr = null; foreach (DataRow row in dt.Rows) { if (Convert.ToInt32(row["Id"]) == config.Id) { dr = row; break; } } //si la encontramos, la borramos y grabamos los cambios if (dr != null) { dt.Rows.Remove(dr); ds.WriteXml(this.filePath); } } catch (Exception ex) { throw (ex); } }
private void StringToDataSet() { DataSet ds; StringReader rdr; StringBuilder sb = new StringBuilder(1024); sb.Append("<Products>"); sb.Append(" <Product>"); sb.Append(" <ProductID>1</ProductID>"); sb.Append(" <ProductName>Chai</ProductName>"); sb.Append(" <UnitPrice>18</UnitPrice>"); sb.Append(" <Discontinued>false</Discontinued>"); sb.Append(" </Product>"); sb.Append(" <Product>"); sb.Append(" <ProductID>2</ProductID>"); sb.Append(" <ProductName>Chang</ProductName>"); sb.Append(" <UnitPrice>19</UnitPrice>"); sb.Append(" <Discontinued>false</Discontinued>"); sb.Append(" </Product>"); sb.Append("</Products>"); rdr = new System.IO.StringReader(sb.ToString()); ds = new DataSet(); ds.ReadXml(rdr); ds.WriteXml(AppConfig.XmlFile); txtResult.Text = File.ReadAllText(AppConfig.XmlFile); }
/// <summary> /// 保存 /// </summary> /// <returns></returns> private int Save() { this.neuFpEnter1_Sheet1.SortRows((int)ColSet.顺序号, true, false); //自定义保存 Neusoft.FrameWork.Models.NeuObject o = this.GetSQL(); if (o == null) { return(-1); } string errInfo = ""; Neusoft.FrameWork.Management.PublicTrans.BeginTransaction(); this.dbMgr.SetTrans(Neusoft.FrameWork.Management.PublicTrans.Trans); if (this.SaveSqlInfo(o, ref errInfo) != -1) { try { System.Data.DataSet ds = this.neuFpEnter1_Sheet1.DataSource as System.Data.DataSet; if (ds != null) { System.IO.StringWriter sw = new System.IO.StringWriter(); ds.WriteXml(sw, XmlWriteMode.WriteSchema); string xml = sw.ToString(); sw.Close(); if (this.SaveDefineInfo(o.ID, xml, ref errInfo) != -1) { this.myPreDefine.ID = ""; this.myPreDefine.User01 = o.ID; this.myPreDefine.User03 = o.Name; } else { Neusoft.FrameWork.Management.PublicTrans.RollBack(); this.ShowMessageBox(errInfo, "错误"); return(-1); } } } catch (Exception ex) { Neusoft.FrameWork.Management.PublicTrans.RollBack(); this.ShowMessageBox(ex.Message, "错误"); return(-1); } } else { Neusoft.FrameWork.Management.PublicTrans.RollBack(); this.ShowMessageBox(errInfo, "错误"); return(-1); } Neusoft.FrameWork.Management.PublicTrans.Commit(); return(1); }
public void Luu_Cau_Hinh() { try { System.Data.DataSet ds = new System.Data.DataSet(); var dt = new DataTable("CauHinhCSDL"); dt.Columns.Add("MayChu"); dt.Columns.Add("SuDungTaiKhoanWindows"); dt.Columns.Add("TaiKhoanSQL"); dt.Columns.Add("Password"); dt.Columns.Add("CSDL"); dt.Rows.Clear(); dt.Rows.Add( new object[] { txtMayChuSQL.Text, cbSuDungTaiKhoanWindows.Checked.ToString(), txtTaiKhoanSQL.Text, txtPassword.Text, txtTenCSDL.Text } ); ds.Tables.Add(dt); ds.WriteXml("CauHinhCSDL.xml"); } catch (Exception ex) { XtraMessageBox.Show(ex.Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public bool SaveQueue(string fileName) { // TODO: Implement Method - LogManager.SaveQueue() string path = ""; // to be replaced with data table of queue System.Data.DataTable dt = null; path = System.Configuration.ConfigurationSettings.AppSettings["XmlLogPath"]; if (!System.IO.Directory.Exists(path)) { System.IO.Directory.CreateDirectory(path); } if (!path.EndsWith("\\")) { path = path + "\\"; } System.Data.DataSet ds = new System.Data.DataSet(); ds.Tables.Add(dt); ds.WriteXml(path + fileName, System.Data.XmlWriteMode.IgnoreSchema); ds.Dispose(); return(true); }
private void button1_Click(object sender, EventArgs e) { listBox1.SelectedIndexChanged += new EventHandler(example1_SelectedIndexChanged); //create a dataset DataSet ds = new DataSet("XMLAuthors"); //connect to the northwind database and //select all of the rows from products table SqlConnection conn = new SqlConnection(_connectString); SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM authors", conn); //use memory stream so we don't have to create temp files MemoryStream memStrm = new MemoryStream(); StreamReader strmRead = new StreamReader(memStrm); StreamWriter strmWrite = new StreamWriter(memStrm); //fill the dataset da.Fill(ds, "Authors"); //load data into grid dataGridView1.DataSource = ds.Tables[0]; //dataGrid1.DataMember = "Authors"; //write the xml from the dataset to the memory stream ds.WriteXml(strmWrite, XmlWriteMode.IgnoreSchema); memStrm.Seek(0, SeekOrigin.Begin); //read from the memory stream to a XmlDocument object doc.Load(strmRead); //get all of the products elements XmlNodeList nodeLst = doc.SelectNodes("//au_lname"); //load them into the list box foreach (XmlNode nd in nodeLst) listBox1.Items.Add(nd.InnerText); }
public void run() { Exception exp = null; System.IO.StringReader sr = null; System.IO.StringWriter sw = null; try { BeginCase("ReadXml - DataSetOut"); DataSet oDataset = new DataSet("DataSetOut"); sw = new System.IO.StringWriter(); oDataset.WriteXml(sw,System.Data.XmlWriteMode.WriteSchema); sr = new System.IO.StringReader(sw.GetStringBuilder().ToString()); oDataset = new DataSet("DataSetOut"); oDataset.ReadXml(sr); Compare(oDataset.Tables.Count ,0); } catch(Exception ex) {exp = ex;} finally { EndCase(exp); exp = null; sw.Close(); } }
/// <summary> /// 保存设置 /// </summary> /// <param name="invoiceType">发票类型</param> /// <param name="dtSetting">设置数据</param> /// <returns></returns> public static bool SaveSetting(InvoiceType invoiceType, DataTable dtSetting) { try { System.Data.DataSet ds = GetInvoiceSettingConfig( ); string invoiceName = "门诊收费发票"; if (invoiceType == InvoiceType.挂号发票) { invoiceName = "门诊挂号发票"; } DataRow[] drs = ds.Tables["INVOICE_ITEMS"].Select("INVOICE_NAME='" + invoiceName + "'"); foreach (DataRow dr in drs) { ds.Tables["INVOICE_ITEMS"].Rows.Remove(dr); } foreach (DataRow dr in dtSetting.Rows) { ds.Tables["INVOICE_ITEMS"].Rows.Add(dr.ItemArray); } ds.WriteXml(configFilePath); return(true); } catch { return(false); } }
public static void AddTestData() { // declare DataSet and DataTable DataSet ds = new DataSet(); DataTable dt = new DataTable(); // declare the name and type of each column dt.Columns.Add(new DataColumn("ID", typeof(Int32))); dt.Columns.Add(new DataColumn("Name", typeof(String))); dt.Columns.Add(new DataColumn("Vertical", typeof(Int32))); // add test data to each row in the DataTable fillRow(dt, 1, "Buck", 200); fillRow(dt, 2, "Buckaroo", 325); fillRow(dt, 3, "Hoot Ow", 999); fillRow(dt, 4, "Shelburg's Chute", 1023); // add the DataTable to the DataSet and name it ds.Tables.Add(dt); ds.Tables[0].TableName = "SkiRun"; // name the DataSet ds.DataSetName = "SkiRuns"; // create a XmlWriterSettings object to set the writing method XmlWriterSettings settings = new XmlWriterSettings(); settings.Indent = true; settings.IndentChars = "\t"; // create an XMLWriter, write the datatable to the file using it, and close XmlWriter xmlWriter = XmlWriter.Create(DataSettings.dataFilePath, settings); ds.WriteXml(xmlWriter); xmlWriter.Close(); }
private static void ConvertDataSetToXMLFile(DataSet xmlDS, string xmlFile) { MemoryStream stream = null; XmlTextWriter writer = null; try { stream = new MemoryStream(); //从stream装载到XmlTextReader writer = new XmlTextWriter(stream, Encoding.Unicode); //用WriteXml方法写入文件. xmlDS.WriteXml(writer); int count = (int)stream.Length; byte[] arr = new byte[count]; stream.Seek(0, SeekOrigin.Begin); stream.Read(arr, 0, count); //返回Unicode编码的文本 UnicodeEncoding utf = new UnicodeEncoding(); StreamWriter sw = new StreamWriter(xmlFile); sw.WriteLine("<?xml version=\"1.0\" encoding=\"utf-8\"?>"); sw.WriteLine(utf.GetString(arr).Trim()); sw.Close(); } catch (System.Exception ex) { throw ex; } finally { if (writer != null) writer.Close(); } }
/// <summary> /// Method exports database from the provided connection string to the XML file with provided name. /// </summary> /// <param name="fileName">Name of the new file that method will create.</param> /// <param name="connString">Connection string for database that will be exported.</param> /// <returns>Result that will notify employee on success status.</returns> public static string exportIntoXML(string fileName, string connString) { string result; using (SqlConnection conn = new SqlConnection(connString)) { SqlCommand command = new SqlCommand("SELECT * FROM UserData", conn); command.CommandType = CommandType.Text; SqlDataAdapter da = new SqlDataAdapter(command); DataSet ds = new DataSet(); da.Fill(ds, "UserData"); //Get a FileStream object// StreamWriter xmlDoc = new StreamWriter(System.Web.Hosting.HostingEnvironment.MapPath("~/doc/" + fileName + ".xml"), false); //Apply the WriteXml method to write an XML document// ds.WriteXml(xmlDoc); xmlDoc.Close(); } if (File.Exists(System.Web.Hosting.HostingEnvironment.MapPath("~/doc/" + fileName + ".xml"))) { result = "Successfully created XML file: " + fileName + ".xml"; } else { result = "Operation failed!"; } return result; }
private void button1_Click(object sender, EventArgs e) { string s = Application.StartupPath; try { XmlTextReader xmlreader1 = new XmlTextReader("D:\\Dropboxdata\\Rms\\RMS\\RMS\\bin\\Debug\\MyXmlFile.xml"); XmlTextReader xmlreader2 = new XmlTextReader("D:\\Dropboxdata\\Rms\\RMS\\RMS\\bin\\Debug\\XML2.xml"); DataSet ds = new DataSet(); ds.ReadXml(xmlreader1); DataSet ds2 = new DataSet(); ds2.ReadXml(xmlreader2); ds.Merge(ds2); // ds2.Merge(ds); ds.WriteXml("D:\\Dropboxdata\\Rms\\RMS\\RMS\\bin\\Debug\\Books.xml"); MessageBox.Show("Completed merging XML documents"); } catch (System.Exception ex) { MessageBox.Show(ex.Message); } }
//将DataSet转换为xml对象字符串 public static string ConvertDataSetToXML(DataSet xmlDS) { MemoryStream stream = null; XmlTextWriter writer = null; try { stream = new MemoryStream(); //从stream装载到XmlTextReader writer = new XmlTextWriter(stream, Encoding.Unicode); //用WriteXml方法写入文件. xmlDS.WriteXml(writer); int count = (int)stream.Length; byte[] arr = new byte[count]; stream.Seek(0, SeekOrigin.Begin); stream.Read(arr, 0, count); UnicodeEncoding utf = new UnicodeEncoding(); return utf.GetString(arr).Trim(); } catch (System.Exception ex) { throw ex; } finally { if (writer != null) writer.Close(); } }
public void GetDataSet() { SoapContext sc = HttpSoapContext.ResponseContext; if (null == sc) { throw new ApplicationException("Only SOAP requests allowed"); } SqlConnection conn = new SqlConnection(@"data source=(local)\NetSDK;" + "initial catalog=Northwind;integrated security=SSPI"); SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM customers", conn); DataSet ds = new DataSet("CustomerDS"); da.Fill(ds, "Customers"); // dispose of all objects that are no longer necessary da.Dispose(); conn.Dispose(); MemoryStream memoryStream = new MemoryStream(1024); GZipOutputStream gzipStream = new GZipOutputStream(memoryStream); ds.WriteXml(gzipStream); gzipStream.Finish(); memoryStream.Seek(0, SeekOrigin.Begin); DimeAttachment dimeAttachment = new DimeAttachment("application/x-gzip", TypeFormatEnum.MediaType, memoryStream); sc.Attachments.Add(dimeAttachment); }
/// <summary> /// 保存 /// </summary> public void Save(string fname, DataSet ds) { using(StreamWriter sWrite = new StreamWriter(fname, false, System.Text.Encoding.Default)) { ds.WriteXml(sWrite, XmlWriteMode.WriteSchema); } }
static void Main(string[] args) { var connectionString = ConfigurationManager.ConnectionStrings["Nordwind"].ConnectionString; var selectStatement = "SELECT * FROM Categories"; using (SqlConnection connection = new SqlConnection(connectionString)) { using (SqlCommand command = new SqlCommand(selectStatement)) { command.Connection = connection; SqlDataAdapter adapter = new SqlDataAdapter(command); DataSet ds = new DataSet(); connection.Open(); adapter.Fill(ds, "Categories"); ds.WriteXml("ds.xml"); // Save this DataSet as XML ds.WriteXmlSchema("ds.xsd"); ds.Clear(); ds.ReadXml("ds.xml"); DataTable categories = ds.Tables["Categories"]; foreach(DataRow item in categories.Rows) { Console.WriteLine("id: {0}, {1} {2}:", item["CategoryID"], item["CategoryName"], item["Description"]); } Console.ReadLine(); } } }
public static void SaveGridToXml(System.Windows.Forms.DataGridView grid, string fileName) { string path = System.Windows.Forms.Application.StartupPath + "\\data.xml"; System.Data.DataSet dataSet = (System.Data.DataSet)grid.DataSource; dataSet.WriteXml(fileName); }
private void WriteXmlDoc(int provinceID) { SqlConnection con=new SqlConnection("server=127.0.0.1;uid=sa;pwd=;database=Address"); SqlCommand com=con.CreateCommand(); com.CommandText="select * from area where ParentID="+provinceID+""; SqlDataAdapter adpt=new SqlDataAdapter(); adpt.SelectCommand=com; DataSet ds=new DataSet(); con.Open(); try { adpt.Fill(ds); } catch(Exception ex) { } finally { con.Close(); } ds.WriteXml(this.Response.OutputStream); this.Response.End(); }
public static DataSet DownloadGroupListXml() { var groupsDataSet = new DataSet(); groupsDataSet.ReadXml(GetInfoFromServer(@"http://www.bsuir.by/schedule/rest/studentGroup")); groupsDataSet.WriteXml(Path.Combine("Data", "groups.xml")); return groupsDataSet; }
private void button1_Click(object sender, EventArgs e) { string connectString = "Server=.\\SQLExpress;Database=adventureworkslt;Trusted_Connection=Yes"; //create a dataset DataSet ds = new DataSet("XMLProducts"); //connect to the pubs database and //select all of the rows from products table SqlConnection conn = new SqlConnection(connectString); SqlDataAdapter da = new SqlDataAdapter("SELECT Name, StandardCost FROM SalesLT.Product", conn); da.Fill(ds, "Products"); ds.Tables[0].Rows[0]["Name"] = "NewName"; DataRow dr = ds.Tables[0].NewRow(); dr["Name"] = "Unicycle"; dr["StandardCost"] = "45.00"; ds.Tables[0].Rows.Add(dr); ds.WriteXmlSchema("products.xdr"); ds.WriteXml("proddiff.xml", XmlWriteMode.DiffGram); webBrowser1.Navigate(AppDomain.CurrentDomain.BaseDirectory + "/proddiff.xml"); //load data into grid dataGridView1.DataSource = ds.Tables[0]; }
// База данных - создание public static void CreateBD() { // создание набора данных DataSet ds = new DataSet(); DataColumn dc; // создаем таблицу заказов // добавляем таблицу в список таблиц набора данных ds.Tables.Add(new DataTable("Пользователи")); // атрибут dc = new DataColumn("Номер", Type.GetType("System.Int32")); ds.Tables["Пользователи"].Columns.Add(dc); // атрибут dc = new DataColumn("Имя", Type.GetType("System.String")); ds.Tables["Пользователи"].Columns.Add(dc); // атрибут dc = new DataColumn("Фамилия", Type.GetType("System.String")); ds.Tables["Пользователи"].Columns.Add(dc); // атрибут dc = new DataColumn("ДатаРождения", Type.GetType("System.String")); ds.Tables["Пользователи"].Columns.Add(dc); // первичным ключом будет номер DataColumn[] key = new DataColumn[1] { ds.Tables["Пользователи"].Columns["Номер"] };// ds.Tables["Пользователи"].PrimaryKey = key; ds.WriteXml("users.xml", XmlWriteMode.WriteSchema); }
public XmlDataAdapter(String dbname) { _savePath = Environment.CurrentDirectory; _savePath = Path.Combine(_savePath,dbname + ".xml"); if(Directory.Exists(Path.GetDirectoryName(_savePath)) == false) Directory.CreateDirectory(Path.GetDirectoryName(_savePath)); if (File.Exists(_savePath)) { _dataset = new DataSet(); try { _dataset.ReadXml(_savePath, XmlReadMode.Auto); } catch(Exception e) { File.Move(_savePath, String.Format("{0}.corrupted",_savePath)); _dataset = new DataSet(dbname); _dataset.WriteXml(_savePath, XmlWriteMode.WriteSchema); } } else { _dataset = new DataSet(dbname); _dataset.WriteXml(_savePath, XmlWriteMode.WriteSchema); } }
/// <summary> /// Test exporting XML from DataSet /// </summary> private static void Test_DataSet_ExportXML() { using (CUBRIDConnection conn = new CUBRIDConnection()) { conn.ConnectionString = TestCases.connString; conn.Open(); String sql = "select * from nation order by `code` asc"; CUBRIDDataAdapter da = new CUBRIDDataAdapter(); da.SelectCommand = new CUBRIDCommand(sql, conn); DataSet ds = new DataSet(); da.Fill(ds, "nation"); string filename = @".\Test_DataSet_ExportXML.xml"; ds.WriteXml(filename); if (!System.IO.File.Exists(filename)) { throw new Exception("XML output file not found!"); } else { System.IO.File.Delete(filename); } } }
private void button1_Click(object sender, EventArgs e) { XmlDocument doc = new XmlDocument(); //create a dataset DataSet ds = new DataSet("TASKDATA"); //connect to the northwind database and //select all of the rows from products table SqlConnection conn = new SqlConnection(_connectString); SqlDataAdapter da = new SqlDataAdapter("SELECT Title,userid,content FROM task", conn); //fill the dataset da.Fill(ds, "Task"); //load data into grid dataGridView1.DataSource = ds.Tables["Task"]; //use memory stream so we don't have to create temp files MemoryStream memStrm = new MemoryStream(); StreamReader strmRead = new StreamReader(memStrm); StreamWriter strmWrite = new StreamWriter(memStrm); //dataGrid1.DataMember = "Authors"; //write the xml from the dataset to the memory stream string file = "task.xml"; //ds.WriteXml(strmWrite, XmlWriteMode.IgnoreSchema); ds.WriteXml(file, XmlWriteMode.IgnoreSchema); memStrm.Seek(0, SeekOrigin.Begin); //read from the memory stream to a XmlDocument object //doc.Load(strmRead); //get all of the products elements XmlNodeList nodeLst = doc.SelectNodes("//TASKDATA/Task"); textBox1.Text = ""; foreach (XmlNode node in nodeLst) { textBox1.Text += node.InnerXml + "\r\n"; } }
public static DataSet DownloadTeacherListXml() { var teachersDataSet = new DataSet(); teachersDataSet.ReadXml(GetInfoFromServer(@"http://www.bsuir.by/schedule/rest/employee")); teachersDataSet.WriteXml(Path.Combine("Data", "teachers.xml")); return teachersDataSet; }
public static DataSet DownloadGroupXml(string id) { var groupsDataSet = new DataSet(); groupsDataSet.ReadXml(GetInfoFromServer($"http://www.bsuir.by/schedule/rest/schedule/{id}")); groupsDataSet.WriteXml(Path.Combine("Data", $"{id}.xml")); return groupsDataSet; }
private static void SaveSizeForm(XtraForm form) { try { string path = FrameworkParams.LAYOUT_FOLDER + @"\" + FrameworkParams.currentUser.username + form.Name + @".xml"; CreateFileStroreSize(path); DataSet ds = new DataSet(); ds.ReadXml(path); if (ds.Tables.Count == 0) { DataTable table = new DataTable(); table.Columns.Add(form.Name); ds.Tables.Add(table); } if (!ds.Tables[0].Columns.Contains(form.Name)) ds.Tables[0].Columns.Add(form.Name); if (ds.Tables[0].Rows.Count == 0) ds.Tables[0].Rows.Add(form.Width + "," + form.Height + "," + form.Location.X + "," + form.Location.Y); else ds.Tables[0].Rows[0][form.Name] = form.Width + "," + form.Height + "," + form.Location.X + "," + form.Location.Y; ds.WriteXml(path); } catch { } }
private void SaveButton_Click(object sender, EventArgs e) { try { DataSet tempDataSet = new DataSet(); tempDataSet.ReadXml("Config/Mouse_Config.xml"); if (ShowMouseCheckBox.Checked) { tempDataSet.Tables[0].Rows[0]["ShowMouse"] = "true"; Cursor.Show(); showMouse = true; } else { tempDataSet.Tables[0].Rows[0]["ShowMouse"] = "false"; Cursor.Hide(); showMouse = false; } tempDataSet.WriteXml("Config/Mouse_Config.xml"); this.Close(); } catch (Exception ee) { } }
public byte[] GetReportContent(DataSet ds, string[] extraParams) { if (extraParams.Length != extraParamNames.Count) throw new ArgumentException(string.Format( "[ReportExecutionWrapper] Wrong number of extra parameters passed in to method Run() [expected {0}, was {1}].", extraParamNames.Count, extraParams.Length)); initialize(); StringBuilder sb = new StringBuilder(); StringWriter sw = new StringWriter(sb); ds.WriteXml(sw, XmlWriteMode.WriteSchema); sw.Close(); parameters[0].Value = sb.ToString(); for (int i = 0; i < extraParams.Length; i++) parameters[i + 1].Value = extraParams[i]; reportExecutionService.SetExecutionParameters(parameters, "nl-NL"); string extension, mimeType, encoding; Warning[] warnings; string[] streamIds; byte[] reportContent = reportExecutionService.Render("PDF", "", out extension, out mimeType, out encoding, out warnings, out streamIds); return reportContent; }
protected void Page_Load(object sender, EventArgs e) { // create the connection, DataAdapter and DataSet string connectionString = WebConfigurationManager.ConnectionStrings["Northwind"].ConnectionString; string sql = "SELECT TOP 5 EmployeeID, TitleOfCourtesy, LastName, FirstName FROM Employees"; SqlConnection conn = new SqlConnection(connectionString); SqlDataAdapter da = new SqlDataAdapter(sql, conn); DataSet ds = new DataSet(); // Fill the DataSet and fill the first grid. da.Fill(ds, "Employees"); Datagrid1.DataSource = ds.Tables["Employees"]; Datagrid1.DataBind(); // Generate the XML file. string xmlFile = Server.MapPath("Employees.xml"); ds.WriteXml(xmlFile, XmlWriteMode.WriteSchema); // Load the XML file. DataSet dsXml = new DataSet(); dsXml.ReadXml(xmlFile); // Fill the second grid. Datagrid2.DataSource = dsXml.Tables["Employees"]; Datagrid2.DataBind(); }
private void button1_Click(object sender, System.EventArgs e) { DataSet ds = new DataSet(); ds.Tables.Add(CreateMaster()); ds.Tables.Add(CreateDetails()); DataView dv; dv = ds.Tables[0].DefaultView; dv.Sort = "Nombre"; dv.RowFilter = "Nombre LIKE 'D%'"; dataGrid1.DataSource = dv; ds.WriteXml(@"C:\aa.xml"); ds.Tables[0].Constraints.Add("PK_CODIGO", ds.Tables[0].Columns["Codigo"], true); DataRow dr = ds.Tables[0].Rows.Find("4"); MessageBox.Show(dr["Nombre"].ToString()); DataRow[] rows = ds.Tables[0].Select("Codigo > '2'"); // DataSet ds2 = ds.Clone(); // ds2.Tables[0].Rows.Add(rows[0]); // ds2.Tables[0].Rows.Add(rows[1]); // ds2.EnforceConstraints = false; DataRelation rel = new DataRelation("Relacion1", ds.Tables[0].Columns["Codigo"], ds.Tables[1].Columns["Codigo"]); ds.Relations.Add(rel); rows = ds.Tables[0].Rows[0].GetChildRows("Relacion1"); }
/// <summary> /// Writes out the DataSet as an XML file with changes /// </summary> /// <param name="ds">The DataSource to write out</param> /// <param name="filename">The name of the file to write to.</param> public static void SaveDataSet(DataSet ds, string filename) { try { ds.WriteXml(filename, XmlWriteMode.DiffGram); } catch{} }
/// <summary> /// /// </summary> /// <param name="cacheKey"></param> /// <param name="ds"></param> public static void CacheDataSet2Xml(string cacheKey, DataSet ds) { string fileCachedPath = storePath + cacheKey + ".xml"; if (!System.IO.Directory.Exists(storePath)) System.IO.Directory.CreateDirectory(storePath); ds.WriteXml(fileCachedPath); Insert(cacheKey, ds, new CacheDependency(fileCachedPath), DateTime.MaxValue); }
public static void captureData() { lock (MainClass.data) { try { System.Data.DataSet ds = null; bool create = false; if (!System.IO.File.Exists(MainClass.location + "bd.xml")) { System.Data.DataTable dt = new System.Data.DataTable("Balances"); dt.Columns.Add("Date"); dt.Columns.Add("Coin"); dt.Columns.Add("Amount"); dt.Rows.Add("", "", ""); System.Data.DataTable dtParameters = new System.Data.DataTable("Parameters"); dtParameters.Columns.Add("Parameter"); dtParameters.Columns.Add("Value"); dtParameters.Rows.Add("", ""); ds = new System.Data.DataSet(); ds.DataSetName = "Database"; ds.Tables.Add(dt); ds.Tables.Add(dtParameters); ds.WriteXml(MainClass.location + "bd.xml"); create = true; } ds = new System.Data.DataSet(); ds.ReadXml(MainClass.location + "bd.xml"); BitMEX.BitMEXApi bitMEXApi = new BitMEX.BitMEXApi(MainClass.bitmexKeyWeb, MainClass.bitmexSecretWeb, MainClass.bitmexDomain); string json = bitMEXApi.GetWallet(); JContainer jCointaner = (JContainer)JsonConvert.DeserializeObject(json, (typeof(JContainer))); if (create) { ds.Tables[0].Rows.Clear(); } ds.Tables[0].Rows.Add(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), MainClass.pair, jCointaner[0]["walletBalance"].ToString()); ds.Tables[1].Rows.Clear(); ds.Tables[1].Rows.Add("OpenOrders", bitMEXApi.GetOpenOrders(MainClass.pair).Count); ds.Tables[1].Rows.Add("Amount", jCointaner[0]["walletBalance"].ToString()); System.IO.File.Delete(MainClass.location + "bd.xml"); ds.WriteXml(MainClass.location + "bd.xml"); } catch { } } }
private void btnRead_Click(object sender, EventArgs e) { toolStripStatusLabelWarn.Text = ""; if (textBoxConference.Text == "") { MessageBox.Show("请输入会议名称!", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (boolRead) //结束 { boolRead = false; btnRead.Text = "签到"; timerS.Stop(); saveFileDialogSign.FileName = textBoxConference.Text.Trim(); if (saveFileDialogSign.ShowDialog() == DialogResult.OK) { dSet.WriteXml(saveFileDialogSign.FileName); } } else //开始 { boolRead = true; btnRead.Text = "结束"; dSet.Tables["离线会议信息"].Rows[0][0] = textBoxConference.Text; dSet.Tables["签到表"].Rows.Clear(); switch (intCard) { case 0: textBoxSign.TextChanged += new EventHandler(textBoxSign_TextChanged); this.textBoxSign.Focus(); this.textBoxSign.SelectAll(); break; case 1: cMember.iComPort = intComNumber; cMember.lComBand = lComBand; textBoxSign.TextChanged -= new EventHandler(textBoxSign_TextChanged); timerS.Start(); //timerS_Tick(null, null); break; } } }
private void saveData() { dictionaryDataSet.AcceptChanges(); // Write the XML schema and data to file with FileStream. System.Xml.XmlTextWriter xmlWriter = new System.Xml.XmlTextWriter(m_filename, System.Text.Encoding.Unicode); xmlWriter.Formatting = Formatting.Indented; xmlWriter.Indentation = 4; dictionaryDataSet.WriteXml(xmlWriter); xmlWriter.Close(); }
private void btnKerko_Click(object sender, System.EventArgs e) { this.Cursor = Cursors.WaitCursor; try { InputController data = new InputController(); DateTime dataFillimi = Convert.ToDateTime(this.dtpFillimi.Value); DateTime dataMbarimi = Convert.ToDateTime(this.dtpMbarimi.Value); int a = this.KntData(dataFillimi, dataMbarimi); if (a != 0) { error.SetError(this.dtpFillimi, "Data e fillimit nuk mund te jete me e madhe se data e mbarimit"); this.dtpFillimi.IsValid = false; return; } else { error.SetError(this.dtpFillimi, ""); this.dtpFillimi.IsValid = true; this.printBilancData = true; this.lblgrid1.Text = "Bilanci nga data " + konverto(dataFillimi.Date) + Environment.NewLine + "deri ne daten " + konverto(dataMbarimi.Date); ds = data.KerkesaRead("ShfaqBilanci", dataFillimi, dataMbarimi); ds.WriteXml("C:\\Program Files\\VisionInfoSolution\\HotelManagment" + "\\ShfaqBilanci.xml", XmlWriteMode.WriteSchema); grid1.DataSource = ds.Tables[0]; numer_rreshtash = ds.Tables[0].Rows.Count; grid1.Height = 262; if (numer_rreshtash > 14) { grid1.Width = 254; } else { grid1.Width = 238; } this.gridEX2.DataSource = null; } } catch (SqlException ex) { VisionInfoSolutionLibrary.MessageBox.Show(this, ex); return; } catch (Exception ex) { VisionInfoSolutionLibrary.MessageBox.Show(this, ex); return; } finally { this.Cursor = Cursors.Default; } }
string IContentEditor.GetContent() { //Check if grid is still in edit mode, then flush the data DataGridCell savedCurrentCellValue = workSheetDataGrid.CurrentCell; //This is value type workSheetDataGrid.CurrentCell = new DataGridCell(-1, -1); //unselect current cell workSheetDataGrid.CurrentCell = savedCurrentCellValue; StringBuilder serializedDataSetStringBuilder = new StringBuilder(); workSheetDataSet.WriteXml(new StringWriter(serializedDataSetStringBuilder), System.Data.XmlWriteMode.DiffGram); return(serializedDataSetStringBuilder.ToString()); }
private void grid1_CurrentCellChanged(object sender, System.EventArgs e) { this.Cursor = Cursors.WaitCursor; try { dsDetyrime = new DataSet(); InputController data = new InputController(); DateTime dataKerkimi; int rowIndex = grid1.CurrentRowIndex; if (grid1[rowIndex, 0].ToString() != "Bilanci") { dataKerkimi = Convert.ToDateTime(grid1[rowIndex, 3]); this.dsBilanciDitor = data.KerkesaRead("ShfaqBilanciPerDatenEdheneDetaje", dataKerkimi.Date); this.gridEX2.DataSource = this.dsBilanciDitor.Tables[0]; this.lblgrid2.Text = "Veprimet e kryer ne daten " + konverto(dataKerkimi.Date); ds1 = data.KerkesaRead("ShfaqBilanciPerDatenEdhene", dataKerkimi); //dsDetyrime = data.KerkesaRead("ShfaqBilanciPerDatenEdheneJanusGrid", dataKerkimi); ds1.WriteXml("C:\\Program Files\\VisionInfoSolution\\HotelManagment" + "\\ShfaqBilanciPerDatenEdhene.xml", XmlWriteMode.WriteSchema); this.printBilancDitor = true; if (ds1.Tables[0].Rows.Count < 1) { this.dateDitor = ""; } else if (ds1.Tables[0].Rows.Count < 2 && (ds1.Tables[0].Rows[0][1].ToString() == "" && Convert.ToInt32(ds1.Tables[0].Rows[0][0]) == 0)) { this.dateDitor = ""; } else { this.dateDitor = dataKerkimi.ToShortDateString(); } //kryhet mbushja e grides2 e cila paraqet veprimet qe jane kryer //ne daten e klikuar int nr2 = ds1.Tables[0].Rows.Count; } } catch (SqlException ex) { VisionInfoSolutionLibrary.MessageBox.Show(this, ex); return; } catch (Exception ex) { VisionInfoSolutionLibrary.MessageBox.Show(this, ex); return; } finally { this.Cursor = Cursors.Default; } }
private void btnTest_Click(object sender, EventArgs e) { strConn = "workstation id=CY;packet size=4096;user id=" + textBoxUser.Text.Trim() + ";password="******";data source=\"" + textBoxServer.Text.Trim() + "\";;initial catalog=" + textBoxDatabase.Text.Trim().ToLower(); sqlConn.ConnectionString = strConn; try { sqlConn.Open(); } catch (System.Data.SqlClient.SqlException err) { MessageBox.Show("数据库连接错误,请与管理员联系"); strConn = ""; return; } MessageBox.Show("数据库连接正常"); sqlConn.Close(); dSet.Tables["数据库信息"].Rows[0][0] = textBoxServer.Text; dSet.Tables["数据库信息"].Rows[0][1] = textBoxUser.Text; if (checkBoxRember.Checked) //记住密码 { dSet.Tables["数据库信息"].Rows[0][2] = textBoxPassword.Text; } else { dSet.Tables["数据库信息"].Rows[0][2] = ""; } dSet.Tables["数据库信息"].Rows[0][3] = textBoxDatabase.Text; dSet.WriteXml(dFileName); this.Close(); }
/* CreateXMLString * Returns a string containing XML serialized data * from the given dataset. * * Modified 17 Apr 2006 nbaker * Calls ProcessDatasetXml to strip timezone information * from the serialized data. */ public static string CreateXMLString(System.Data.DataSet dataSet) { if (dataSet == null) { return(string.Empty); } using (StringWriter writer = new StringWriter()) { dataSet.WriteXml(writer, XmlWriteMode.WriteSchema); return(Regex.Replace(writer.ToString(), @"(?<date>[\d-]*T[\d:\.]*)[+-]\d+:\d\d", "${date}", RegexOptions.Compiled)); } }
private void btnSign_Click(object sender, EventArgs e) { if (textBoxSign.Text.Trim() == "") { MessageBox.Show("ÇëÊäÈë×¢²áÂ룡", "×¢²á´íÎó", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } dSet.Tables["Èí¼þ×¢²á"].Rows[0][0] = textBoxSign.Text.Trim(); dSet.WriteXml(dFileName); dlResult = DialogResult.OK; this.Close(); }
/// <summary> /// Creates the XML schema /// </summary> /// <param name="className">Class name</param> /// <param name="methodName">Method name</param> /// <param name="paramList">Parameters list</param> /// <returns></returns> public Byte[] GetAxDataCreateSchema(string className, string methodName, params object[] paramList) { XmlDocument xmlDoc = new XmlDocument(); try { //this.AxLogin(); this.AxLoginAs(); AxaptaObject axObj = Ax.CreateAxaptaObject(className); string ret = (string)this.callMethod(className, methodName, paramList); //converto la stringa in XML document xmlDoc.LoadXml(ret); //creo un reader di dati XML per popolare il dataset XmlNodeReader xmlReader = new XmlNodeReader(xmlDoc.DocumentElement); System.Data.DataSet ds = new System.Data.DataSet(); //carico il dataset coi dati XML (Carico lo schema) ds.ReadXml(xmlReader, System.Data.XmlReadMode.InferSchema); //comprimo il dataset compreso di schema con GZIP e restituisco un byte array MemoryStream ms = new MemoryStream(); System.IO.Compression.GZipStream zip = new System.IO.Compression.GZipStream(ms, System.IO.Compression.CompressionMode.Compress); ds.WriteXml(zip, System.Data.XmlWriteMode.WriteSchema); zip.Close(); ms.Close(); axObj.Dispose(); return(ms.GetBuffer()); } catch (Microsoft.Dynamics.AxaptaException ex) { this.WriteErrorToEventLog(ex); SoapException se = new SoapException(ex.Message, SoapException.ServerFaultCode, ex.InnerException); throw se; } catch (Exception ex) { this.WriteErrorToEventLog(ex); SoapException se = new SoapException(ex.Message, SoapException.ClientFaultCode, ex.InnerException); throw se; } finally { this.AxLogoff(); } }
/// <summary> /// Обновление настроек в файле настроек /// </summary> public void UpdateSettingInFile() { try { System.Data.DataSet ds = new System.Data.DataSet(); ds.ReadXml(nameFile, XmlReadMode.Auto); System.Data.DataTable table = ds.Tables[C_SETTINGS]; System.Data.DataRow row = table.Rows[0]; row[C_DAYS_VIEW] = numericUpDownDayAfter.Value; row[C_DAY_OCCURRED] = numericUpDownOccurred.Value; ds.WriteXml(Const.DATA_SETTING_FILE_NAME); } catch { SaveSettingInFile(); } }
/// <summary> /// Сохранение настроек в файле настроек /// </summary> private void SaveSettingInFile() { try { System.Data.DataSet ds = new System.Data.DataSet(C_CONFIG); System.Data.DataTable table = ds.Tables.Add(C_SETTINGS); DataTable dtb = ds.Tables[C_SETTINGS]; dtb.Columns.Add(C_DAYS_VIEW, System.Type.GetType(C_TCOLUMNS)); dtb.Columns.Add(C_DAY_OCCURRED, System.Type.GetType(C_TCOLUMNS)); DataRow row = dtb.NewRow(); row[C_DAYS_VIEW] = numericUpDownDayAfter.Value; row[C_DAY_OCCURRED] = numericUpDownOccurred.Value; dtb.Rows.Add(row); ds.WriteXml(Const.DATA_SETTING_FILE_NAME); } catch { } }
private void btnSet_Click(object sender, EventArgs e) { intLength = Int32.Parse(textBoxCardLength.Text.Trim()); intComNumber = comboBoxCom.SelectedIndex; lComBand = Int32.Parse(comboBoxBand.Text); intCard = comboBoxCard.SelectedIndex; dSet.Tables["智能卡信息"].Rows[0][0] = comboBoxCard.SelectedIndex.ToString(); dSet.Tables["智能卡信息"].Rows[0][1] = comboBoxCom.SelectedIndex.ToString(); dSet.Tables["智能卡信息"].Rows[0][2] = textBoxCardLength.Text; dSet.Tables["智能卡信息"].Rows[0][3] = comboBoxBand.Text; dSet.WriteXml(dFileName); dSet1.Tables["附加信息"].Rows[0][0] = comboBoxAdd1.SelectedIndex.ToString(); dSet1.Tables["附加信息"].Rows[0][1] = comboBoxAdd2.SelectedIndex.ToString(); dSet1.WriteXml(dFileName1); this.Close(); }
//private void releaseObject(object obj) //{ // try // { // System.Runtime.InteropServices.Marshal.ReleaseComObject(obj); // obj = null; // } // catch (Exception ex) // { // obj = null; // } // finally // { // GC.Collect(); // } //} private void Button1_Click_1(object sender, EventArgs e) { try { System.Data.OleDb.OleDbConnection MyConnection; System.Data.DataSet ds; System.Data.OleDb.OleDbDataAdapter MyCommand; MyConnection = new System.Data.OleDb.OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;Data Source='" + _000_Classlar.Global.AppPath + "\\_023_XML_Islemleri\\XML\\Test.xls" + "';Extended Properties=Excel 8.0;"); MyCommand = new System.Data.OleDb.OleDbDataAdapter("select * from [Sayfa1$]", MyConnection); MyCommand.TableMappings.Add("Table", "Test"); ds = new System.Data.DataSet(); MyCommand.Fill(ds); MyConnection.Close(); ds.WriteXml(_000_Classlar.Global.AppPath + "\\_023_XML_Islemleri\\XML\\Test.xml"); dataGridView2.DataSource = ds.Tables[0]; } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
/// <summary> /// How to create XML file from Excel /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button7_Click(object sender, EventArgs e) { try { System.Data.OleDb.OleDbConnection MyConnection; System.Data.DataSet ds; System.Data.OleDb.OleDbDataAdapter MyCommand; MyConnection = new System.Data.OleDb.OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;Data Source='D:\\Codes\\C#\\XmlDemo1\\XmlDemo1\\bin\\Debug\\xl2xml.xls';Extended Properties=Excel 8.0;"); MyCommand = new System.Data.OleDb.OleDbDataAdapter("select * from [Sheet1$]", MyConnection); MyCommand.TableMappings.Add("Table", "Product"); ds = new System.Data.DataSet(); MyCommand.Fill(ds); MyConnection.Close(); ds.WriteXml("Product.xml"); MessageBox.Show("Ok!"); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
//static DataTable GetDataTableFromCsv(string path, bool isFirstRowHeader) //{ // string header = isFirstRowHeader ? "Yes" : "No"; // string pathOnly = Path.GetDirectoryName(path); // string fileName = Path.GetFileName(path); // string csvfilename = Path.GetFileNameWithoutExtension(path); // string sql = @"SELECT * FROM [" + fileName + "]"; // using (OleDbConnection connection = new OleDbConnection( // @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + pathOnly + // ";Extended Properties='Text;HDR=Yes;IMEX=1;FMT=Delimited(,)';")) // using (OleDbCommand command = new OleDbCommand(sql, connection)) // using (OleDbDataAdapter adapter = new OleDbDataAdapter(command)) // { // DataTable dataTable = new DataTable(); // dataTable.Locale = CultureInfo.CurrentCulture; // adapter.Fill(dataTable); // dataTable.TableName = csvfilename; // //dataTable.Columns.Remove(dataTable.Columns["obs"]); // return dataTable; // } //} /// <summary> /// Load a data file /// </summary> /// <typeparam name="T"></typeparam> /// <param name="name"></param> /// <param name="section"></param> /// <param name="user"></param> /// <returns></returns> /// public static String Load() { System.Data.DataSet dset = new System.Data.DataSet(); string[] files = Directory.GetFiles(@"\\localhost\Output Files\PkView\Peter\", "*.csv", SearchOption.TopDirectoryOnly); if (files.Length > 0) { foreach (string file in files) { DataTable dt = ReadCsv(file); File.Delete(file); dset.Tables.Add(dt); } } var writer = new System.IO.StringWriter(); dset.WriteXml(writer, System.Data.XmlWriteMode.WriteSchema); return(writer.ToString()); }
private void btnOK_Click(object sender, EventArgs e) { object[] oTemp = new object[3]; if (strConn != "") { sqlConn.Open(); sqlComm.CommandText = "UPDATE parameters SET [num of week] =" + numericUpDownWeek.Value.ToString() + ", [num of pass] =" + numericUpDownPass.Value.ToString(); sqlComm.ExecuteNonQuery(); sqlConn.Close(); } else { dSet.Tables["parameters"].Rows.Clear(); oTemp[0] = numericUpDownWeek.Value; oTemp[1] = numericUpDownPass.Value; oTemp[2] = numericUpDownTAC.Value; dSet.Tables["parameters"].Rows.Add(oTemp); dSet.WriteXml(dFileName); } this.Close(); }
/// <summary> /// /// </summary> public static void CreatePrintConfigFile() { if (System.IO.File.Exists(configFilePath)) { return; } try { #region 创建发票设置结构 System.Data.DataTable tbInvoice = new System.Data.DataTable("INVOICES"); tbInvoice.Columns.Add("INVOICE_NAME", Type.GetType("System.String")); tbInvoice.Columns.Add("PAPER_WIDTH", Type.GetType("System.Int32")); tbInvoice.Columns.Add("PAPER_HEIGHT", Type.GetType("System.Int32")); System.Data.DataTable tbInvoiceItem = new System.Data.DataTable("INVOICE_ITEMS"); tbInvoiceItem.Columns.Add("INVOICE_NAME", Type.GetType("System.String")); tbInvoiceItem.Columns.Add("ITEM_NAME", Type.GetType("System.String")); tbInvoiceItem.Columns.Add("FONT_NAME", Type.GetType("System.String")); tbInvoiceItem.Columns.Add("FONT_SIZE", Type.GetType("System.Int32")); tbInvoiceItem.Columns.Add("X", Type.GetType("System.Int32")); tbInvoiceItem.Columns.Add("Y", Type.GetType("System.Int32")); tbInvoiceItem.Columns.Add("NEED_PRINT", Type.GetType("System.Int16")); #endregion #region 创建默认值(收费) //发票名 tbInvoice.Rows.Add(new object[] { "门诊收费发票", 12.33, 9.33 }); //发票明细 tbInvoiceItem.Rows.Add(new object[] { "门诊收费发票", "医院名称", "黑体", 10, 50, 55, 1 }); tbInvoiceItem.Rows.Add(new object[] { "门诊收费发票", "姓名", "宋体", 9, 90, 115, 1 }); tbInvoiceItem.Rows.Add(new object[] { "门诊收费发票", "门诊号", "宋体", 9, 270, 115, 1 }); tbInvoiceItem.Rows.Add(new object[] { "门诊收费发票", "年", "宋体", 9, 245, 90, 1 }); tbInvoiceItem.Rows.Add(new object[] { "门诊收费发票", "月", "宋体", 9, 300, 90, 1 }); tbInvoiceItem.Rows.Add(new object[] { "门诊收费发票", "日", "宋体", 9, 330, 90, 1 }); tbInvoiceItem.Rows.Add(new object[] { "门诊收费发票", "发票号", "宋体", 9, 50, 85, 1 }); tbInvoiceItem.Rows.Add(new object[] { "门诊收费发票", "医生", "宋体", 9, 110, 70, 1 }); tbInvoiceItem.Rows.Add(new object[] { "门诊收费发票", "科室", "宋体", 9, 50, 70, 1 }); tbInvoiceItem.Rows.Add(new object[] { "门诊收费发票", "大写金额", "宋体", 9, 140, 275, 1 }); tbInvoiceItem.Rows.Add(new object[] { "门诊收费发票", "小写金额", "宋体", 9, 140, 250, 1 }); tbInvoiceItem.Rows.Add(new object[] { "门诊收费发票", "收款人", "宋体", 9, 300, 305, 1 }); tbInvoiceItem.Rows.Add(new object[] { "门诊收费发票", "发票项目", "宋体", 9, 90, 150, 1 }); tbInvoiceItem.Rows.Add(new object[] { "门诊收费发票", "其他信息", "宋体", 9, 0, 0, 0 }); #endregion #region 创建默认值(挂号) //发票名 tbInvoice.Rows.Add(new object[] { "门诊挂号发票", 12.33, 9.33 }); //内容 tbInvoiceItem.Rows.Add(new object[] { "门诊挂号发票", "收款单位", "宋体", 0, 0, 1 }); tbInvoiceItem.Rows.Add(new object[] { "门诊挂号发票", "诊病科别", "宋体", 0, 0, 1 }); tbInvoiceItem.Rows.Add(new object[] { "门诊挂号发票", "医生", "宋体", 0, 0, 1 }); tbInvoiceItem.Rows.Add(new object[] { "门诊挂号发票", "发票号", "宋体", 0, 0, 1 }); tbInvoiceItem.Rows.Add(new object[] { "门诊挂号发票", "年", "宋体", 9, 245, 90, 1 }); tbInvoiceItem.Rows.Add(new object[] { "门诊挂号发票", "月", "宋体", 9, 300, 90, 1 }); tbInvoiceItem.Rows.Add(new object[] { "门诊挂号发票", "日", "宋体", 9, 330, 90, 1 }); tbInvoiceItem.Rows.Add(new object[] { "门诊挂号发票", "姓名", "宋体", 9, 90, 115, 1 }); tbInvoiceItem.Rows.Add(new object[] { "门诊挂号发票", "门诊号", "宋体", 9, 270, 115, 1 }); tbInvoiceItem.Rows.Add(new object[] { "门诊挂号发票", "医师职级", "宋体", 0, 0, 1 }); tbInvoiceItem.Rows.Add(new object[] { "门诊挂号发票", "挂号费", "宋体", 0, 0, 1 }); tbInvoiceItem.Rows.Add(new object[] { "门诊挂号发票", "诊查费", "宋体", 0, 0, 1 }); tbInvoiceItem.Rows.Add(new object[] { "门诊挂号发票", "检查费", "宋体", 0, 0, 1 }); tbInvoiceItem.Rows.Add(new object[] { "门诊挂号发票", "材料费", "宋体", 0, 0, 1 }); tbInvoiceItem.Rows.Add(new object[] { "门诊挂号发票", "小写金额", "宋体", 9, 140, 250, 1 }); tbInvoiceItem.Rows.Add(new object[] { "门诊挂号发票", "大写金额", "宋体", 9, 140, 275, 1 }); tbInvoiceItem.Rows.Add(new object[] { "门诊挂号发票", "收款人", "宋体", 9, 300, 305, 1 }); #endregion System.Data.DataSet dsInvocies = new System.Data.DataSet("发票设置"); dsInvocies.Tables.Add(tbInvoice); dsInvocies.Tables.Add(tbInvoiceItem); dsInvocies.WriteXml(configFilePath); } catch (Exception err) { ErrorWriter.WriteLog(err.Message); throw new Exception("创建发票打印配置文件错误!"); } }
private void Execute(ExportType exportType, string fileName) { // Make sure our server is connected... Dataphoria.EnsureServerConnection(); using (var statusForm = new StatusForm(Strings.Exporting)) { using (var connection = new DAEConnection()) { if (DesignerID == "SQL") { SwitchToSQL(); } try { using (var adapter = new DAEDataAdapter(GetTextToExecute(), connection)) { using (var dataSet = new DataSet()) { var process = DataSession.ServerSession.StartProcess(new ProcessInfo(DataSession.ServerSession.SessionInfo)); try { connection.Open(DataSession.Server, DataSession.ServerSession, process); try { switch (exportType) { case ExportType.Data: adapter.Fill(dataSet); dataSet.WriteXml(fileName, XmlWriteMode.IgnoreSchema); break; case ExportType.Schema: adapter.FillSchema(dataSet, SchemaType.Source); dataSet.WriteXmlSchema(fileName); break; default: adapter.Fill(dataSet); dataSet.WriteXml(fileName, XmlWriteMode.WriteSchema); break; } } finally { connection.Close(); } } finally { DataSession.ServerSession.StopProcess(process); } } } } finally { if (DesignerID == "SQL") { SwitchFromSQL(); } } } } }
private void btnSave_Click(object sender, System.EventArgs e) { dataSet1.WriteXml("c:\\authors.xml"); }
private void btn_Ok_Click(object sender, EventArgs e) { System.Data.DataSet ds = this.GetDataSet(); ds.WriteXml(this.xmlFile); this.Close(); }
private void btnKerko_Click(object sender, System.EventArgs e) { try { this.Cursor = Cursors.WaitCursor; dtFillimi = (DateTime)this.dtpDateFillimi.Value; dtMbarimi = (DateTime)this.dtpDateMbarimi.Value; emer = this.txtEmri.Text; mbiemer = this.txtMbiemri.Text; grup = this.txtGrupi.Text; agjensi = this.txtAgjensia.Text; InputController data = new InputController(); if (this.rbKliente.Checked) { dsHyrjeNeHotel = data.KerkesaRead("HyrjeNeHotelKlienteDale", emer, mbiemer, dtFillimi, dtMbarimi); dsHyrjeNeHotel.WriteXml("C:\\Program Files\\VisionInfoSolution\\HotelManagment" + @"\HyrjeDaljeKliente.xml", XmlWriteMode.WriteSchema); if (dsHyrjeNeHotel.Tables[0].Rows.Count < 1) { System.Windows.Forms.MessageBox.Show(this, "Per kushtet e zgjedhura nuk ka asnje hyrje-dalje ne hotel", "Raporti per Hyrje-Daljet ne hotel", MessageBoxButtons.OK, MessageBoxIcon.Information); this.ReadyToPrint = false; this.crystalReportViewer1.ReportSource = null; } else { this.crystalReportViewer1.ReportSource = new HotelManagment.Reports.CrHyrjeDaljeKliente(); this.ReadyToPrint = true; } } else if (this.rbGrupe.Checked) { dsHyrjeNeHotel = data.KerkesaRead("HyrjeNeHotelGrupeDale", grup, agjensi, dtFillimi, dtMbarimi); dsHyrjeNeHotel.WriteXml("C:\\Program Files\\VisionInfoSolution\\HotelManagment" + @"\HyrjeDaljeGrupe.xml", XmlWriteMode.WriteSchema); if (dsHyrjeNeHotel.Tables[0].Rows.Count < 1) { System.Windows.Forms.MessageBox.Show(this, "Per kushtet e zgjedhura nuk ka asnje hyrje-dalje ne hotel", "Raporti per Hyrje-Daljet ne hotel", MessageBoxButtons.OK, MessageBoxIcon.Information); this.crystalReportViewer1.ReportSource = null; this.ReadyToPrint = false; } else { this.crystalReportViewer1.ReportSource = new HotelManagment.Reports.CrHyrjeDaljeGrupe(); this.ReadyToPrint = true; } } this.RifreskoRaportin(); } catch (SqlException ex) { VisionInfoSolutionLibrary.MessageBox.Show(this, ex); return; } catch (Exception ex) { VisionInfoSolutionLibrary.MessageBox.Show(this, ex); } finally { this.Cursor = Cursors.Default; } }
//Function to write log file public static void Writefile_new(string strErrMesg, string strPath) { try { strPath = strPath + "//Log"; string LogFilename = "Log" + "_" + DateTime.Now.ToString("yyyyMMdd"); System.Data.DataSet Dsfile = new System.Data.DataSet(); if (System.IO.Directory.Exists(strPath) == false) { System.IO.DirectoryInfo dirinfo = new System.IO.DirectoryInfo(strPath); dirinfo.Create(); CreateNewXml(ref Dsfile); Dsfile.WriteXml(strPath + " \\XmlData.xml"); System.IO.FileInfo objfile = new System.IO.FileInfo(strPath + "\\" + LogFilename + "_0.log"); System.IO.StreamWriter Tex = objfile.CreateText(); Tex.Write(strErrMesg + "\r\n"); Tex.Close(); System.GC.Collect();// return; } if (System.IO.File.Exists(strPath + "\\XmlData.xml") == true) { System.Data.DataRow[] dr; int FileIndex = 0; Dsfile.ReadXml(strPath + " \\XmlData.xml"); dr = Dsfile.Tables[0].Select("SysDate ='" + DateTime.Now.ToString("dd-MM-yyyy") + "'"); if (dr.Length > 0) { FileIndex = Convert.ToInt32(dr[0]["Sysvalue"].ToString()); } else { Dsfile.Clear(); CreateNewXml(ref Dsfile); Dsfile.WriteXml(strPath + "\\XmlData.xml"); } if (System.IO.File.Exists(strPath + "\\" + LogFilename + "_" + FileIndex + ".log")) { System.IO.FileInfo objfile = new System.IO.FileInfo(strPath + "\\" + LogFilename + "_" + FileIndex.ToString() + ".log"); if (objfile.Length > 500000) //523636 { System.IO.FileInfo objfile1 = new System.IO.FileInfo(strPath + "\\" + LogFilename + "_" + (FileIndex + 1).ToString() + ".log"); System.IO.StreamWriter Tex = objfile1.CreateText(); Tex.Write(strErrMesg + "\r\n"); Tex.Close(); Dsfile.Tables[0].Rows[0]["Sysvalue"] = FileIndex + 1; Dsfile.WriteXml(strPath + "\\XmlData.xml"); System.GC.Collect(); } else { System.IO.StreamWriter Tex = objfile.AppendText(); Tex.Write(strErrMesg + "\r\n"); Tex.Close(); System.GC.Collect(); } } else { System.IO.FileInfo objfile = new System.IO.FileInfo(strPath + "\\" + LogFilename + "_" + FileIndex.ToString() + ".log"); System.IO.StreamWriter Tex = objfile.CreateText(); Tex.Write(strErrMesg + "\r\n"); Tex.Close(); System.GC.Collect(); } } else { CreateNewXml(ref Dsfile); Dsfile.WriteXml(strPath + "\\XmlData.xml"); System.IO.FileInfo objfile = new System.IO.FileInfo(strPath + LogFilename + "_0.log"); System.IO.StreamWriter Tex = objfile.CreateText(); Tex.Write(strErrMesg + "\r\n"); Tex.Close(); System.GC.Collect(); } } catch (Exception ex) { Microsoft.Practices.EnterpriseLibrary.Logging.Logger.Write(ex.Message); } }
/// <summary> /// 保存 /// </summary> /// <returns></returns> private int save() { this.neuFpEnter1_Sheet1.SortRows((int)ColSet.顺序号, true, false); //自定义保存 Neusoft.FrameWork.Models.NeuObject o = this.getSQL(); if (o == null) { // return(-1); } string errInfo = ""; Neusoft.FrameWork.Management.PublicTrans.BeginTransaction(); this.dbMgr.SetTrans(Neusoft.FrameWork.Management.PublicTrans.Trans); if (this.saveSqlInfo(o, ref errInfo) != -1) { try { //string path = Application.StartupPath + "\\Profile\\CustomQuery\\" + this.dbMgr.Operator.ID; //if (!System.IO.Directory.Exists(path)) //{ // System.IO.Directory.CreateDirectory(path); //} //string fileName = path //+ "\\" //+ o.ID.Substring(o.ID.LastIndexOf('.') + 1, o.ID.Length - o.ID.LastIndexOf('.') - 1) //+ ".xml"; System.Data.DataSet ds = this.neuFpEnter1_Sheet1.DataSource as System.Data.DataSet; if (ds != null) { //string xml = ds.GetXmlSchema(); System.IO.StringWriter sw = new System.IO.StringWriter(); ds.WriteXml(sw, XmlWriteMode.WriteSchema); string xml = sw.ToString(); sw.Close(); //ds.WriteXml(fileName, XmlWriteMode.WriteSchema); //if (System.IO.File.Exists(fileName)) //{ //string xml = System.IO.File.ReadAllText(fileName); if (this.saveDefineInfo(o.ID, xml, ref errInfo) != -1) { this.myPreDefine.ID = ""; this.myPreDefine.User01 = o.ID; this.myPreDefine.User03 = o.Name; } else { Neusoft.FrameWork.Management.PublicTrans.RollBack(); this.ShowMessageBox(errInfo, "错误"); return(-1); } // } } } catch (Exception ex) { Neusoft.FrameWork.Management.PublicTrans.RollBack(); this.ShowMessageBox(ex.Message, "错误"); return(-1); } } else { Neusoft.FrameWork.Management.PublicTrans.RollBack(); this.ShowMessageBox(errInfo, "错误"); return(-1); } Neusoft.FrameWork.Management.PublicTrans.Commit(); return(1); }
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"); }