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; */ }
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)); }
/// <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; }
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(); }
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); } } }
/// <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(); }
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(); }
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); }
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); }
/// <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; } }
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; } }
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); } }
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); } }
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"]); }
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; }
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; }
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)); }
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); }
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); }
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); }
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 파일이 없습니다."); } }
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; }
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); } }
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); }
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(); } }
/// <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"; } } }