Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Using DropDownList in Datalist for multiple items.
- Thread starter qwert231
- Start date
qwert: See if this helps. In this case I bring together 3 fields in a dropdown list:
Private Sub Page_Load(sender As Object, e As EventArgs)
If Not IsPostBack Then
Dim NV As String = "NV"
Dim dbconnSiteRecs As OleDbConnection = New OleDbConnection( _
"Provider=Microsoft.Jet.OLEDB.4.0; " & _
"Data Source=" & Server.MapPath(".\fpdb\Sites.mdb;"
)
dbconnSiteRecs.Open()
Dim DBCommand = New OleDbCommand ("SELECT DISTINCT tblZipCodes.City, tblZipCodes.County, WebMasterSites.ZipCode & ' ' & tblZipCodes.County & ' Co., ' & tblZipCodes.City & ', ' & tblZipCodes.State As ZipInfo FROM WebMasterSites LEFT JOIN tblZipCodes ON WebMasterSites.ZipCode = tblZipCodes.Zip_Code WHERE (((WebMasterSites.ZipCode)<>'NV')) ORDER BY tblZipCodes.County, tblZipCodes.City", dbconnSiteRecs)
Dim reader As OleDbDataReader
ddZip.DataSource = DBCommand.ExecuteReader()
ddZip.DataTextField = "ZipInfo"
ddZip.DataBind()
dbconnSiteRecs.Close()
ddZip.SelectedItem.Text = "Select Zip Code..."
End If
End Sub
Private Sub Page_Load(sender As Object, e As EventArgs)
If Not IsPostBack Then
Dim NV As String = "NV"
Dim dbconnSiteRecs As OleDbConnection = New OleDbConnection( _
"Provider=Microsoft.Jet.OLEDB.4.0; " & _
"Data Source=" & Server.MapPath(".\fpdb\Sites.mdb;"
)dbconnSiteRecs.Open()
Dim DBCommand = New OleDbCommand ("SELECT DISTINCT tblZipCodes.City, tblZipCodes.County, WebMasterSites.ZipCode & ' ' & tblZipCodes.County & ' Co., ' & tblZipCodes.City & ', ' & tblZipCodes.State As ZipInfo FROM WebMasterSites LEFT JOIN tblZipCodes ON WebMasterSites.ZipCode = tblZipCodes.Zip_Code WHERE (((WebMasterSites.ZipCode)<>'NV')) ORDER BY tblZipCodes.County, tblZipCodes.City", dbconnSiteRecs)
Dim reader As OleDbDataReader
ddZip.DataSource = DBCommand.ExecuteReader()
ddZip.DataTextField = "ZipInfo"
ddZip.DataBind()
dbconnSiteRecs.Close()
ddZip.SelectedItem.Text = "Select Zip Code..."
End If
End Sub
- Thread starter
- #5
Thanks Is, actually, I am doing an ItemDataBound event that finds my Drop down, sets it's datasource, and also, sets it's Selected.
Here's the code:
Here's the code:
Code:
Private Sub dlTest_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DataListItemEventArgs) Handles dlTest.ItemDataBound
Dim _group As String
If Not IsDBNull(DataBinder.Eval(e.Item.DataItem, "mGroup")) Then
_group = DataBinder.Eval(e.Item.DataItem, "mGroup")
Else : _group = "No Group"
End If
Dim newDDL As System.Web.UI.WebControls.DropDownList
newDDL = e.Item.FindControl("ddlGroups")
newDDL.DataSource = Me.DsImgConn1
newDDL.DataMember = "Groupings"
newDDL.DataTextField = "GroupName"
newDDL.DataValueField = "GroupName"
newDDL.DataBind()
newDDL.Items.Insert(0, "No Group")
Dim _item As ListItem
For Each _item In newDDL.Items
If _item.Text = _group Then _item.Selected = True
Next
End Subqwert: This is an excellent question -- and, not being a "guru" (more technical than exp prog) I have to dig a little deeper than most.
What I see you doing here is (1) populating a listbox, and, during the binding of that listbox, you're also populating your dropdown (ddGroups), selecting those field members in the dropdown that match your listbox (setting selected=true).
An expert might drop by and clear this up rather quickly, but I find the problem interesting enough to experiment with it, just need a bit of help here.
my html looks like:
<HTML>
<HEAD>
<TITLE>test list aspx</TITLE>
</HEAD>
<form id="Form1" runat="server">
<asp:ListBox id="dlTest" runat="server" OnItemDataBound="Item_DataBound" Width="190px" Height="113px" />
<aspropDownList id="ddGroups" runat="server" width="100"/>
<br><asp:Textbox id="txtA" runat="server" />
</form>
</BODY>
</HTML>
And also, how exactly do you get your source data from:
newDDL.DataSource = Me.DsImgConn1
Haven't seen that before. The way I see your problem, one populates the list box (using the databound code) and at the same time populates the dropdown, selecting those items which equate to the listbox.
Also, using one table (tblGroups) with "ID" and "mGroups" -- so might be off here.
I hope this is not asking too much, I find this problem very interesting, and I'm sure we can nail it. However, with LV, jfrost and a few other gurus hanging out here, they could probably bring this to a fast resolution --
Hopefully this isn't bothering you too much qwert -- figured since I spoiled your introduction with my misreading the least I can do is give this a shot. Impressive stuff here qwert, good job.
What I see you doing here is (1) populating a listbox, and, during the binding of that listbox, you're also populating your dropdown (ddGroups), selecting those field members in the dropdown that match your listbox (setting selected=true).
An expert might drop by and clear this up rather quickly, but I find the problem interesting enough to experiment with it, just need a bit of help here.
my html looks like:
<HTML>
<HEAD>
<TITLE>test list aspx</TITLE>
</HEAD>
<form id="Form1" runat="server">
<asp:ListBox id="dlTest" runat="server" OnItemDataBound="Item_DataBound" Width="190px" Height="113px" />
<asp
ropDownList id="ddGroups" runat="server" width="100"/><br><asp:Textbox id="txtA" runat="server" />
</form>
</BODY>
</HTML>
And also, how exactly do you get your source data from:
newDDL.DataSource = Me.DsImgConn1
Haven't seen that before. The way I see your problem, one populates the list box (using the databound code) and at the same time populates the dropdown, selecting those items which equate to the listbox.
Also, using one table (tblGroups) with "ID" and "mGroups" -- so might be off here.
I hope this is not asking too much, I find this problem very interesting, and I'm sure we can nail it. However, with LV, jfrost and a few other gurus hanging out here, they could probably bring this to a fast resolution --
Hopefully this isn't bothering you too much qwert -- figured since I spoiled your introduction with my misreading the least I can do is give this a shot. Impressive stuff here qwert, good job.
- Thread starter
- #7
Actually, you are a bit mistaken. I am not using a listbox, I am using a DataList, which is similar to a Datagrid. There are multiple items in the DataList representing rows of a datatable. Each item (cell) containts a radiobutton, textbox, and a drop down list.
So, By using the afore mentioned code, my drop down list is correctly being populated, with the correct item being selected.
Code:
<asp:datalist CellPadding="10" id=dlTest DataMember="Photos" DataSource="<%# DsImgConn1 %>" Runat="server" BorderColor="black" BorderWidth="0" CellSpacing="0" HorizontalAlign="Center" RepeatDirection="Horizontal" RepeatColumns="3">
<ItemStyle HorizontalAlign="Center" VerticalAlign="Top"></ItemStyle>
<ItemTemplate>
<TABLE>
<TR>
<TD vAlign="top"><IMG id=repImg2 src='<%# givePath(Container.DataItem("ImageName")) %>'>
</TD>
<TD vAlign="top"><FONT face="Arial" size="-2">PHOTO ID #:
<asp:Label id="repLbl">
<%# Container.DataItem("ImageName") %>
</asp:Label><BR>
<HR>
<asp:CheckBox id=cbHide runat="server" Text="Hide" Checked='<%# DataBinder.Eval(Container, "DataItem.Hide") %>'>
</asp:CheckBox><BR>
SORT ORDER<BR>
<asp:TextBox id=TextBox1 runat="server" Text='<%# Container.DataItem("mSort") %>' Width="46px">
</asp:TextBox><BR>
GROUP<BR>
<asp:DropDownList id="ddlGroups" runat="server"></asp:DropDownList></FONT></TD>
</TR>
</TABLE>
</ItemTemplate>
</asp:datalist>So, By using the afore mentioned code, my drop down list is correctly being populated, with the correct item being selected.
qwert: After evaluating this a bit more, I think I now have the picture.
You have a datalist, populated from a table with the following fields:
1) image name
2) image path
3) checkbox
4) text value
-----------------------
5) drop down value (cd be 2d table values?)
You're setting the datalist to 3 columns, etc. (I have rendered this much). Now, the trick is to allow the dropdown list to hold various values, and you want the user to be able to select one of those values and save the new value (after having initially shown the value that "was" selected when the page was served - this value would appear in the dropdown list when the page is rendered).
I had trouble (not in VS.NET IDE) getting the OnItemBound dataset(DsImgConn1)to serve as drop down list source. In addition, I threw exceptions on trying to set the Dataset at the level of the DataList html.
It would seem that, if the values used to populate the drop down list are in a 1 to many relationship with the data list item, that a 1 to many table might serve the purpose (keying on an ID field in the main table).
I would think you could then update the tables via the dataset generated using an "..update(DsImgConn1)" type statement.
There might be other approaches - again, this is an excellent problem - could be very useful indeed.
Let me know if my premise is correct or not, if you don't mind, that the values populating the dd list are in fact independent of the various data items.
For example, DataList might look like:
Img: x.gif
Img path: "images/x.gif"
Name: Photo1
Hide: True
ddGroups: Blue
Img: y.gif
Img path: "images/y.gif"
Name: Photo2
Hide: False
ddGroups: Red
Img: z.gif
Img path: "images/z.gif"
Name: Photo3
Hide: False
ddGroups: Yellow
where ddGroups may have, e.g., 26 values (here colors), and the main table populating the data list items only 10 records(as an example).
User can select new color, which then must force an insert (update) event.
I have a few ideas on this (perhaps a diff approach). Your views? Hope I am not being too inquisitive, this is an excellent problem.
You have a datalist, populated from a table with the following fields:
1) image name
2) image path
3) checkbox
4) text value
-----------------------
5) drop down value (cd be 2d table values?)
You're setting the datalist to 3 columns, etc. (I have rendered this much). Now, the trick is to allow the dropdown list to hold various values, and you want the user to be able to select one of those values and save the new value (after having initially shown the value that "was" selected when the page was served - this value would appear in the dropdown list when the page is rendered).
I had trouble (not in VS.NET IDE) getting the OnItemBound dataset(DsImgConn1)to serve as drop down list source. In addition, I threw exceptions on trying to set the Dataset at the level of the DataList html.
It would seem that, if the values used to populate the drop down list are in a 1 to many relationship with the data list item, that a 1 to many table might serve the purpose (keying on an ID field in the main table).
I would think you could then update the tables via the dataset generated using an "..update(DsImgConn1)" type statement.
There might be other approaches - again, this is an excellent problem - could be very useful indeed.
Let me know if my premise is correct or not, if you don't mind, that the values populating the dd list are in fact independent of the various data items.
For example, DataList might look like:
Img: x.gif
Img path: "images/x.gif"
Name: Photo1
Hide: True
ddGroups: Blue
Img: y.gif
Img path: "images/y.gif"
Name: Photo2
Hide: False
ddGroups: Red
Img: z.gif
Img path: "images/z.gif"
Name: Photo3
Hide: False
ddGroups: Yellow
where ddGroups may have, e.g., 26 values (here colors), and the main table populating the data list items only 10 records(as an example).
User can select new color, which then must force an insert (update) event.
I have a few ideas on this (perhaps a diff approach). Your views? Hope I am not being too inquisitive, this is an excellent problem.
- Thread starter
- #11
Thank you. I think you're starting to see it. I have the ddList populating correctly, even selecting the correct value. Now all I need is that when they change the value and hit submit the new value is loaded into the database. As well as if they changed the checkbox and/or the textbox.
I am seeming to have a hard time using the design time created dataAdapter's Update command to update the database with the user's response. I am assuming that while the controls contain the user's data, it is not reflected in the dataset.
I am seeming to have a hard time using the design time created dataAdapter's Update command to update the database with the user's response. I am assuming that while the controls contain the user's data, it is not reflected in the dataset.
qwert: Got in late -- there was a thread a few days ago, a person was having trouble updating his odbc file using the update(DataSet) statement...I played around with it for awhile and found a declaration missing that, when put into the code, allowed the update to proceed. Do a quick search over the last 2 or 3 pages max, and see that argument -- sounds like it may be the same as you're discussing.
- Status
Similar threads
- Question