Forms Data Controls :: How To Combine Some List Items Together
Jan 8, 2011
just want to have a quick question about the value of dropdownlist listitem. I have a gridview which has its datakey value linked to a dropdownlist. In the dropdownlist I have many listitems. So I decided to combine some list items together. Originally, the values of the items are 1,2,3,4,5,6,7,8. But I want to have only 5 items by combining 5,6,7,8 into one listitem called "Others." So if the listitem "Others" is selected, the gridview will show all the records that have value 5 or 6 or 7 or 8. Is it possible? How can that be done?
I hope I made myself clear. Any question, I am happy to clarify.
I have al list that I would like to populate with new items from a textbox. But when I add a new Item it overwrites the old list with te "new" list. I declared the list outside the method so I don't know what the problem is.
This should give me the friends of the user currently logged in in the Repeater, but gives me an exception on the runtime that an instance needs to be initialized, can you please suggest a solution...
Also, what should be the value of the NavigateUrl property of a Hyperlink in an ItemTemplate if the url is:
"http://domain.com/viewprofile.aspx?id=" + 'THE UserID property of the current element in the list'
Is it possible to assign a colour to a drop down list item based on it's value?For example: I have a drop downlist where I've got a bunch of items that have integer
values. I would like to highlight the items with values in 1000s in grey.
I've boldified the items I'd like to be highlighted in grey ,For added complexity I need to highlight the items with values 1000 in a light shade of gray and items with values 2000 in a darker shade of grey. I'm using Web Developer, and C#
I have a DropDownList inside the EditTemplateItem (if the user clicks edit) in a GridView.The DropDownList receives all available rows from the database. My problem is,if the user clicks Edit in the GridView to edit a row and opens the DropDownList Box the original item is not selected but the first one.That means the items are sorted. Have someone an idea how I can solve this issue that the right item / the original is selected if I change to edit mode of the grid view?
using asp.net 4 and vs 2010 I have a listview that displays data from a database. I have to configure it to display all column data where present, however, not all columns have data, with the result that blank spaces get rendered where this data would normally be displayed.
The code:
[Code]....
So, for example, some of the individuals that exist in this table might no longer be associated with a specific department, institution or have data in the "Address2" column.
On my website, registered users can make a profile about themselves suchas name, Favoirite color, hobbies, etcI have a DataTable called User which hold this information.also there are other datatables for Hobbies and Colors which list all possible options.To let the user update their choices I have a FormView in Edit mode on the aspx page whichis binded to the UserTable with a GetProfileByUserId Method and objectdatasource.
Within the formview, i have added drop down lists that are binded to the hobbies and Colors tables so they can edit their previous selection.On clicking Uodate update formview calls an Update Method that adds new selections to the User databaseNow I have two questionsIs it possible to show in the dropdown list the selected value that the User has already made?If the user only changes hobbies and not colors when they click update will a null value be passed into the data table for colors that replaces their previous selection?
I have a dropdown list inside gridview which has a object data source and I am adding the list items as true, false which stores in the database table as a bit value. Even if i am addin the values 1 and 0 to the drop down list, its throwing the below error'grdDebug' has a SelectedValue which is invalid because it does not exist in the list of items.Parameter name: value My code to add the dropdownlist with list items are as below
Working in Access, I need to create a view which takes values from two different records in another table and puts them on one row in the view. I'm having a hard time doing this since both row items come from the same field in the original table (actually in this case, using views instead of tables).
I have two queries I try to join together, but come up with the wrong results: vwComp1:
SELECT q.CompStatus, q.EQID, c.CompsID, q.LastName, q.FirstNameFROM _EQ AS q, Comps AS cWHERE q.CompStatus=1 AND c.CompsID=q.CompID vwComp2: SELECT q.CompStatus, q.EQID, c.CompsID, q.LastName, q.FirstName FROM _EQAS q, CompsAS c WHERE q.CompStatus=2 AND c.CompsID=q.CompID vwAssignment: SELECT vwComp1.*, vwComp2.* FROM vwComp1, vwComp2
This does fine in the vwComp2 part of vwAssignment, in the sense that it displays the correct name information, etc.; but for vwComp1, it just takes the name and other fields from the first row of vwComp1 and repeats it on every row of vwAssignment. This is really strange because vwComp1 and vwComp2, when displayed individually, each correctly puts the names in each row; something like this:
Bob White Rhonda Red Bob White Freda Freschetta Bob White Linda Lime Bob White Jean Green
--when it should read something like this: Bob White Rhonda Red Fred Redd Freda Freschetta Jim Brown Linda Lime Rob Black Jean Green
I have code when I click on button I want show the value of selected List item in textbox but following code gisplay the item in alert,,
<html><script>function getValue(){ var x=document.getElementById("sel");for(var i =0; i < x.options.length; i++){if(x.options[i].selected ==true){ alert(x.options[i].value);}}}</script></head><body><selectmultiple="multiple"id="sel"><optionvalue="volvo">Volvo</option><optionvalue="saab">Saab</option><optionvalue="opel">Opel</option><optionvalue="audi">Audi</option></select><inputtype="button"value="Get Value"onclick="getValue()"/></body></html>
How to solver this error? I am getting error for "DropDown"
Error: 'DStation' has a SelectedValue which is invalid because it does not exist in the list of items.Parameter name: value on line: DStation.DataBind();
My .cs code is below
string CommandText = ("select distinct StationName from stations where DeletionDate is null"); DStation.DataSource = DataManager.DatabaseManager.GetOrCreateConnection (DataManager.DatabaseManager.ConnectionType.MySQL).GetData(CommandText); DStation.DataTextField = "StationName";
I got this error when select a row from a grid view to update
'ddl_ctegOf_Product_update' has a SelectedValue which is invalid because it does not exist in the list of items.Parameter name: value 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.ArgumentOutOfRangeException: 'ddl_ctegOf_Product_update' has a SelectedValue which is invalid because it does not exist in the list of items.Parameter name: value
Source Error: Line 265: txt_prodID_update.Text = gridTo_updateFrom.SelectedRow.Cells[1].Text; Line 266: txt_prod_name_update.Text = gridTo_updateFrom.SelectedRow.Cells[2].Text; Line 267: ddl_ctegOf_Product_update.SelectedValue = gridTo_updateFrom.SelectedRow.Cells[3].Text; Line 268: txt_cateIn_hardCopy_update.Text = gridTo_updateFrom.SelectedRow.Cells[4].Text.Replace(" ", ""); Line 269: txt_prodID_update.ReadOnly = true;
The code of update:
private void PopulateDropDownList() { string constr = ConfigurationManager.ConnectionStrings[1].ConnectionString; using (SqlConnection con = new SqlConnection(constr)) { using (SqlCommand cmd = new SqlCommand("SELECT CategoryProd_ID,Cate_Pro_Name FROM CategoryOfProduct", con)) { using (SqlDataAdapter da = new SqlDataAdapter(cmd))
how to combine two table from database into one gridview?
is it possible to add in a textbox into gridview?
why my checkbox is not showing in the gridview. this is the UI and the code. the UI display the data i retrieved from the database but why is the image and the checkbox not showing?
I would like to use the IEnumerable function Intersect() to combine a few list and get the similar integers from each list. The problem I'm faced with is that I don't know how many list I will need to compare.
Here is an example:
A{1,2,3,4} B{1,2,3} C{1,2}
results = A.Intersect(B).Intersect(C)
This works great, but the next time around I may have a D{1,2} next time I come across the function.
I'd like to use the Intersect method, but I'm open to new ideas as well.
I have a couple of things that are not working with my Gridview:
1) I've managed to display 3 columns in one column (see code above) but the data is separated by commas, how can I display each data item in separate rows.
2) How can I make the data unique, as I have added the distinct command which I configured in my SQL data source
3) I need the rows to not display nulls, but at the moment it isn't displaying the row if one of the columns is null?
I'm designing my own custom control that contains a .NET dropdownlist. What I'm wondering is if it is possible to populate my dropdownlist with listitems placed in a placeholder? For example:
This doesn't work because the DropDownList control only allows ListItems as child controls. But, I want to do something similar to this so when the user includes my control on a page, they can do something like this:
