I have a scenario where I need 2 dropdowns like state and city.City dropdown depands upon on State drop down.Will you please tell me how to achieve it ASP.NET MVC?I found this article but not sure is there any alternate way to do?http://stephenwalther.com/blog/archive/2008/09/07/asp-net-mvc-tip-41-creating-cascading-dropdown-lists-with-ajax.aspx
View 1 RepliesHow we can create country state city dropdown in asp.net?
View 6 RepliesHere 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
I'm trying to write a Javascript Zip Code lookup utility.
1) The User will select a State from a drop down.
2) The City Drown Down will then be populated based on the State selected
3) A textbox below is then populated with the corresponding Zip Code(s) based on Selected State and Zip Code on an ASP.NET page.
Problem: I get the error Request() is not defined which causes the application to hault when a State is selected.
What should I cahnge in the following code?
<script language="javascript">
var request = new Request();
var url = "";
function getZipCode()
{
request.GetNoCache(url + "getZipCode.aspx?City=" +document.getElementById("drpCity").options[document.getElementById("drpCity").selectedIndex].value+ "&State=" +document.getElementById("drpStateSearch").options[document.getElementById("drpStateSearch").selectedIndex].value,
function(result)........
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]...
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 Repliesusing 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 ?
is there any easy way to add city names,state names,and country names in dropdownlist..
View 1 RepliesUsing 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 RepliesSince I am new to Ajax control kit so thought to ask this question,I need to know what controls should i use for the following requirement.I've a state Drop down on selection of state drop down i would like to display all city of selected state in check box so that user can choose multiple cities and would like check box control to display only 5 city name per row for example if there are 10 cities in one state it should show 2 rows with 4 city and one row for 2 city.
View 1 RepliesInto my application there is EditAds.aspx page where the user get a link on his email after he add an Ad into my application. My inquiry is can i bind the cascading ddl to show the value of State column into Ad/product row as well if the user want to update the rest of state will be also reachable. It maybe hard to get what i am looking for exactly so i make a short screen record ...
Rebinding values of Ad/product depending on AdsID which is  a query string in the page called: QADNUM
[URL] ....
if (!IsPostBack)
{
if (cookie["Location"] == null)
{
DataTable rEfilterstathpBizDT = new DataTable();
using (SqlConnection REGGfilterstathpBizCon = new SqlConnection(sc))
[Code] ......
I have been looking around for an API that does this but couldn't find one, all what I need is the time of that given City or ZipCode, can I do that manually in VB.NET?
View 2 RepliesJust curious if subdomains can be generated dynamically. For example say I have [URL]. In a SQL DB is a list of cities. Can these be used to generate new subdomain for each city? (ie [URL], [URL], etc.) Or do I have to create every sub domain I want manually?
View 4 RepliesI have string like these
abcd 45
abc dehfr 3
abcd refs lal 45
I have to get the string and number different. This is like the City with house number. So i want to split the city and house number. How do i do this.
My site is going to display content based on a city. So, if a user comes directly to my site, I am going to default them to say for instance:
www.mysite.com/cincinnati
I need to be able to handle two scenarios here. One, when they come directly to my site ('/'), I need to somehow redirect to my default city and 2, show an error page if they type in an invalid city. Any thoughts? I saw the route constraint, but how do you deal with invalid scenarios like showing an error page when the constraint fails?
i need to display my vistitors city when he/she visists my site how can achieve this? ihave an idea
while installing os we set our timing zones can we achieve with this ? are there any classes in .net
Let's say I have a LatLng , is there any way of checking if it represents a possible location within a city? How can I get the limits of a city? I'm using Google Map.
View 1 RepliesI have a form in that form i am having a dropdownlist, if I select a particular company name, it will redirect to another page and generate a empcode automatically as per the company name example TCS001. My problem is, if the person filling the employee form, in that form I having an city name in dropdownlist if the user select the particular city name like Mumbai in the dropdown, I want to make the empcode as TCS/MUM/001, I tried but its not working properly..
View 1 RepliesI have 3 dropdowns in my VB.Net 3.5 web app. After a user selects a value from the first (let's call it Countries) the second (called States) should populate correspondingly. Dropdown three (cities) should also cascade down after a State is selected. The Countries and States dropdowns have SQL DataSources. The Cities dropdown has to call 2 procs (based on the selected State value) so it does not have a SQLDataSource. My question is, the code below works for Countries and States, however, I cannot ge the Cities to populate...
<asp:DropDownList ID="drpCountries" runat="server" DataTextField="CountryName" DataValueField="CountryId" DataSourceID="sdsCountries" AutoPostBack="true">
</asp:DropDownList>
<asp:SqlDataSource ID="sdsCountries" runat="server" ConnectionString="<%$ ConnectionStrings:MyConnectionString %>"
SelectCommand="SELECT * FROM [Countries] ORDER BY [CountryName] ASC"></asp:SqlDataSource>
<asp:UpdatePanel ID="updStates" runat="server" UpdateMode="Conditional">
<ContentTemplate>
<asp:DropDownList ID="drpStates" runat="server" DataTextField="StateName" DataValueField="StateId" AutoPostBack="true" DataSourceID="sdsStates">
</asp:DropDownList>
</ContentTemplate>
<Triggers>
<asp:AsyncPostBackTrigger ControlID="drpCountries" EventName="SelectedIndexChanged" />
</Triggers>
</asp:UpdatePanel>
<asp:SqlDataSource ID="sdsStates" runat="server" ConnectionString="<%$ ConnectionStrings:MyConnectionString %>"
SelectCommand="SELECT * FROM [states] WHERE StateId = @StateID ORDER BY [StateName] ASC">
<SelectParameters>
<asp:ControlParameter ControlID="drpCountries" Name="StateID" PropertyName="SelectedValue" DefaultValue="" />
</SelectParameters>
</asp:SqlDataSource>
THIS DOES NOT WORK:
<asp:UpdatePanel ID="updCities" runat="server" UpdateMode="Conditional">
<ContentTemplate>
<asp:DropDownList ID="drpCities" runat="server" DataTextField="CityName" DataValueField="CityId" AutoPostBack="true">
</asp:DropDownList>
</ContentTemplate>
<Triggers>
<asp:AsyncPostBackTrigger ControlID="drpStates" EventName="SelectedIndexChanged" />
</Triggers>
</asp:UpdatePanel>
Protected Sub drpStates_DataBinding(ByVal sender As Object, ByVal e As System.EventArgs) _
Handles drpStates.DataBinding
' Call some procs and get a DataSet
drpCities.DataSource = ds
drpCities.DataBind()
End Sub
I have to do the following.
There is a database (SQL Server) with locations (longitude and latitude values). I need to plot the route on the map (Google or otherwise) based on those locations extracted from database. Plotting lines and map are on ASP.NET webpage.
What would be the most and cost-effective way to accomplish the task above?
Now i'm working on the cascading dropdownlist for to bind a country and city, city is based on country dropdownlist. its working well , if city comes more than 8000 records in city dropdownlist , takes more to bind city.
View 1 RepliesI know there has to be a way to do this but for some reason I keep getting it wrong. I have one query which pulls all of the cities from a zipcode database like so:
[Code]....
Then I have another which counts the records from a transactions table per city, like so:
[Code]....
Only the zipcode is stored in the transactions table, so the idea here is to get a list off all the distinct cities that reside in the state. Once I have the cities, I want a count for each city as a whole, so I need to go back in and get all of the zipcodes that make up one city, and then count the transactions for those zipcodes. It works using the first query above, looping through them and then executing the second for every pass. But shouldn't there be a way to do it all in one query?
using the bing map API, can I make a server-side call and get lat/long for a given city? I can do it on the client side using JavaScript, but I need something more robust in this case and want to use the server side.
View 1 RepliesI'm building a WebControl for user registration. To expedite its use checks I used clientside validation through AjaxControlToolkit.ValidatorCalloutExtender. The validation is triggered when REGISTER button is pressed and popup information for missing or incorrect fields is showed. But I have a problem about a cascading dropdownlist(DDL) [Country]>>[City], because during the client-side validation I'm no more able to refresh my City DDL depending on the new selected Country. Server side, SelectedIndexChanged event is triggered but the DDL in the browser is not refreshed! (The DDL Country and City are Causevalidation=false) This occurs for each control on the page changed by server during client-side validation. How can I fix?
View 1 Repliesi has an gridview with the columns userid, username and password, first column of the column is an image button when click it then under(it means innergridview) that particular row, based on userid i have to display City, Country & PhoneNo. how to do this?
View 2 Replies