Web Forms :: Dropdown List Is Not Retrieving Data?
Aug 9, 2010
I have a photo website with a login page. (It is an exercise out of a book: Scott Mitchell's "ASP.Net in 24 hours".) After a user logs in he can go to another page and manage photo categories. That page works. I have two users that have photo categories setup in the database.
There is also a page where a user can add photo images. This is the page that is giving me problems. It has a name and description field. (The functionality for uploading a photo is next in the book. It is not on the page yet.) The page also has a dropdown list that is supposed to be populated by the category names of the logged in user. This is the control that is giving me problems. It is not being populated by the logged in user's Category names.
The two database tables used are pretty simple:
[code]....
There are two SQLDataSources on the page:
One is for inserting new photos. The other retrieves the Categories of the current user. The page has a DetailsView with the Photo's Title and Description. There is also a dropdown list with the Category names. It is aa InsertItem Template in DetailsView.
When the page opens, the current UserID is retrieved and put into a Hidden Field. It is then used to retrieve the Category Names by the second SQLDataSource. I have gone through the book's steps a few times now. The dropdown list is not being populated. I am not getting any errors.
How can I track down why the dropdown list is not being populated?
Both of my users have Category values set up in the database. So, the dropdown list has values that should be appearing.
Here is the source code:
[Code]....
View 3 Replies
Similar Messages:
Oct 10, 2010
I am stuck at this point "Displaying a dropdown list of Categories with a --None -- Option. I want the gridview control to display 2 dropdown list one in read-only mode and the other in edit mode. When a record is in read-only mode, the dropdownlist's enabled property will be set to false."When it's on a read-only mode, it doesn't display the selected Category. it shows but the "No Category". When i click on edit to edit or change category, it doesn't display the selected category.
The example is given below( I am reading the book Sams Teach yourself ASP.NET 2.0 by Scott Mitchell. page 628)
<asp:Label ID="UserIdValue" runat="server" Visible="False"></asp:Label>
<asp:SqlDataSource ID="picturesDataSource" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT * FROM [Pictures] WHERE ([UserId] = @UserId) ORDER BY [UploadedOn] DESC"
DeleteCommand="DELETE FROM [Pictures] WHERE [PictureID] = @PictureID"
InsertCommand="INSERT INTO [Pictures] ([UserId], [CategoryID], [Title], [Description], [UploadedOn]) VALUES (@UserId, @CategoryID, @Title, @Description, @UploadedOn)"
UpdateCommand="UPDATE [Pictures] SET [UserId] = @UserId, [CategoryID] = @CategoryID, [Title] = @Title, [Description] = @Description, [UploadedOn] = @UploadedOn WHERE [PictureID] = @PictureID">
<DeleteParameters>
<asp:Parameter Name="PictureID" Type="Int32" />
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name="UserId" />
<asp:Parameter Name="CategoryID" Type="Int32" />
<asp:Parameter Name="Title" Type="String" />
<asp:Parameter Name="Description" Type="String" />
<asp:Parameter Name="UploadedOn" Type="DateTime" />
</InsertParameters>
<SelectParameters>
<asp:ControlParameter ControlID="UserIdValue" Name="UserId" PropertyName="Text"/>
</SelectParameters>
<UpdateParameters>
<asp:Parameter Name="UserId"/>
<asp:Parameter Name="CategoryID" Type="Int32" />
<asp:Parameter Name="Title" Type="String" />
<asp:Parameter Name="Description" Type="String" />
<asp:Parameter Name="UploadedOn" Type="DateTime" />
<asp:Parameter Name="PictureID" Type="Int32" />
</UpdateParameters>
</asp:SqlDataSource>
<br />
<asp:SqlDataSource ID="categoriesDataSource" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT [CategoryID], [Name] FROM [Categories] WHERE ([UserId] = @UserId)">
<SelectParameters>
<asp:ControlParameter ControlID="UserIdValue" Name="UserId" PropertyName="Text" />
</SelectParameters>
</asp:SqlDataSource>
<br />
<asp:SqlDataSource ID="maxPictureIDDataSource" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT MAX(PictureID)
FROM Pictures
WHERE UserId = @UserId">
<SelectParameters>
<asp:ControlParameter ControlID="UserIdValue" Name="UserId"
PropertyName="Text" />
</SelectParameters>
</asp:SqlDataSource>
<br />
<asp:Label ID="cannotUploadImageMessage" runat="server"
Text="The photo could not be added to your album either because you did not specify a file to upload or the file specified was not a JPEG image with the file extension .JPG"></asp:Label>
<br />
<asp:DetailsView ID="dvPictureInsert" runat="server"
DataSourceID="PicturesDataSource" Height="50px" Width="125px"
AutoGenerateRows="False" CellPadding="4" DataKeyNames="PictureID"
DefaultMode="Insert" ForeColor="#333333" GridLines="None">
<AlternatingRowStyle BackColor="White" />
<CommandRowStyle BackColor="#D1DDF1" Font-Bold="True" />
<EditRowStyle BackColor="#2461BF" />
<FieldHeaderStyle BackColor="#DEE8F5" Font-Bold="True" />
<Fields>
<asp:TemplateField HeaderText="Picture">
<InsertItemTemplate>
<asp:FileUpload ID="imageUpload" runat="server" />
<asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server"
ControlToValidate="imageUpload" Display="Dynamic"
ErrorMessage="There was no file selected" ValidationGroup="PictureAdd"></asp:RequiredFieldValidator>
</InsertItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Category" SortExpression="CategoryID">
<EditItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("CategoryID") %>'></asp:TextBox>
</EditItemTemplate>
<InsertItemTemplate>
<asp:DropDownList ID="pictureCategory" DataSourceID="categoriesDataSource"
runat="server" DataTextField="Name" DataValueField="CategoryID"
SelectedValue='<%# Bind("CategoryID") %>'
Visible='<%# Bind("CategoryID") %>' AppendDataBoundItems="True">
<asp:ListItem Selected="True" Value="">-- Select Category --</asp:ListItem>
</asp:DropDownList>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Bind("CategoryID") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Title" SortExpression="Title">
<EditItemTemplate>
<asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("Title") %>'></asp:TextBox>
</EditItemTemplate>
<InsertItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("Title") %>'></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server"
ControlToValidate="TextBox1" Display="Dynamic"
ErrorMessage="you must provide a name for the title"
ValidationGroup="PictureAdd"></asp:RequiredFieldValidator>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="Label2" runat="server" Text='<%# Bind("Title") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Description" SortExpression="Description">
<EditItemTemplate>
<asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("Description") %>'></asp:TextBox>
</EditItemTemplate>
<InsertItemTemplate>
<asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("Description") %>'
View 2 Replies
Jan 17, 2011
I have a databound dropdownlist and have a problem with the default value it selects.When I attempt to edit a record the dropdownlist shows the first value in the list rather than the current value. I want the dropdown list to display the current value.
I'm sure this is very simple but I'm very new to ASP.NET.
I'm using .NET version 4.
View 4 Replies
Nov 3, 2010
I have 2 drop down lists.I have a very simple dropdown list #1 that diplays a title and holds an id value which is a GUID.I know it is getting this value and sending this value as I tested sending it to a label.I have the dropdown list #1 to autopostback to dropdown list #2 that "Is supposed to get" another title and value based on the GUID value of the first dropdown list. for some reason it wont return anything. I have done 100's of these but never based off a guid value.I assume the value needs to be converted to guid before selecting it in the second dropdown list.How can I do this? or is there something I am missing?
View 9 Replies
Sep 8, 2010
Does anyone know how to do this so when I select something the 1st dropdown and the 2nd one becomes visible and populates list from a Select statement. I really need help on how to do in an aspx and not on the code behind page.
View 12 Replies
Jun 12, 2010
I Have the gridview control with 2 dropdown list and 2 text boxes,When the textbox chnaged event happen 1 row will create and the dropdown back to initial values( its not retaining the selected values),I am binding the control after text changed method,Is there any properties needs to be set or any other way we can retain the values in postbacks?
View 4 Replies
Mar 15, 2010
[Code]....
here i include my coding...
when i compile it..it show the data wit the noted data..
my question is...i want use dropdown menu to select the "category"...
how to use it? lets say i choose "Furniture" the output should be the data under Furniture category
View 5 Replies
Aug 4, 2010
one drop down list cointains all country list ,when we select thet particular country the other drop down list has to show all the states in that country ,this is what i am thinking to do ,can some one guide me how to do ,and give you give some reference links
View 3 Replies
Apr 22, 2010
I have a web form where there are couple of DDL's; DDL1 and DDL2 respectively. I want the DDL2 to be populated based on the selection made in DDL1. From the DDL1, I just want to extract the first three digits of the value selected in DDL1 and use it in the WHERE clause of SQL query which is used to generate DDL2.
My prob is that I am not able to extract the first three digits out of DDL1 and use it in the WHERE clause of DDL2. I have pasted all my code below:
Protected Sub DropDownList2_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs)
Dim ddl1Value As String = DropDownList1.SelectedValue
ddl1Value = (ddl1Value.Substring(0, 3))
SqlDataSource3.SelectParameters(0).DefaultValue = ddl1Value
SqlDataSource3.DataBind()
End Sub
Code for DDL2:
<asp:DropDownList ID="DropDownList2" runat="server" CssClass="style29"
DataSourceID="SqlDataSource3" DataTextField="IXC_Vendor_Name"
AutoPostBack="True" AppendDataBoundItems="true"
DataValueField="IXC_Vendor_Name" Height="24px" Width="338px"
onselectedindexchanged="DropDownList10_SelectedIndexChanged">
<asp:ListItem Selected = "True" Text = " " Value = " " ></asp:ListItem>
</asp:DropDownList>.......
View 8 Replies
May 3, 2010
I have a drop down list . In that list i have to show more then 3000 value comes form SQL Server database
Becasuse of huge amount of data the drop-down list preforms slowly.... is there any way so that the dropdownlist performs faster.
View 3 Replies
Aug 13, 2010
I will try to keep the question short:
1. I am new to ASP and I can not get this to work:
2. I am Using a <asp:DropDownList in a <InsertItemTemplate> in a <asp:ListView
3. The dropdownlist during insert does not get polulated (it is empty) while the same construction and same datasource works in the edittemplate: <asp:DropDownList in a <EditTemplate> in a <asp:ListView
4. I noticed that filling the dropdownlist with a <asp:ListItem works; the insert list is populated. (not usable for me) In both cases I use the same datasource from the code behind like this : Edit:
<asp:DropDownList ID="DropDownStartday" runat="server" SelectedValue='<%# Bind("startday") %>'
DataSource="<%# GetDataSourceStartDay() %>" DataValueField="daynum" DataTextField="dayname"
Insert: (with or without Selectedvalue: NoJoy)
<asp:DropDownList ID="DropDownStartday" runat="server"
DataSource="<%# GetDataSourceStartDay() %>" DataValueField="daynum" DataTextField="dayname"
View 4 Replies
Jul 7, 2010
I am not able bind data to the dropdownlist from database. following is code.
DataTable dtModule = BO.GetBizModel_DDL(ServiceID);
if (dtModule != null)
{
ddlBizModl.Items.Clear();
ddlBizModl.DataSource = dtModule;
ddlBizModl.DataTextField = "BIZ_MODL_NM";
ddlBizModl.DataValueField = "BIZ_MODL_ID";
ddlBizModl.DataBind();
}
dtModule.Dispose();
View 3 Replies
May 11, 2010
I have a gridview with edit and save buttons.
code
<asp:TemplateField
HeaderText="Job Title"
SortExpression="Job Title">
[Code]....
The above code is not working what should I change to make it work?
View 3 Replies
Mar 9, 2011
can i enter a choice that is not in the dropdown list? Just like a combo box, there is a list of item but a user can still have an option to enter in the textbox. does a dropdown list also have this function? or if not is there a workaround?
View 3 Replies
Feb 17, 2010
Clicking the label of a drop down list, re-sets the selected value to the first item in the list. This has a history of causing data entry problems when users accidently click on the label.
In the below example ddlContactType has a selected value as 'PRIMARY' and whenever i click on the lblContactType Text, the dropdown box Selected value is changing to "Select One" Text.
How to prevent this one. It should be on PRIMARY Only.
<p>
<tr> <td ><asp:Label ID="lblContactType" Font-Bold="true" Text="Contract Type: *" ForeColor= "red" runat="server" AssociatedControlID="ddlContactType"></asp:Label> </td> <td > <asp:DropDownList runat="server" ID="ddlContactType" DataSourceID="SqlDataSource2" AppendDataBoundItems="true"
DataTextField="TYPE" DataValueField="ID" SelectedValue='<%# Bind("CONTACT_TYPE_ID") %>'>
<asp:ListItem Text="Select One" Value="0" Selected="True"></asp:ListItem>.......
View 4 Replies
Nov 25, 2010
when i am selecting an item in dropdown list datasource is bind and after another selection it is bind again .but i want it bind only once.
View 4 Replies
Jan 7, 2010
I am using gridview for my application, in the grid i am using dropdown list for two columns ,It's working when i run my application but when i am edit application ddl can't show the editable data ( it show only select).And one more thing that two columns are interrelated , one ddl(Itemgroup) is connected with(ItemName).
View 2 Replies
Mar 24, 2011
I have a boolean gender value in my database. via a linqdatasource I would like to display this in a gridview template.
In the Edit template I would like to use a dropdownlist with male and Female listitems. But how should I bind this to my boolean data value?
View 2 Replies
Dec 6, 2010
i want my dropdown list or my list box, load data from my database .i use visual studio 2008 and sql server 2005.
View 3 Replies
May 18, 2010
i would like to know how to load the dropdown list in the Gridview edit with the dropdown list values from the database
View 3 Replies
Dec 3, 2010
I want to access a dropdown control value of each list item as soon as it is created. I tried with ItemCreated and ItemDataBound events but I am getting null contro when I try to access control as shown below:
ListViewDataItem item = (ListViewDataItem)e.Item;
int LstIndex = item.DataItemIndex;
RadComboBox ddlCategory = (RadComboBox)(listView1.Items[LstIndex].FindControl("rdComboCategory"));
Also, I get listview.item.count zero. IS there any event where I will get listitem count and list items?
View 4 Replies
Jan 11, 2010
I have a database with some data in. Now I'm trying to show that data on my page whit a ListView.
For each object from the database a ListView will generate a dropdownlist.
I also have a DataPager on my page and this is where the problem occurs.
Each object generated from the database has a field that may look like this example.: 1,2,3.
In my code now I´m trying to split this string of comma character and add new items to my dropdownlist.
This works as long as I do not have DataPager on. But if I choose to view an x number of pages at the time when the page loads, I have value in the dropdownlists, only on my first page.
A piece of my code:
[Code]....
View 2 Replies
Nov 16, 2010
How do i set a data source of a drop down list which is inside a grid view, snap shot of asp code given below , the Asp file name is DataEntry.aspx and there is method in the DataEntry.aspx.cs called DTB.BindData("Department"). i want to set the datasource to point to this method
<asp:GridView ID="GridViewEmply" DataKeyNames="EmployeeID" runat="server"
AutoGenerateEditButton="True" ShowFooter="True"
OnRowEditing = "GridViewEmply_RowEdit" OnRowCancelingEdit = "GridViewEmply_RowCancelingEdit"
OnRowUpdating = "GridViewEmply_RowUpdating" OnRowCommand = "GridViewEmply_RowCommand"
OnPageIndexChanging="GridViewEmply_PageIndexChanging"
AllowSorting="True" AutoGenerateColumns="False" AllowPaging="True" Visible="false">
<Columns>
<asp:TemplateField HeaderText="DepartmentName">
<ItemTemplate>
<asp:Label ID="LabelEmplyDeptName" Text='<%# Eval("DepartmentName") %>' runat="server"></asp:Label>
</ItemTemplate>
<FooterTemplate>
<asp:DropDownList ID="ddlDept" runat="server" >
</asp:DropDownList>
</FooterTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
View 3 Replies
Jan 25, 2011
I have created a dynamic dropdownlist. I need to get the selected values from the dynamic list and store it my sql database.
View 5 Replies
Dec 7, 2010
my C# web application contain accessing of database on the basis of datas selected from a dropdown list.. and my pblm is i cant access the first entry from the dropdown, dropdown list contains different dates,when user select one date from dropdown it will redirect to another page.. the page shows details from database on the basis of this particular date.....my C# dropdown's selected index changed code is shown below:-
[Code]....
and HTML code corresponding to this is:-
[Code]....
i cant access the first data from dropdwn,even it cant redirect to target page.. other entries (the 2nd 3rd entrie etc) was accessible and it shows the details from database on the basis of that corresponding value(usually some date).
View 4 Replies
