ReadXml() public method

public ReadXml ( Stream stream ) : XmlReadMode
stream Stream
return XmlReadMode
Beispiel #1
0
        private void ConfiguracionInicial()
        {
            // diseño de la TablaPersona
            TablaPersona.Columns.Add("usuario");
            TablaPersona.Columns.Add("contraseña");
            TablaPersona.Columns.Add("email");
            TablaPersona.Columns.Add("Materia que se dicta");


            // busca si el archivo ya existe para precargar sus datos
            if (System.IO.File.Exists(NombreArchivo))
            {
                TablaPersona.ReadXml(NombreArchivo);
            }
            else
            {
                TablaPersona.WriteXml(NombreArchivo);
            }

            /* asigna TablaPersona a dgvPersonas
            dgvPersonas.DataSource = TablaPersona;
            // elimina la posibilidad de ingresar datos en el datagridview
            dgvPersonas.AllowUserToAddRows = false;
            elimina el encabezado de las filas
            dgvPersonas.RowHeadersVisible = false;    */
        }
Beispiel #2
0
        public void TraerDatos()
        {
            try
            {
                this.conexion.Open();

                SqlCommand comando = new SqlCommand();

                comando.CommandType = System.Data.CommandType.Text;
                comando.CommandText = "SELECT * FROM dbo.alumnos";
                comando.Connection  = this.conexion;

                SqlDataReader lector;
                lector = comando.ExecuteReader();

                DataTable dtAlumnos = new System.Data.DataTable("dbo.alumnos");
                dtAlumnos.Load(lector);

                this._dataSetAlumnos_Cursos.Tables.Add(dtAlumnos);
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                this.conexion.Close();
            }


            DataTable dtCursos = new System.Data.DataTable("dbo.cursos");

            if (File.Exists(AppDomain.CurrentDomain.BaseDirectory + "\\CursosEsquema.xml") && File.Exists(AppDomain.CurrentDomain.BaseDirectory + "\\CursosDatos.xml"))
            {
                dtCursos.ReadXml(AppDomain.CurrentDomain.BaseDirectory + "\\CursosEsquema.xml");
                dtCursos.ReadXml(AppDomain.CurrentDomain.BaseDirectory + "\\CursosDatos.xml");

                MessageBox.Show("Se ha cargado el esquema del DataTable!!!");
            }
            else
            {
                dtCursos = this.CrearDataTableCursos();
                MessageBox.Show("Se ha cargado el DataTable con Metodo!!!");
            }


            this._dataSetAlumnos_Cursos.Tables.Add(dtCursos);
        }
        public ReturnValue ImportTableWithoutBulkCopy(string path)
        {
            return ReturnValue.Wrap(() =>
            {
                PreprareConnection();
                var dt = new DataTable();
                dt.ReadXml(path);

                using (SqlTransaction tran = Connection.BeginTransaction(IsolationLevel.Serializable))
                {
                    Connection.ExecSql(string.Format("DELETE  {0}", dt.TableName), tran);
                    string sql = string.Format("SELECT * FROM {0}", dt.TableName);
                    var cmd = new SqlCommand(sql, Connection, tran);
                    var ds = new DataSet();
                    ds.EnforceConstraints = false;
                    ds.Tables.Add(dt);
                    var dataAdapter = new SqlDataAdapter(cmd);
                    // Automatically generates DeleteCommand, UpdateCommand and InsertCommand for DataAdapter object 
                    var builder = new SqlCommandBuilder(dataAdapter);
                    dataAdapter.Update(dt);
                    tran.Commit();
                    ds.Tables.Remove(dt);
                }
            }, string.Format("Importing table from {0}.", path));
        }
Beispiel #4
0
        /// <summary>
        /// el metodo [configuracioninicial]
        /// Diseña columnas del datatable y
        /// verifica si el archivo existe previamente
        ///
        /// </summary>
        private void ConfiguracionInicial()
        {
            // diseño de la TablaRegistro
            TablaRegistro.Columns.Add("Id");
            TablaRegistro.Columns.Add("Fecha");
            TablaRegistro.Columns.Add("Usuario");
            TablaRegistro.Columns.Add("Tipo");
            TablaRegistro.Columns.Add("Cantidad");
            TablaRegistro.Columns.Add("Contenedor");
            TablaRegistro.Columns.Add("Ticket");
            TablaRegistro.Columns.Add("TipoRegistro");

            // busca si el archivo ya existe para precargar sus datos
            if (System.IO.File.Exists(NombreArchivo))
            {
                TablaRegistro.ReadXml(NombreArchivo);
            }

            //// asigna TablaPersona a dgvPersonas
            //dgvPersonas.DataSource = TablaPersona;
            //// elimina la posibilidad de ingresar datos en el datagridview
            //dgvPersonas.AllowUserToAddRows = false;
            //// elimina el encabezado de las filas
            //dgvPersonas.RowHeadersVisible = false;
        }
Beispiel #5
0
        public void UpdateFile()
        {
            DataTable table = new DataTable();
            table.ReadXml(fileName);

            KillLanMsgProcess();
            Thread.Sleep(2000);
            //�����ļ�

            StringBuilder strbuilder = new StringBuilder();
            string filepath = string.Empty;
            foreach (DataRow row in table.Rows) {
                filepath = row["filepath"].ToString();
                if (filepath.ToLower().LastIndexOf("Itop.update.copy") >= 0) continue;
                string updatefile = Application.StartupPath + "\\update\\" + filepath;
                string appfile = Application.StartupPath + filepath;
                labFile.Text = filepath;
                Application.DoEvents();
                File.Copy(updatefile, appfile, true);
                strbuilder.AppendLine(filepath);
            }
            MessageBox.Show("�������!", "����");

            //���������ϵͳ

            System.Diagnostics.Process.Start("Itop.exe");
            Application.Exit();
        }
Beispiel #6
0
        private void btnImport_Click(object sender, EventArgs e)
        {
            if (openFileDialog.ShowDialog(this) == DialogResult.OK)
            {
                string filename = openFileDialog.FileName;
                string extension = Path.GetExtension(filename);
                if (extension == ".xls" || extension == ".xlsx")
                {
                    Excel db = new Excel(filename, true, false);
                    TableSelectDialog t = new TableSelectDialog(db.GetWorksheetList());

                    if (t.ShowDialog(this) == DialogResult.OK)
                    {
                        this.TableDataSource.Import(db.GetWorksheet(t.Selection));
                    }
                }
                else if (extension == ".xml")
                {
                    DataTable dataTableAnalysisSource = new DataTable();
                    dataTableAnalysisSource.ReadXml(openFileDialog.FileName);

                    this.TableDataSource.Import(dataTableAnalysisSource);
                }
            }
        }
Beispiel #7
0
		/// <summary></summary>
		private void FillGridOld() {
			List<WikiListHeaderWidth> colHeaderWidths=WikiListHeaderWidths.GetFromListHist(_listWikiListHists[gridMain.GetSelectedIndex()]);
			_tableOld=new DataTable();
			using(XmlReader xmlReader=XmlReader.Create(new StringReader(_listWikiListHists[gridMain.GetSelectedIndex()].ListContent))) {
				_tableOld.ReadXml(xmlReader);
			}
			gridOld.BeginUpdate();
			gridOld.Columns.Clear();
			ODGridColumn col;
			for(int c=0;c<_tableOld.Columns.Count;c++) {
				int colWidth=100;//100 = default value in case something is malformed in the database.
				foreach(WikiListHeaderWidth colHead in colHeaderWidths) {
					if(colHead.ColName==_tableOld.Columns[c].ColumnName) {
						colWidth=colHead.ColWidth;
						break;
					}
				}
				col=new ODGridColumn(_tableOld.Columns[c].ColumnName,colWidth,false);
				gridOld.Columns.Add(col);
			}
			gridOld.Rows.Clear();
			ODGridRow row;
			for(int i=0;i<_tableOld.Rows.Count;i++) {
				row=new ODGridRow();
				for(int c=0;c<_tableOld.Columns.Count;c++) {
					row.Cells.Add(_tableOld.Rows[i][c].ToString());
				}
				gridOld.Rows.Add(row);
				gridOld.Rows[i].Tag=i;
			}
			gridOld.EndUpdate();
		}
Beispiel #8
0
        private void Form2_Load(object sender, EventArgs e)
        {
            dt = new DataTable("saz","sazconfig");
            dt.Columns.Add("sx");
            dt.Columns.Add("sy");
            dt.Columns.Add("sw");
            dt.Columns.Add("sh");
            dt.Columns.Add("dx");
            dt.Columns.Add("dy");
            dt.Columns.Add("dw");
            dt.Columns.Add("dh");
            try
            {
                dt.ReadXml("saz.xml");
            }
            catch (Exception err) { }

            dataGridView1.DataSource = dt;

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                new Form1(
                    Convert.ToInt32(dt.Rows[i]["sx"]),
                    Convert.ToInt32(dt.Rows[i]["sy"]),
                    Convert.ToInt32(dt.Rows[i]["sw"]),
                    Convert.ToInt32(dt.Rows[i]["sh"]),
                    Convert.ToInt32(dt.Rows[i]["dx"]),
                    Convert.ToInt32(dt.Rows[i]["dy"]),
                    Convert.ToInt32(dt.Rows[i]["dw"]),
                    Convert.ToInt32(dt.Rows[i]["dh"])
                    ).Show();
            }
            //new Form1().Show();
        }
Beispiel #9
0
        public DataTable Dart()
        {
            string authKey = "";
            int    seed    = DateTime.Now.Millisecond;
            Random r       = new Random(seed);

            int ranNum = r.Next();
            //authKey = "fc9f7996b19984e91edab1bed1dd0a6249836aa8"; // 종근

            String         apiURL  = "http://dart.fss.or.kr/api/search.xml?auth=" + authKey + "&crp_cd=&start_dt=&end_dt=&page_set=100";
            HttpWebRequest request = (HttpWebRequest)WebRequest.Create(apiURL);

            request.Method = "GET";

            HttpWebResponse response = (HttpWebResponse)request.GetResponse();
            StreamReader    reader1  = new StreamReader(response.GetResponseStream());

            string page = reader1.ReadToEnd();

            System.Data.DataTable dt = new System.Data.DataTable();

            StringReader sReader = new StringReader(page);

            System.Xml.XmlReader reader = System.Xml.XmlReader.Create((TextReader)sReader);

            dt.ReadXml(reader);
            return(dt);
        }
Beispiel #10
0
        public DataTable Dart(string stockcode, string startDate, string endDate)
        {
            string authKey = "";
            int    seed    = DateTime.Now.Millisecond;
            Random r       = new Random(seed);

            int ranNum = r.Next();

            String         apiURL  = "http://dart.fss.or.kr/api/search.xml?auth=" + authKey + "&crp_cd=" + stockcode + "&start_dt=" + startDate + "&end_dt=" + endDate + "&page_set=100&sort=date&series=asc";
            HttpWebRequest request = (HttpWebRequest)WebRequest.Create(apiURL);

            request.Method = "GET";

            HttpWebResponse response = (HttpWebResponse)request.GetResponse();
            StreamReader    reader1  = new StreamReader(response.GetResponseStream());

            string page = reader1.ReadToEnd();

            System.Data.DataTable dt = new System.Data.DataTable();

            StringReader sReader = new StringReader(page);

            System.Xml.XmlReader reader = System.Xml.XmlReader.Create((TextReader)sReader);

            dt.ReadXml(reader);
            return(dt);
        }
Beispiel #11
0
        /// <summary>
        /// initialize Backup
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void Backup_Load(object sender, EventArgs e)
        {
            var culture = new CultureInfo(CfgFile.Get("Lang"));
            SetCulture(culture);

            restobj = new Restore();
            var myTable = new DataTable("dataTable");
            myTable.Columns.Add(rm.GetString("name"), typeof (string));
            myTable.Columns.Add(rm.GetString("path"), typeof (string));
            myTable.Columns.Add("Date", typeof (DateTime));
            myTable.Columns.Add(rm.GetString("sel"), typeof (bool));

            myTable.ReadXmlSchema(@"schemefile");
            myTable.ReadXml(@"datafile");
            string str = null;

            for (int i = 0; i < myTable.Rows.Count; i++)
            {
                string item = Convert.ToString(myTable.Rows[i][2]);
                if (str != item)
                {
                    lsbMain.Items.Add(item);
                    str = item;
                }
            }
        }
 /// <summary>
 /// 从 XML 文件中读取数据,形成 DataTable.
 /// 
 /// 参考 A0150_Access 项目的 ReadAccessDB.cs
 /// </summary>
 /// <returns></returns>
 private static DataTable LoadDataTable()
 {
     DataTable newDt = new DataTable();
     newDt.ReadXmlSchema(DATATABLE_SCHEMA_XML_FILE);
     newDt.ReadXml(DATATABLE_XML_FILE);
     return newDt;
 }
        public void initCheckPlugin(int instance, addTextCP callback, string configDir)
        {
            addTextCB = callback;
            this.inst = instance;
            confDir = configDir;

            try
            {
                 // Create Settings Table
                DataTable mySettings = new DataTable("SettingsPluginCheckSerial");
                mySettings.ReadXml(confDir + Path.DirectorySeparatorChar + "config_plugin_checkserial.xml");

                optSerialPort = mySettings.Rows[instance]["ComPort"].ToString();
                optBaudrate = Convert.ToInt32(mySettings.Rows[instance]["Baudrate"].ToString(), 10);
                optDataBitIndex = Convert.ToInt32(mySettings.Rows[instance]["DataBits"].ToString(), 10);
                optHandshakeIndex = Convert.ToInt32(mySettings.Rows[instance]["Handshake"].ToString(), 10);
                optParityIndex = Convert.ToInt32(mySettings.Rows[instance]["Parity"].ToString(), 10);
                optReadTimeout = Convert.ToInt32(mySettings.Rows[instance]["ReadTimeout"].ToString(), 10);
                optStopBitsIndex = Convert.ToInt32(mySettings.Rows[instance]["StopBits"].ToString(), 10);
                optStrCheck = mySettings.Rows[instance]["CheckStr"].ToString();
                optStrSendBeforeCheck = mySettings.Rows[instance]["SendBeforeCheckStr"].ToString();
            }
            catch
            {
                optSerialPort = "COM1";
                optBaudrate = 57600;
                optDataBitIndex = 3;
                optParityIndex = 0;
                optStopBitsIndex = 0;
                optHandshakeIndex = 0;
                optReadTimeout = 500;
            }
        }
Beispiel #14
0
        private void ConfiguracionInicial()
        {
            Login inicio = new Login();

            label1.Text = inicio.textBox1.Text;


            // diseño de la TablaPersona
            TablaPersona.Columns.Add("usuario");
            TablaPersona.Columns.Add("contraseña");
            TablaPersona.Columns.Add("email");
            TablaPersona.Columns.Add("tipo");


            // busca si el archivo ya existe para precargar sus datos
            if (System.IO.File.Exists(NombreArchivo))
            {
                TablaPersona.ReadXml(NombreArchivo);
            }

            /* asigna TablaPersona a dgvPersonas
             * dgvPersonas.DataSource = TablaPersona;
             * // elimina la posibilidad de ingresar datos en el datagridview
             * dgvPersonas.AllowUserToAddRows = false;
             * elimina el encabezado de las filas
             * dgvPersonas.RowHeadersVisible = false;    */
        }
        public void initCheckPlugin(int instance, addTextCP callback, string configDir)
        {
            this.addTextCB = callback;
            this.Instance = instance;
            this.confDir = configDir;

            try {
                 // Create Settings Table
                DataTable mySettings = new DataTable("SettingsPluginCheckNet");
                mySettings.ReadXml(confDir + Path.DirectorySeparatorChar + "config_plugin_checknet.xml");

                optStrServerAddress = mySettings.Rows[instance]["ServerAddress"].ToString();
                optPort = Convert.ToInt32(mySettings.Rows[instance]["Port"].ToString(), 10);
                optStrMode = mySettings.Rows[instance]["Mode"].ToString();
                optTimeout = Convert.ToInt32(mySettings.Rows[instance]["Timeout"].ToString(), 10);
                optStrCheck = mySettings.Rows[instance]["CheckStr"].ToString();
                optStrSendBeforeCheck = mySettings.Rows[instance]["SendBeforeCheckStr"].ToString();
            }
            catch {
                // loading failed -> go to defaults
                optStrCheck = "";
                optStrMode  = "TCP";
                optStrSendBeforeCheck  = "";
                optStrServerAddress = "127.0.0.1";
                optTimeout = 1000;
                optPort = 80;
            }
        }
Beispiel #16
0
        private DataTable Create()
        {
            string dataSchemaPath = Directory.GetCurrentDirectory() + "\\" + dataSchemaName + ".xml";
            string dataPath = Directory.GetCurrentDirectory() + "\\" + dataFileName + ".xml";

            DataTable dt = new DataTable();

            if (File.Exists(dataPath))
            {
                dt.ReadXmlSchema(dataSchemaPath);
                dt.ReadXml(dataPath);
            }
            else
            {
                dt.Columns.Add("VaultName", typeof(string));
                dt.Columns.Add("ArchiveId", typeof(string));
                dt.Columns.Add("ZipName", typeof(string));
                dt.Columns.Add("FilePath", typeof(string));
                dt.Columns.Add("EnterdDate", typeof(DateTime));

                dt.TableName = dataFileName;
                dt.PrimaryKey = new[] { dt.Columns["VaultName"], dt.Columns["ArchiveId"], dt.Columns["FilePath"] };
            }

            return dt;
        }
        public frmCauHinhCSDL()
        {
            InitializeComponent();

            var dt = new DataTable("CauHinhCSDL");
            dt.Columns.Add("MayChu");
            dt.Columns.Add("TaiKhoanSQL");
            dt.Columns.Add("Password");
            dt.Columns.Add("CSDL");

            var fi = new FileInfo(Application.StartupPath + "\\CauHinhCSDL.xml");
            if (!fi.Exists) return;

            dt.ReadXml(Application.StartupPath + "\\CauHinhCSDL.xml");
            try
            {
                if (dt.Rows.Count > 0)
                {
                    txtMayChuSQL.Text = dt.Rows[0]["MayChu"].ToString();
                    txtTaiKhoanSQL.Text = dt.Rows[0]["TaiKhoanSQL"].ToString();
                    txtPassword.Text = dt.Rows[0]["Password"].ToString();
                    txtTenCSDL.Text = dt.Rows[0]["CSDL"].ToString();
                }
            }
            catch (Exception ex)
            {
            }
        }
        public ModuleResults GetResults(InstanceInfo instanceInfo)
        {
            try
            {
                ProbeHelper.InstallProbe(instanceInfo.Directory);

                var uri = new Uri(instanceInfo.Uri, "CMSPages/KInspectorProbe.aspx");
                HttpWebRequest request = WebRequest.CreateHttp(uri);
                using (WebResponse response = request.GetResponse())
                {
                    DataTable result = new DataTable();
                    result.ReadXml(response.GetResponseStream());

                    return new ModuleResults
                    {
                        Result = result,
                    };
                }
            }
            catch (Exception e)
            {
                // Probably 404
                return new ModuleResults
                {
                    Result = e.ToString(),
                    Status = Status.Error
                };
            }
            finally
            {
                ProbeHelper.UninstallProbe(instanceInfo.Directory);
            }
        }
Beispiel #19
0
        private void button1_Click(object sender, EventArgs e)
        {
            string appdir = Path.GetDirectoryName(Application.ExecutablePath);

            DataTable dtin = new DataTable();
            dtin.ReadXml(Path.Combine(appdir, "f3.xml"));
        }
 private void Main_Load(object sender, EventArgs e)
 {
     DataTable _table = new DataTable();
     _table.ReadXml(Application.StartupPath + @"\Data\Books.xml");
     metroGrid1.DataSource = _table;
     metroGrid1.AutoSizeCols();   
 }
		private void Initialize()
		{
			string dataSourceCfgPath = System.Configuration.ConfigurationSettings.AppSettings["DataSourceCfg"];

			try
			{
				DataColumn alias = new DataColumn("Alias");
				DataColumn dsn = new DataColumn("Dsn");
				DataColumn uid = new DataColumn("Uid");
				DataColumn pwd = new DataColumn("Pwd");

				_tbDataSource = new DataTable("DataSource");
				
				_tbDataSource.Columns.Add(alias);
				_tbDataSource.Columns.Add(dsn);
				_tbDataSource.Columns.Add(uid);
				_tbDataSource.Columns.Add(pwd);
				
				_tbDataSource.ReadXml(dataSourceCfgPath);
				
				_bsDataSource = new BindingSource();
				_bsDataSource.DataSource = _tbDataSource;
				
				Console.Out.WriteLine("Load DataSource Success!");
			}
			catch(Exception ex)
			{
				Console.Out.WriteLine("Load DataSource Success! " + ex.Message);
				//MessageBox.Show("Loading DataSource failure! " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
			}
		}
Beispiel #22
0
        public DataTable ReadToDataTable()
        {
            DataTable dt = new DataTable(System.IO.Path.GetFileNameWithoutExtension(FileName));
            dt.ReadXmlSchema(this.FileName);
            dt.ReadXml(FileName);

            return dt;
        }
 public void PreserveSpaceRawTest()
 {
     var dt = new DataTable();
     
     dt.ReadXml(@"FolderDTC\Production.Culture.xml");
     var row = dt.Rows[0];
     Assert.AreEqual("      ", row["CultureId"]);
 }
Beispiel #24
0
 public DataTable ConvertXMLToDataTable(string xml)
 {
     System.IO.TextReader trDataTable = new System.IO.StringReader(xml.Substring(0, xml.IndexOf("<?xml")));
     System.IO.TextReader trSchema = new System.IO.StringReader(xml.Substring(xml.IndexOf("<?xml")));
     DataTable dtReturn = new DataTable();
     dtReturn.ReadXmlSchema(trSchema);
     dtReturn.ReadXml(trDataTable);
     return dtReturn;
 }
Beispiel #25
0
 public static DataTable DeserializeTable(string tableName, string fileName)
 {
     var readTable = new DataTable(tableName);
     using (var reader = new XmlTextReader(new FileStream(fileName, FileMode.Open)))
     {
         var mode = readTable.ReadXml(reader);
     }
     return readTable;
 }
Beispiel #26
0
 public BenchmarkHandler(string heavyOperationFile)
 {
     DataTable heavyOperationDT = new DataTable();
     heavyOperationDT.ReadXml(heavyOperationFile);
     var list = from dr in heavyOperationDT.Rows.OfType<DataRow>()
                select Convert.ToString(dr[0]);
     Init();
     InitHeavyOperation(list.ToList<string>());
 }
 /// <summary>
 ///     reads a datatable from XML
 /// </summary>
 /// <param name="path"></param>
 /// <returns></returns>
 public ReturnValue<DataTable> ReadTable(string path)
 {
     return ReturnValue<DataTable>.Wrap(() =>
     {
         var dt = new DataTable();
         dt.ReadXml(path);
         return dt;
     }, string.Format("Reading datatable from {0}.", path));
 }
Beispiel #28
0
 public void PostQuery(QueryData data)
 {
     var mgr = GetAssemblies();
     List<byte[]> result = new List<byte[]>();
     mgr.ForEach(x => result.Add(x.ExecuteQuery(data)));
     var dt=Packer.Unpack(result[0]);
     DataTable tbl = new DataTable();
     tbl.ReadXml(dt);
 }
Beispiel #29
0
        public System.IO.Stream PostData(System.IO.Stream messageBody)
        {
            System.Data.DataTable tbl = new System.Data.DataTable();
            tbl.ReadXml(messageBody);
            if (tbl.Rows.Count == 0)
            {
                return(MakeTextAnswer("ok"));
            }
            else
            {
                Common.Solution solution = Common.Solution.CreateFromContext(this.scope);

                DateTime serverTime = DateTime.UtcNow;
                Guid     userId     = Guid.Parse(WebOperationContext.Current.IncomingRequest.Headers["userid"]);

                using (SqlConnection conn = new SqlConnection(solution.ConnectionString))
                {
                    conn.Open();
                    SqlTransaction tran = conn.BeginTransaction();
                    try
                    {
                        SqlCommand cmd = new SqlCommand("INSERT INTO [admin].GPS([UserId],[ServerTime],[BeginTime],[EndTime],[Latitude],[Longitude],[Speed],[Direction],[SatellitesCount]) VALUES(@UserId,@ServerTime,@BeginTime,@EndTime,@Latitude,@Longitude,@Speed,@Direction,@SatellitesCount)", conn, tran);
                        cmd.Parameters.Add("@UserId", SqlDbType.UniqueIdentifier);
                        cmd.Parameters.Add("@ServerTime", SqlDbType.DateTime);
                        cmd.Parameters.Add("@BeginTime", SqlDbType.DateTime);
                        cmd.Parameters.Add("@EndTime", SqlDbType.DateTime);
                        cmd.Parameters.Add("@Latitude", SqlDbType.Decimal);
                        cmd.Parameters.Add("@Longitude", SqlDbType.Decimal);
                        cmd.Parameters.Add("@Speed", SqlDbType.Decimal);
                        cmd.Parameters.Add("@Direction", SqlDbType.Int);
                        cmd.Parameters.Add("@SatellitesCount", SqlDbType.Int);
                        cmd.Parameters.Add("@Altitude", SqlDbType.Decimal);
                        foreach (DataRow row in tbl.Rows)
                        {
                            cmd.Parameters["@UserId"].Value          = userId;
                            cmd.Parameters["@ServerTime"].Value      = serverTime;
                            cmd.Parameters["@BeginTime"].Value       = row["BeginTime"];
                            cmd.Parameters["@EndTime"].Value         = row["EndTime"];
                            cmd.Parameters["@Latitude"].Value        = row["Latitude"];
                            cmd.Parameters["@Longitude"].Value       = row["Longitude"];
                            cmd.Parameters["@Speed"].Value           = row["Speed"];
                            cmd.Parameters["@Direction"].Value       = row["Direction"];
                            cmd.Parameters["@SatellitesCount"].Value = row["SatellitesCount"];
                            cmd.Parameters["@Altitude"].Value        = row["Altitude"];
                            cmd.ExecuteNonQuery();
                        }
                        tran.Commit();
                        return(MakeTextAnswer("ok"));
                    }
                    catch (Exception e)
                    {
                        tran.Rollback();
                        throw;
                    }
                }
            }
        }
 public XmlFileWrapper(string filePath)
 {
     if (!Path.GetExtension(filePath).Equals(".xml", StringComparison.OrdinalIgnoreCase))
     {
         throw new ArgumentException(Lib.XmlFileExpected, "filePath");
     }
     this.filePath = filePath;
     data = new DataTable();
     data.ReadXml(filePath);
 }
Beispiel #31
0
        public mainForm()
        {
            InitializeComponent();

            DataTable _table = new DataTable();
            _table.ReadXml(Application.StartupPath + @"\Data\test.xml");
            metroGrid1.DataSource = _table;

            metroGrid1.Font = new Font("Segoe UI", 11f, FontStyle.Regular, GraphicsUnit.Pixel);
        }
Beispiel #32
0
        public System.IO.Stream PostData(System.IO.Stream messageBody)
        {
            System.Data.DataTable tbl = new System.Data.DataTable();
            tbl.ReadXml(messageBody);
            if (tbl.Rows.Count == 0)
                return MakeTextAnswer("ok");
            else
            {
                Common.Solution solution = Common.Solution.CreateFromContext(this.scope);

                DateTime serverTime = DateTime.UtcNow;
                Guid userId = Guid.Parse(WebOperationContext.Current.IncomingRequest.Headers["userid"]);

                using (SqlConnection conn = new SqlConnection(solution.ConnectionString))
                {
                    conn.Open();
                    SqlTransaction tran = conn.BeginTransaction();
                    try
                    {
                        SqlCommand cmd = new SqlCommand("INSERT INTO [admin].GPS([UserId],[ServerTime],[BeginTime],[EndTime],[Latitude],[Longitude],[Speed],[Direction],[SatellitesCount]) VALUES(@UserId,@ServerTime,@BeginTime,@EndTime,@Latitude,@Longitude,@Speed,@Direction,@SatellitesCount)", conn, tran);
                        cmd.Parameters.Add("@UserId", SqlDbType.UniqueIdentifier);
                        cmd.Parameters.Add("@ServerTime", SqlDbType.DateTime);
                        cmd.Parameters.Add("@BeginTime", SqlDbType.DateTime);
                        cmd.Parameters.Add("@EndTime", SqlDbType.DateTime);
                        cmd.Parameters.Add("@Latitude", SqlDbType.Decimal);
                        cmd.Parameters.Add("@Longitude", SqlDbType.Decimal);
                        cmd.Parameters.Add("@Speed", SqlDbType.Decimal);
                        cmd.Parameters.Add("@Direction", SqlDbType.Int);
                        cmd.Parameters.Add("@SatellitesCount", SqlDbType.Int);
                        cmd.Parameters.Add("@Altitude", SqlDbType.Decimal);
                        foreach (DataRow row in tbl.Rows)
                        {
                            cmd.Parameters["@UserId"].Value = userId;
                            cmd.Parameters["@ServerTime"].Value = serverTime;
                            cmd.Parameters["@BeginTime"].Value = row["BeginTime"];
                            cmd.Parameters["@EndTime"].Value = row["EndTime"];
                            cmd.Parameters["@Latitude"].Value = row["Latitude"];
                            cmd.Parameters["@Longitude"].Value = row["Longitude"];
                            cmd.Parameters["@Speed"].Value = row["Speed"];
                            cmd.Parameters["@Direction"].Value = row["Direction"];
                            cmd.Parameters["@SatellitesCount"].Value = row["SatellitesCount"];
                            cmd.Parameters["@Altitude"].Value = row["Altitude"];
                            cmd.ExecuteNonQuery();
                        }
                        tran.Commit();
                        return MakeTextAnswer("ok");
                    }
                    catch (Exception e)
                    {
                        tran.Rollback();
                        throw;
                    }
                }
            }
        }
        public MainForm()
        {
            InitializeComponent();

            DataTable _table = new DataTable();
            _table.ReadXml(Application.StartupPath + @"\Data\Books.xml");
            metroGrid1.DataSource = _table;

            metroGrid1.Font = new Font("Segoe UI", 11f, FontStyle.Regular, GraphicsUnit.Pixel);
            metroGrid1.AllowUserToAddRows = false;
        }
        public frDanhSachMatHang()
        {
            InitializeComponent();

            txtNgay.DateTime = DateTime.Now;

            //dsDanhSachHangHoa.InMaVach.AddInMaVachRow(
            //    "M" + DateTime.Now.ToShortDateString(),
            //    "Mặt đá màu",
            //    Convert.ToDecimal(0.040),
            //    Convert.ToDecimal(0.026),
            //    300000,
            //    Convert.ToDecimal(0.014),
            //    "24k",
            //    "CL",
            //    "600",
            //    1
            //    );

            var dt = new DataTable("CauHinhCSDL");
            dt.Columns.Add("TenTiem");
            dt.Columns.Add("DiaChi");

            var fi = new FileInfo(Application.StartupPath + "\\CauHinhCSDL.xml");
            if (!fi.Exists) return;

            dt.ReadXml(Application.StartupPath + "\\CauHinhCSDL.xml");
            try
            {
                if (dt.Rows.Count > 0)
                {
                    txtTenDoanhNghiep.Text = dt.Rows[0]["TenTiem"].ToString();
                    txtDiaChi.Text = dt.Rows[0]["DiaChi"].ToString();
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }

            cbCongCom.Items.Clear();
            string[] port = SerialPort.GetPortNames();
            foreach (string item in port)
            {
                cbCongCom.Items.Add(item);
            }
            if (port.Length > 0)
            {
                cbCongCom.SelectedIndex = 0;
            }

            bbiXem_ItemClick(this, null);
        }
 private void btnReadXmlTable_Click(object sender, EventArgs e)
 {
     DataTable tblPeople2 = new DataTable();
     try
     {
         tblPeople2.ReadXml("People.xml");
         dataGridView1.DataSource = tblPeople2;
     }
     catch
     {
         MessageBox.Show("XML 파일이 없습니다.");
     }
 }
Beispiel #36
0
 DataTable loadFromXMLOrCache()
 {
     DataTable tbl = (DataTable)Cache[cacheKey];
     if (null == tbl)
     {
         string xmlFile = Server.MapPath("~/app_data/orders.xml");
         tbl = new DataTable();
             tbl.ReadXml(xmlFile);
         CacheDependency dep = new CacheDependency(xmlFile);
         Cache.Insert(cacheKey, tbl, dep);
     }
     return tbl;
 }
Beispiel #37
0
 public static System.Data.DataTable DeSerializeDataTable(Stream Contentdata)
 {
     try
     {
         System.Data.DataTable retour = new System.Data.DataTable();
         retour.ReadXml(Contentdata);
         return(retour);
     }
     catch (Exception ex)
     {
         throw new Exception("DeSerializeDataTable " + ex.Message, ex);
     }
 }
Beispiel #38
0
 public cParser(cScanner a_scanner, string a_filename)
 {
     cf_scanner = a_scanner;
     cf_dataTable = new DataTable("table");
     cf_dataTable.Columns.Add("i", typeof(int));
     cf_dataTable.Columns.Add("terminals", typeof(string[]));
     cf_dataTable.Columns.Add("jump", typeof(int));
     cf_dataTable.Columns.Add("accept", typeof(bool));
     cf_dataTable.Columns.Add("stack", typeof(bool));
     cf_dataTable.Columns.Add("return", typeof(bool));
     cf_dataTable.Columns.Add("error", typeof(bool));
     cf_dataTable.Columns.Add("action", typeof(string));
     cf_dataTable.ReadXml(a_filename);
 }
Beispiel #39
0
 private void OpenDataFile()
 {
     UpdateStatus("Загрузка файла...", Cursors.WaitCursor);
     dtCadList = new XML.online_data.rosreestr_infoDataTable();
     try
     {
         dtCadList.ReadXml(AppDomain.CurrentDomain.BaseDirectory + "result.xml");
         UpdateStatus("Готово", Cursors.Arrow);
     }
     catch (Exception ex)
     {
         UpdateStatus(ex.Message, Cursors.Arrow);
         return;
     }
     if (dtCadList != null)
     {
         FillListView();
     }
 }
Beispiel #40
0
        /// <summary>
        /// Diseña columnas del datatable,
        /// verifica si el archivo existe previamente
        /// asigna tabla al DataGridView
        /// </summary>
        private void ConfiguracionInicial()
        {
            // diseño de la TablaPersona
            TablaPersona.Columns.Add("Nombre");
            TablaPersona.Columns.Add("Domicilio");
            TablaPersona.Columns.Add("DNI");
            TablaPersona.Columns.Add("Edad");

            // busca si el archivo ya existe para precargar sus datos
            if (System.IO.File.Exists(NombreArchivo))
            {
                TablaPersona.ReadXml(NombreArchivo);
            }

            // asigna TablaPersona a dgvPersonas
            dgvPersonas.DataSource = TablaPersona;
            // elimina la posibilidad de ingresar datos en el datagridview
            dgvPersonas.AllowUserToAddRows = false;
            // elimina el encabezado de las filas
            dgvPersonas.RowHeadersVisible = false;
        }
        private void btLeerArchivo_Click(Object sender, EventArgs e)
        {
            if (!System.IO.File.Exists(@"clientes.xml"))
            {
                label1.Text = "No existe archivo cliente.xml";
            }
            else
            {
                oTabla.Clear();

                oTabla.ReadXml(@"clientes.xml");
                label1.Text = "";
                foreach (System.Data.DataRow oFila in oTabla.Rows)
                {
                    System.String mNombre    = oFila["nombre"].ToString();
                    System.Int32  edad       = System.Convert.ToInt32(oFila["edad"].ToString());
                    System.String mDomicilio = oFila["domicilio"].ToString();

                    label1.Text = label1.Text + mNombre + " - " + edad + " - " + mDomicilio + "\r\n";
                }
            }
        }