In given code finally I want to populate unique values at runtime in 2 drop downlist.
protected void Page_Load(object sender, EventArgs e)
{
vidDocument.Load(Server.MapPath("~/CurrentStatus.xml"));
HttpContext.Current.Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.ExpiresAbsolute = DateTime.Now.AddMonths(-1);
[Code]....
I am designing my own Customize Calendar for my webproject.Using Calendar Control of asp.net2.0 I want to add three dropdowns at the top to collect Hour, Minutes and Seconds.What I required to load dropdown menus on runtime with values:
View 1 RepliesI have created a dynamic dropdownlist. I need to get the selected values from the dynamic list and store it my sql database.
View 5 RepliesI'm using objectDataSource and Formview. Currently I'm using a Text-Box to put the CategoryID.
I want to display the Category-Name instead of Category ID in Drop Down list.
in my proj i have a grid view which consists of name and droppown list as shown below:
<asp:GridView ID="gvJobs" runat="server" AllowPaging="true" AllowSorting="true" AutoGenerateColumns="False" OnRowDataBound="gvJob_RowDataBound" OnRowCommand="gvJobs_RowCommand" >
<Columns>
<asp:TemplateField HeaderText="Jobs" SortExpression="name" HeaderStyle-HorizontalAlign="Left">
[Code]....
when i click the dropdown list it is postbacking(since i made auto postback=true). on that time i am unable to get the selected value from dropdown list.
i have 4 text boxes and 2 dropdowns are there when ever i fill it all values should place in grid view., after entering of 5 or 6 records, i click on SAVE button then ,i want to save those values in to Data Base ,which are at Grid view.....
Example:
[code]...
Is it possible to display two column values from a SQL database in to one DDL? I have been trying to write a SQL query, where in I select two fields to be displayed in the DDL but when I run the application it only displays one. Not sure why. Here is my code below:
<asp:DropDownList ID="DropDownList8" runat="server"
DataTextField="LATA"
DataValueField="LATA"
onselectedindexchanged="DropDownList8_SelectedIndexChanged"
DataSourceID="SqlDataSource1">
</asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:Inventory_DBConnectionString %>"
SelectCommand="SELECT DISTINCT [LATA], [LATA Name] AS LATA_Name FROM [CA] WHERE ([SWITCH ID] = @SWITCH_ID)">
<SelectParameters>
<asp:QueryStringParameter Name="SWITCH_ID" QueryStringField="ddl1"
Type="String" />
</SelectParameters>
</asp:SqlDataSource>
I have a Detailsview grid with an SqlDatasource, this DVG is only going to be used to insert records. The primary purpose of the DS is to populate a DDL control in the insertItem Template that I created my code is this:
[Code]....
The DDL control populates correctly, but when I try to modify the INSERTCommand property in my DS, I try to assign the value to my parameters "TesterID" and "TesterDate" but the only options for controls to pick from, is the DGV but not the DDL in it. I assume it has to do with the InsertItem template but even if I reset it I still cannot pick the textbox as a control that would give the value to my parameters.
I did find a workaroun by build a public method and calling it in the onclick event of the insert button but looks like I have to create another connection to the database which to me seems unnecessary since I already have a DS and everything. how can I do this without having to use my method. here is my method just in case.
[Code]....
I have a table that has 3 fields (Individual-Id, LastName, and FirstName). I want to create a drop down table that displays both the FirstName and the LastName (example: Smith, John). The field Individual-Id is the 'value' field.
View 4 RepliesI 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") %>'
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 RepliesI am geting a json value with multiple stateid amd more statid are multiple,but I want stateid only unique(distinct) in jquery array.
View 2 RepliesI 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.
someone can help and provide some info or links to achieve the following:
I would like to prompt a message box with a drop down list that retrieves values from a sql server at runtime so user can select from. After user selects the value from the drop down list, the value is passed to the Master/content page to use as an additional query parameter to proceed to the next step to display content page.I understand how to create a message box in javascript, but I understand you can't do queries from javascript, if I'm correct.
i am using a list view to view, insert, update and delete my data for the admin page this admin page made for the news and we have categories for that so i need to use a drop down list for these categories and when the admin choose on of these categories records its value as an ID to the database.
[Code]....
I want to have a default value/item of "---Select One---" and then list all of the values from the SQL statement. Currently I am having trouble doing this. I tried to add it to the List Item but it doesn't show on the page.
View 25 RepliesMultiple DropDownList in GridView populated with unique values in ASP.Net
View 1 Repliesi have a dataset filled from the DB, let assume the data in the dataset is: -
[code]....
I have a ASP.Net page that has a gridview control. This gridView control has a checkbox controls. I would like to assign a boolean value from a database field to the Checked property- Checked='<%# Bind("RESULTS") %>'.
When page loads,I get error - Specified cast is invalid!
The code is as follows...
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="dsResults"
BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px"
CellPadding="3" OnRowUpdated="GridView1_RowUpdated">
<Columns>
<asp:TemplateField HeaderText="COMPLIANT" SortExpression="RESULTS">
<EditItemTemplate>
<asp:CheckBox ID="CheckBox2" runat="server" Checked='<%# Bind("RESULTS") %>' />
</EditItemTemplate>
<ItemTemplate>
<asp:CheckBox ID="CheckBox1" runat="server" Checked='<%# Bind("RESULTS") %>'
Enabled="False" />
</ItemTemplate>
</asp:TemplateField>
Note: If a constant value is passed at design time it works fine. But i want to assign the value at runtime using Bind.
Environment details: VS 2008, ASP.NET 2.0 and .Net Framework 3.0 & C# language.
I tried returning values like 0s and 1s, Ys and Ns and True and False from a database field. But i still get the above mentioned error.
I tried retreving the value in OnRowDataBound event using Eval, since Bind is not available in code behind. But it would make the field readonly and i cannot edit and update the Results field.
Even though there is a value returned by the query why does the Checkbox does not assign the value using <%# Bind("Results") %> to Checked property instead throws error - Specified cast is invalid.
how i can edit and update Checkbox.
where did the Bind method of ASP.Net 1.x is moved? How can i use Bind in code behind of ASP.Net 2.0?When i type DataBinder the intellisense shows Eval and other stuff but i don't see Bind that would solve the problem of two- way binding.
I have 3 drop down list boxes - One for month, day and year. I'm trying to get the value of what the user selects on those drop down list boxes. I have dynamically populated my drop down list boxes and I'm trying to output the end value on a label
private int month;
private int day;
private int year;
protected void Page_Load(object sender, EventArgs e)
{
for (month = 0; month <= 12; month++)
{
DropDownList2.Items.Add(month.ToString());
}
for (day = 0; day <= 31; day++)
{
DropDownList3.Items.Add(day.ToString());
}
for (year = DateTime.Now.Year; year <= DateTime.Now.Year + 75; year++)
{
DropDownList4.Items.Add(year.ToString());
}
}
protected void Button4_Click(object sender, EventArgs e)
{
month = ?
day = ?
year = ?
Label7.Text = month + "/" + day + "/" + year;
The problem right now is I can't figure out how to actually retrieve the value the user uses
I want to add the below values from Enum to drop down list
<option value="0">-- Select --</option>
<option value="AC">Active</option>
<option value="IN">InActive</option>
<option value="PC">Pending Closure</option>
I would like someone to explain how I can pass a drop down list from the presentation layer to the controller using the Model View Controller Design Pattern from Microsoft in order to bind enum values to it?
View 2 RepliesHow do I create an array of values from a drop down list?
View 2 RepliesI'm stuck with a problem to populate a DropDownList control with values from the database using item field template in read only mode. since I'm new to ASP.NET. Below is the code and the error I'm getting:
'PictureReadOnlyCategories' has a SelectedValue which is invalid because it does not exist in the list of items. Parameter name: value Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.ArgumentOutOfRangeException: 'PictureReadOnlyCategories' has a SelectedValue which is invalid because it does not exist in the list of items. Parameter name: value
The code for this is :
<asp:SqlDataSource ID="categoriesDataSource" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand ="SELECT [CategoryID], [Name] FROM [Categories] WHERE ([UserId] = @UserId)">
<SelectParameters>
[Code]....
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"