Forms Data Controls :: Replace Text In GridView Or Something?
Nov 6, 2010
I have big problem I have a table where the column is "Enabled" datatype = bit.
In this column I have data True / False. The show GridView column 'Enabled'. Problem is, as everywhere in this column, write True / False. How, in view of this information in the GridView displayed: True = Verified, False / UnVerified GridView, column is "Enabled"
Column Enabled:
No False
No True
Column Enabled I want this
Unverified
Verified
It should probably change the text, or something like that.
i want to access gridview collumn 2 and for each row replace the text that is there with a "*" because its a password fields so instead on show the pass hide it with * so its more or less this but... see comment line
I've got a gridview on my page that gets its infomation from a database. One of the columns shows whether a news article is featured or not. It currently displays a 1 or 0.
I would like to change it so that it shows a tick icon if it's a 1, or a nbsp; if it's 0.
I'm using a book to create a shopping site and need to change the following code so that the current dropdown list, of colour options, is replaced by just read only text. I'm a novice and despite best efforts I can't fathom it out. If anyone can change the code for me I would be extremely grateful.
The code below is the code-behind page for a Product List page where I want each product displayed to also display its colour options as just text (I don't need the shopper to select a colour choice until they click through to the detail page)
using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data; public partial class UserControls_ProductsList : System.Web.UI.UserControl { protected void Page_Load(object sender, EventArgs e) { PopulateControls(); } private void PopulateControls() { // Retrieve DepartmentID from the query string string departmentId = Request.QueryString["DepartmentID"]; // Retrieve CategoryID from the query string string categoryId = Request.QueryString["CategoryID"]; // Retrieve Page from the query string string page = Request.QueryString["Page"]; if (page == null) page = "1"; // Retrieve Search string from query string string searchString = Request.QueryString["Search"]; // How many pages of products? int howManyPages = 1; // pager links format string firstPageUrl = ""; string pagerFormat = ""; // If performing a product search if (searchString != null) { // Retrieve AllWords from query string string allWords = Request.QueryString["AllWords"]; // Perform search list.DataSource = CatalogAccess.Search(searchString, allWords, page, out howManyPages); list.DataBind(); // Display pager firstPageUrl = Link.ToSearch(searchString, allWords.ToUpper() == "TRUE", "1"); pagerFormat = Link.ToSearch(searchString, allWords.ToUpper() == "TRUE", "{0}"); } // If browsing a category... else if (categoryId != null) { // Retrieve list of products in a category list.DataSource = CatalogAccess.GetProductsInCategory(categoryId, page, out howManyPages); list.DataBind(); // get first page url and pager format firstPageUrl = Link.ToCategory(departmentId, categoryId, "1"); pagerFormat = Link.ToCategory(departmentId, categoryId, "{0}"); } else if (departmentId != null) { // Retrieve list of products on department promotion list.DataSource = CatalogAccess.GetProductsOnDeptPromo (departmentId, page, out howManyPages); list.DataBind(); // get first page url and pager format firstPageUrl = Link.ToDepartment(departmentId, "1"); pagerFormat = Link.ToDepartment(departmentId, "{0}"); } else { // Retrieve list of products on catalog promotion list.DataSource = CatalogAccess.GetProductsOnFrontPromo(page, out howManyPages); list.DataBind(); // have the current page as integer int currentPage = Int32.Parse(page); } // Display pager controls topPager.Show(int.Parse(page), howManyPages, firstPageUrl, pagerFormat, false); bottomPager.Show(int.Parse(page), howManyPages, firstPageUrl, pagerFormat, true); } // Executed when each item of the list is bound to the data source protected void list_ItemDataBound(object sender, DataListItemEventArgs e) { // obtain the attributes of the product DataRowView dataRow = (DataRowView)e.Item.DataItem; string productId = dataRow["ProductID"].ToString(); DataTable attrTable = CatalogAccess.GetProductAttributes(productId); // get the attribute placeholder PlaceHolder attrPlaceHolder = (PlaceHolder)e.Item.FindControl("attrPlaceHolder"); // temp variables string prevAttributeName = ""; string attributeName, attributeValue, attributeValueId; // current DropDown for attribute values Label attributeNameLabel; DropDownList attributeValuesDropDown = new DropDownList(); // read the list of attributes foreach (DataRow r in attrTable.Rows) { // get attribute data attributeName = r["AttributeName"].ToString(); attributeValue = r["AttributeValue"].ToString(); attributeValueId = r["AttributeValueID"].ToString(); // if starting a new attribute (e.g. Color, Size) if (attributeName != prevAttributeName) { prevAttributeName = attributeName; attributeNameLabel = new Label(); attributeNameLabel.Text = attributeName + ": "; attributeValuesDropDown = new DropDownList(); attrPlaceHolder.Controls.Add(attributeNameLabel); attrPlaceHolder.Controls.Add(attributeValuesDropDown); } // add a new attribute value to the DropDownList attributeValuesDropDown.Items.Add(new ListItem(attributeValue, attributeValueId)); } } }
Failed to load viewstate. The control tree into which viewstate is being loaded must match the control tree that was used to save viewstate during the previous request. For example, when adding controls dynamically, the controls added during a post-back must match the type and position of the controls added during the initial request.
The above error occurs with gridview control , when used with template field columns with item template / and edit templates etc. updating a row within gridview, at the time of loadiong it loads perfectly fined, but when tried to modify an existing row within gridview control, then it produces the error. Make sure the grid view control has to be a child control which manages the child table info with in a master form. to reproduce the above problem the grid view must be loading the child records info of a master within the masterform, meaning both master data and gridview data all to be managed in one single form.
I had to replace gridview control with datagrid and then it worked perfectly fine. I wasted almost 4 days of my time., there is no way we could figure out the problem. here is the full info of the problem.
Server Error in '/' Application.
Failed to load viewstate. The control tree into which viewstate is being loaded must match the control tree that was used to save viewstate during the previous request. For example, when adding controls dynamically, the controls added during a post-back must match the type and position of the controls added during the initial request.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Web.HttpException: Failed to load viewstate. The control tree into which viewstate is being loaded must match the control tree that was used to save viewstate during the previous request. For example, when adding controls dynamically, the controls added during a post-back must match the type and position of the controls added during the initial request.
Source Error:
[Code]....
Stack Trace:
[HttpException (0x80004005): Failed to load viewstate. The control tree into which viewstate is being loaded must match the control tree that was used to save viewstate during the previous request. For example, when adding controls dynamically, the controls added during a post-back must match the type and position of the controls added during the initial request.] System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +306 System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState) +134 System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +221 System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState) +134 System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +221 System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState) +134 System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +221 System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState) +134 System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +221 System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState) +134 System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +221 System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState) +134 System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +221 System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState) +134 System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +221 System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState) +134 System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +221 System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState) +134 System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +221 System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState) +134 System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +221 System.Web.UI.Page.LoadAllState() +312 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1661
Version Information: Microsoft .NET Framework Version:2.0.50727.3603; ASP.NET Version:2.0.50727.3082
I have a GridView that is populated in code from a MySQL database.The code:
Code: If con.State = Data.ConnectionState.Open Then con.ChangeDatabase("EcoWatch") strSQL = "SELECT DeviceDescription, deviceStatus FROM switchstatus WHERE ClientID='" & ClientID & "' ORDER BY DeviceType" myDataAdapter = New MySqlDataAdapter(strSQL, con)
[Code]...
What I need to accomplish is : 1). Change the text "ON" or "OFF" with the relevant images:"~/Images/SwON.png" and "~/Images/SwOFF.png" 2). Add an additional ImageButton column to the far right of the GridView that allows the user to perform an action.
I would like setting up my GRIDVIEW to display an image in of the columns instead of a text where deathmarker column contains a specific word (Y).I got it working to show an image in every row, but i need a way of filtering this so it should only appear if the deathmarker column is populated with the letter "Y".below is the asp.net code
I am relatively new to asp.net and program using VB. I have written the following code to try and replace ReadOnly CheckBoxes with an image as the CheckBoxes appear grayed out and difficult to see. The GridView is linked to a SQL DataSource to display information only.
The problem I am having is displaying the image for unchecked boxes where the data (PET) in the SQL table is set to 'false'. The code displays the checkbox image fine when the bit is set to 'true', but no image appears in the GridView rows where the bit is 'false'.
i have a grid view that displays a load of figures, and as there is a lot of zero's in these tables i wondered if it would be possible to just display nothing were there is a "0" ... just to make it look cleaner?
I have this scenario where i want to select multiple customers at a time and add them to a group/role. to do this i thought of using a gridView and listed them all with sqlDatasource and enabled 'selection' for gridview. but by default grid view is allowing only one selection at a time. so is there a way i can insert a new column of check boxes and some how read the gridview to know which checkboxes are selected? if you know a better approach than a gridview or check box please suggest me. i am not very familiar with asp.net so
I am working on creating a stored procedure that will output a pivot table. In the pivot table will be either the string NULL or a number. How can I reformat this in ASP.NET so the NULL value becomes a blank cell in the gridview and the number (whatever it is) becomes an 'X' ?
How to use pattern replacement in the RTF?. For example you can add a placeholder like {USER_FIRST_NAME} in the RTF document. When the user clicks the download button, your application can take the information from the database and replace every instance of {USER_FIRST_NAME} with the data from the database....
In my asp.net+vb web i have a label named company.text i use a dropdownlist to select the company names and that selected value is binded on company.text. When the dropdownlist is selected the data hets displayed in the gridview and also the selected company named is displayed in company.text.
i want to use this label (company.text) as a hyperlink to another page so that that company name can be used for string.Â
I have a gridview which is binded to a Sqldatasource. I would like to replace a column data field value to 'Not Applicable' if that column has got a value of 2 in database.
i want to replace the control after binding like suppose i bind a gridview with the edit button . when i press the edit button all field are come as a textbox control. i replace this textbox to another control how to do this.
I'm trying to get the text value of a label when that row is selected in my gridview. The label's text is databound. Originally when I used the <ASP:BoundField /> I retrieved the data by using this syntax "Server.HtmlDecode(row.Cells[1].Text )" when an "onrowcommand" event is triggered. My question is what is the syntax to retrieve the text value of this label if I am using a template field in my gridview. The code for my label is below.
I am printing a GridView on a Panel using the PrintHelper sample code. Two issues arise from the result. One: I would like to print the text of one column, without the hypertext underlining. Two: I would like to print strings ("Active" or "Inactive") for one column instead of a CheckBox.
I have site where I am listing used equipment. I have a gridview that I have a image field and a template field. In the template field I have the equipment information listed via lables. I also have two link buttons for click for more details and add item to queue. What I am trying to do is when a user clicks on either link button I want to redirect the user to the equipdetails.aspx page based on the EquipID. The problem is that I am getting an errorObject reference not set to an instance of an object. I know that this error is due to the value being nothing. So I need to know how to get the specific row so I can get the correct EquipID. Here is the gridview code and codebehind.
