Web Forms :: How To Get Other Country And State Option In Dropdown
Feb 2, 2011
i am entering the value in a txtCountry and txtState if the other country and other state option is been selected. while i am entering the otherCountry and OtherState option at the dropdown lists Databound event.
so at the time of getting the data from database if the other option is selected then i am giving the variable value to the txtCountry and txtState likewise. but here i am not getting the exact output and getting error.
my code looks like below.
[Code]....
in above Code the ViewData function gets the data at edit time from the database
View 1 Replies
Similar Messages:
Nov 26, 2010
How we can create country state city dropdown in asp.net?
View 6 Replies
Jun 29, 2010
I have a dynamic dropdown that is populated from sql. The user is supposed to select an option from the dropdown, then click a search button on the form to return some results based on that selection. It works fine if the dropdown gets populated with more than one record. However, if only one record is returned, that one record can't be selected. Whether you select it or just leave it alone since it's the only one, when you click the form button (search button), no results are returned b/c the dropdown selection must not be actually selected.
I've included the relevant code below. First the DDL, then the datasource, and finally the C# code in the if (!Page.IsPostBack)
[Code]....
View 4 Replies
Mar 30, 2010
I am developing my map function. When i click the state on country map, it should return the state name. But it didn't. I've spending a lot of time google about it and try a lot of ways to solve it. But i keep getting the JS error:"null" is null or not an object. Is it because my dropdown list having this runat="server" attribute???I don't want to delete this attribute since i am using it in my code behind.
Here is piece of my code behind for the state ddl.
[Code]....
And here is piece of my html code:
[Code]....
Then, i have multiple events for the map onclick function. Here is the code:
[Code]....
View 2 Replies
Feb 15, 2013
I have one page Country.aspx through that i add country in my database... I have another page name State.aspx through which i can add states in my database..
Now The country i have added in database through first page when i want to add states in database i want that added country to be shown in drop down list in my state.aspx page..
here in state.aspx page i have one drop down for country which i select and one textbox for state which i want to add...how can i add states with this....here when i click on save the state should be saved in database
how can i do that??
I have taken three different tables name country,state and city for that and 3 different pages country.aspx,state.aspx,city.aspx ..
/*country.aspx*/
<form id="form1" runat="server">
<div>
<h2>Add Country</h2>
<table>
<tr> <td>
<asp:Label ID="Label1" runat="server" Text="Country:"></asp:Label>
[CODE]...
View 1 Replies
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
Sep 18, 2010
Here is my scenario.In default.aspx page user selects the country, state, city from drop down list, and store them in cache for further use. but when other user open the web site from other computer it shows the same country, state, and city selected by user 1. Is there any problem related to cache? I have stored data as following.
cache["ctryID"] = ctryID;
cache["stateID"]= stateID;
cache["cityID"]= cityID;
I want to show default country, state , city at page load of default.aspx
View 2 Replies
Aug 10, 2010
i have one dropdownlist in the gridview. i have to load that dropdownlist when that page is loaded. dropdownlist should contain the country list from country table
View 7 Replies
Apr 3, 2010
In My project I have DoupDownList(ddl). In my ddl in need to bind country names along With Country Flag..So Can Any One Help Me In thi issue...Country Name And Country Flag Bouth i need to Bind in my ddl
View 5 Replies
Dec 3, 2010
I want populate the dropdownlist1 with Country and dropdownlist2 with City of that Country from web
Is there a place on web where we can get a list of countries and cities handy, and then populate into our dropdownlists in ASP.net page.
View 2 Replies
Sep 7, 2010
The 2 dropdownlist controls are-ddlCountry and ddlState. The 2 database tables are-Country and State Country table has fields named- C_ID(pk) and Country State table fields are-S_ID(pk), State, C_ID I'm able to bind the dropdownlist controls to the database. But I want the contents of ddlState to change according to the Country selected from ddlCountryI don't want to use ajax
View 9 Replies
Jan 5, 2011
I have a dropdownlist on my page that when a user selects an item sets the list for another dropdownlist. My problem is that no matter what the user selects in the 1st dropdown it resets itself to the first item in the list. I have autopostback=true and nableviewstate= true. Is there another setting i'm missing or is it my code?
[Code...]
View 4 Replies
Oct 30, 2010
I have a webservice that a developer can use to create a user account, apart of the create user account form, it requires an input of the user's "Postal Address"The Postal address has "Country State Id"Normally, I would provide a list for everything else, but when it comes to country state list it contains thousands and thousands of states/regions and its too much to list in a API specification document.
So my question is, 1) do you create a web service for the developer to retrieve the country state id?
or 2) provide the developer with a database file, with the list of country state id?
View 1 Replies
May 19, 2010
I need a dropdown to display respective states when specific country is selected similarly for cities. I kept 3 dropdowns for country, state and city with 3 different tables with primary, foreign key constraints and stored procedures. The Stored Procedure is as shown ALTER PROCEDURE [dbo].[Usp_countryselect]
WITH
EXECUTE AS CALLER
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SELECT [country_id], [country_name]
FROM country
Similarly for states and city.
The code for populate lists is as shown
public class PopulateLists
{
public int FillCountry(ref System.Web.UI.WebControls.DropDownList drpdown)
{
SqlDatabase db = new SqlDatabase();
DbCommand cmd=db.GetStoredProcCommand("USP_countryselect");
DataSet dsCountry= db.ExecuteDataSet(cmd);
drpdown.DataSource =dsCountry.Tables[0] ; drpdown.DataTextField=dsCountry.Tables[0].Columns["country_name"].ToString() ;
drpdown.DataValueField = dsCountry.Tables[0].Columns["country_id"].ToString() ;
drpdown.DataBind();
return 1;
}
public int FillState(ref System.Web.UI.WebControls.DropDownList drpdown)
{
SqlDatabase db = new SqlDatabase();
DbCommand cmd = db.GetStoredProcCommand("USP_statesselect");
DataSet dsStates = db.ExecuteDataSet(cmd);
drpdown.DataSource = dsStates.Tables[0];
drpdown.DataTextField = dsStates.Tables[0].Columns["state_name"].ToString();
drpdown.DataValueField = dsStates.Tables[0].Columns["state_id"].ToString();
drpdown.DataBind();
return 1;
}
.
.
.
}
protected void Page_Load(object sender, EventArgs e)
{
BindDropdowns();
}
protected void BindDropdowns()
{
PopulateLists objPopulateLists = new PopulateLists();
int bytReturn;
bytReturn = objPopulateLists.FillCountry(ref Drpcountry);
bytReturn = objPopulateLists.FillState(ref Drpstate);
bytReturn = objPopulateLists.FillCity(ref Drpcity);
}
But in the output screen it is displaying all the values in the dropdowns irrespective of country and state selection.
View 3 Replies
Nov 6, 2010
how to setup a edit option in the drop down...
Example:
I have a drop down for 6 colors...and user didn't find the color which he wants...can I place a last option as new or Edit or something which allows the user to enter the color he wants in the dropdown or change that drop down to textbox to enter data... If this is possibly then how can i capture those values in the code behind...
View 3 Replies
Apr 21, 2010
retrieving values related to user select a country then its automatically shows the states name of that country in next dropdownlist and after that it will automatically display the city names respected to that country.
View 6 Replies
May 7, 2015
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace testing1 {
[Code] ...
This is not working after i am entering the pin and clicking fill city , state country all the spaces are staying blank why ?
View 1 Replies
Nov 21, 2012
is there any easy way to add city names,state names,and country names in dropdownlist..
View 1 Replies
Sep 20, 2012
Using four dropdown lists (country, state, city, pincode) in one table. i want to select one after other like based upon the country, states has to be displayed and based upon the states, cities has to be displayed and based upon the cities , pincode has to display.Â
View 1 Replies
Aug 4, 2010
I have a listview that is displaying records currently based on a dropdown.. works great.. now, within those results returned, i would like to filter down some more.. How can i add a dropdownlist to the page that is populated with data from the listview(only 1 field would be used to create the list ) and if you chose to filter by that drop down, then the listview is revised to display only records with the selected value.
Example..
Currently you pick from a drop down.. Report#1, Report#2 or Report#3 Say report#1 returns 100 records.. and the field im going to be filtering on is my "Vendor" field.. so once my listview displays my results, a dropdownlist is populated with all the vendors that were returned with the query.. could just be a few..
Now you are sitting there paging thru all the records.. and realize you really just need to see out of the 100 records, records that belong to Vendor#3, so you pick #3 from the drop downlist and the procedure is called again now filtering on that vendor..
View 21 Replies
Apr 14, 2010
I have a list of options (IEnumerable< SelectListItem >) in my model that I want to use in multiple dropdowns in my view. But each of these dropdowns could have a different selected option.
Is there an easy way to simply specfiy which should be selected if using the Html.DropDownList helper?
At this point, the only way I can see is to generate the html myself and loop through the list of options like so:
[code]....
View 3 Replies
Jun 15, 2010
I have an aspx page that has...
if (!IsPostBack)
{
PopulateBrand();
in the Page_Load. This PopulateBrand() simply populates my drop down. That works great and on post back it retains the value.
The problem I'm having is that there is also a link on the page that is posting back some parameters to this page. What is happening is that when this is clicked it's falling through this !IsPostBack section and wiping out my drop down values that I had selected and repopulating it.
How can I prevent this and just retain what I selected when this page is posting back to itself when the link is clicked?
View 1 Replies
Mar 4, 2010
Eg:-- When I type "A" all the elements starting with A should be displayed... If "B" then elements with B....etc)
Ex:
<asp:DropDownList ID="ddlLocation" style="width:140px" runat="server">
<asp:ListItem Value="1" >India</asp:ListItem>
<asp:ListItem Value="2" >India - Hyderabad</asp:ListItem>
<asp:ListItem Value="3">South Africa</asp:ListItem>
<asp:ListItem Value="4">Australia</asp:ListItem>
</asp:DropDownList>
javascript :
function DisplayText()
{
var textboxId = '<% = txtText.ClientID %>';
var dropdownListId = '<% = ddlLocation.ClientID %>';
document.getElementById(textboxId).value = document.getElementById(dropdownListId).value;
document.getElementById(textboxId).focus();
}
code behind :
ddlLocation.Attributes.Add("onChange", "DisplayText();");
View 1 Replies
Jan 26, 2010
Not sure why Access Modifier drop down is disabled for a Resource file.
View 1 Replies
Feb 15, 2011
i get the problem in updating the treeview nodes from databse.i have created a dropdown list and on selectionindex change event i written the code for selection of nodes in the treeview.on first time selecting the option in dropdown list i get the selected nodes which works fine..but when i change the option in the dropdown control the treeview nodes cant updated on page but it seems selected as per database in the code behind when i debbug it
View 7 Replies
