i want to display two columns of a table in a single dropdownlist or a listview.
india ind
pakistan pak
australia aus
these two columns should display at same control which comes from same table...
I am trying to rewrite an Access Database in to a asp.net front end and i have hit an issue that i can not find a good way round.
in the access version of the software there is a screen the displays all cusotmers and invoice information about these customers, there are currently 15 columns on the screen and we currently have around 25K customers and this will only go up. This is done using a multi column listbox i need to replicate this screen in asp.net but i spent all day on this on as yet not found a good way of do this.
the user will need the ability to select multiple customers at a time and because of the amount of data a scroll bar is a must, this is why the listbox is an ideal tool, apart from the fact the standard one in asp.net does not allow multi columns. grid lines would also be useful. I have look at a few third party multi column multi column list boxes but the only one that i have found that seems to work OBOUT's takes far to long to render 25K rows.
i have the following problem. i'd like to use a listview with paging for mulitple selection of items in a list. The selection is no problem. I do have f.i. a list which holds the key values.
List<Int64> selectedList =
new
List<Int64>();
As soons as the user makes a selection or removes a selection the list will be updated accordingly. Also hold this list info when changing pages of the listview.
[Code]....
This list can be stored either in a session or a viewstate.
My question is how can i retrieve the information of the list back into my listview and thus displaying the selection the user has made when he jumps from page to page.
Below my listview.
[Code]....
I'm trying to create a list of items with a listview (ASP.NET VB) and would like to allow a user to use 1 of 2 checkboxes (or radio buttons), to allow them to mark that record as "approve" or "delete", then once they've made all of their selections, they press a button at the bottom to action each of their requests.
So they might select 10 records to delete and 5 to approve, but I want them to run all at the same time, rather than making them edit a field for them all 1 by 1.
I'm also having a bit of trouble identifying a particular record in my codebehind, is the only way to do it through listview1.items then get the index of it, and compare it to the same sql query somehow?
Currently,below is my code.
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("Data Source= E\SQLEXPRESS;" + "Initial Catalog=k;Integrated Security=SSPI");
SqlDataAdapter adapSel;
string mySQL = "select column_name from information_schema.columns where table_name='examtimetable' '" + dd_list + "'";....
I receive an error "Incorrect syntax near 'System.Web.UI.WebControls.DropDownList'."
Our current application is working fine but when you try to misbehave like we found out that When login with same user in multiple tab with different organization(there is a organization dropdown in the master page which sets the cookie whenever it is changed.) in tab one it is org 1 and tab 2 it is org2 , cookie has the later org 2 in it but when we go back in tab1(which had org1) and save the record org 2 will be saved with the record So can some one share some sort of a checklist with us which address these types of problem.
View 3 RepliesI am having with the a full text index I am developing for a product catalog. It does all work to a degree I am just seeing some strange things happening.
From the database side I have a Products table that is being indexed on both the PartNumber and Description columns because I would like the users to be able to search either or using the search function.
Problem 1:
whenever I use multiple words in the search I don't always get the results I am looking for, this happens most notably when I am attempting to say put in a full part number (which for in this case would look like "I 10-9.2")
Problem 2:
I am not 100% sure that this is the most efficient way of completing what I am attempting to accomplish here since I have 2 columns that I need to perform the search on
Here is an excerpt from the click even when the user clicks the search button on the page:
[Code]....
And here is the search functions called from the click event to firstly check if there are any results and the second to display the results in a custom gridview:
[Code]....
I have certain columns in my DataSource such as "ID", "StartTime", "EndTime", etc.I would like to present them a bit differently in the listview.for example, I want to present the "StartTime" and the "EndTime" in ("hh:mm:ss") form, and would like to show only IDs smaller than 10.I thought about writing the code in
protected void ListView1_ItemDataBound(object sender, ListViewItemEventArgs e)
{
}
I have no problem writing the conditions in code behind, but the question is:since the ListView1_ItemDataBound event handler is fired for every column, how can I know in which one I am concerned, and so which condition to use?for example, if it is a "StartTime" then I want to have (DateTime)item.ToString("hh:mm:ss"), but if it is "ID", I only want to check if ID<5.
i have a dropdownlist for a class named person and person properties are PersonID, Name, Age.
public class Person
{
public string PersonID { get; set; } [code]....
can i list Age in same dropdownlist?
I know this might be a trivial question but I can't find how to do it...
I want to increase the space between the columns, there barely is any space, the columns are just very near each other...
I have a forum like page ( vBulletin like page). There are mainly two columns involved. User and Decription. The page looks like this
User Description
-----------------------------------------
userpic Subject
username Description
Download link
-----------------------------------------
user pic Subject
username Description
-----------------------------------------
user pic Subject
username Description
-----------------------------------------
In it , userpic, username, subject and descriptions are to be repeated every time. I used listview for this.. But the column 'download link' is to be used at once only in the first post ( of thread author). So, how can I achieve this. I am using asp.net 3.5 and sql server 2005.
How to setup a multi value dropdownlist from a list collection...
Datasource: Listcollection which contains ColorCode and Description...
how to I setup a dropdown with Colorcode-Description like ORG-orange...
then how to capture these selected value as colorcode only by removing description for update purpose...
Now I am doing like this...
ddl.datesource=list ...contains (colorcode, description)
ddl.DataTextField = "ColorCode";
ddl.DataValueField = "ColorCode";
ddl.databind();
then selected value should be like this...
ddlcolor.Items.FindByValue((DataBinder.Eval(formView1.DataItem, "colorCode").ToString())).Selected = true;
for update:
ClassA.Color= ddl.selectedvalue();
Now what I need change to in the above code to get the combination of both..otherwise i need have textbox for description which syncs with ddl..which is bit complex for my level of programming.
i have a datalist .
i used an object datasource to show data in datalist .
and my datalist have two or more repeated columns .
how i can make header for top of each column ?
not for each item and not for each row .just for each column .?
I have an .aspx page with a databound multi-select jquery dropdown. This works nicley but how can i get hold of the selected items in the code behind?
View 2 RepliesI have created a ListView that has editing enabled, the wizard generated the table with the use of textboxes but i require the use of dropdown lists for some options. I have created the dropdown list
<asp:DropDownList ID="ActionStatusTextBox" runat="server">
<asp:ListItem Value="Ongoing">Ongoing</asp:ListItem>
<asp:ListItem Value="Open">Open</asp:ListItem>
<asp:ListItem Value="Closed">Closed</asp:ListItem>
</asp:DropDownList>
The drop down list generates successfully but doesn't submit and enter itself in the databse.
<%# Bind("ActionStatus") %>'
The above snippet needs to used somewhere in order to bind the data but which parameter does it need attaching to to pass the data?
I am trying to Fill my dropdownlist with two column as textfield and 1 column as value field.
dropdownlist2.items.add(new listitem(??? , ??? )
I used Foreach and many many options , I can assing the textfield easy but value I can't
Dim db1
As
New TripsLinqDataContextDim
listhotel = From th
In db1.Triphotels _
Where th.TripCountryID = cid _
Select
CStr(th.TripHotelID) +
" - " + th.City.TripCityName +
" - " + th.TripHotelName
ListBox1.DataSource = listhotel
ListBox1.DataBind()
This will list hotelname and id and city , but I need to set the Triphotelid as value of item in dropdownlist
I want to bind data(For ex: Employee name, Employee ID from Employee) to a dropdownlist and the data should be displayed in dropdownlist as two columns. I don't want to separate this columns by using any special characters like | or '-'. I want to display them as different columns in a dropdownlist.
How can i achieve this using .net and the data i need to retrieve using SQL server 2008.
How do I bind all my columns name in my database in a dropdownlist?
View 8 RepliesCan a dropdownlist control show 2 columns and then populate two different target textboxes based on its selection?
I need something like this:
A dropdownlist showing 2 columns, for example:
A USA
B England
C France
D Spain
Then, if B-England is selected, I need "B" to be moved to Textbox1 and "England" to be moved to Textbox2.
I have various difficulties handling dropdownlist in listview itemtemplate.Hopefully, resolving this example will help me understand how to make things work.I need to do several things upon DropDownList1_SelectedIndexChanged.(1) Fetch row index of listview then set the row as listview selected, or vice versa, in which dropdownlist was changed.(2) Fetch text of namelabel in that selected listview row.(3) Fetch selected text of dropdownlist in that selected listview row.
[Code]....
At the moment...(1) Label1.Text = ListView1.SelectedIndex always shows '-1' regardless in which row dropdownlist is selected/changed.(2) Label2.Text = NL.Text pops 'Object reference not set to an instance of an object'.(3) Label3.Text = DDL1.SelectedItem.Text pops 'Object reference not set to an instance of an object'.
I have a database table containing scripts for plays/dramas. The scripts can be categorized under 'Theatre and Education', 'Plays for Young People' or both (by using bools to determine whether they belong to said categories);
scriptID: int
theatreAndEducation:bit
playsForYoungPeople: bit[code]....
I have an emergency request that I need to sort it out very quickly as I did not notice it early :(.
I have a dropdownlist, the contnet in the gridview (sqldatasource connection) changes based on the value the user slects, say I have play1, play2 from the dropdownlist, I would like to show column1, column2 and column3 with user selects play1; show column4, column5, and clomn6 when use selects play2; the datatable actually includes all 6 columns.
I understand that I need to use something like RowCreated event, and I need to set up condition based on the dropdownlist value, but I dont really know how to.
I have a listview that I am trying to initiate the connection string in codebehind. When I do it, I get the following error:The ConnectionString property has not been intialized.I know that I am successfully creating the connection string in codebehind because all other controls populate correctly from the dsame database.I do not get an error if I initiate the connection string in the html code.
View 6 RepliesDatabinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control. error when I place a drop down list into my instert item template of my listview, but I have the exact same control in my edit view and it works fine, any reason I am getting this error? I know what it means but why would it work in the edit mode, and not the insert mode?
View 2 RepliesI have this code:
aspx
[Code]....
aspx.cs
[Code]....
Why can I not view anything in my dropdown list? It is totally blank