private DataView XmlDataView() { UserDefinedTableDB objUserDefinedTable = new UserDefinedTableDB(); DataSet ds; ds = objUserDefinedTable.GetUserDefinedRows(ModuleIDsrc()); // create a dataview to process the sort and filter options return(new DataView(ds.Tables[0])); }
protected void BindGrid() { UserDefinedTableDB objUserDefinedTable = new UserDefinedTableDB(); string strSortField = string.Empty; string strSortOrder = string.Empty; SqlDataReader dr; if (ViewState["SortField"].ToString() != string.Empty && ViewState["SortOrder"].ToString() != string.Empty) { strSortField = ViewState["SortField"].ToString(); strSortOrder = ViewState["SortOrder"].ToString(); } else { if (Settings["SortField"].ToString() != string.Empty) { strSortField = Settings["SortField"].ToString(); } if (Settings["SortOrder"].ToString() != string.Empty) { strSortOrder = Settings["SortOrder"].ToString(); } else { strSortOrder = "ASC"; } } grdData.Columns.Clear(); dr = objUserDefinedTable.GetUserDefinedFields(ModuleID); try { while (dr.Read()) { DataGridColumn colField = null; if (dr["FieldType"].ToString() == "Image") { colField = new BoundColumn(); ((BoundColumn)colField).DataField = dr["FieldTitle"].ToString(); ((BoundColumn)colField).DataFormatString = "<img src=\"" + ((SettingItem)Settings["ImagePath"]).FullPath + "/{0}" + "\" alt=\"{0}\" border =0>"; } else if (dr["FieldType"].ToString() == "File") { colField = new HyperLinkColumn(); ((HyperLinkColumn)colField).DataTextField = dr["FieldTitle"].ToString(); ((HyperLinkColumn)colField).DataTextFormatString = "{0}"; ((HyperLinkColumn)colField).DataNavigateUrlFormatString = ((SettingItem)Settings["DocumentPath"]).FullPath + "/{0}"; ((HyperLinkColumn)colField).DataNavigateUrlField = dr["FieldTitle"].ToString(); } else { colField = new BoundColumn(); ((BoundColumn)colField).DataField = dr["FieldTitle"].ToString(); switch (dr["FieldType"].ToString()) { case "DateTime": //Changed to Italian format as it is sayed to be the default (see intro of history.txt) //Better would be to make this follow the current culture - Rob Siera, 15 jan 2005 ((BoundColumn)colField).DataFormatString = "{0:dd MMM yyyy}"; break; case "Int32": ((BoundColumn)colField).DataFormatString = "{0:#,###,##0}"; colField.HeaderStyle.HorizontalAlign = HorizontalAlign.Right; colField.ItemStyle.HorizontalAlign = HorizontalAlign.Right; break; case "Decimal": ((BoundColumn)colField).DataFormatString = "{0:#,###,##0.00}"; colField.HeaderStyle.HorizontalAlign = HorizontalAlign.Right; colField.ItemStyle.HorizontalAlign = HorizontalAlign.Right; break; } } colField.HeaderText = dr["FieldTitle"].ToString(); if (dr["FieldTitle"].ToString() == strSortField) { // 2004/07/04 by Ozan Sirin, FIX: It does not show sort images when running root site instead of rainbow virtual folder. if (strSortOrder == "ASC") { colField.HeaderText += "<img src='" + Rainbow.Settings.Path.WebPathCombine(Rainbow.Settings.Path.ApplicationRoot, "DesktopModules/UserDefinedTable/sortascending.gif") + "' border='0' alt='" + Esperantus.Localize.GetString("USERTABLE_SORTEDBY", "Sorted By", null) + " " + strSortField + " " + Esperantus.Localize.GetString("USERTABLE_INASCORDER", "In Ascending Order", null) + "'>"; } else { colField.HeaderText += "<img src='" + Rainbow.Settings.Path.WebPathCombine(Rainbow.Settings.Path.ApplicationRoot, "DesktopModules/UserDefinedTable/sortdescending.gif") + "' border='0' alt='" + Esperantus.Localize.GetString("USERTABLE_SORTEDBY", "Sorted By", null) + " " + strSortField + " " + Esperantus.Localize.GetString("USERTABLE_INDSCORDER", "In Descending Order", null) + "'>"; } } colField.Visible = bool.Parse(dr["Visible"].ToString()); colField.SortExpression = dr["FieldTitle"].ToString() + "|ASC"; grdData.Columns.Add(colField); } } finally { dr.Close(); } if (IsEditable) { HyperLinkColumn hc = new HyperLinkColumn(); hc.Text = "Edit"; hc.DataNavigateUrlField = "UserDefinedRowID"; hc.DataNavigateUrlFormatString = HttpUrlBuilder.BuildUrl("~/DesktopModules/UserDefinedTable/UserDefinedTableEdit.aspx", TabID, "&mID=" + ModuleID + "&UserDefinedRowID={0}"); grdData.Columns.Add(hc); } DataSet ds; ds = objUserDefinedTable.GetUserDefinedRows(ModuleID); // create a dataview to process the sort and filter options DataView dv; dv = new DataView(ds.Tables[0]); // sort data view if (strSortField != string.Empty && strSortOrder != string.Empty) { dv.Sort = strSortField + " " + strSortOrder; } grdData.DataSource = dv; grdData.DataBind(); }