Web Forms :: How To Add Country State City Using Different Pages To Database
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 ..
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.
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 ?
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.Â
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
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
i 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?
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.
I'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?
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
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:
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
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
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
Since 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.
Into 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))
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?
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?
In my Application_BeginRequest I have code that gets query string value ?c=FR or ?c=US and store it in cookies.Based on query string value I have either US or FR,locale is selected from locale table.If ?c=FR then locale will be fr-FR and if it is US then locale will be en-US.My code is below.
void Application_BeginRequest(object sender, EventArgs e) { LocalizationInfo loc = GetLocalizationInfo(); if (Request.Cookies["Localization"] == null) Response.Cookies.Add(new HttpCookie("Localization")); Response.Cookies["Localization"]["Country"] = loc.Country; CultureInfo objCI = new CultureInfo(loc.Locale); Thread.CurrentThread.CurrentCulture = objCI; Thread.CurrentThread.CurrentUICulture = objCI; } public static LocalizationInfo GetLocalizationInfo() { string countryCode = ""; string sLocale = ""; if (HttpContext.Current.Response.Cookies["Localization"]["Country"] != null) countryCode = HttpContext.Current.Response.Cookies["Localization"]["Country"]; if (!string.IsNullOrEmpty(HttpContext.Current.Request.QueryString["c"])) countryCode = HttpContext.Current.Request.QueryString["c"]; if (countryCode == "") countryCode = "US"; sLocale = HertzRent2Buy.DataProvider.ListData.GetLocale(countryCode); LocalizationInfo ret = new LocalizationInfo(); ret.Country = countryCode; ret.Locale = sLocale; return ret; } public struct LocalizationInfo { public string Country; public string Locale; }
Now when I run the project and in query string I set [URL] then for the very first page(home page itself) it shows me French translation,but on subsequent page,that query string parameter ?c=FR is lost and hence it shows be English translation not French translation since it does not pickup French resx file.If I manually append ?c=FR in subsequent page then it shows the French translation.Is there is way how I can make that query stringparameter available in all pages.Structure is there to hold Country and locale variables. In all pages I am calling GetLocalizationInfo() method as follow
LocalizationInfo info = some.DataProvider.Globalization.GetLocalizationInfo();
And I create instance info to pass locale and country as parameter. GetProductDetails(id,info.Country,info.locale). why my query string parameters get lost on subsequent pages.
i have places a treeview in the master page, if i click on certain node it will navigate to some x.aspx page.here the proble is treview nodes all are collasped.
I have many country check boxes on page and i want to search data from database based on check boxes checked i.e. user can check check single or multiple checkboxes. So how can i fetch the data/records from database based on same.