Forms Data Controls :: Replace Value Retrieved From Storedprocedure With Querystring Paramater?
Feb 7, 2011
I've got a request to redesign the web application to allow support for up to 3 users (before there was data only for one people on page). Since I don't want to build entire page again I wonder how is possible to replace value which is for example:
[Code]....
with value retrieved from querystring?
Users are displayed on page in row: querystring value ID(for example 123), QS value ID2(for example 231), QS value ID3(for example 343).
Users are all stored in one row of the same table. If second user is selected then value of his/her should be taken as value of ID.
I'm using quite a lot <%# Eval ("ID")%> on my page and I don't want to replace it with some object but just overwrite it's value according to querystrings values.
I hope this doesn't sound too complicated as the real problem is fairly easy but don't have ideas how to deal with it. I've thought I can put to replace the value retrieved from SP but I can only change parameters. And ID is not select parameter.
I have a problem that if I pass a string that contain + in a query string and try to read it , it get the same string but by replacing + with empty charFor example if i pass query like ../Page.aspx?data=sdf1+sdf then in page load I read data by data = Request.QueryString["data"] it will get as below data ="sdf1 sdf" I solve the problem by replacing any empty char with + .. But Is there any problem that cause that ? and Is my solution by replacing empty char with + is the best solution in all cases?
a simple way to filter SQL data when it is retrieved by a GridView control?
Among the various applications I need to create are selecting records based on user inputed criteria (via a DropDownList), and excluding records that have null values (which I need to allow in my database) in certain columns.
In one grid there is only one column and entries are 100+, all entries are hyperlink entries, but the gridview does not look nice with one column and 100+entries, is there any way I can split that entries in 3-4 coluns to look even.
The following code works well as long as I pass a querystring value to the datalist.
Private Sub BindGrid() Dim id As Integer = Integer.Parse(Context.Request.QueryString("id")) Dim strConnString As String = ConfigurationManager.ConnectionStrings("Conn").ConnectionString Using con As New SqlConnection(strConnString) Using cmd As New SqlCommand() cmd.CommandText = "select Id, Name from tblFiles where Id=@Id"
[Code] ......
However, the page errors with the message "Value cannot be null." if I don't pass a value. I know that DataList does not have an EmptyItem Property like a Gridview control. I do not want the page to error if I don't pass a value. Need info to deal with empty values in a datalist.
Most websites have pointed me to this code to use:
The 'list' throws an error. The error is "Too few type arguments to 'System.COllections.Generic.List". I am not sure if the code is written in C# and that is what is causing the error. It seems that it should work but I can not figure out the 'list' error.
I am using VS2008 and oracle 10g ODP.Net. The oracle database that I used in the connection is working and tested it using sql plus.The connection string when used in a GriDView works perfectly. Now when I created a new listview control with the same connection it gives an error.Database schema could not be retrieved for this connection. Please make sure connection settings are correct and the database is online
Object reference not set to an instance of an object at VSDataObjectSupport (478,6)
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 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'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 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'.
Short story: what can I replace asp:Menu web control so submenu items can be viewed in (a) Safari (iPad) and (b) IE8.0 NOT in compatible view. Need simple solution so non-Java script dummy can do.
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'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)); } } }
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
