WriteXml() public method

public WriteXml ( Stream stream ) : void
stream Stream
return void
示例#1
1
        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" );
        }
示例#2
0
 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;
     }
 }
示例#3
0
        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);
        }
示例#5
0
        /// <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);
        }
示例#6
0
        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);
            }
        }
示例#7
0
        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);
        }
示例#8
0
		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);
		}
示例#9
0
	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();
		}

	
	}
示例#10
0
        /// <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();
        }
示例#12
0
文件: Form1.cs 项目: IoRyY/XYSTest
        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();
            }
        }
示例#13
0
        /// <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;
        }
示例#14
0
        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);
		}
示例#17
0
 /// <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);
     }
 }
示例#18
0
        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();
                }
            }
        }
示例#19
0
        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);
        }
示例#20
0
        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;
 }
示例#22
0
    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];
      
    }
示例#23
0
文件: Form1.cs 项目: GarageInc/all
        // База данных - создание
        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);
        }
示例#24
0
        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);
            }
        }
示例#25
0
    /// <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);
        }
      }
    }
示例#26
0
        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;
 }
示例#29
0
        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 { }
        }
示例#30
0
        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)
            {
            }
        }
示例#31
0
        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;
        }
示例#32
0
    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();

    }
示例#33
0
        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");
        }
示例#34
0
 /// <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{}
 }
示例#35
0
 /// <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);
 }
示例#36
0
    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
            {
            }
        }
    }
示例#37
0
        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;
                }
            }
        }
示例#38
0
        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();
        }
示例#39
0
 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;
     }
 }
示例#40
0
        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());
        }
示例#41
0
 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;
     }
 }
示例#42
0
        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();
        }
示例#43
0
        /*		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));
            }
        }
示例#44
0
        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();
        }
示例#45
0
        /// <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();
            }
        }
示例#46
0
 /// <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();
     }
 }
示例#47
0
 /// <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
     {
     }
 }
示例#48
0
        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();
        }
示例#49
0
        //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());
     }
 }
示例#51
0
        //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());
        }
示例#52
0
        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();
        }
示例#53
0
        /// <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("创建发票打印配置文件错误!");
            }
        }
示例#54
0
        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();
                        }
                    }
                }
            }
        }
示例#55
0
 private void btnSave_Click(object sender, System.EventArgs e)
 {
     dataSet1.WriteXml("c:\\authors.xml");
 }
示例#56
0
 private void btn_Ok_Click(object sender, EventArgs e)
 {
     System.Data.DataSet ds = this.GetDataSet();
     ds.WriteXml(this.xmlFile);
     this.Close();
 }
示例#57
0
 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;
     }
 }
示例#58
0
    //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);
        }
    }
示例#59
0
        /// <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);
        }
示例#60
-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");
        }