I'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'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 need to bind my dropdownlist to my dataset that is returning application specific text values. But for purposes on that page, i need to assign the value to each one starting at 0 to the number of items returned from my dataset..
Example, if my dataset only returns 1 item, the value of that item needs to be 0
[Code]....
If my dataset returns 4 items, the value of those items needs to be 0 thru 3
[Code]....
Is it possible to assign values like that to a dropdownlist from the code behind?
Using dropdown in gridview and bind the values in dropdown then based on dropdown display the value in another column.
View 1 RepliesShould i use dataset in code behind or SqlDataSource on the form designer to fill or bind a DropDownList in my asp.net page I am currently using SqlDatasource on the form and i bind the control to MySqlDatasource because i find it is very easy and to much faster but somebody told me to use dataset from code behind because of security and performance
View 3 Repliesi have 2 dropdown list and i need to create a Generic method so that I an reuse it...
View 1 RepliesI have a Gridview and two link button in that GridView , one link button click is to add edit row ( Edit ), one link button click is to select row ( Select ). I have a dropdownlist inside row which selected when i click link button Select in the gridview edit template, as of my business logic i need to show the dropdownlist only when the user clicks Edit button and when the user clicks Select button . That mean when the user clicks Select button then they clicks Edit button on the gridvview i should allow him to edit the dropdownlist (showing the value to the user through a label).
ASPX CODE
[Code].... C#
When I click Select link button , then I click Edit link button . They have errors : Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index" I don't know what error?. How to fix it
binding values with dropdownlist.i have one dropdownlist name,dropdowndiagnosticcategory..i have made one function bind_category() for binding the category values.The code for binding the values with dropdownlist is as under,here
private void bind_category()
{
string s = "Data Source=LAB1-40;Initial Catalog=MNSDaignosticCenter;Integrated Security=True";
SqlConnection con = new SqlConnection(s);
con.Open();
SqlCommand cmd = new SqlCommand
[code]...
I'm using asp.net MVC 2.0, my controller coding is,
[code]...
i need to bind this value to the drpdown list in the aspx page.
[code]...
I have a GridView control that has a SQLDataSource.
The GridView provides me with a list of musical artists (from the tblArtists)
In the Grid, I have a field, FKGenreID, that is a Foreign Key value for music Genres.
(An example of the data in that field would be "7", which upon lookup would mean Classical in the
tblGenreList table.)
What I'd like to do is add a DropDownList control that looks up the tblGenreList table and populates the DropDownList with the ID and Description from the tblGenreList Lookup table.
Now the tricky part is that if the GridView field (FKGenreID) has a value, then I'd like the corresponding Genre Description to be displayed in the DropDownList
Alternately, if there is no value for FKGenreID in the GridView, then I'd like the DropDownList to show that nothing was selected, but have the list of Genres available.
Most importantly here, when the user makes a selection, I'd like the GenreID (from the DropDownList) to be entered into the FKGenreID field in the GridView field.
My thought is that a gridview record may or may not have a value in the FKGenreID field. Either way, the DropDownList is bound to that field. The DropDownList would display a list ofGenre Descriptions for the user to select from. Upon selection, the GenreID column of the DropDownList becomes the value in for the FKGenreID field in the GridView.
Is this possible?
In case it matters, I'm using ASP.NET 4, Visual Studio 2010, and coding in VB
I have one drodownlist which show data based om textbox values...
Let us consider i have Select Name from table1 where Type IN(@typ) here @typ is textbox values here for example textbox will have some thing like this L1,L2,L3.. How to filter Name based and shown in drodownlist based on this L1,L2,L3(on textbox)..
How do I bind data from an Excel file named Book1.xlsx in Column A to a dropdownlist? I've tried like this:
Code:
connExcel.Open()
cmdExcel.CommandText = "SELECT distinct BCName From [Sheet1$] where BCName <> '' and ProjectName like 'Total%';"
oda.SelectCommand = cmdExcel
oda.Fill(dt2)
connExcel.Close()
dropdown1.DataSource = dt2
dropdown1.DataBind()
But the dropdown is filled with "System.Data.DataRowView" for all the 5 lines in the dropdown. How do I get the values shown instead of this? It must be some formatting of dt2 I think.
I have one table(tableName is getDetails and having three column ID, Name, City)
View 6 RepliesHow to bind two database field in single listbox in display field.
Is it possible ??
If yes then how can we implement it?
Here'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 a table and 7 column name.
I bind the 7 column name in one dropdownlist.
Now the problem is,how do I extract the data value in a dropdownlist?
For example,
Dropdownlist contain 7 column name
-subject_name
-subject_code
-venue
-time
-seat_no
-admission_no
-subject_id
when I click the subject_name,I want it to appear in a gridview
Example
Math|9.00-10.00|Hall|18|09090J|...
Below is my current codes which I have a problem.
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("Data Source= EN\SQLEXPRESS;" + "Initial Catalog=ms;Integrated Security=SSPI");
SqlDataAdapter adapSel;
string mySQL = "SELECT '" + dd_list.SelectedValue+ "' FROM examtimetable ";
adapSel = new SqlDataAdapter(mySQL, conn);
conn.Open();
DataSet dsSel = new DataSet();
adapSel.Fill(dsSel);
GridView1.DataSource = dsSel;
GridView1.DataBind();
conn.Close();
}
Previously I have bind 7 column name in my dropdownlist
protected void Page_Load(object sender, EventArgs e)
{
if (Page.IsPostBack == false)
{
SqlConnection conn = new SqlConnection("Data Source= EN\SQLEXPRESS;" + "Initial Catalog=ms;Integrated Security=SSPI");
SqlCommand sqlCmd = new SqlCommand("select column_name from information_schema.columns where table_name='examtimetable' and COLUMN_NAME not like '%ID'", conn);
conn.Open();
SqlDataReader ds;
ds = sqlCmd.ExecuteReader();
dd_list.Items.Clear();
dd_list.DataSource = ds;
dd_list.DataTextField = "Column_Name";
dd_list.DataValueField = "Column_Name";
dd_list.DataBind();
dd_list.Items.Insert(0, "Select Option");
ds.Close();
conn.Close();
}
}
I have the following table structure:
[code]....
The following query returns the default recordset:
[code]....
I have a gridview with 3 nested dropdownlists in one cell on edit like this:To get the exact fields when the user clicks on edit I used the following code(yes it's messy)
[Code]....
The BLLOnderhoud is a class and the getReserveInfo is used to get the Model - Brand(merk) Information.Since the dropdownlists are nested in the gridview I can't call them directly and they can't call any of my functions.And this is the problem, when I change the dropdownfield Model the Auto field wich is the last dropdown(in the picture is a typo) should be binded like in the following code:
[Code]....
But the dropdownlist onDataBound event can't call any of my functions that are in my class.So my question is how can the onDataBound event of the second dropbox trigger a function? The only thing that the function has to do is to bind the 3rd dropdownlist
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.