public void GetReady () { dataTable = new DataTable ("itemTable"); dc1 = new DataColumn ("itemId"); dc2 = new DataColumn ("itemName"); dc3 = new DataColumn ("itemPrice"); dc4 = new DataColumn ("itemCategory"); dataTable.Columns.Add (dc1); dataTable.Columns.Add (dc2); dataTable.Columns.Add (dc3); dataTable.Columns.Add (dc4); DataRow dr; seed = 123; rowCount = 5; rndm = new Random (seed); for (int i = 1; i <= rowCount; i++) { dr = dataTable.NewRow (); dr["itemId"] = "item " + i; dr["itemName"] = "name " + rndm.Next (); dr["itemPrice"] = "Rs. " + (rndm.Next () % 1000); dr["itemCategory"] = "Cat " + ((rndm.Next () % 10) + 1); dataTable.Rows.Add (dr); } dataTable.AcceptChanges (); dataView = new DataView (dataTable); dataView.ListChanged += new ListChangedEventHandler (OnListChanged); listChangedArgs = null; }
public void LoadImgs() { LoadSelect(); System.IO.DirectoryInfo dir = new System.IO.DirectoryInfo(Request.PhysicalApplicationPath + "\\Images\\avatar"); DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("ID")); dt.Columns.Add(new DataColumn("Name")); dt.AcceptChanges(); foreach (System.IO.FileInfo file in dir.GetFiles()) { string ID = file.Name.Replace(file.Extension, ""); try { int i = int.Parse(ID); DataRow dr = dt.NewRow(); dr["ID"] = file.Name.Replace(file.Extension, ""); dr["Name"] = "../../Images/avatar/" + file.Name; dt.Rows.Add(dr); } catch { continue; } } dt.AcceptChanges(); dlstImg.DataSource = dt; dlstImg.DataBind(); }
/// <summary> /// Processes the result of a data submission to the Server where the result of that operation is /// <see cref="TSubmitChangesResult.scrOK" />. (Overload for DataTables.) /// </summary> /// <param name="ACallingFormOrUserControl"></param> /// <param name="ALocalDT"></param> /// <param name="ASubmitDT"></param> /// <param name="APetraUtilsObject"></param> /// <param name="AVerificationResults"></param> /// <param name="ASetPrimaryKeyOnlyMethod"></param> /// <param name="AMasterDataTableSaveCall"></param> /// <param name="ACalledFromUserControl"></param> /// <param name="ACallAcceptChangesOnReturnedDataBeforeMerge"></param> public static void ProcessSubmitChangesResultOK(IFrmPetra ACallingFormOrUserControl, DataTable ALocalDT, DataTable ASubmitDT, TFrmPetraEditUtils APetraUtilsObject, TVerificationResultCollection AVerificationResults, Action <bool>ASetPrimaryKeyOnlyMethod, bool AMasterDataTableSaveCall, bool ACalledFromUserControl, bool ACallAcceptChangesOnReturnedDataBeforeMerge = false) { if (AMasterDataTableSaveCall) { // Call AcceptChanges to get rid now of any deleted columns before we Merge with the result from the Server ALocalDT.AcceptChanges(); // Merge back with data from the Server (eg. for getting Sequence values) if (ACallAcceptChangesOnReturnedDataBeforeMerge) { ASubmitDT.AcceptChanges(); } ALocalDT.Merge(ASubmitDT, false); // Need to accept any new modification ID's ALocalDT.AcceptChanges(); if (ASetPrimaryKeyOnlyMethod != null) { // Ensure the Primary-Key(s)-containing Controls are disabled to prevent further modification of Primary Key values ASetPrimaryKeyOnlyMethod(true); } } CommonPostMergeOperations(ACallingFormOrUserControl, APetraUtilsObject, AVerificationResults, ACalledFromUserControl); }
private void button4_Click(object sender, EventArgs e) { //Satır Sil butonu try { //Liste güncellenir TeklifList = Teklif.teklif_listesi_olustur(dt); if (dataGridView1.SelectedRows.Count != 0) { foreach (DataGridViewRow row in dataGridView1.SelectedRows) { dataGridView1.Rows.Remove(row); } //Datatable güncellenir dt.AcceptChanges(); } else { MessageBox.Show("Lütfen silinecek satırı seçiniz.", "Bilgilendirme", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (NullReferenceException exception) { MessageBox.Show("Satır seçilmedi"); } catch (System.Exception exception) { MessageBox.Show("Bir hata meydana geldi.ERROR=" + exception.Message); } }
public static DataTable ParseToDataTable(IList<Data.PemeriksaanDetail> srs) { DataTable deta = new DataTable(); foreach (PropertyInfo info in typeof(Data.PemeriksaanDetail).GetProperties()) { deta.Columns.Add(info.Name, info.PropertyType); } deta.AcceptChanges(); foreach (var i in srs) { Data.PemeriksaanDetail sr = new Data.PemeriksaanDetail(); sr = i; DataRow row = deta.NewRow(); foreach (var property in sr.GetType().GetProperties()) { row[property.Name] = property.GetValue(sr, null); } deta.Rows.Add(row); } deta.AcceptChanges(); return deta; }
public void Execute(string query, out Object data) { //execute the query and return data from it //i.e. like a select query MySqlCommand cmd = new MySqlCommand(query, _conn); MySqlDataReader rdr = cmd.ExecuteReader(); //tbd....check that rows aren't empty first //get the column list DataColumnCollection cols = rdr.GetSchemaTable().Columns; DataTable dt = new System.Data.DataTable(); for (int i = 0; i < cols.Count; i++) { dt.Columns.Add(cols[i]); } dt.AcceptChanges(); //read the data while (rdr.Read()) { //who knows if this works i'm experimenting for now... object[] values = null; rdr.GetValues(values); dt.Rows.Add(values); dt.AcceptChanges(); } rdr.Close(); data = dt; }
public static System.Data.DataTable AutoFind組込(System.Data.DataTable _dtbSeihin, System.Data.DataTable _dtbBuhin) { #region 20161223 - BotFjP - 日付と図面番号で 順番 // DataView _dvSeihin = new DataView(_dtbSeihin); _dtbSeihin.DefaultView.Sort = "納期,図面番号"; _dtbSeihin = _dtbSeihin.DefaultView.ToTable(); //DataView _dvBuhin = new DataView(_dtbBuhin); _dtbBuhin.DefaultView.Sort = "納期,図面番号"; _dtbBuhin = _dtbBuhin.DefaultView.ToTable(); for (int i = 0; i < _dtbBuhin.Rows.Count; i++) { _dtbSeihin.Rows[i]["組込番号"] = _dtbBuhin.Rows[i]["組込番号"].ToString(); } _dtbSeihin.AcceptChanges(); #endregion #region 20161223 - BotFjP - add column 棚番号 注文番号 _dtbSeihin.Columns.Add("注文番号", typeof(string)); _dtbSeihin.Columns.Add("棚番号", typeof(string)); #endregion _dtbSeihin.AcceptChanges(); return(_dtbSeihin); }
private void btnImport_Click(object sender, EventArgs e) { System.Data.DataTable dt = new System.Data.DataTable("datable"); DataSet dsSource = new DataSet("dataSet"); dt.Reset(); Microsoft.Office.Interop.Excel.Workbook ExWorkbook; Microsoft.Office.Interop.Excel.Worksheet ExWorksheet; Microsoft.Office.Interop.Excel.Range ExRange; Microsoft.Office.Interop.Excel.Application Exobj = new Microsoft.Office.Interop.Excel.Application(); openFileDialog1.Filter = "Excel Files |*.xls;*.xlsx;*.xlsm"; DialogResult result = openFileDialog1.ShowDialog(); if (result == DialogResult.OK)//test result { ExWorkbook = Exobj.Workbooks.Open(openFileDialog1.FileName, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value); ExWorksheet = (Microsoft.Office.Interop.Excel.Worksheet)ExWorkbook.Sheets.get_Item(1); ExRange = ExWorksheet.UsedRange; for (int Cnum = 1; Cnum <= ExRange.Columns.Count; Cnum++) { dt.Columns.Add(new DataColumn((ExRange.Cells[1, Cnum] as Microsoft.Office.Interop.Excel.Range).Value2.ToString())); } dt.AcceptChanges(); string[] columnNames = new string[dt.Columns.Count]; for (int i = 0; i < dt.Columns.Count; i++) { columnNames[0] = dt.Columns[i].ColumnName; } for (int Rnum = 2; Rnum <= ExRange.Rows.Count; Rnum++) { DataRow dr = dt.NewRow(); for (int Cnum = 1; Cnum <= ExRange.Columns.Count; Cnum++) { if ((ExRange.Cells[Rnum, Cnum] as Microsoft.Office.Interop.Excel.Range).Value2 != null) { dr[Cnum - 1] = (ExRange.Cells[Rnum, Cnum] as Microsoft.Office.Interop.Excel.Range).Value2.ToString(); } dt.Rows.Add(dr); dt.AcceptChanges(); } } ExWorkbook.Close(true, Missing.Value, Missing.Value); Exobj.Quit(); dataGridView1.DataSource = dt; } }
private System.Data.DataTable GetDataTable(IEnumerable list) { System.Data.DataTable dt = new System.Data.DataTable(); bool schemaIsBuild = false; PropertyInfo[] props = null; foreach (object item in list) { if (!schemaIsBuild) { props = item.GetType().GetProperties(); foreach (var pi in props) { dt.Columns.Add(new DataColumn(pi.Name, pi.PropertyType)); } } schemaIsBuild = true; var row = dt.NewRow(); foreach (var pi in props) { row[pi.Name] = pi.GetValue(item, null); } dt.Rows.Add(row); dt.AcceptChanges(); } return(dt); }
public static void Load_ListDS() { if (File.Exists(m_MySensors_FilePath)) { SensorDS = new DataSet("SensorDS"); SensorDS.ReadXml(m_MySensors_FilePath, XmlReadMode.ReadSchema); } else { if (SensorDS != null) { SensorDS.Dispose(); GC.Collect(); } DataTable dt0 = new DataTable("SensorTBL"); dt0.Columns.Add(new DataColumn(Cfg.C_IS_PICK, Type.GetType(Cfg.SYS_INT32))); dt0.Columns[Cfg.C_IS_PICK].DefaultValue = 1; dt0.Columns.Add(new DataColumn(Sensor.C_SENSOR_ID, Type.GetType(Cfg.SYS_INT64))); dt0.Columns[Sensor.C_SENSOR_ID].DefaultValue = Sensor.Sensor_ID; dt0.Columns.Add(new DataColumn(Sensor.C_LOCATION_NAME, Type.GetType(Cfg.SYS_STRING))); dt0.Columns[Sensor.C_LOCATION_NAME].DefaultValue = Sensor.Location_Name; dt0.Rows.Add(dt0.NewRow()); dt0.AcceptChanges(); SensorDS = new DataSet("SensorDS"); SensorDS.Tables.Add(dt0); SensorDS.AcceptChanges(); } SensorDS.Tables[0].DefaultView.Sort = Sensor.C_SENSOR_ID; }
private DataSet GetLookupValuesFromDatabase() { DataSet ds = new DataSet(); DataTable dt = new DataTable(); DataColumn idCol = new DataColumn("ID", typeof(int)); DataColumn nameCol = new DataColumn("Name", typeof(string)); dt.Columns.Add(idCol); dt.Columns.Add(nameCol); dt.AcceptChanges(); DataRow newRow = null; newRow = dt.NewRow(); newRow[idCol] = 1; newRow[nameCol] = "Joe Bloggs ID#1"; dt.Rows.Add(newRow); newRow = dt.NewRow(); newRow[idCol] = 2; newRow[nameCol] = "Mr A. Nonymous ID#2"; dt.Rows.Add(newRow); newRow = dt.NewRow(); newRow[idCol] = 3; newRow[nameCol] = "Mrs N. Extdoorneighbour ID#3"; dt.Rows.Add(newRow); newRow = dt.NewRow(); newRow[idCol] = 4; newRow[nameCol] = "Mr. Pea Body ID#4"; dt.Rows.Add(newRow); ds.Tables.Add(dt); ds.AcceptChanges(); return ds; }
public static DataTable GetTableFromCSVTextFile (String TextFileName, String TableName, char Delimitter) { DataTable CSVTable = new DataTable (TableName); StreamReader CSVReader = new StreamReader (TextFileName, Encoding.UTF7); String OriginalHeadLine = CSVReader.ReadLine (); String HeadLine = OriginalHeadLine.Replace (" ", ""); String [] CSVCols = HeadLine.Split (Delimitter); int ActuallIndex = 0; foreach (String ColumnName in CSVCols) { CSVTable.Columns.Add (ColumnName, typeof (System.String)); } while (CSVReader.Peek () != null) { String ContentLine = CSVReader.ReadLine (); if (ContentLine == null) break; String [] CSVContent = ContentLine.Split (Delimitter); DataRow NewRow = CSVTable.NewRow (); int ColIndex = 0; foreach (String Content in CSVContent) { NewRow [ColIndex++] = Content; } CSVTable.Rows.Add (NewRow); } CSVReader.Close (); CSVTable.AcceptChanges (); return CSVTable; }
public static void AddRowTableDetail(ref DataTable dtResultDetail, string TestData_ID, int Patient_ID, int Test_ID) { try { DataRow dr = dtResultDetail.NewRow(); DataRow drStandardTest = Utility.GetDataRow(PreloadedLists.StandardTest, LStandardTest.Columns.TestDataId, TestData_ID); dr[TResultDetail.Columns.TestDetailId] = -1; dr[TResultDetail.Columns.ParaName] = drStandardTest[LStandardTest.Columns.DataName]; dr[TResultDetail.Columns.NormalLevel] = drStandardTest[LStandardTest.Columns.NormalLevel]; dr[TResultDetail.Columns.NormalLevelW] = drStandardTest[LStandardTest.Columns.NormalLevelW]; dr[TResultDetail.Columns.DataSequence] = drStandardTest[LStandardTest.Columns.DataSequence]; dr[TResultDetail.Columns.PrintData] = drStandardTest[LStandardTest.Columns.DataPrint]; dr[TResultDetail.Columns.MeasureUnit] = drStandardTest[LStandardTest.Columns.MeasureUnit]; dr[TResultDetail.Columns.TestDataId] = drStandardTest[LStandardTest.Columns.TestDataId]; dr[TResultDetail.Columns.PatientId] = Patient_ID; dr[TResultDetail.Columns.TestTypeId] = drStandardTest[LStandardTest.Columns.TestTypeId]; ; dr[TResultDetail.Columns.TestId] = Test_ID; dtResultDetail.Rows.Add(dr); dtResultDetail.AcceptChanges(); } catch (Exception ex) { Utility.ShowMsg(ex.Message); } }
protected System.Data.DataTable GetDataFromGrid2() { System.Data.DataTable dt = new System.Data.DataTable(); #region dt.Columns.Add("GOODNAME"); dt.Columns.Add("GOODGUIGE"); dt.Columns.Add("GOODNUM"); dt.Columns.Add("GOODDANWEI"); dt.Columns.Add("GOODPRICE"); dt.Columns.Add("GOODMONEY"); #endregion for (int i = 0; i < Repeater2.Items.Count; i++) { RepeaterItem rItem = Repeater2.Items[i]; DataRow newRow = dt.NewRow(); newRow[0] = ((HtmlInputText)rItem.FindControl("goodsname2")).Value.Trim(); newRow[1] = ((HtmlInputText)rItem.FindControl("goodsguige2")).Value.Trim(); newRow[2] = ((HtmlInputText)rItem.FindControl("goodsnum2")).Value.Trim(); newRow[3] = ((HtmlInputText)rItem.FindControl("goodsdanwei2")).Value.Trim(); newRow[4] = ((HtmlInputText)rItem.FindControl("goodsprice2")).Value.Trim(); newRow[5] = ((HtmlInputText)rItem.FindControl("moneyone2")).Value.Trim(); dt.Rows.Add(newRow); } for (int i = Repeater2.Items.Count; i < 3; i++) { DataRow newRow = dt.NewRow(); dt.Rows.Add(newRow); } dt.AcceptChanges(); return(dt); }
protected void btnSaveChanges_Click(object sender, EventArgs e) { using (System.Data.DataTable xmlData = Lib.Blok.GetXmlData()) { foreach (GridViewRow item in dataGrid1.Rows) { switch (((CheckBox)item.Cells[0].FindControl("chkSelected")).Checked) { case true: xmlData.DefaultView.RowFilter = ""; xmlData.DefaultView.RowFilter = "ID=" + BAYMYO.UI.Converts.NullToInt32(dataGrid1.DataKeys[item.RowIndex]["ID"]); xmlData.DefaultView[0]["Sira"] = BAYMYO.UI.Converts.NullToInt16(((DropDownList)item.FindControl("ddlSira")).SelectedValue); xmlData.DefaultView[0]["Yer"] = ((DropDownList)item.FindControl("ddlYer")).SelectedValue; xmlData.DefaultView[0]["Dil"] = ((DropDownList)item.FindControl("ddlDil")).SelectedValue; xmlData.DefaultView[0]["TumDil"] = ((CheckBox)item.FindControl("chkTumDil")).Checked; xmlData.DefaultView[0]["TumSayfa"] = ((CheckBox)item.FindControl("chkTumSayfa")).Checked; xmlData.DefaultView[0]["Aktif"] = ((CheckBox)item.FindControl("chkAktif")).Checked; break; } } xmlData.AcceptChanges(); xmlData.WriteXml(Server.MapPath(Lib.Blok.XmlPath)); infoLiteral.Text = "Tablo üzerindeki değişiklikler başarılı bir şekilde kaydedildi!"; } }
void CustomizeControl1_RemoveClick(SortedDictionary <string, Control> controls) { try { if (!string.IsNullOrEmpty(Request.QueryString["bid"])) { using (System.Data.DataTable xmlData = Lib.Blok.GetXmlData()) { xmlData.DefaultView.RowFilter = ""; xmlData.DefaultView.RowFilter = "ID=" + Request.QueryString["bid"]; if (xmlData.DefaultView.Count > 0) { switch (Request.QueryString["type"]) { case "html": FileIO.Remove(Server.MapPath(Lib.Blok.HtmlPath) + xmlData.DefaultView[0]["Adi"]); break; } xmlData.DefaultView[0].Delete(); xmlData.AcceptChanges(); xmlData.WriteXml(Server.MapPath(Lib.Blok.XmlPath)); ScriptManager.RegisterStartupScript(Page, typeof(Page), "x", "alert('Silme işleminiz başarılı bir şekilde tamamlandı!');", true); Response.Redirect(Settings.PanelPath + "?go=blok&type=" + Request.QueryString["type"], false); } } } } catch (Exception ex) { throw ex; } }
void FormDetailTVP(ref DataTable Dt) { DataColumn CHKD_ProcessId = Dt.Columns.Add("CHKD_ProcessId", typeof(String)); DataColumn CHKD_RowId = Dt.Columns.Add("CHKD_RowId", typeof(Int32)); DataColumn CHKD_Checked = Dt.Columns.Add("CHKD_Checked", typeof(Boolean)); Dt.AcceptChanges(); }
private void FillTable() { dataTable1.Rows.Add(new object[] { "Ann", "Washington", 30 }); dataTable1.Rows.Add(new object[] { "Bill", "New York", 40 }); dataTable1.Rows.Add(new object[] { "Clive", "New York", 50 }); dataTable1.AcceptChanges(); }
/// <summary> /// Transtorms list into JSON string accepted by http://d3js.org/ charts /// </summary> /// <param name="chartData"></param> /// <returns></returns> public static string ToChartJson(this List<StatsdChartData> chartData) { var table = new DataTable("Nodes"); table.Columns.Add("date"); var rows = new Dictionary<DateTime, DataRow>(); foreach (var chart in chartData) { table.Columns.Add(string.Format("chart{0}", chartData.IndexOf(chart)+1)); } foreach (var chart in chartData) { foreach (var dataPoint in chart.DataPoints) { if (!rows.ContainsKey(dataPoint.UtcTime)) { var row = table.NewRow(); row["date"] = dataPoint.UtcTime; rows.Add(dataPoint.UtcTime, row); } rows[dataPoint.UtcTime][string.Format("chart{0}", chartData.IndexOf(chart) + 1)] = dataPoint.Value; } } foreach (var row in rows) { table.Rows.Add(row.Value); } table.AcceptChanges(); DataSet ds = new DataSet(); ds.Tables.Add(table); return JsonConvert.SerializeObject(ds, Formatting.None); }
/// <summary> /// /// </summary> /// <param name="sql">构建表结构的sql</param> /// <param name="dt">数据集</param> /// <param name="sqlconnnection">数据库连接字符串</param> /// <returns></returns> public static bool ExecuteSave(string sqlconnnection, string sql, DataTable dt) { SqlCommand cmd = new SqlCommand(); cmd.CommandTimeout = 300; SqlConnection conn = new SqlConnection(sqlconnnection); ConnOpen(conn); try { SqlDataAdapter adapter = new SqlDataAdapter(cmd); adapter.SelectCommand = new SqlCommand(sql, conn); SqlCommandBuilder cmdbuilder = new SqlCommandBuilder(adapter); adapter.Update(dt); dt.AcceptChanges(); cmd.Parameters.Clear(); return true; } catch { return false; } finally { ConnClose(conn);//关闭数据库并释放内存 } }
public static DataTable ListToTable(this List<Dictionary<string, string>> dic) { var dt = new DataTable("Results"); dic.ForEach(props => { props.ToList().ForEach(i => { if (!dt.Columns.Contains(i.Key)) { dt.Columns.Add(new DataColumn(i.Key)); } }); var dr = dt.NewRow(); props.ToList().ForEach(i => dr[i.Key] = i.Value); dt.Rows.Add(dr); }); dt.AcceptChanges(); return dt; }
private void openFileSourceToolStripMenuItem_Click(object sender, EventArgs e) { try { OpenFileDialog _of = new OpenFileDialog(); _of.Filter = "All Files (*.*)|*.*"; _of.FilterIndex = 1; _of.Multiselect = false; if (_of.ShowDialog() == DialogResult.OK) { _dtbSource = Common.GetDataTable(_of.FileName); for (int i = _dtbSource.Columns.Count - 1; i >= 0; i--) { if (!string.IsNullOrEmpty(_dtbSource.Rows[0][i].ToString())) { _dtbSource.Columns[i].ColumnName = _dtbSource.Rows[0][i].ToString(); } else { //delete null columns _dtbSource.Columns.RemoveAt(i); } } _dtbSource.Rows[0].Delete(); _dtbSource.AcceptChanges(); // MessageBox.Show("col5:" + _dtbSource.Columns[5].ColumnName.ToString()+ "col6" + _dtbSource.Columns[6].ColumnName.ToString()); MessageBox.Show("Import Excel 出来ました。", "お知らせ", MessageBoxButtons.OK, MessageBoxIcon.Information); txtChumon.Focus(); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
public static void Baocaohuychot(DataTable m_dtReport, string kieuthuoc_vt, string sTitleReport, string dieukienbaocao, bool theonhom) { string tieude = "", reportname = "", reportcode = "thuoc_baocao_huychot_theonhom"; ReportDocument crpt = null; if (kieuthuoc_vt .Contains("THUOC")) { if (theonhom) { reportcode = "thuoc_baocao_huychot_theonhom"; } else { reportcode = "thuoc_baocao_huychot"; } } else//VTTH { if (theonhom) { reportcode = "vt_baocao_huychot_theonhom"; } else { reportcode = "vt_baocao_huychot"; } } crpt = Utility.GetReport(reportcode, ref tieude, ref reportname); if (crpt == null) return; MoneyByLetter _moneyByLetter = new MoneyByLetter(); var objForm = new frmPrintPreview(sTitleReport, crpt, true, m_dtReport.Rows.Count <= 0 ? false : true); objForm.mv_sReportFileName = Path.GetFileName(reportname); objForm.mv_sReportCode = reportcode; Utility.UpdateLogotoDatatable(ref m_dtReport); try { if (theonhom) m_dtReport.DefaultView.Sort = "stt_hthi_nhom,tenbietduoc"; else m_dtReport.DefaultView.Sort = "tenbietduoc"; m_dtReport.AcceptChanges(); crpt.SetDataSource(m_dtReport.DefaultView); Utility.SetParameterValue(crpt, "BranchName", globalVariables.Branch_Name); Utility.SetParameterValue(crpt, "Address", globalVariables.Branch_Address); Utility.SetParameterValue(crpt, "Phone", globalVariables.Branch_Phone); Utility.SetParameterValue(crpt, "ParentBranchName", globalVariables.ParentBranch_Name); Utility.SetParameterValue(crpt, "dieukienbaocao", dieukienbaocao); Utility.SetParameterValue(crpt, "sTitleReport", tieude); Utility.SetParameterValue(crpt, "BottomCondition", THU_VIEN_CHUNG.BottomCondition()); Utility.SetParameterValue(crpt, "txttrinhky",""); objForm.crptViewer.ReportSource = crpt; objForm.ShowDialog(); // Utility.DefaultNow(this); } catch (Exception ex) { Utility.CatchException(ex); } }
protected override IEnumerable ExecuteSelect(DataSourceSelectArguments selectArgs) { // only continue if a membership provider has been configured if (!Utils.IsProviderConfigured()) return null; // get roles and build data table DataTable dataTable = new DataTable(); String[] roles = Utils.BaseRoleProvider().GetAllRoles(); dataTable.Columns.Add("Role"); dataTable.Columns.Add("UsersInRole"); // add users in role counts for (int i = 0; i < roles.Length; i++) { DataRow row = dataTable.NewRow(); row["Role"] = roles[i]; row["UsersInRole"] = Utils.BaseRoleProvider().GetUsersInRole(roles[i].ToString()).Length; dataTable.Rows.Add(row); } dataTable.AcceptChanges(); DataView dataView = new DataView(dataTable); // sort if a sort expression available if (selectArgs.SortExpression != String.Empty) { dataView.Sort = selectArgs.SortExpression; } // return as a DataList return (IEnumerable) dataView; }
public void DSMauC79_80a_HD()//cấu trúc chung mẫu c80a-HD; c79a-HD { dtChungC79_80_a_HD = new System.Data.DataTable(); dtChungC79_80_a_HD.Columns.Add("stt", typeof(string)); // dtChungC79_80_a_HD.Columns.Add("tennhom", typeof(string)); dtChungC79_80_a_HD.Columns.Add("dt_stt", typeof(string)); dtChungC79_80_a_HD.Columns.Add("dt_bv", typeof(string)); dtChungC79_80_a_HD.Columns.Add("dt_ngayqd", typeof(string)); dtChungC79_80_a_HD.Columns.Add("dt_ngayhl", typeof(string)); dtChungC79_80_a_HD.Columns.Add("dt_nhom", typeof(string)); dtChungC79_80_a_HD.Columns.Add("masobyt", typeof(string)); dtChungC79_80_a_HD.Columns.Add("tenhc", typeof(string)); dtChungC79_80_a_HD.Columns.Add("tenvp", typeof(string)); dtChungC79_80_a_HD.Columns.Add("tentm", typeof(string)); dtChungC79_80_a_HD.Columns.Add("quicach", typeof(string)); dtChungC79_80_a_HD.Columns.Add("donvitinh", typeof(string)); dtChungC79_80_a_HD.Columns.Add("tennuoc", typeof(string)); dtChungC79_80_a_HD.Columns.Add("tenhang", typeof(string)); dtChungC79_80_a_HD.Columns.Add("dvktcao", typeof(string)); dtChungC79_80_a_HD.Columns.Add("dvktthuong", typeof(string)); dtChungC79_80_a_HD.Columns.Add("codantem", typeof(string)); dtChungC79_80_a_HD.Columns.Add("giamua", typeof(decimal)).DefaultValue = 0; dtChungC79_80_a_HD.Columns.Add("dinhmucts", typeof(string)); dtChungC79_80_a_HD.Columns.Add("giattbh", typeof(decimal)).DefaultValue = 0; dtChungC79_80_a_HD.Columns.Add("slngoaitru", typeof(decimal)).DefaultValue = 0; dtChungC79_80_a_HD.Columns.Add("slnoitru", typeof(decimal)).DefaultValue = 0; dtChungC79_80_a_HD.Columns.Add("thanhtien", typeof(decimal)).DefaultValue = 0; dtChungC79_80_a_HD.Columns.Add("ghichu", typeof(string)); dtChungC79_80_a_HD.AcceptChanges(); }
public static DataTable ExpandoToDataTable(List<dynamic> data) { int counter = 0; DataTable dt = new DataTable("data"); //generate columns foreach (dynamic item in data) { if (item is ExpandoObject) { if (counter <= 0) { foreach (var dataitem in (IDictionary<string, object>)item) { dt.Columns.Add(dataitem.Key); } } { var NewItem = dt.NewRow(); foreach (var dataitem in (IDictionary<string, object>)item) { NewItem[dataitem.Key] = dataitem.Value; } dt.Rows.Add(NewItem); } counter++; } } dt.AcceptChanges(); return dt; }
//protected string[][] ArmadoParametros() //{ // string[][] Params = new string[grdParams.Rows.Count][]; // HiddenField hddTipoDato = new HiddenField(); // HiddenField hddValor = new HiddenField(); // HiddenField hddNombre = new HiddenField(); // HiddenField hddLongitud = new HiddenField(); // int Longitud = 0; //Para forzar la salida de un número // for (int w = 0; w < grdParams.Rows.Count; w++) // { // hddTipoDato = (HiddenField)grdParams.Rows[w].FindControl("hddTipoDato"); // hddValor = (HiddenField)grdParams.Rows[w].FindControl("hddValor"); // hddNombre = (HiddenField)grdParams.Rows[w].FindControl("hddNombre"); // hddLongitud = (HiddenField)grdParams.Rows[w].FindControl("hddLongitud"); // int.TryParse(hddLongitud.Value, out Longitud); // Params[w] = new string[] { hddNombre.Value, hddValor.Value, hddTipoDato.Value.ToLowerInvariant(), Longitud.ToString() }; // } // return Params; //} protected System.Data.DataTable ArmadoParametros() { System.Data.DataTable Params = new System.Data.DataTable("Parametros"); System.Data.DataRow dr; HiddenField hddTipoDato = new HiddenField(); HiddenField hddValor = new HiddenField(); HiddenField hddNombre = new HiddenField(); HiddenField hddLongitud = new HiddenField(); int Longitud = 0; //Para forzar la salida de un número Params.Columns.Add("Nombre"); Params.Columns.Add("Valor"); Params.Columns.Add("Tipo"); Params.Columns.Add("Longitud"); for (int w = 0; w < grdParams.Rows.Count; w++) { hddTipoDato = (HiddenField)grdParams.Rows[w].FindControl("hddTipoDato"); hddValor = (HiddenField)grdParams.Rows[w].FindControl("hddValor"); hddNombre = (HiddenField)grdParams.Rows[w].FindControl("hddNombre"); hddLongitud = (HiddenField)grdParams.Rows[w].FindControl("hddLongitud"); int.TryParse(hddLongitud.Value, out Longitud); dr = Params.NewRow(); dr["Nombre"] = hddNombre.Value; dr["Valor"] = hddValor.Value; dr["Tipo"] = hddTipoDato.Value.ToLowerInvariant(); dr["Longitud"] = Longitud.ToString(); Params.Rows.Add(dr); } Params.AcceptChanges(); return(Params); }
public System.Data.DataTable SeihinAutoFixExcelFileCSVConvertXLS(System.Data.DataTable _dtbExec) { #region 20161214 - BotFJP - Delete columns not use for (int i = _dtbExec.Columns.Count - 1; i >= 0; i--) { if (new[] { 29, 31, 34 }.Contains(i)) { continue; } else { _dtbExec.Columns.RemoveAt(i); } } _dtbExec.Columns[0].ColumnName = "納期"; _dtbExec.Columns[1].ColumnName = "図面番号"; //部品=>組込番号 製品=>受注番号 _dtbExec.Columns[2].ColumnName = "受注番号"; _dtbExec.Columns.Add("組込番号", typeof(string)); _dtbExec.AcceptChanges(); #endregion #region 20161214 - BotFJP - Fix data 納期 Meo dc //foreach (DataRow _row in _dtbSource.Rows) //{ // _row["納期"] = DateTime.Parse(_row["納期"].ToString()).ToString("MM/dd"); //} //_dtbSource.AcceptChanges(); #endregion return(_dtbExec); }
/// <summary> /// 获取带DataGrid的仪表盘 /// </summary> /// <param name="title">表盘标题</param> /// <param name="unit">表盘单位</param> /// <param name="actualValue">实际值</param> /// <param name="alarmValue">报警设定值</param> /// <param name="maximunValue">表盘上限(可选)</param> /// <param name="minimumValue">表盘下限(可选)</param> /// <returns></returns> public static string GetGridMeterGaugeJsonString(string title, string unit, decimal actualValue, decimal alarmValue, decimal maximunValue = 0, decimal minimumValue = 0) { string[] myColumnsName = new string[] { "项目", "值" }; string[] myRowsName = new string[] { "表盘实际值", "报警设定值", "表盘的上限值", "表盘下限值" }; decimal[] myRowsValue = new decimal[] { actualValue, alarmValue, maximunValue, minimumValue }; string myUnitX = unit; string myUnitY = ""; int myFrozenColumns = 0; DataTable dt = new DataTable(); dt.Columns.Add("RowName", typeof(string)); dt.Columns.Add("Value", typeof(decimal)); for (int i = 0; i < myRowsName.Length; i++) { DataRow dr = dt.NewRow(); dr["RowName"] = myRowsName[i]; dr["Value"] = myRowsValue[i]; dt.Rows.Add(dr); } dt.AcceptChanges(); return GetGridChartJsonString(dt, myColumnsName, myRowsName, myUnitX, myUnitY, myFrozenColumns); }
protected void Page_Load(object sender, EventArgs e) { DataTable myTable = new DataTable("myTable"); DataColumn colItem = new DataColumn("item", Type.GetType("System.String")); DataColumn colItem1 = new DataColumn("item1", Type.GetType("System.Int32")); myTable.Columns.Add(colItem); myTable.Columns.Add(colItem1); // Add five items. DataRow NewRow; for (int i = 0; i < 2; i++) { NewRow = myTable.NewRow(); NewRow["item"] = i; myTable.Rows.Add(NewRow); } myTable.Rows[0]["item"] = "Juan"; myTable.Rows[0]["item1"] = "60"; myTable.Rows[1]["item"] = "Diego"; myTable.Rows[1]["item1"] = "40"; myTable.AcceptChanges(); //DataView custDV = new DataView(custDS.Tables["Customers"], "Country = 'USA'", "ContactName", DataViewRowState.CurrentRows); DataView custDV = new DataView(myTable); //Display(custDV); }
/// <summary> /// converts a excel byte array (fileuploader creates this for you) to data table. /// needs the NuGet package excelDatareader (npm: Install-Package ExcelDataReader), using Excel. /// Use if you cant/dont want to save documents to your directories /// </summary> /// <param name="excelArray">The excel array.</param> /// <returns></returns> /*public static System.Data.DataTable XLSXByteArraytoDataTable(byte[] excelArray) * { * IExcelDataReader excelReader; * System.Data.DataTable dt = new System.Data.DataTable(); * MemoryStream excelStream = new MemoryStream(excelArray); * excelReader = ExcelReaderFactory.CreateOpenXmlReader(excelStream); * excelReader.IsFirstRowAsColumnNames = true; * DataSet ds = excelReader.AsDataSet(); * dt = ds.Tables[0]; * return dt; * }*/ /// <summary> /// Converts a CSV file's data to a Data Table /// </summary> /// <param name="inputFile">The input file.</param> /// <returns></returns> public static System.Data.DataTable CSVToDataTable(string inputFile) { System.Data.DataTable dt = new System.Data.DataTable(); FileStream fs = File.OpenRead(inputFile); StreamReader sr = new StreamReader(fs); string totalContent = sr.ReadToEnd(); string[] lines = totalContent.Split("\r\n"[0]); for (int i = 0; i < lines.Length; i++) { dt.Rows.Add(); string[] lineContent = lines[i].Split(","[0]); //should be the same length as the colLength for (int j = 0; j < lineContent.Length; j++) { if (dt.Columns.Count < j + 1) { dt.Columns.Add(); } dt.Rows[i][j] = lineContent[j]; } } dt.AcceptChanges(); return(dt); }
private DataTable RemoveNonOutToCustomerData(DataTable dt) { if (dt.Rows.Count > 0) { string trfFrom, trfTo; for (int i = dt.Rows.Count - 1; i >= 0; i--) { trfFrom = dt.Rows[i][dalTrfHist.TrfFrom].ToString(); trfTo = dt.Rows[i][dalTrfHist.TrfTo].ToString(); if (dt.Rows[i][dalTrfHist.TrfResult].ToString().Equals("Passed")) { if (tool.getFactoryID(trfFrom) == -1 || tool.getCustID(trfTo) == -1) { dt.Rows[i].Delete(); } } else { dt.Rows[i].Delete(); } } dt.AcceptChanges(); } return(dt); }
/// <summary> /// Export a DataTable to an CSV File /// </summary> /// <param name="dt">The Data Table.</param> /// <param name="response">The HttpResponse that will download the Excel File.</param> /// <param name="fileName">Name of the file.</param> /// <param name="startCol">The first column of the Gridview to export.</param> /// <exception cref="System.ArgumentOutOfRangeException">Starting column must be within the range of the column count</exception> public static void DataTableToCSV(System.Data.DataTable dt, HttpResponse response, string fileName, int startCol) { System.Data.DataTable myTable = dt.Copy(); if (startCol > myTable.Columns.Count || startCol < 0) { throw new ArgumentOutOfRangeException("Starting column must be within the range of the column count"); } for (int i = startCol; i < myTable.Columns.Count; i++) { myTable.Columns.Add(dt.Columns[i].ToString()); } for (int j = 0; j < dt.Rows.Count; j++) { int length = dt.Columns.Count - startCol; string[] colValues = new string[length]; for (int k = 0; k < length; k++) { colValues[k] = dt.Rows[j][k].ToString(); } myTable.Rows.Add(colValues); } myTable.AcceptChanges(); DataTableToCSV(myTable, response, fileName); }
void MedStoreLoad() { try { conn.Open(); string sqlquery = "SELECT * FROM MED_STORE"; //string sqlquery = "SELECT * FROM MED_INFO"; OracleCommand cmd = new OracleCommand(sqlquery, conn); OracleDataAdapter oda = new OracleDataAdapter(); oda.SelectCommand = cmd; dt = new DataTable(); // dt.Columns["MED_NAME"].ColumnName = "Name"; oda.Fill(dt); BindingSource bsource = new BindingSource(); bsource.DataSource = dt; dataGridView1.DataSource = bsource; oda.Update(dt); dt.Columns[0].ColumnName = "ID"; dt.Columns[1].ColumnName = "Name"; dt.Columns[2].ColumnName = "Quantity"; dt.Columns[3].ColumnName = "Damage Qty"; dt.Columns[4].ColumnName = "Reorder Level"; dt.AcceptChanges(); conn.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public static System.Data.DataTable CreateChildDataTable() { System.Data.DataTable dtChild = new System.Data.DataTable("Child"); dtChild.Columns.Add("ParentId", typeof(int)); dtChild.Columns.Add("ChildId", typeof(int)); dtChild.Columns.Add("String1", typeof(string)); dtChild.Columns.Add("String2", typeof(string)); dtChild.Columns.Add("ChildDateTime", typeof(DateTime)); dtChild.Columns.Add("ChildDouble", typeof(double)); dtChild.Rows.Add(new object[] { 1, 1, "1-String1", "1-String2", new DateTime(2000, 1, 1, 0, 0, 0, 0), 1.534 }); dtChild.Rows.Add(new object[] { 1, 2, "2-String1", "2-String2", DateTime.MaxValue, -1.534 }); dtChild.Rows.Add(new object[] { 1, 3, "3-String1", "3-String2", DateTime.MinValue, double.MaxValue / 10000 }); dtChild.Rows.Add(new object[] { 2, 1, "1-String1", "1-String2", new DateTime(1973, 6, 20, 0, 0, 0, 0), double.MinValue * 10000 }); dtChild.Rows.Add(new object[] { 2, 2, "2-String1", "2-String2", new DateTime(2008, 12, 1, 13, 59, 59, 59), 0.45 }); dtChild.Rows.Add(new object[] { 2, 3, "3-String1", "3-String2", new DateTime(2003, 1, 1, 1, 1, 1, 1), 0.55 }); dtChild.Rows.Add(new object[] { 5, 1, "1-String1", "1-String2", new DateTime(2002, 1, 1, 1, 1, 1, 1), 0 }); dtChild.Rows.Add(new object[] { 5, 2, "2-String1", "2-String2", new DateTime(2001, 1, 1, 1, 1, 1, 1), 10 }); dtChild.Rows.Add(new object[] { 5, 3, "3-String1", "3-String2", new DateTime(2000, 1, 1, 1, 1, 1, 1), 20 }); dtChild.Rows.Add(new object[] { 6, 1, "1-String1", "1-String2", new DateTime(2000, 1, 1, 1, 1, 1, 0), 25 }); dtChild.Rows.Add(new object[] { 6, 2, "2-String1", "2-String2", new DateTime(2000, 1, 1, 1, 1, 0, 0), 30 }); dtChild.Rows.Add(new object[] { 6, 3, "3-String1", "3-String2", new DateTime(2000, 1, 1, 0, 0, 0, 0), 35 }); dtChild.AcceptChanges(); return(dtChild); }
/// <summary>コンストラクタ</summary> public TextBoxDataGridValidationBindingGroupWindow2() { InitializeComponent(); DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("count", typeof(Int32))); dt.Columns.Add(new DataColumn("name", typeof(System.String))); DataRow dr=null; dr = dt.NewRow(); dr["count"] = 100; dr["name"] = "あああ"; dt.Rows.Add(dr); dr = dt.NewRow(); dr["count"] = 200; dr["name"] = "いいい"; dt.Rows.Add(dr); dr = dt.NewRow(); dr["count"] = 300; dr["name"] = "ううう"; dt.Rows.Add(dr); // ここまでの変更をコミット dt.AcceptChanges(); this.dataGrid1.DataContext = dt; // ソースクラスをバインド this.DataContext = new SourceClass(); }
protected void btndelete2_Click(object sender, EventArgs e) { System.Data.DataTable dt = this.GetDataFromGrid2(); for (int i = 0; i < Repeater2.Items.Count; i++) { RepeaterItem rItem = Repeater2.Items[i]; System.Web.UI.WebControls.CheckBox chk = (System.Web.UI.WebControls.CheckBox)rItem.FindControl("cbchecked"); if (chk.Checked) { dt.Rows.RemoveAt(i - count); count++; } } for (int i = dt.Rows.Count; i < 6; i++) { DataRow newRow = dt.NewRow(); dt.Rows.Add(newRow); } dt.AcceptChanges(); this.Repeater2.DataSource = dt; this.Repeater2.DataBind(); //if (Request.QueryString["action"] == "addjl") //{ // bind_info(); //} //if (Request.QueryString["action"] == "modjl") //{ // bind_info2(); //} }
void FormTVP(ref DataTable Dt) { DataColumn Floor_Id = Dt.Columns.Add("Floor_Id", typeof(Int32)); DataColumn Floor_Name = Dt.Columns.Add("Floor_Name", typeof(String)); DataColumn Floor_Code = Dt.Columns.Add("Floor_Code", typeof(String)); Dt.AcceptChanges(); }
public static DataTable CreateTicketDt() { DataTable dt = new DataTable(); dt.Columns.Add("TrainCode"); dt.Columns.Add("TrainCodeKey"); dt.Columns.Add("StartStation"); dt.Columns.Add("AimStation"); dt.Columns.Add("TakeTime"); dt.Columns.Add("ShangWu"); dt.Columns.Add("TeDeng"); dt.Columns.Add("YiDeng"); dt.Columns.Add("ErDeng"); dt.Columns.Add("GaoJiRuanWo"); dt.Columns.Add("RuanWo"); dt.Columns.Add("YingWo"); dt.Columns.Add("RuanZuo"); dt.Columns.Add("YingZuo"); dt.Columns.Add("WuZuo"); dt.Columns.Add("QiTa"); dt.Columns.Add("OrderKey"); dt.Columns.Add("CanOrder"); dt.Columns.Add("Order", typeof(Image)); dt.Columns.Add("First"); dt.Columns.Add("Last"); dt.AcceptChanges(); return dt; }
void MgfLoad() { try { conn.Open(); // string sqlquery = "SELECT MED_ID,MED_NAME,MED_STG,MED_MGF,MED_BATCH,MED_GROUP,MED_TYPE,COST_PRICE,SELL_PRICE,NOTES FROM MED_INFO"; string sqlquery = "SELECT * FROM MFG_INFO"; OracleCommand cmd = new OracleCommand(sqlquery, conn); OracleDataAdapter oda = new OracleDataAdapter(); oda.SelectCommand = cmd; dt = new DataTable(); // dt.Columns["MED_NAME"].ColumnName = "Name"; oda.Fill(dt); BindingSource bsource = new BindingSource(); bsource.DataSource = dt; dataGridView1.DataSource = bsource; oda.Update(dt); dt.Columns[0].ColumnName = "ID"; dt.Columns[1].ColumnName = "Name"; dt.Columns[2].ColumnName = "Address"; dt.Columns[3].ColumnName = "Mobile"; dt.AcceptChanges(); conn.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// Calculates and sorts the places/probs of the AE vs. VQ data /// </summary> /// <param name="dt"></param> /// <param name="sortName"></param> /// <param name="fieldName"></param> /// <param name="bRecalc"></param> private static void CalculatePlacementForDiffReport ( System.Data.DataTable dt, string sortName, string fieldName, bool bRecalc = false ) { dt.AcceptChanges(); DataView dv = new DataView(dt, null, sortName, DataViewRowState.CurrentRows); for (int row = 0; row < dv.Count; row++) { dv[row][fieldName] = row + 1; if (bRecalc) { double diff = (double)(dv[row]["prbVQ"]) - (double)(dv[row]["prbAE"]); dv[row]["prbDiA"] = Math.Abs(diff); dv[row]["prbDiD"] = diff; int pdiff = (int)(dv[row]["plVQ"]) - (int)(dv[row]["plAE"]); dv[row]["plDiA"] = (int)(Math.Abs(pdiff)); dv[row]["plDiI"] = pdiff; } } }
protected override DataTable ProcessResult(DataTable schema) { schema.BeginLoadData(); foreach (DataRow row in schema.Rows) { // ToBoolean foreach (DataColumn col in schema.Columns) if (col.Caption.StartsWith("IS_")) row[col.Caption] = row[col.Caption] != DBNull.Value && Convert.ToInt32(row[col.Caption], CultureInfo.InvariantCulture) != 0; if (Convert.ToInt32(row["HELPER_CID"], CultureInfo.InvariantCulture) != 0) row["SOURCE"] = HelperGetObjectDefinition(Convert.ToInt32(row["HELPER_CID"], CultureInfo.InvariantCulture)); } schema.EndLoadData(); schema.AcceptChanges(); schema.Columns.Remove("HELPER_CID"); return schema; }
public void DSMauC79_80a_HD()//cấu trúc chung mẫu c80a-HD; c79a-HD { dtChungC79_80_a_HD = new System.Data.DataTable(); dtChungC79_80_a_HD.Columns.Add("stt", typeof(string)); // dtChungC79_80_a_HD.Columns.Add("tennhom", typeof(string)); dtChungC79_80_a_HD.Columns.Add("dt_stt", typeof(string)); dtChungC79_80_a_HD.Columns.Add("dt_bv", typeof(string)); dtChungC79_80_a_HD.Columns.Add("dt_ngay", typeof(string)); dtChungC79_80_a_HD.Columns.Add("dt_nhom", typeof(string)); dtChungC79_80_a_HD.Columns.Add("masobyt", typeof(string)); dtChungC79_80_a_HD.Columns.Add("tenhc", typeof(string)); dtChungC79_80_a_HD.Columns.Add("tenvp", typeof(string)); dtChungC79_80_a_HD.Columns.Add("duongdung", typeof(string)); dtChungC79_80_a_HD.Columns.Add("dangbaoche", typeof(string)); dtChungC79_80_a_HD.Columns.Add("hamluong", typeof(string)); dtChungC79_80_a_HD.Columns.Add("dangtrinhbay", typeof(string)); dtChungC79_80_a_HD.Columns.Add("tenhang", typeof(string)); dtChungC79_80_a_HD.Columns.Add("tennuoc", typeof(string)); dtChungC79_80_a_HD.Columns.Add("sogiayphep", typeof(string)); dtChungC79_80_a_HD.Columns.Add("donvi", typeof(string)); dtChungC79_80_a_HD.Columns.Add("giamua", typeof(decimal)).DefaultValue = 0; dtChungC79_80_a_HD.Columns.Add("giattbh", typeof(decimal)).DefaultValue = 0; dtChungC79_80_a_HD.Columns.Add("slngoaitru", typeof(decimal)).DefaultValue = 0; dtChungC79_80_a_HD.Columns.Add("slnoitru", typeof(decimal)).DefaultValue = 0; dtChungC79_80_a_HD.Columns.Add("thanhtien", typeof(decimal)).DefaultValue = 0; dtChungC79_80_a_HD.Columns.Add("ghichu", typeof(string)); dtChungC79_80_a_HD.AcceptChanges(); }
public static DataTable CreateChildDataTable() { DataTable dtChild = new DataTable("Child"); dtChild.Columns.Add("ParentId",typeof(int)); dtChild.Columns.Add("ChildId",typeof(int)); dtChild.Columns.Add("String1",typeof(string)); dtChild.Columns.Add("String2",typeof(string)); dtChild.Columns.Add("ChildDateTime",typeof(DateTime)); dtChild.Columns.Add("ChildDouble",typeof(double)); dtChild.Rows.Add(new object[] {1,1,"1-String1","1-String2",new DateTime(2000,1,1,0,0,0,0),1.534}); dtChild.Rows.Add(new object[] {1,2,"2-String1","2-String2",DateTime.MaxValue ,-1.534}); dtChild.Rows.Add(new object[] {1,3,"3-String1","3-String2",DateTime.MinValue,double.MaxValue/10000}); dtChild.Rows.Add(new object[] {2,1,"1-String1","1-String2",new DateTime(1973,6,20,0,0,0,0),double.MinValue*10000}); dtChild.Rows.Add(new object[] {2,2,"2-String1","2-String2",new DateTime(2008,12,1,13,59,59,59),0.45}); dtChild.Rows.Add(new object[] {2,3,"3-String1","3-String2",new DateTime(2003,1,1,1,1,1,1),0.55}); dtChild.Rows.Add(new object[] {5,1,"1-String1","1-String2",new DateTime(2002,1,1,1,1,1,1),0}); dtChild.Rows.Add(new object[] {5,2,"2-String1","2-String2",new DateTime(2001,1,1,1,1,1,1),10}); dtChild.Rows.Add(new object[] {5,3,"3-String1","3-String2",new DateTime(2000,1,1,1,1,1,1),20}); dtChild.Rows.Add(new object[] {6,1,"1-String1","1-String2",new DateTime(2000,1,1,1,1,1,0),25}); dtChild.Rows.Add(new object[] {6,2,"2-String1","2-String2",new DateTime(2000,1,1,1,1,0,0),30}); dtChild.Rows.Add(new object[] {6,3,"3-String1","3-String2",new DateTime(2000,1,1,0,0,0,0),35}); dtChild.AcceptChanges(); return dtChild; }
public DataSet SensitiveData() { DataSet data = new DataSet(); //Do our authentication //this can be via a database or whatever if(Authentication.Username == "test" && Authentication.Password == "test") { //they are allowed access to our sensitive data //just create some dummy data DataTable dtTable1 = new DataTable(); DataColumn drCol1 = new DataColumn("Data", System.Type.GetType("System.String")); dtTable1.Columns.Add(drCol1); DataRow drRow = dtTable1.NewRow(); drRow["Data"] = "Sensitive Data"; dtTable1.Rows.Add(drRow); dtTable1.AcceptChanges(); data.Tables.Add(dtTable1); } else { data = null; } return data; }
//Activate This Construntor to log All To Standard output //public TestClass():base(true){} //Activate this constructor to log Failures to a log file //public TestClass(System.IO.TextWriter tw):base(tw, false){} //Activate this constructor to log All to a log file //public TestClass(System.IO.TextWriter tw):base(tw, true){} //BY DEFAULT LOGGING IS DONE TO THE STANDARD OUTPUT ONLY FOR FAILURES public void run() { Exception exp = null; DataTable myTable = new DataTable("myTable"); DataColumn dc = new DataColumn("Id",typeof(int)); dc.Unique=true; myTable.Columns.Add(dc); myTable.Rows.Add(new object[] {1}); myTable.Rows.Add(new object[] {2}); myTable.Rows.Add(new object[] {3}); myTable.AcceptChanges(); DataRow myRow = myTable.Rows[0]; myRow.Delete(); try { BeginCase("Delete1"); Compare( myRow.RowState , DataRowState.Deleted ); } catch(Exception ex) {exp = ex;} finally {EndCase(exp); exp = null;} try { BeginCase("Delete2"); myTable.AcceptChanges(); Compare( myRow.RowState , DataRowState.Detached ); } catch(Exception ex) {exp = ex;} finally {EndCase(exp); exp = null;} }
private DataTable BuildDataTableDefinition(TableDescriptor table) { var dataTable = new DataTable(); foreach (var col in table.Columns) { dataTable.Columns.Add(new DataColumn(col.Name.GetName())); } dataTable.AcceptChanges(); dataTable.RowChanged += (sender, args) => { dataTable.ExtendedProperties["Changed"] = true; }; dataTable.TableNewRow += (sender, args) => { dataTable.ExtendedProperties["Changed"] = true; }; dataTable.RowDeleting += (sender, args) => { dataTable.ExtendedProperties["Changed"] = true; }; return dataTable; }
private void AutoFixBCOrder_Load(object sender, EventArgs e) { try { #region 20161129 - BotJava - Auto Import SourceTana _dtbSourceTana = Common.GetDataTable("C:\\Users\\HonC\\Desktop\\FixBCOrder\\SourceTana.xls"); for (int i = _dtbSourceTana.Columns.Count - 1; i >= 0; i--) { if (!string.IsNullOrEmpty(_dtbSourceTana.Rows[0][i].ToString())) { _dtbSourceTana.Columns[i].ColumnName = _dtbSourceTana.Rows[0][i].ToString(); } } _dtbSourceTana.Rows[0].Delete(); _dtbSourceTana.AcceptChanges(); // dtgSourceTana.DataSource = _dtbSourceTana; #endregion } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
public static System.Data.DataTable RecordListToDataTable(List <Record> list) { try { System.Data.DataTable MethodResult = null; System.Data.DataTable dt = new System.Data.DataTable(); dt.Columns.Add("ID"); //Add your additional column fields here foreach (Record sr in list) { DataRow dr = dt.NewRow(); dr[0] = sr.ID; //Add the extra rows to the table here dt.Rows.Add(dr); } dt.AcceptChanges(); MethodResult = dt; return(MethodResult); } catch (Exception ex) { Console.WriteLine(ex); throw; } }
private void btnImportShukko_Click(object sender, EventArgs e) { try { OpenFileDialog _of = new OpenFileDialog(); _of.Filter = "All Files (*.*)|*.*"; _of.FilterIndex = 1; _of.Multiselect = false; if (_of.ShowDialog() == DialogResult.OK) { _dtbShukko = Common.GetDataTable(_of.FileName); #region 20161201 - BotJava - Fix Format Excel -> change column name for (int i = 0; i < _dtbShukko.Columns.Count; i++) { _dtbShukko.Columns[i].ColumnName = _dtbShukko.Rows[0][i].ToString(); } _dtbShukko.Rows[0].Delete(); _dtbShukko.AcceptChanges(); #endregion dtgShukko.DataSource = _dtbShukko; } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void button1_Click(object sender, EventArgs e) { OpenFileDialog _of = new OpenFileDialog(); System.Data.DataTable _dtbTanaSource = new System.Data.DataTable(); _of.Filter = "All Files (*.*)|*.*"; _of.FilterIndex = 1; _of.Multiselect = false; if (_of.ShowDialog() == DialogResult.OK) { _dtbTanaSource = Common.GetDataTable(_of.FileName); #region 20161201 - BotJava - Fix Format Excel -> change column name for (int i = 0; i < _dtbTanaSource.Columns.Count - 1; i++) { _dtbTanaSource.Columns[i].ColumnName = _dtbTanaSource.Rows[0][i].ToString(); } _dtbTanaSource.Rows[0].Delete(); _dtbTanaSource.AcceptChanges(); #endregion dtgShukko.DataSource = _dtbTanaSource; } }
public MainWindow() : base(Gtk.WindowType.Toplevel) { Build(); System.Console.WriteLine(DatabaseProvider.IsValidType(typeof(DbObservableList))); ob_list.ElementAdded += HandleElementAdded; ob_list.ElementChanged += HandleElementChanged; ob_list.ElementRemoved += HandleElementRemoved; ob_list.ElementsSorted += HandleElementsSorted; //should come to this table.Columns.Add("ID", typeof(int)); table.Columns.Add("Title", typeof(string)); table.Rows.Add(new object[] { 1, "Title 1" }); table.Rows.Add(new object[] { 2, "Title 2" }); table.Rows[0][0] = 66; table.AcceptChanges(); // table.Rows[0].Delete(); // System.Console.WriteLine(table.Rows.Count); // table.Rows.RemoveAt(1); //you'll notice that Removed event //for this one gets fired before the Removed event //of element 0 (because it auto-commits it) // table.AcceptChanges(); datatreeview1.ItemsDataSource = table; // datatreeview1.ItemsDataSource = ob_list; datacombobox1.ItemsDataSource = ob_list; datacomboboxentry1.ItemsDataSource = ob_list; }
private void DemonstrateDtaView() { DataTable table = new DataTable("table"); DataColumn colItem = new DataColumn("item", Type.GetType("System.String")); table.Columns.Add(colItem); DataRow NewRow; for (int i = 0; i < 5; ++i) { NewRow = table.NewRow(); NewRow["item"] = "Item" + i; table.Rows.Add(NewRow); } table.Rows[0]["item"] = "cat"; table.Rows[1][0] = "dog"; // Commits all the changes made to this table since the last time AcceptChanges was called. // The DataRowState also changes: all Added and Modified rows become Unchanged, // and Deleted rows are removed. table.AcceptChanges(); DataView firstView = new DataView(table); DataView secondView = new DataView(table); PrintTableOrView(table, "Current Value in Table"); firstView.RowStateFilter = DataViewRowState.ModifiedOriginal; PrintTableOrView(firstView, "First DataView: Modifiedoriginal"); DataRowView rowView; rowView = secondView.AddNew(); rowView["item"] = "fish"; secondView.RowStateFilter = DataViewRowState.ModifiedCurrent | DataViewRowState.Added; PrintTableOrView(secondView, "Second DataVies: ModifiedCurent | Added"); }
DataSet create_dataset() { string d_tu = "", d_den = ""; d_tu = tu.Value.ToString().PadLeft(2, '0') + yy.Value.ToString().PadLeft(4, '0').Substring(2); d_den = den.Value.ToString().PadLeft(2, '0') + yyyy.Value.ToString().PadLeft(4, '0').Substring(2); DataSet tmp = new DataSet(); System.Data.DataTable dttmp = new System.Data.DataTable(); dttmp.Columns.Add("stt", typeof(int)); dttmp.Columns.Add("mabd", typeof(decimal)); dttmp.Columns.Add("ma", typeof(string)); dttmp.Columns.Add("ten", typeof(string)); dttmp.Columns.Add("dang", typeof(string)); dttmp.Columns.Add(d_tu, typeof(string)); if (d_den != d_tu) { dttmp.Columns.Add(d_den, typeof(string)); dttmp.Columns.Add("chenhlech", typeof(string)); } dttmp.AcceptChanges(); tmp.Tables.Add(dttmp); tmp.AcceptChanges(); return(tmp); }
public DataTable ToDataTable(INetwork network) { if (network == null) throw new ArgumentNullException("network", "The input network must not be null."); if (!(network is IEdgeAttributes)) throw new ArgumentException(string.Format("The input network must implement {0}.", typeof(IEdgeAttributes).Name), "network"); IEdgeAttributes src = network as IEdgeAttributes; DataTable table = new DataTable("Edge data"); AttributeListMgr mgr = src.EdgeAttributeMgr as AttributeListMgr; if (mgr == null) throw new ArgumentException("The EdgeAttributeMgr of the input network must not be null.", "network"); string[] colNames = EnsureUniqueColNames(mgr); int ctr = 0; foreach (IAttributeList list in mgr.Lists) { table.Columns.Add(new DataColumn(colNames[ctr++], list.DataType)); } if (table.Columns.Count>0) for (int i = 0; i < mgr.Depth; i++) { table.Rows.Add(mgr.GetRow(i)); } table.AcceptChanges(); return table; }
/// <summary> /// 保存后重新加载页面 /// </summary> /// <returns></returns> protected System.Data.DataTable AfterSavedReload() { System.Data.DataTable dt = new System.Data.DataTable(); #region dt.Columns.Add("BM_TUHAO"); //图号0 dt.Columns.Add("BM_MARID"); //物料编码1 dt.Columns.Add("BM_ZONGXU"); //总序2 dt.Columns.Add("BM_CHANAME"); //中文名称3 dt.Columns.Add("BM_NOTE"); //备注4 dt.Columns.Add("BM_MALENGTH"); //材料长度5 dt.Columns.Add("BM_MAWIDTH"); //材料宽度6 dt.Columns.Add("BM_NUMBER"); //数量7 dt.Columns.Add("BM_UNITWGHT"); //单重8 dt.Columns.Add("BM_MAUNITWGHT"); //材料单重9 dt.Columns.Add("BM_MATOTALWGHT"); //材料总重10 dt.Columns.Add("BM_MABGZMY"); //面域(m2)11 dt.Columns.Add("BM_BEIZHUATR"); dt.Columns.Add("BM_TUUNITWGHT"); //图纸上单重12 dt.Columns.Add("BM_TUMAQLTY"); //图纸上材质13 dt.Columns.Add("BM_TUSTAD"); //图纸上标准13 dt.Columns.Add("BM_TUPROBLEM"); //图纸上问题15 dt.Columns.Add("BM_MAQUALITY"); //材质16 dt.Columns.Add("BM_GUIGE"); //规格17 dt.Columns.Add("BM_MANAME"); //材料名称18 dt.Columns.Add("BM_MAGUIGE"); //材料规格19 dt.Columns.Add("BM_THRYWGHT"); //理论重量20 dt.Columns.Add("BM_TOTALWGHT"); //总重21 dt.Columns.Add("BM_MATOTALLGTH"); //材料总长22 dt.Columns.Add("BM_MAUNIT"); //单位23 dt.Columns.Add("BM_STANDARD"); //国标24 dt.Columns.Add("BM_MASHAPE"); //毛坯25 dt.Columns.Add("BM_MASTATE"); //状态26 dt.Columns.Add("BM_PROCESS"); //工艺流程27 dt.Columns.Add("BM_ENGSHNAME"); //英文名称28 dt.Columns.Add("BM_KEYCOMS"); //关键部件29 dt.Columns.Add("BM_FIXEDSIZE"); //是否定尺30 dt.Columns.Add("BM_WMARPLAN"); //是否提材料计划 dt.Columns.Add("BM_KU"); //库 dt.Columns.Add("BM_TOTALNUMBER"); //34 dt.Columns.Add("BM_PNUMBER"); //计划数量 dt.Columns.Add("BM_MPMY"); //计划面域 dt.Columns.Add("BM_MSXUHAO"); //明细序号 dt.Columns.Add("BM_XUHAO"); //序号 dt.Columns.Add("BM_ISMANU"); dt.Columns.Add("BM_PARTOWNWGHT"); #endregion for (int i = 0; i < 15; i++) { DataRow newRow = dt.NewRow(); newRow[30] = "N"; newRow[31] = "N"; newRow[32] = "Y"; newRow[39] = "Y"; dt.Rows.Add(newRow); } dt.AcceptChanges(); return(dt); }
private void DataGridViewShow() { string sqltxt = "select * from sys_meta_info where tablename = '" + tablename_comboBox.Text + "'"; m_adp = new SqlDataAdapter(sqltxt, m_conn); System.Data.DataSet DS = new System.Data.DataSet(); m_adp.Fill(DS); m_dic_meta_info_Table = DS.Tables[0]; if (m_dic_meta_info_Table.Rows.Count == 0) { if (DialogResult.Yes == MessageBox.Show("没有任何关于" + tablename_comboBox.Text + "表的相关数据!是否要自动添加所有记录", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Asterisk, MessageBoxDefaultButton.Button1)) { for (int index = 0; index < fieldname_comboBox.Items.Count; index++) { System.Data.DataRow dataRow; dataRow = m_dic_meta_info_Table.NewRow(); dataRow.BeginEdit(); dataRow["tablename"] = (tablename_comboBox.Text.Trim() == "" ? null : tablename_comboBox.Text.Trim()); dataRow["fieldname"] = fieldname_comboBox.Items[index].ToString().Trim(); dataRow["fieldcnname"] = null; dataRow["editortype"] = "text"; dataRow["catname"] = null; dataRow["orderno"] = "0"; dataRow["description"] = null; dataRow["listtable"] = null; dataRow["listcondition"] = null; dataRow["keyfield"] = null; dataRow["listfield"] = null; dataRow["listvalues"] = null; dataRow["visible"] = 1; dataRow["readonly"] = 0; m_dic_meta_info_Table.Rows.Add(dataRow); dataRow.EndEdit(); } try { //使用SqlCommandBuilder 对像填充SqlDataAdapter 的InsertCommand、DeleteCommand、UpdateCommand对像 SqlCommandBuilder cmdBuilder = new SqlCommandBuilder(m_adp); m_adp.UpdateCommand = cmdBuilder.GetUpdateCommand(); int val = m_adp.Update(m_dic_meta_info_Table); m_dic_meta_info_Table.AcceptChanges(); } catch (Exception ex) { // m_dic_meta_info_Table.Rows[m_dic_meta_info_Table.Rows.Count - 1].Delete(); MessageBox.Show(ex.Message); } } } //DataColumn[] primarKey = new DataColumn[1]; //primarKey[0] = m_dic_meta_info_Table.Columns["fieldname"]; //m_dic_meta_info_Table.PrimaryKey = primarKey; dataGridView1.DataSource = m_dic_meta_info_Table; }
private void add_button_Click(object sender, EventArgs e) { // int editortypeID = editortype_comboBox.SelectedIndex; System.Data.DataRow dataRow; dataRow = m_dic_meta_info_Table.NewRow(); dataRow.BeginEdit(); dataRow["tablename"] = (tablename_comboBox.Text.Trim() == "" ? null : tablename_comboBox.Text.Trim()); dataRow["fieldname"] = fieldname_comboBox.Text.Trim(); dataRow["fieldcnname"] = fieldcnnametxt.Text.Trim() == "" ? null : fieldcnnametxt.Text.Trim(); dataRow["editortype"] = EditorTypeEn[editortype_comboBox.SelectedIndex]; dataRow["catname"] = catname_comboBox.Text.Trim() == "" ? null : catname_comboBox.Text.Trim(); dataRow["orderno"] = "0"; dataRow["description"] = descriptiontxt.Text.Trim() == "" ? null : descriptiontxt.Text.Trim(); dataRow["listtable"] = listtable_comboBox.Text.Trim() == "" ? null : listtable_comboBox.Text.Trim(); dataRow["listcondition"] = listconditiontxt.Text.Trim() == "" ? null : listconditiontxt.Text.Trim(); dataRow["keyfield"] = keyfield_comboBox.Text.Trim() == "" ? null : keyfield_comboBox.Text.Trim(); dataRow["listfield"] = listfield_comboBox.Text.Trim() == "" ? null : listfield_comboBox.Text.Trim(); dataRow["listvalues"] = txtBoxListValues.Text.Trim(); dataRow["relativepath"] = txtBoxRelativePath.Text.Trim(); dataRow["visible"] = visible_checkBox.Checked ? 1 : 0; dataRow["readonly"] = readonly_checkBox.Checked ? 1 : 0; m_dic_meta_info_Table.Rows.Add(dataRow); dataRow.EndEdit(); try { SqlDataAdapter adapter = m_adp; ////使用SqlCommandBuilder 对像填充SqlDataAdapter 的InsertCommand、DeleteCommand、UpdateCommand对像 SqlCommandBuilder cmdBuilder = new SqlCommandBuilder(adapter); adapter.InsertCommand = cmdBuilder.GetInsertCommand(); int val = adapter.Update(m_dic_meta_info_Table); m_dic_meta_info_Table.AcceptChanges(); this.dataGridView1.CurrentCell = this.dataGridView1.Rows[0].Cells[0]; // 更新类别名下拉框 FillCatNames(this.tablename_comboBox.Text); } catch (Exception ex) { m_dic_meta_info_Table.Rows[m_dic_meta_info_Table.Rows.Count - 1].Delete(); MessageBox.Show(ex.Message); } }
public System.Data.DataTable BuhinAutoFixExcelFileCSVConvertXLS(System.Data.DataTable _dtbSource) { #region 20161214 - BotFJP - Delete columns not use for (int i = _dtbSource.Columns.Count - 1; i >= 0; i--) { if (new[] { 29, 31, 33 }.Contains(i)) { continue; } else { _dtbSource.Columns.RemoveAt(i); } } _dtbSource.Columns[0].ColumnName = "納期"; _dtbSource.Columns[2].ColumnName = "図面番号"; //部品=>組込番号 製品=>受注番号 _dtbSource.Columns[1].ColumnName = "組込番号"; _dtbSource.AcceptChanges(); #endregion #region 20161214 - BotFJP - Fix data 納期 //IF 納期 月 1,2 => Replace 年 = 年 + 1 foreach (DataRow _row in _dtbSource.Rows) { if (new string[] { "1", "2" }.Contains(_row["納期"].ToString().Split('/')[0])) { _row["納期"] = _row["納期"].ToString().Replace("2016", "2017"); } } _dtbSource.AcceptChanges(); #endregion #region 20161214 - BotFJP - Add column Status and 注文番号 DataColumn _newcol = new DataColumn("Status", typeof(string)); _newcol.DefaultValue = "True"; _dtbSource.Columns.Add(_newcol); _dtbSource.AcceptChanges(); #endregion return(_dtbSource); }