private void Load_catesearch() { var list = per.Load_danhmuc_search(1); if (list.Count > 0) { DataRelation relCat; DataTable tbl = DataUtil.LINQToDataTable(list); DataSet ds = new DataSet(); ds.Tables.Add(tbl); tbl.PrimaryKey = new DataColumn[] { tbl.Columns["CAT_ID"] }; relCat = new DataRelation("Category_parent", ds.Tables[0].Columns["CAT_ID"], ds.Tables[0].Columns["CAT_PARENT_ID"], false); ds.Relations.Add(relCat); DataSet dsCat = ds.Clone(); DataTable CatTable = ds.Tables[0]; DataUtil.TransformTableWithSpace(ref CatTable, dsCat.Tables[0], relCat, null); Drcate_search.DataSource = dsCat.Tables[0]; Drcate_search.DataTextField = "CAT_NAME"; Drcate_search.DataValueField = "CAT_ID"; Drcate_search.DataBind(); } ListItem l = new ListItem("Tất cả", "0"); l.Selected = true; Drcate_search.Items.Insert(0, l); }
public void Loadchuyenmuc() { try { var CatList = ( from t2 in DB.ESHOP_CATEGORies where t2.CAT_RANK > 0 select new { CAT_ID = t2.CAT_NAME == "------- Root -------" ? 0 : t2.CAT_ID, CAT_NAME = (string.IsNullOrEmpty(t2.CAT_CODE) ? t2.CAT_NAME : t2.CAT_NAME + "(" + t2.CAT_CODE + ")"), CAT_NAME_EN = (string.IsNullOrEmpty(t2.CAT_CODE_EN) ? t2.CAT_NAME_EN : t2.CAT_NAME_EN + "(" + t2.CAT_CODE_EN + ")"), CAT_PARENT_ID = t2.CAT_PARENT_ID, CAT_RANK = t2.CAT_RANK } ); if (CatList.ToList().Count > 0) { DataRelation relCat; DataTable tbl = DataUtil.LINQToDataTable(CatList); DataSet ds = new DataSet(); ds.Tables.Add(tbl); tbl.PrimaryKey = new DataColumn[] { tbl.Columns["CAT_ID"] }; relCat = new DataRelation("Category_parent", ds.Tables[0].Columns["CAT_ID"], ds.Tables[0].Columns["CAT_PARENT_ID"], false); ds.Relations.Add(relCat); DataSet dsCat = ds.Clone(); DataTable CatTable = ds.Tables[0]; DataUtil.TransformTableWithSpace(ref CatTable, dsCat.Tables[0], relCat, null); ddlCategory.DataSource = dsCat.Tables[0]; ddlCategory.DataTextField = "CAT_NAME"; ddlCategory.DataValueField = "CAT_ID"; ddlCategory.DataBind(); } ListItem l = new ListItem("------ Chọn chuyên mục ------", "0", true); l.Selected = true; ddlCategory.Items.Insert(0, l); } catch (Exception ex) { clsVproErrorHandler.HandlerError(ex); } }
/// <summary> /// Reduces the DataSet "set" removing the strongly-typed DataTables from the input Type array /// </summary> /// <param name="set"> Data set to reduce</param> /// <param name="DataTableTypes"> /// input Type array of strongly-typed DataTables to remove from set /// </param> public static void Preserve(System.Data.DataSet set, Type[] DataTableTypes) { System.Data.DataSet Set = set.Clone(); bool orgConst = set.EnforceConstraints; Set.EnforceConstraints = false; foreach (System.Data.DataTable table in Set.Tables) { System.Data.DataTable toremove = null; HashSet <Type> hs = new HashSet <Type>(DataTableTypes.ToArray()); Type t = table.GetType(); if (!hs.Contains(t)) { toremove = set.Tables[table.TableName, table.Namespace]; } if (toremove != null) { toremove.ChildRelations.Clear(); toremove.ParentRelations.Clear(); foreach (System.Data.Constraint constraint in table.Constraints) { if (constraint.GetType().Equals(typeof(System.Data.ForeignKeyConstraint))) { toremove.Constraints.Remove(constraint.ConstraintName); } } toremove.TableName += "..."; } } foreach (System.Data.DataTable table in Set.Tables) { System.Data.DataTable toremove = set.Tables[table.TableName + "...", table.Namespace]; if (toremove != null) { toremove.Dispose(); set.Tables.Remove(toremove); } } Set.EnforceConstraints = orgConst; }
void IContentEditor.ResetAll() { workSheetDataGrid.DataMember = null; workSheetDataGrid.DataSource = null; workSheetDataSet.Dispose(); workSheetDataSet = workSheetDataSetTemplate.Clone(); try { workSheetDataGrid.SetDataBinding(workSheetDataSet, "Worksheet1"); } catch {} //DataGrid has error while setting databinding in event: "'0' is not a valid value for 'value'. 'value' should be between 'minimum' and 'maximum'" m_currentNoteCaption = ""; m_currentNoteID = ""; }
public static DataSet GetNhatKyTheoNgay(PLMultiCombobox NV_ID, DateTime TuNgay, DateTime DenNgay) { DataSet ds = new DataSet(); DatabaseFB db = HelpDB.getDatabase(); DbCommand cmd = db.GetStoredProcCommand("IN_NHAT_KY_CONG_VIEC"); db.AddInParameter(cmd, "@TUNGAY", DbType.DateTime, TuNgay); db.AddInParameter(cmd, "@DENNGAY", DbType.DateTime, DenNgay); db.LoadDataSet(cmd, ds, "IN_NHAT_KY_CONG_VIEC"); #region Lọc lại dữ liệu trên DataSet DataRow[] dsrow = ds.Tables[0].Select("NV_ID in " + NV_ID._getStrSelectedIDs()); DataSet NewDs = ds.Clone(); foreach (DataRow item in dsrow) NewDs.Tables[0].ImportRow(item); #endregion return NewDs; }
private void LoadCat() { try { var AllList = (from g in db.TYPE_COMPANies where g.TYPE_RANK > 0 select new { g.TYPE_ID, g.TYPE_PARENT, g.TYPE_RANK, g.TYPE_ACTIVE, g.ORDERBY, g.TYPE_NAME }); if (AllList.ToList().Count > 0) { DataRelation relCat; Session["companies.listmenucha"] = DataUtil.LINQToDataTable(AllList); DataTable tbl = Session["companies.listmenucha"] as DataTable; DataSet ds = new DataSet(); ds.Tables.Add(tbl); tbl.PrimaryKey = new DataColumn[] { tbl.Columns["TYPE_ID"] }; relCat = new DataRelation("TYPE_PARENT", ds.Tables[0].Columns["TYPE_ID"], ds.Tables[0].Columns["TYPE_PARENT"], false); ds.Relations.Add(relCat); DataSet dsCat = ds.Clone(); DataTable CatTable = ds.Tables[0]; unit_data.TransformTableWithSpace(ref CatTable, dsCat.Tables[0], relCat, null); HttpContext.Current.Session["companies.listmenucha"] = dsCat.Tables[0]; ASPxTreeList_menu.DataSource = dsCat.Tables[0]; ASPxTreeList_menu.DataBind(); } } catch (Exception ex) { clsVproErrorHandler.HandlerError(ex); } }
public static DataSet GetThoiGianLamViec(PLMultiCombobox NV_ID, bool LoaiLV, bool LoaiDTVS, bool LoaiNP, DateTime TuNgay, DateTime DenNgay) { DataSet ds = new DataSet(); DatabaseFB db = HelpDB.getDatabase(); DbCommand cmd = db.GetStoredProcCommand("IN_THOI_GIAN_LAM_VIEC"); db.AddInParameter(cmd, "@ILOAILV", DbType.Byte, LoaiLV == true ? 1 : 0); db.AddInParameter(cmd, "@ILOAIDTVS", DbType.Byte, LoaiDTVS == true ? 2 : 0); db.AddInParameter(cmd, "@ILOAINP", DbType.Byte, LoaiNP == true ? 3 : 0); db.AddInParameter(cmd, "@TUNGAY", DbType.DateTime, TuNgay); db.AddInParameter(cmd, "@DENNGAY", DbType.DateTime, DenNgay); db.LoadDataSet(cmd, ds, "IN_THOI_GIAN_LAM_VIEC"); #region Lọc lại dữ liệu trên DataSet DataRow[] dsrow = ds.Tables[0].Select("NV_ID in " + NV_ID._getStrSelectedIDs()); DataSet NewDs = ds.Clone(); foreach (DataRow item in dsrow) NewDs.Tables[0].ImportRow(item); #endregion return NewDs; }
private void SearchResult() { try { string keyword = txtKeyword.Value; int _limit = 20; int _skip = 0; if (_page != 0) _skip = _page * _limit - _limit; var AllList = (from g in DB.MENUs where "" == keyword || g.MENU_NAME.Contains(keyword) orderby g.ID descending select g); if (AllList.ToList().Count > 0) { DataRelation relCat; DataTable tbl = DataUtil.LINQToDataTable(AllList); DataSet ds = new DataSet(); ds.Tables.Add(tbl); tbl.PrimaryKey = new DataColumn[] { tbl.Columns["ID"] }; relCat = new DataRelation("Category_parent", ds.Tables[0].Columns["ID"], ds.Tables[0].Columns["MENU_PARENT_ID"], false); ds.Relations.Add(relCat); DataSet dsCat = ds.Clone(); DataTable CatTable = ds.Tables[0]; CpanelUtils.TransformTableWithSpace2(ref CatTable, dsCat.Tables[0], relCat, null); RplistMenu.DataSource = dsCat.Tables[0]; RplistMenu.DataBind(); //LitPage.Text = pagechange.changePage("customer_list.aspx", AllList.ToList().Count, _limit, _page); } } catch (Exception ex) { clsVproErrorHandler.HandlerError(ex); } }
private void LoadMenu() { try { var AllList = DB.MENUs.Where(n => n.MENU_ACTIVE == 1); if (AllList.ToList().Count > 0) { DataRelation relCat; DataTable tbl = DataUtil.LINQToDataTable(AllList); DataSet ds = new DataSet(); ds.Tables.Add(tbl); tbl.PrimaryKey = new DataColumn[] { tbl.Columns["ID"] }; relCat = new DataRelation("Category_parent", ds.Tables[0].Columns["ID"], ds.Tables[0].Columns["MENU_PARENT_ID"], false); ds.Relations.Add(relCat); DataSet dsCat = ds.Clone(); DataTable CatTable = ds.Tables[0]; CpanelUtils.TransformTableWithSpace2(ref CatTable, dsCat.Tables[0], relCat, null); Drchuyenmuc.DataValueField = "ID"; Drchuyenmuc.DataTextField = "MENU_NAME"; Drchuyenmuc.DataSource = dsCat.Tables[0]; Drchuyenmuc.DataBind(); } ListItem l = new ListItem("------- Root -------", "0"); l.Selected = true; Drchuyenmuc.Items.Insert(0, l); } catch (Exception ex) { clsVproErrorHandler.HandlerError(ex); } }
private DataSet resolveSplits(DataSet thisDS) { DataTable allocation = thisDS.Tables["Allocation"]; DataTable split = thisDS.Tables["Split"]; DataSet newAllocation = thisDS.Clone(); newAllocation.Relations.Clear(); newAllocation.EnforceConstraints = false; //newAllocation.Tables["Allocation"].PrimaryKey = null; //newAllocation.Tables["Split"].PrimaryKey = null; //newAllocation.Tables["Allocation"].Constraints.Clear(); //newAllocation.Tables["Split"].Constraints.Clear(); var query1 = from DataRow o in allocation.Rows where o["Company"].ToString() != "Split" select new { ChargeID = o["ChargeID"], Cardholder_Name = o["Cardholder Name"], Process_Date = o["Process Date"], Merchant_Name_Location = o["Merchant Name/Location"], Amount = o["Amount"], Company = o["Company"], Account = o["Account"], Description = o["Description"] }; //TODO: Clean this up? Use OO? foreach (var row in query1) { DataRow dr = newAllocation.Tables["Allocation"].NewRow(); dr["ChargeID"] = row.ChargeID; dr["Cardholder Name"] = row.Cardholder_Name; dr["Process Date"] = row.Process_Date; dr["Merchant Name/Location"] = row.Merchant_Name_Location; dr["Amount"] = row.Amount; dr["Company"] = row.Company; dr["Account"] = row.Account; dr["Description"] = row.Description; newAllocation.Tables["Allocation"].Rows.Add(dr); } var query = from DataRow o in allocation.Rows where o["Company"].ToString() == "Split" join DataRow ol in split.Rows on o["ChargeID"] equals ol["ChargeID"] //where ol["Company"].ToString() == company select new { ChargeID = o["ChargeID"], Cardholder_Name = o["Cardholder Name"], Process_Date = o["Process Date"], Merchant_Name_Location = o["Merchant Name/Location"], Company = ol["Company"], Account = ol["Account"], Amount = ol["Amount"], Description = o["Description"] }; foreach (var row in query) { DataRow dr = newAllocation.Tables["Allocation"].NewRow(); dr["ChargeID"] = row.ChargeID; dr["Cardholder Name"] = row.Cardholder_Name; dr["Process Date"] = row.Process_Date; dr["Merchant Name/Location"] = row.Merchant_Name_Location; dr["Amount"] = row.Amount; dr["Company"] = row.Company; dr["Account"] = row.Account; dr["Description"] = row.Description; newAllocation.Tables["Allocation"].Rows.Add(dr); } return newAllocation; }
private void LoadTypeReg(int _id_prof) { try { //Kiểm tra type của prof int _type = Utils.CIntDef(ddlType.SelectedValue); var AllList = (from g in db.TYPE_COMPANies where g.TYPE_RANK > 0 && (g.TYPE_REG == null || g.TYPE_REG == _type) select new { g.TYPE_ID, g.TYPE_PARENT, g.TYPE_RANK, g.TYPE_NAME }); if (AllList.ToList().Count > 0) { DataRelation relCat; Session["companies.listmenucha"] = DataUtil.LINQToDataTable(AllList); DataTable tbl = Session["companies.listmenucha"] as DataTable; DataSet ds = new DataSet(); ds.Tables.Add(tbl); tbl.PrimaryKey = new DataColumn[] { tbl.Columns["TYPE_ID"] }; relCat = new DataRelation("TYPE_PARENT", ds.Tables[0].Columns["TYPE_ID"], ds.Tables[0].Columns["TYPE_PARENT"], false); ds.Relations.Add(relCat); DataSet dsCat = ds.Clone(); DataTable CatTable = ds.Tables[0]; unit_data.TransformTableWithSpace(ref CatTable, dsCat.Tables[0], relCat, null); HttpContext.Current.Session["companies.listmenucha"] = dsCat.Tables[0]; ASPxTreeList_menu.DataSource = dsCat.Tables[0]; ASPxTreeList_menu.DataBind(); } } catch (Exception ex) { clsVproErrorHandler.HandlerError(ex); } }
private DataSetCollection categorizeRows(string sortColumn1, string sortColumn2, string sortColumn3, DataSet dataSet) { // Create the query. var transaction = from DataRow row in dataSet.Tables["Allocation"].Rows orderby row[sortColumn1] ascending, row[sortColumn2] ascending, row[sortColumn3] ascending group row by row[sortColumn1] into newGroup orderby newGroup.Key select newGroup; // create a temporary dataset DataSetCollection dataSetArray = new DataSetCollection(); foreach (var rowGroup in transaction) { DataSet tempDS = dataSet.Clone(); tempDS.ExtendedProperties["user"] = rowGroup.Key.ToString(); foreach (var row in rowGroup) { tempDS.Tables["Allocation"].ImportRow(row); foreach(DataRow sRow in dataSet.Tables["Split"].Rows) { //TODO: Does this actually do anything? if(sRow["ChargeID"] == ((DataRow)row)["ChargeID"]) { tempDS.Tables["Split"].ImportRow(sRow); } } } dataSetArray.Add(tempDS); } return dataSetArray; }
private DataSet createAudit(string sortColumn, DataSet dataSet) { // Create the query. var transaction = from DataRow row in dataSet.Tables["Allocation"].Rows orderby row[sortColumn] ascending select row; DataSet tempDS = dataSet.Clone(); tempDS.ExtendedProperties["user"] = sortColumn; foreach (var row in transaction) { tempDS.Tables["Allocation"].ImportRow(row); foreach (DataRow sRow in dataSet.Tables["Split"].Rows) { //TODO: Does this actually do anything? if (sRow["ChargeID"] == ((DataRow)row)["ChargeID"]) { tempDS.Tables["Split"].ImportRow(sRow); } } // try it but it needs to organize splits by company too (no split total) } return tempDS; }
private void SearchResult() { try { string keyword = txtKeyword.Value; var AllList = (from g in DB.ESHOP_PROPERTies where ("" == keyword || (g.PROP_NAME).Contains(keyword)) && g.PROP_RANK > 0 select new { g.PROP_ID, g.PROP_PARENT_ID, g.PROP_NAME, g.PROP_RANK }); if (AllList.ToList().Count > 0) { DataRelation relCat; Session["PropList"] = DataUtil.LINQToDataTable(AllList); //DataTable tbl = Session["CatList"] as DataTable; DataTable tbl = DataUtil.LINQToDataTable(AllList); DataSet ds = new DataSet(); ds.Tables.Add(tbl); tbl.PrimaryKey = new DataColumn[] { tbl.Columns["PROP_ID"] }; relCat = new DataRelation("Category_parent", ds.Tables[0].Columns["PROP_ID"], ds.Tables[0].Columns["PROP_PARENT_ID"], false); ds.Relations.Add(relCat); DataSet dsCat = ds.Clone(); DataTable CatTable = ds.Tables[0]; CpanelUtils.TransformTableWithSpace(ref CatTable, dsCat.Tables[0], relCat, null); GridItemList.DataSource = dsCat.Tables[0]; //if (CatTable.Rows.Count > GridItemList.PageSize) // GridItemList.AllowPaging = true; //else // GridItemList.AllowPaging = false; GridItemList.DataBind(); } } catch (Exception ex) { clsVproErrorHandler.HandlerError(ex); } }
public void DataSet_ColumnNameWithSpaces () { DataSet ds = new DataSet ("New Data Set"); DataTable table1 = ds.Tables.Add ("New Table 1"); DataTable table2 = ds.Tables.Add ("New Table 2"); table1.Columns.Add ("col 1" , typeof (int)); table1.Columns.Add ("col 2" , typeof (int)); table1.PrimaryKey = new DataColumn[] {ds.Tables [0].Columns [0]}; // No exception shud be thrown XmlDataDocument doc = new XmlDataDocument (ds); // Should fail to save as there are no rows try { doc.Save (new StringWriter ()); Fail ("#1"); } catch (InvalidOperationException) { } table1.Rows.Add (new object[] {0}); table1.Rows.Add (new object[] {1}); table1.Rows.Add (new object[] {2}); // No exception shud be thrown StringWriter swriter = new StringWriter (); doc.Save (swriter); StringReader sreader = new StringReader (swriter.ToString ()); DataSet ds1 = ds.Clone (); XmlDataDocument doc1 = new XmlDataDocument (ds1); AssertEquals ("#2" , 0, ds1.Tables [0].Rows.Count); doc1.Load (sreader); AssertEquals ("#3" , 3, ds1.Tables [0].Rows.Count); }
private void LoadCat() { try { var AllList = (from g in DB.ESHOP_CATEGORies where g.CAT_RANK > 0 select new { g.CAT_ID, g.CAT_PARENT_ID, g.CAT_RANK, CAT_NAME = (string.IsNullOrEmpty(g.CAT_CODE) ? g.CAT_NAME : g.CAT_NAME + "(" + g.CAT_CODE + ")") }); if (AllList.ToList().Count > 0) { DataRelation relCat; Session["CatGroupList"] = DataUtil.LINQToDataTable(AllList); DataTable tbl = Session["CatGroupList"] as DataTable; DataSet ds = new DataSet(); ds.Tables.Add(tbl); tbl.PrimaryKey = new DataColumn[] { tbl.Columns["CAT_ID"] }; relCat = new DataRelation("Category_parent", ds.Tables[0].Columns["CAT_ID"], ds.Tables[0].Columns["CAT_PARENT_ID"], false); ds.Relations.Add(relCat); DataSet dsCat = ds.Clone(); DataTable CatTable = ds.Tables[0]; DataUtil.TransformTableWithSpace(ref CatTable, dsCat.Tables[0], relCat, null); GridItemList.DataSource = CatTable; GridItemList.DataBind(); } //var allCat=DB.GetTable<ESHOP_CATEGORy>(); //GridItemList.DataSource = allCat; //GridItemList.DataBind(); //Session["CatGroupList"] = allCat; } catch (Exception ex) { clsVproErrorHandler.HandlerError(ex); } }
private void SearchResult() { try { string keyword =CpanelUtils.ClearUnicode(txtKeyword.Value); var AllList = (from g in DB.ESHOP_CATEGORies where ("" == keyword || (DB.fClearUnicode(g.CAT_NAME)).Contains(keyword)) && g.CAT_RANK > 0 select new { g.CAT_ID, g.CAT_PARENT_ID, CAT_NAME = (string.IsNullOrEmpty(g.CAT_CODE) ? g.CAT_NAME : g.CAT_NAME + "(" + g.CAT_CODE + ")"), g.CAT_POSITION, g.CAT_LANGUAGE, g.CAT_ORDER, g.CAT_PERIOD_ORDER, g.CAT_RANK }); if (AllList.ToList().Count > 0) { DataRelation relCat; //Session["CatList"] = DataUtil.LINQToDataTable(AllList); //DataTable tbl = Session["CatList"] as DataTable; DataTable tbl = DataUtil.LINQToDataTable(AllList); DataSet ds = new DataSet(); ds.Tables.Add(tbl); tbl.PrimaryKey = new DataColumn[] { tbl.Columns["CAT_ID"] }; relCat = new DataRelation("Category_parent", ds.Tables[0].Columns["CAT_ID"], ds.Tables[0].Columns["CAT_PARENT_ID"], false); ds.Relations.Add(relCat); DataSet dsCat = ds.Clone(); DataTable CatTable = ds.Tables[0]; DataUtil.TransformTableWithSpace(ref CatTable, dsCat.Tables[0], relCat, null); if (IsPostBack) { GridItemList.DataSource = AllList; GridItemList.DataBind(); } else { GridItemList.DataSource = dsCat.Tables[0]; GridItemList.DataBind(); } } } catch (Exception ex) { clsVproErrorHandler.HandlerError(ex); } }
private void LoadMenu() { try { var AllList = DB.MENUs.Where(n => n.MENU_ACTIVE == 1); if (AllList.ToList().Count > 0) { DataRelation relCat; DataTable tbl = DataUtil.LINQToDataTable(AllList); DataSet ds = new DataSet(); ds.Tables.Add(tbl); tbl.PrimaryKey = new DataColumn[] { tbl.Columns["ID"] }; relCat = new DataRelation("Category_parent", ds.Tables[0].Columns["ID"], ds.Tables[0].Columns["MENU_PARENT_ID"], false); ds.Relations.Add(relCat); DataSet dsCat = ds.Clone(); DataTable CatTable = ds.Tables[0]; CpanelUtils.TransformTableWithSpace2(ref CatTable, dsCat.Tables[0], relCat, null); Rplistmenu.DataSource = dsCat.Tables[0]; Rplistmenu.DataBind(); } //var allCat=DB.GetTable<ESHOP_CATEGORy>(); //GridItemList.DataSource = allCat; //GridItemList.DataBind(); //Session["CatGroupList"] = allCat; } catch (Exception ex) { clsVproErrorHandler.HandlerError(ex); } }
/// <summary> /// 取XML中的第几条记录,指定排序字段 /// </summary> /// <param name="pageSize">每页显示的记录条数</param> /// <param name="pageIndex">页索引</param> /// <param name="orderbyFiled">排序字段</param> /// <param name="sortOrder">排序顺序 true:倒叙 false:正序</param> /// <returns></returns> public DataView GetRecord(int pageSize, int pageIndex, string orderbyFiled, bool sortOrder) { // 开始记录位置 int sartIndex = pageSize * (pageIndex - 1); // 终止记录位置 int endIndex = pageSize * pageIndex; // 返回结果集 DataSet dsResult = new DataSet(); // 临时DataSet,用来读取XML内容 DataSet dsTemp = new DataSet(); // 读取XML内容 dsTemp.ReadXml(strXmlFile); if (endIndex > dsTemp.Tables[0].Rows.Count) { endIndex = dsTemp.Tables[0].Rows.Count; } // 克隆XML数据结构到结果集中 dsResult = dsTemp.Clone(); // 循环把要读取的记录添加到结果集中 for (int i = sartIndex; i < endIndex; i++) { dsResult.Tables[0].Rows.Add(dsTemp.Tables[0].Rows[i].ItemArray); } DataView dvResult = dsResult.Tables[0].DefaultView; if (sortOrder) { dvResult.Sort = orderbyFiled + " desc"; } else { dvResult.Sort = orderbyFiled + " asc"; } return dvResult; }
private void btnSearchResults_Click(object sender, System.EventArgs e) { dsResults = Session["search"] as DataSet; // If we can't get the previous results then we lost session // information (failure), or no previous results were available. // Default to normal search. if (dsResults == null) { btnSearch_Click(sender, e); } // We can't use parameters as this is a common filter // expression to use with the DataSet. StringBuilder qry = new StringBuilder(); if (txtFirstName.Text != String.Empty) { qry.Append("FirstName LIKE '%"); qry.Append(txtFirstName.Text).Append("%' AND "); } if (txtLastName.Text != String.Empty) { qry.Append("LastName LIKE '%"); qry.Append(txtLastName.Text).Append("%' AND "); } if (cbPlace.SelectedItem.Value != "0") { qry.Append("PlaceID = '"); qry.Append(cbPlace.SelectedItem.Value).Append("' AND "); } if (cbType.SelectedItem.Value != "0") { qry.Append("TypeID = '"); qry.Append(cbType.SelectedItem.Value).Append("' AND "); } if (txtYearIn.Text != String.Empty) { qry.Append("YearIn = "); qry.Append(txtYearIn.Text).Append(" AND "); } if (txtYearOut.Text != String.Empty) { qry.Append("YearOut = "); qry.Append(txtYearOut.Text).Append(" AND "); } string filter = qry.ToString(); if (filter.Length != 0) { // Remove trailing AND filter = filter.Remove(filter.Length - 4, 4); } DataRow[] rows = dsResults.Tables["User"].Select(filter); // Rebuild results with new filtered set of rows, maintaining // structure dsResults = dsResults.Clone(); foreach (DataRow row in rows) { dsResults.Tables["User"].ImportRow(row); } // Place results in session state. Session["search"] = dsResults; BindFromSession(); }
private DataSet GetCachedData(string CacheKeyName, int NoOfTopRecords, string SQLQueryOrSP, CommandType cmdType, params SqlParameter[] commandParameters) { DataSet dsCached = new DataSet(); try { if (HttpContext.Current.Cache.Get(CacheKeyName) != null) { dsCached = (DataSet)HttpContext.Current.Cache[CacheKeyName]; } else { Database dbObj = new SqlDatabase(this.connectionStr); DbCommand command = dbObj.GetStoredProcCommand(SQLQueryOrSP); if (commandParameters != null) { for (int index = 0; index < commandParameters.Length; index++) { dbObj.AddInParameter(command, commandParameters[index].ParameterName, commandParameters[index].DbType, commandParameters[index].Value); } } dsCached = dbObj.ExecuteDataSet(command); HttpContext.Current.Cache.Insert(CacheKeyName, dsCached, null, dtCacheTime, TimeSpan.Zero); } if (NoOfTopRecords > 0) { DataSet ds = new DataSet(); ds = dsCached.Clone(); for (int j = 0; j < NoOfTopRecords; j++) { ds.Tables[0].Rows.Add(dsCached.Tables[0].Rows[j].ItemArray); } dsCached = ds; } } catch (SqlException ex) { } catch (Exception ex) { } return dsCached; }
private static void HistoryRefreshDataSetTable(DataSet ds, SqlDataAdapter adapter) { string tableName = adapter.TableMappings[0].DataSetTable; var srcTable = ds.Tables[tableName]; DataTable dtTmp = srcTable.Clone(); DataSet dsTmp = ds.Clone(); adapter.Fill(dsTmp); ds.Merge(dsTmp); //adapter.Fill(dsTmp,tableName); //(dtTmp); //var x = adapter.SelectCommand.ExecuteReader(); //srcTable.Merge(dtTmp); }
public void CloneCopy2 () { DataSet ds = new DataSet (); ds.ReadXmlSchema ("Test/System.Data/store.xsd"); ds.Clone (); }
public void CloneCopy_TestForeignKeyConstraints () { DataTable dirTable = new DataTable("Directories"); DataColumn dir_UID = new DataColumn("UID", typeof(int)); dir_UID.Unique = true; dir_UID.AllowDBNull = false; dirTable.Columns.Add(dir_UID); // Build a simple Files table DataTable fileTable = new DataTable("Files"); DataColumn file_DirID = new DataColumn("DirectoryID", typeof(int)); file_DirID.Unique = false; file_DirID.AllowDBNull = false; fileTable.Columns.Add(file_DirID); // Build the DataSet DataSet ds = new DataSet("TestDataset"); ds.Tables.Add(dirTable); ds.Tables.Add(fileTable); // Add a foreign key constraint DataColumn[] parentColumns = new DataColumn[1]; parentColumns[0] = ds.Tables["Directories"].Columns["UID"]; DataColumn[] childColumns = new DataColumn[1]; childColumns[0] = ds.Tables["Files"].Columns["DirectoryID"]; ForeignKeyConstraint fk = new ForeignKeyConstraint("FK_Test", parentColumns, childColumns); ds.Tables["Files"].Constraints.Add(fk); ds.EnforceConstraints = true; Assert.AreEqual (1, ds.Tables["Directories"].Constraints.Count, "#1"); Assert.AreEqual (1, ds.Tables["Files"].Constraints.Count, "#2"); // check clone works fine DataSet cloned_ds = ds.Clone (); Assert.AreEqual (1, cloned_ds.Tables["Directories"].Constraints.Count, "#3"); Assert.AreEqual (1, cloned_ds.Tables["Files"].Constraints.Count, "#4"); ForeignKeyConstraint clonedFk = (ForeignKeyConstraint)cloned_ds.Tables["Files"].Constraints[0]; Assert.AreEqual ("FK_Test", clonedFk.ConstraintName, "#5"); Assert.AreEqual (1, clonedFk.Columns.Length, "#6"); Assert.AreEqual ("DirectoryID", clonedFk.Columns[0].ColumnName, "#7"); UniqueConstraint clonedUc = (UniqueConstraint)cloned_ds.Tables ["Directories"].Constraints[0]; UniqueConstraint origUc = (UniqueConstraint)ds.Tables ["Directories"].Constraints[0]; Assert.AreEqual (origUc.ConstraintName, clonedUc.ConstraintName, "#8"); Assert.AreEqual (1, clonedUc.Columns.Length, "#9"); Assert.AreEqual ("UID", clonedUc.Columns[0].ColumnName, "#10"); // check copy works fine DataSet copy_ds = ds.Copy (); Assert.AreEqual (1, copy_ds.Tables["Directories"].Constraints.Count, "#11"); Assert.AreEqual (1, copy_ds.Tables["Files"].Constraints.Count, "#12"); ForeignKeyConstraint copyFk = (ForeignKeyConstraint)copy_ds.Tables["Files"].Constraints[0]; Assert.AreEqual ("FK_Test", copyFk.ConstraintName, "#13"); Assert.AreEqual (1, copyFk.Columns.Length, "#14"); Assert.AreEqual ("DirectoryID", copyFk.Columns[0].ColumnName, "#15"); UniqueConstraint copyUc = (UniqueConstraint)copy_ds.Tables ["Directories"].Constraints[0]; origUc = (UniqueConstraint)ds.Tables ["Directories"].Constraints[0]; Assert.AreEqual (origUc.ConstraintName, copyUc.ConstraintName, "#16"); Assert.AreEqual (1, copyUc.Columns.Length, "#17"); Assert.AreEqual ("UID", copyUc.Columns[0].ColumnName, "#18"); }
public void CloneCopy () { DataTable table = new DataTable ("pTable"); DataTable table1 = new DataTable ("cTable"); DataSet set = new DataSet (); set.Tables.Add (table); set.Tables.Add (table1); DataColumn col = new DataColumn (); col.ColumnName = "Id"; col.DataType = Type.GetType ("System.Int32"); table.Columns.Add (col); UniqueConstraint uc = new UniqueConstraint ("UK1", table.Columns[0] ); table.Constraints.Add (uc); col = new DataColumn (); col.ColumnName = "Name"; col.DataType = Type.GetType ("System.String"); table.Columns.Add (col); col = new DataColumn (); col.ColumnName = "Id"; col.DataType = Type.GetType ("System.Int32"); table1.Columns.Add (col); col = new DataColumn (); col.ColumnName = "Name"; col.DataType = Type.GetType ("System.String"); table1.Columns.Add (col); ForeignKeyConstraint fc = new ForeignKeyConstraint ("FK1", table.Columns[0], table1.Columns[0] ); table1.Constraints.Add (fc); DataRow row = table.NewRow (); row ["Id"] = 147; row ["name"] = "Row1"; row.RowError = "Error#1"; table.Rows.Add (row); // Set column to RO as commonly used by auto-increment fields. // ds.Copy() has to omit the RO check when cloning DataRows table.Columns["Id"].ReadOnly = true; row = table1.NewRow (); row ["Id"] = 147; row ["Name"] = "Row1"; table1.Rows.Add (row); //Setting properties of DataSet set.CaseSensitive = true; set.DataSetName = "My DataSet"; set.EnforceConstraints = false; set.Namespace = "Namespace#1"; set.Prefix = "Prefix:1"; DataRelation dr = new DataRelation ("DR", table.Columns [0],table1.Columns [0]); set.Relations.Add (dr); set.ExtendedProperties.Add ("TimeStamp", DateTime.Now); CultureInfo cultureInfo = new CultureInfo( "ar-SA" ); set.Locale = cultureInfo; //Testing Copy () DataSet copySet = set.Copy (); Assert.AreEqual (set.CaseSensitive, copySet.CaseSensitive, "#A01"); Assert.AreEqual (set.DataSetName, copySet.DataSetName, "#A02"); Assert.AreEqual (set.EnforceConstraints, copySet.EnforceConstraints, "#A03"); Assert.AreEqual (set.HasErrors, copySet.HasErrors, "#A04"); Assert.AreEqual (set.Namespace, copySet.Namespace, "#A05"); Assert.AreEqual (set.Prefix, copySet.Prefix, "#A06"); Assert.AreEqual (set.Relations.Count, copySet.Relations.Count, "#A07"); Assert.AreEqual (set.Tables.Count, copySet.Tables.Count, "#A08"); Assert.AreEqual (set.ExtendedProperties ["TimeStamp"], copySet.ExtendedProperties ["TimeStamp"], "#A09"); for (int i = 0;i < copySet.Tables.Count; i++) { Assert.AreEqual (set.Tables [i].Rows.Count, copySet.Tables [i].Rows.Count, "#A10"); Assert.AreEqual (set.Tables [i].Columns.Count, copySet.Tables [i].Columns.Count, "#A11"); } //Testing Clone () copySet = set.Clone (); Assert.AreEqual (set.CaseSensitive, copySet.CaseSensitive, "#A12"); Assert.AreEqual (set.DataSetName, copySet.DataSetName, "#A13"); Assert.AreEqual (set.EnforceConstraints, copySet.EnforceConstraints, "#A14"); Assert.IsFalse (copySet.HasErrors, "#A15"); Assert.AreEqual (set.Namespace, copySet.Namespace, "#A16"); Assert.AreEqual (set.Prefix, copySet.Prefix, "#A17"); Assert.AreEqual (set.Relations.Count, copySet.Relations.Count, "#A18"); Assert.AreEqual (set.Tables.Count, copySet.Tables.Count, "#A19"); Assert.AreEqual (set.ExtendedProperties ["TimeStamp"], copySet.ExtendedProperties ["TimeStamp"], "#A20"); for (int i = 0;i < copySet.Tables.Count; i++) { Assert.AreEqual (0, copySet.Tables [i].Rows.Count, "#A21"); Assert.AreEqual (set.Tables [i].Columns.Count, copySet.Tables [i].Columns.Count, "#A22"); } }
[Test] public void Clone() { DataSet ds = new DataSet(), dsTarget = null; ds.Tables.Add(DataProvider.CreateParentDataTable()); ds.Tables.Add(DataProvider.CreateChildDataTable()); ds.Relations.Add(new DataRelation("myRelation",ds.Tables[0].Columns[0],ds.Tables[1].Columns[0])); ds.Tables[0].Rows.Add(new object[] {9,"",""}); ds.Tables[1].Columns[2].ReadOnly = true; ds.Tables[0].PrimaryKey = new DataColumn[] {ds.Tables[0].Columns[0],ds.Tables[0].Columns[1]}; //copy schema only, no data // Clone 1 dsTarget = ds.Clone(); //Assert.AreEqual(ds.GetXmlSchema(), dsTarget.GetXmlSchema() , "DS16"); //use my function because GetXmlSchema not implemented in java Assert.AreEqual(DataProvider.GetDSSchema(ds), DataProvider.GetDSSchema(dsTarget), "DS17"); // Clone 2 Assert.AreEqual(false, dsTarget.GetXml() == ds.GetXml(), "DS18"); }
private void LoadTypeParent() { try { var CatList = ( from t2 in db.TYPE_COMPANies select new { TYPE_ID = t2.TYPE_NAME == "-------Root-------" ? 0 : t2.TYPE_ID, TYPE_PARENT = t2.TYPE_PARENT, TYPE_RANK = t2.TYPE_RANK, TYPE_NAME = t2.TYPE_NAME } ); if (CatList.ToList().Count > 0) { DataRelation relCat; DataTable tbl = DataUtil.LINQToDataTable(CatList); DataSet ds = new DataSet(); ds.Tables.Add(tbl); tbl.PrimaryKey = new DataColumn[] { tbl.Columns["TYPE_ID"] }; relCat = new DataRelation("TYPE_PARENT", ds.Tables[0].Columns["TYPE_ID"], ds.Tables[0].Columns["TYPE_PARENT"], false); ds.Relations.Add(relCat); DataSet dsCat = ds.Clone(); DataTable CatTable = ds.Tables[0]; unit_data.TransformTableWithSpace(ref CatTable, dsCat.Tables[0], relCat, null); Drmenu_parent.DataSource = dsCat.Tables[0]; Drmenu_parent.DataTextField = "TYPE_NAME"; Drmenu_parent.DataValueField = "TYPE_ID"; Drmenu_parent.DataBind(); } else { DataTable dt = new DataTable("Newtable"); dt.Columns.Add(new DataColumn("TYPE_ID")); dt.Columns.Add(new DataColumn("TYPE_NAME")); DataRow row = dt.NewRow(); row["TYPE_ID"] = 0; row["TYPE_NAME"] = "-------Root-------"; dt.Rows.Add(row); Drmenu_parent.DataTextField = "TYPE_NAME"; Drmenu_parent.DataValueField = "TYPE_ID"; Drmenu_parent.DataSource = dt; Drmenu_parent.DataBind(); } } catch (Exception ex) { clsVproErrorHandler.HandlerError(ex); } }
public void RefreshView(bool initialize) { try { if (currentConnection == null) { return; } if (!currentConnection.Connected) { return; } RefreshTimer.Enabled = false; String s = currentConnection.Ps(); DataSet ds = JobRuntimeDS.Clone(); ds.Clear(); ds.ReadXml(new StringReader(s), XmlReadMode.Auto); JobGrid.SuspendLayout(); if (initialize) { JobRuntimeDS.Clear(); } JobRuntimeDS.Merge(ds.Tables["JobRuntimeType"]); ServerConfigRefreshRate r = UIConfigFileHandler.Instance().Config.RefreshRate; switch (r) { case ServerConfigRefreshRate.High: RefreshTimer.Interval = 1000; RefreshTimer.Enabled = true; break; case ServerConfigRefreshRate.Low: RefreshTimer.Interval = 30000; RefreshTimer.Enabled = true; break; case ServerConfigRefreshRate.Normal: RefreshTimer.Interval = 10000; RefreshTimer.Enabled = true; break; case ServerConfigRefreshRate.Paused: RefreshTimer.Enabled = false; break; } } catch (Exception ex) { currentConnection.Disconnect(); MessageBox.Show(ex.Message); } finally { JobGrid.ResumeLayout(true); } }
/// <summary> /// 取XML中的第几条记录 /// </summary> /// <param name="pageSize">每页显示的记录条数</param> /// <param name="pageIndex">页索引</param> /// <returns></returns> public DataSet GetRecord(int pageSize, int pageIndex) { // 开始记录位置 int sartIndex = pageSize * (pageIndex - 1); // 终止记录位置 int endIndex = pageSize * pageIndex; // 返回结果集 DataSet dsResult = new DataSet(); // 临时DataSet,用来读取XML内容 DataSet dsTemp = new DataSet(); // 读取XML内容 dsTemp.ReadXml(strXmlFile); if (endIndex > dsTemp.Tables[0].Rows.Count) { endIndex = dsTemp.Tables[0].Rows.Count; } if (dsTemp.Tables.Count > 0) { if (dsTemp.Tables[0].Rows.Count > 0) { // 克隆XML数据结构到结果集中 dsResult = dsTemp.Clone(); // 循环把要读取的记录添加到结果集中 for (int i = sartIndex; i < endIndex; i++) { dsResult.Tables[0].Rows.Add(dsTemp.Tables[0].Rows[i].ItemArray); } } } return dsResult; }
public void Rows_With_Null_Values () { DataSet ds = new DataSet (); DataTable table = ds.Tables.Add ("table1"); table.Columns.Add ("col1", typeof (int)); table.Columns.Add ("col2", typeof (int)); XmlDataDocument doc = new XmlDataDocument (ds); table.Rows.Add (new object[] {1}); StringWriter sw = new StringWriter (); doc.Save (sw); DataSet ds1 = ds.Clone (); XmlDataDocument doc1 = new XmlDataDocument (ds1); StringReader sr = new StringReader (sw.ToString()); doc1.Load (sr); AssertEquals ("#1", 1, ds1.Tables [0].Rows [0][0]); AssertEquals ("#2", true, ds1.Tables [0].Rows [0].IsNull (1)); }
private void LoadCategoryParent() { try { var CatList = ( from t2 in DB.ESHOP_PROPERTies select new { PROP_ID = t2.PROP_NAME == "------- Root -------" ? 0 : t2.PROP_ID, PROP_NAME = t2.PROP_NAME, PROP_PARENT_ID = t2.PROP_PARENT_ID, PROP_RANK = t2.PROP_RANK } ); if (CatList.ToList().Count > 0) { DataRelation relCat; DataTable tbl = DataUtil.LINQToDataTable(CatList); DataSet ds = new DataSet(); ds.Tables.Add(tbl); tbl.PrimaryKey = new DataColumn[] { tbl.Columns["PROP_ID"] }; relCat = new DataRelation("Category_parent", ds.Tables[0].Columns["PROP_ID"], ds.Tables[0].Columns["PROP_PARENT_ID"], false); ds.Relations.Add(relCat); DataSet dsCat = ds.Clone(); DataTable CatTable = ds.Tables[0]; CpanelUtils.TransformTableWithSpace(ref CatTable, dsCat.Tables[0], relCat, null); ddlCategory.DataSource = dsCat.Tables[0]; ddlCategory.DataTextField = "PROP_NAME"; ddlCategory.DataValueField = "PROP_ID"; ddlCategory.DataBind(); } else { DataTable dt = new DataTable("Newtable"); dt.Columns.Add(new DataColumn("PROP_ID")); dt.Columns.Add(new DataColumn("PROP_NAME")); DataRow row = dt.NewRow(); row["ARE_ID"] = 0; row["ARE_NAME"] = "--------Root--------"; dt.Rows.Add(row); ddlCategory.DataTextField = "PROP_NAME"; ddlCategory.DataValueField = "PROP_ID"; ddlCategory.DataSource = dt; ddlCategory.DataBind(); } } catch (Exception ex) { clsVproErrorHandler.HandlerError(ex); } }
private void btnSearchFurther_Click(object sender, System.EventArgs e) { dsResults = Session["search"] as DataSet; //return a normal search if the session doesn't exist anymore if( dsResults == null ) btnSearch_Click( sender, e ); //here this is a filter not an sql query so no parameters :< //similar to the regular search, though StringBuilder qry = new StringBuilder(); if( txtOrderNumber.Text != String.Empty ) { qry.Append( "orderNumber = " ); qry.Append( txtOrderNumber.Text ).Append( " AND " ); } if( txtSalesRepUName.Text != String.Empty ) { qry.Append( "UID1 LIKE '%" ); qry.Append( txtSalesRepUName.Text ).Append( "%' AND " ); } if( txtSalesRepName.Text != String.Empty ) { qry.Append( "employeename LIKE '%" ); qry.Append( txtSalesRepName.Text ).Append( "%' AND " ); } string filter = qry.ToString(); if( filter.Length != 0 ) { filter = filter.Remove( filter.Length - 4, 4 ); } DataRow[] rows = dsResults.Tables["Order"].Select( filter ); //get the results back dsResults = dsResults.Clone(); foreach( DataRow row in rows ) { dsResults.Tables["Order"].ImportRow( row ); } //put the results in the session Session["search"] = dsResults; BindFromSession(); }
private void LoadCategoryParent() { try { var CatList = ( from t2 in DB.ESHOP_CATEGORies where t2.CAT_RANK > 0 && (_type == 0 ? (t2.CAT_TYPE != 1) : t2.CAT_TYPE == 1) && (_gtype != 1 ? (getCatid().Contains(t2.CAT_ID.ToString()) || getCatid().Contains(t2.CAT_PARENT_ID.ToString())) : true) select new { CAT_ID = t2.CAT_NAME == "------- Root -------" ? 0 : t2.CAT_ID, CAT_NAME = (string.IsNullOrEmpty(t2.CAT_CODE) ? t2.CAT_NAME : t2.CAT_NAME + "(" + t2.CAT_CODE + ")"), CAT_NAME_EN = (string.IsNullOrEmpty(t2.CAT_CODE_EN) ? t2.CAT_NAME_EN : t2.CAT_NAME_EN + "(" + t2.CAT_CODE_EN + ")"), CAT_PARENT_ID = t2.CAT_PARENT_ID, CAT_RANK = t2.CAT_RANK } ); if (CatList.ToList().Count > 0) { DataRelation relCat; DataTable tbl = DataUtil.LINQToDataTable(CatList); DataSet ds = new DataSet(); ds.Tables.Add(tbl); tbl.PrimaryKey = new DataColumn[] { tbl.Columns["CAT_ID"] }; relCat = new DataRelation("Category_parent", ds.Tables[0].Columns["CAT_ID"], ds.Tables[0].Columns["CAT_PARENT_ID"], false); ds.Relations.Add(relCat); DataSet dsCat = ds.Clone(); DataTable CatTable = ds.Tables[0]; DataUtil.TransformTableWithSpace(ref CatTable, dsCat.Tables[0], relCat, null); if (CatList.ToList()[0].CAT_RANK > 1) ddlCategory.DataSource = CatList; else ddlCategory.DataSource = dsCat.Tables[0]; ddlCategory.DataTextField = "CAT_NAME"; ddlCategory.DataValueField = "CAT_ID"; ddlCategory.DataBind(); } else { DataTable dt = new DataTable("Newtable"); dt.Columns.Add(new DataColumn("CAT_ID")); dt.Columns.Add(new DataColumn("CAT_NAME")); dt.Columns.Add(new DataColumn("CAT_NAME_EN")); DataRow row = dt.NewRow(); row["CAT_ID"] = 0; row["CAT_NAME"] = "--------Root--------"; row["CAT_NAME_EN"] = "--------Root--------"; dt.Rows.Add(row); ddlCategory.DataTextField = "CAT_NAME"; ddlCategory.DataValueField = "CAT_ID"; ddlCategory.DataSource = dt; ddlCategory.DataBind(); } } catch (Exception ex) { clsVproErrorHandler.HandlerError(ex); } }
public void CopyClone_RelationWithoutConstraints () { DataSet ds = new DataSet (); DataTable table1 = ds.Tables.Add ("table1"); DataTable table2 = ds.Tables.Add ("table2"); DataColumn pcol = table1.Columns.Add ("col1", typeof (int)); DataColumn ccol = table2.Columns.Add ("col1", typeof (int)); DataRelation rel = ds.Relations.Add ("rel1", pcol, ccol, false); DataSet ds1 = ds.Copy (); DataSet ds2 = ds.Clone (); Assert.AreEqual (1, ds1.Relations.Count, "#1"); Assert.AreEqual (1, ds2.Relations.Count, "#2"); Assert.AreEqual (0, ds1.Tables [0].Constraints.Count, "#3"); Assert.AreEqual (0, ds1.Tables [1].Constraints.Count, "#4"); Assert.AreEqual (0, ds2.Tables [0].Constraints.Count, "#5"); Assert.AreEqual (0, ds2.Tables [1].Constraints.Count, "#6"); }