i'm binding data to ddl from database.i'm selecting one column from database table to bind.In that column there may be items with same name.but when selecting in ddl there must be no same values.
View 4 RepliesI'm trying to bind a dataset (where the data is coming from a webservice) to a dropdownlist; the problem is that I'm getting duplicates in the list... how can I display distinct values only:
[Code]....
I have one table(tableName is getDetails and having three column ID, Name, City)
View 6 RepliesHere's my current table data.
AccountNumber Product
00505871 Product1
00505871 Product2
00503297 Product3
00900004 Product4
00505871 Product3
00514884 Product3
00503297 Product2
00505871 Product1
How can I achieve following result.
AccountNumber ProductString
00505871 Product1,Product2,Product3,
00503297 Product2,Product3
00900004 Product4
00514884 Product3
I have a datatable dt with 4 columns. I want to retrieve only distinct values from column1 of datatable.
How can I achieve this using c# code?
This is my query
Dim s_Person = From Person In db.People Join ProspectStatus In db.ProspectStatus On Person.Id Equals ProspectStatus.Prospect_ID Where (Person.Organization_ID = s_Organization_ID)Select Person.
I only want to return DISTINCT values of Person.ID. Right now, it returns the same person multiple times because there are several entries in the status table.
Dim s_Person = From Person In db.People Join ProspectStatus In db.ProspectStatus
I have a database that is filled with documents. In the database there is the documents id, name and version. Two documents can have the same name and id but are seperated by different versions.For instance there can be two entries, id: A44, name: Dilbert was here. But they are version A and B.When retrieving these to a listview I wish to limit the documents shown to only one version. Doing so means that I am only to show one document with the same id. I only get the id and name to show in the listview so I thought that distinct might do the trick. But since the name can change throughout different versions this was no good.Basically I wish to retrieve all documents but with distinct id. How do I achieve this?
View 10 RepliesI have a datatable which has been dynamically generated from FoxPro tables using a UNION Select statement. e.g.
SELECT * FROM x UNION SELECT * FROM y UNION SELECT * FROM Z ORDER By v_alue1
This produces a datatable with about 100 rows, each containing many fields, one of which is c_olor. From this datatable, I would like to select the distinct colors and then output in a dropdown.
I have a public class Color which just has one property which I can then use as the DataTextField and DataValueField for the dropdownlist
[code]...
However this never results in the distinct colors.
I have searched and searched for what I am looking for, and this seems to be one of the methods to produce a distinct set of results, but this and the others do not work.
My reasoning behind getting the colors this way, is that I need to get various other distinct values from the same UNION SELECT datasource, so would just do one DB call, cache the results, and then just used this cached datasource to retrieve all my distinct values.
I have a table 'tbl' and a column 'col'. The elements are like 1,1,2,2,2,3,4,4. Now I want to show two columns one is the one will contain the distinct values from 'col' like 1,2,3,4.... and second will contain the count for each of them like for above case it will be 2,3,1,2.
View 1 RepliesI have distinct value combinations of two values.i cannot achive in sql why beacause ,here crystal report having grouping options and output will going to print in a foote..
Sample format crystale report
SNo Name TranID
1 Guru 18
2 Inbaa 19
3 Guru 20
4 Inbaa 19
------------------------------------
Total Name : 3 Tran ID :3
------------------------------------
Name inbaa with Tran ID 19 is duplicate ..
I have the following table structure:
[code]....
The following query returns the default recordset:
[code]....
As I kept my fetched datatables into session and accessing it on another page there I am
wroking on datatable to fetch only distinct values of particular column to assign to dropdown list.
I would like to select a distinct query based on three fields and display the rest of the fields. For example,
I have firstname, lastname, address, city, state and zip, but I only want to use the distinct on these fields first and last name. However when i use the distinct function I get a distinct on all the selected rows. I just want to distinct firstname and lastname and display the other fields. for example,
Mary Smith New York
Mary Smithy New York
Mary Smith Maine
I would like the result to be:
Mary Smith New York
Mary Smithy New York
I don't care about Mary Smith Maine, because i am only using the distinct for "Mary Smith" firstname and last name and showing the city.
Using dropdown in gridview and bind the values in dropdown then based on dropdown display the value in another column.
View 1 RepliesHow to swap ddl's selected value on buton click.E.g User has Selected One from ddl1 and three from ddl2 then when the user clicks the Button the values should be swapped.
User Selected
DD1 DD2
One Three
After Swap button click
DD1 DD2
Three One
<asp:DropDownList ID="ddl1" runat="server">
<asp:ListItem>One</asp:ListItem>
<asp:ListItem>Two</asp:ListItem>
<asp:ListItem>Three</asp:ListItem>
</asp:DropDownList>
[code]...
I have a requrement to create multicolumn dropdown list.
It must look exactly like the one given below
i ran one query to imoplement this functionality in SQL Server Stored Procedure
[code]....
The seperator bar is not in uniform place,so it is not looking like a column seperation
I see that dropdownlist has an "items" property to get the list of displayed items for a dropdown, but it doesn't seem to have an equivalent property for getting the "values" associated with the items. For example, I may have a dropdown that displays "High", "Medium" and "Low", but returns values of "H", "M", "L". How can I easily get that list of HML?
View 5 RepliesI have a dropdownlist which display the price of products which is retrive from database, how do i mulitply if the user entered the quantity in the textbox. I keep getting error input string was not in a correct format.
Here is my aspx code:
<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="Order.aspx.cs" Inherits="Order" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">[code]......
I have a problem I have been googling the entire day and still have no soloution. I have a detailsview with 2 dropdownlists. Fisrt one is ddlCaregory. Second is ddlSubCategory. The value is passed from the first ddl to display the SubCategory linked to ddlCategory. Both ddlCategory and ddlSubCategory are Templatefields. This is also in VB.
The Details view has a sqlDataSource (sdsApplicants), ddlCategory has a Datasource (sdsCategory) and ddlSubCategory (sdsSubCategory). ddlCategories lists the data returned from sds Categories and save any changes to sdsApplicants. I can get ddlSubCat to display the correct SubCatagory bases on ddlcategory sesection but as soon as I try bind it to sdsApplicants I get the following error
'ddlSubCategory' has a SelectedValue which is invalid because it does not exist in the list of items.
Parameter name: value
I have hard coded and added items to dropdownlist ie teamsize as 1,2,3 like that.When i load this dropdownlist for edit/update i get duplicate values like this
1
1
2
3
4...
How do i eliminate this duplicate values?
Let's say I have DropDownList ddlRooms bound to the datasource which returns list of available rooms from table tblRooms. On the other hand I have users, and their info is stored in table tblUsers. Using FormView frmUsers can be inserted, edited and updated... frmUsers is be bound to separate datasource. To each user, I would ilke to assign a room, so the value of txtUserRoom will be populated based on the selected value from ddlRooms. How can i pass the selected value of ddlRooms to txtUserRoom while keeping txtUserRoom stil bound to user datasource? Do I need two separate fileds or can i just put value of ddlRooms into datasource user?
View 3 RepliesI have a dropdownlist which gets the data from the oracle database, the values that contains quotes example "Apple's" or "Website's" or not getting seelcted from the list except these values remaining values have no issues.
View 3 Replies my c# web application populating dropdowns with datas at run time... i.e my web form contains 3 dropdowns and one gridview.. dropdown1 populate with 'pgmtitle' which is fetch from database,when user select one item-pgmtitle from dropdown1,participants(BadgeNo,Name)
of that pgm will be populated in gridview. when user click on the participant badgeno,dropdownlist3 will poputated with recieving officers name.. wen user select one of the recieving officer from dropdown3,his designation is dispalyed in a textbox,and dropdon2
will populated with feedback sentdate... this is my requirement... and my pblm is, when i choose another pgmtilte(say pgmtilte2) from dropdownlist1,previous value associated with(pgmtilte1) appended with dropdown2 and dropdown3.. here is my HTML code:-
[Code]....
I have a dynamically created dropdownbox and image.. I want the result such
View 7 Repliesi have created a dynamic dropdownlist. i need to get the selected values from the list and store it in my sql database. i am new to asp.
View 5 Replies