SQL Server :: Script For The Countries And States Table?
Jul 22, 2010
where can i get the script for the countries and there corresponding states of all over the world.
As by googling I could Only find the states of Uk and USA but I want the states of all over the world and there corresponding countries.
View 2 Replies
Similar Messages:
May 3, 2010
i want a list of all countries and states for free interms of xml,html,word,doc,notepad, .sql format..
View 8 Replies
Mar 4, 2010
I'm trying to create a User Registration page in ASP.NET and wondering what is the best way to get the list of up-to-date Countries and Cities? Are there any Web Services on the web that I can use to retrieve such information? If not, what are the options?
View 2 Replies
Apr 20, 2010
I have a country table that has a list of countries. However, instead of just displaying the list alphabetical, I need to list the United States first, and then all the other countries in Alphabetical order. My select statement is pretty simple, jsut don't know how to get the US listed first...
Select Country from tCountry order by Country
View 4 Replies
Nov 25, 2010
I need to pass a table type parameter to a user-defined table valued function in SQL Server 2005.How would I do this?
My function name is udf_t_GetSales ( @financialYearMonthsData as table)
The table @financialYearMonthsData has 3 columns ( MonthId int, DisplayText nvarchar(500), CalendarYear int)
View 7 Replies
Dec 10, 2010
my main intention is that, the exsisting table of sql server database(.dbo) with 1000's of records, that should be import to a new access database table(.mdb).for example if we want to had a new table in db2, of exsisting table in db1 with some conditions by using "select * into New_Tabel from (select * from Exsisting_Table where <Condition>) as objectName". Here the new table is created and records inserted in one execution in db2. The same work should be done for access(sqlserver db --> Access db).Here the new access database table with given name (as string_sysdate) must be created dynamically by clicking a button (multiples time creating new table).Is there any query or c# code for sql server database to access database.
View 2 Replies
Nov 3, 2010
Say I need to develop a online cheese games and the game is just between computer and a real human player.
The req is to keep states (like steps,win history) usable even after the user closing browsers or server temp being offline in short time. Thus when the player goes back to the game page, he should be keep playing from what he played last time, and get his play history as well.
It is definitely need cookie to enable all this, but i m concerning about the security of using that. I should prevent ppl hacking the cookie directly to change the history or sth. My thought is to make the server end assign a token to client. All the steps and history data are associated with this token string and stored in a persistent layer (database).
Is it a overdesign , or there is a way to encrypt cookies.
View 3 Replies
May 23, 2010
I have multiple nested GridView controls where I have one field/column that always have one of three values only (0, 1, and 2) and this is editable field. Now, instead of putting this field as a DropDownList for the end-user to choose either one of these values (0, 1, or 2), I am representing each value with a specific clickable image, so the user can click the image to switch among the mentioned field states (0, 1, or 2).
I managed to do this with ImageButton and AJAX. However, the volume of this field is too high, the page is quite big, and the end-user needs to do change the state/value of this field most frequently, which causing a flicking issue in the page and slowness (because the code is done by AJAX, so in the server side) where the customer is not accepting it.
how we can rectify this issue; for example using javascript coding (but I need to get the selected value from code-behind)? I found the AJAX Toolkit ToggleButtonExtender which is very good and not causing the flicking/slowness issue, but unfortunately, this ToggleButton has only two states while I need three states option.
View 2 Replies
Nov 11, 2010
Does ASP.net MVC Uses Session internally to store the states ?
Wil MVC faile across Webfarms if session not managed properly ?
View 6 Replies
Mar 11, 2011
For some reason my query is returning multiple states. It will return records for CA, TX, AZ. All I want is NY that's it and to me it looks really clear.
SELECT [name1], [name2], [mail_street1], [mail_street2], [mail_city], [mail_state], [mail_zip], [phone], [website] FROM [flat_list] WHERE (([rl] = 'x') OR ([rs] = 'x') AND ([mail_state] = 'NY')) ORDER BY [name1], [name2]
View 1 Replies
Feb 9, 2010
My client has customers in 100 countries in which a customer can have access to more than a country. So, to show visual appearance to the customer, our client want to show world map and fill each country with a different color where the customer has access to.
Is there anyway to do this in ASP.NET?
If not ASP.NET, Is their any third party which does this stuff.
View 1 Replies
Dec 7, 2010
I have a website that is written in english. I am starting to get users from other countries. They speak english so it is not a problem as yet. But what is involved in adding multi language features to a site? Do you need to actually do the translations? For example, I have users from Slovenia which - I think uses some sort of cryllic alphabet. What is necessary to do this?
View 6 Replies
Jun 9, 2010
I have a client who wants me to block his site from certain countries. Each month I add all the new IP address ranges for these countries into a sql database. If the user has a blocked IP address, the site directs them to a phoney 504 error page. This way it doesn't appear that the site is being blocked, but rather is just having difficulites. Thats the way we want it.
It works fine however, there are some users (5%) who get a 500 error. No rhyme or reason. It works across all browsers and operating systems. I have no way of finding out why from my hosting service. I can't dupliate it. I have the following code that runs at Page_Init
[Code]....
View 10 Replies
May 6, 2010
how to display the All countries date and time in C# I have one dropdown list and one label and one submit button in DropDown list i have add all countries list like GMT + 05:30 Chennai, Kolkata, Mumbai, New Delhiwhen i select the particular list and press submit button to display.
View 3 Replies
Feb 9, 2010
I want to list all the countries in my dropdown list. where can i get all the names? from service right? How to do this?
View 4 Replies
Oct 20, 2010
is it possible to use Bing Maps or Google Maps (or any other) and mark countries on a world map? I have some countries in SQL DB depending on the logged in user, e.g. France, Mexico, Australia, Japan. These countries should be mark on a world map. Is this possible?
View 2 Replies
Sep 22, 2010
need Country dropdown with Flags using JQuery..I am new to Jquery.
View 16 Replies
Feb 2, 2010
Does anyone know a better way to insert all us states?
insert
[tbl_state](state_txt)
select
[code]...
View 2 Replies
Apr 13, 2010
I really enjoy the flex states framework. You define a few states for your control, and then can set child controls to only appear in certain states. Check out this code:
<s:states>
<s:State name="signin"/>
<s:State name="register"/>
[code]...
View 1 Replies
Apr 22, 2010
I am working on a site where I need to set different countries get restricted. The selected countries don't able to download the contet of that site? How do I do this.
View 3 Replies
Jan 5, 2011
I have a little problem with my sliding panels, I have a Page with 2 sliding panels (right and left). These panels have a 'slide button' and you can reduce panels by clicking on it. I use cookies to record state of panel, so when you change page panels stay collapsed or extended. But it doesn't work very well, in fact the state is recorded for the page. If I change page, panel will extend (default position) but if I go back on the page it will disapear. Is it possible to ignore the path in the cookie and use a cookie for all website?
Jquery code :
$('#rightfold').click(function () {
if ($('.menudroite').is(':visible')) {
$('.menudroite').hide("slide", { direction: "right" }, 400);
$.cookie('rightfold', 'collapsed');
$('.triggerdroite').animate({ backgroundColor: "#B2C9D1" }, 1000);
$('#rightfold').animate({ color: "#000000" }, 1000);
}
else {
$('.menudroite').show("slide", { direction: "right" }, 400);
$.cookie('rightfold', 'extended');
$('.triggerdroite').animate({ backgroundColor: "#6c7a7f" }, 1000);
$('#rightfold').animate({ color: "#d9f4ff" }, 1000);
}
});
$('#leftfold').click(function () {
if ($('.menugauche').is(':visible')) {
$('.menugauche').hide("slide", { direction: "left" }, 400);
$.cookie('leftfold', 'collapsed');
$('.triggergauche').animate({ backgroundColor: "#B2C9D1" }, 1000);
$('#leftfold').animate({ color: "#000000" }, 1000);
}
else {
$('.menugauche').show("slide", { direction: "left" }, 400);
$.cookie('leftfold', 'extended');
$('.triggergauche').animate({ backgroundColor: "#6c7a7f" }, 1000);
$('#leftfold').animate({ color: "#d9f4ff" }, 1000);
}
});
// COOKIES
var leftfold = $.cookie('leftfold');
var rightfold = $.cookie('rightfold');
// Set the user's selection for the left column
if (leftfold == 'collapsed') {
$('.menugauche').css("display", "none");
};
// Set the user's selection for the right column
if (rightfold == 'collapsed') {
$('.menudroite').css("display", "none");
};
View 2 Replies
Apr 21, 2010
I have 2 listboxes. 1 listbox displays all countries. then I have added 2 buttons, Add and Remove, to add and remove the selected countries from first listbox to second listbox. how can I move selected countries from one list box to another listbox in MVC framework.I am using Linq.
View 4 Replies
Sep 21, 2010
If you have a global navigation tree, Countries --> States --> Cities for example, how do you correctly implement this in MVC2? In my example, the view model for States does not contain Countries and the tree would break as it needs the Countries list to build the tree. It sounds like this should be easy, but it doesn't sound right to include the entire model for a single State or City view.
View 3 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
Feb 17, 2010
Plz go through my code-
<asp:ScriptManager runat="server"/>
<cc1:ModalPopupExtender ID="mpe_AddState" runat="server" PopupControlID="PanelAddState" TargetControlID="btnAddNew" BackgroundCssClass="ModalPopupBG" OkControlID="btnOk"
CancelControlID="btnCancel" BehaviorID="ModelPopUp_AddState">
</cc1:ModalPopupExtender>
<!-- Begin of Content table -->
<table width="100%" border="0" cellspacing="2" cellpadding="2" align="left">
<tr> <td>
<!-- Begin of Search Country Panel -->
<asp:Panel runat="server" DefaultButton="btnSearch">
<table border="0" cellspacing="3" cellpadding="3" align="left">
<tr> <td width="15%" >Search</td> <td width="30%">
<asp:TextBox runat="server" CssClass="textBox" ></asp:TextBox>
<asp:RequiredFieldValidator ID="rfv_txtSearch" runat="server" ErrorMessage="Field can't be left Blank" SetFocusOnError="true" ControlToValidate="txtSearch" Display="None" ValidationGroup="search"> </asp:RequiredFieldValidator>
<cc1:ValidatorCalloutExtender runat="server" TargetControlID="rfv_txtSearch">
</cc1:ValidatorCalloutExtender> </td> <td width="25%">
<asp:Button runat="server" Text="Search" ValidationGroup="search" />
</td> </tr> <tr> <td width="15%">Country</td> <td width="30%">
<asp:DropDownList id="ddlCountry" runat="server" AutoPostBack="true" Height="30px" Width="76px">
</asp:DropDownList> </td> <td width="15 %">
<asp:Button runat="server" Text="AddNew" /> </td>
<td width="25%"></td> </tr> <tr> <td> </td> </tr>
</table> </asp:Panel>
<!-- End of Search Country Panel -->
<!-- Begin of Add State Panel -->
<asp:Panel runat="server" CssClass="formTextBold"
style="width:390px; height:500px; cursor: move;" Height="278px" Width="335px">
<div> <table border="0" > <tr><td></td></tr> <tr bgcolor="skyblue">
<td colspan ="3" style ="font-weight :bold "> Enter The State Details
</td> <td align ="center"><a href="#" onclick ="HidePopup();">
<font color="red" size="+1">X</font> </a> </td> </tr> <tr> <td> </td> </tr> <tr>
<td> </td> <td> State Code </td> <td>
<asp:TextBox id="txtStateCode" runat="server"></asp:TextBox>
</td> </tr> <tr> <td> </td> <td >State Name</td> <td>
<asp:TextBox id="txtStateName" runat="server"></asp:TextBox>
</td> </tr> <tr> <td> </td> </tr>
<tr> <td> </td> </tr> <tr> <td> </td>
<td >Country Name</td> <td>
<asp:DropDownList id="ddlSelectCountry" runat="server">
</asp:DropDownList></td> <tr> <td> </td> </tr>
<tr> <td> </td> </tr> <tr>
<td width="28%" colspan="2"></td> <td >
<asp:Button runat="server" Text="Ok" Width="50px" />
<asp:Button runat="server" Text="Cancel" /> </td>
</tr> </tr> </table> </div> </asp:Panel>
<!-- End of Add Country Panel -->
.cs code is-
protected void Page_Load(object sender, EventArgs e) {
if(!IsPostBack) {
ddlSelectCountry.DataSource = Obj_BLogic.Country_List();
ddlSelectCountry.DataTextField = "Country_Name";
ddlSelectCountry.DataValueField = "Country_Id";
ddlSelectCountry.DataBind(); }
ddlCountry.DataSource = Obj_BLogic.Country_List();
ddlCountry.DataTextField = "Country_Name";
ddlCountry.DataValueField = "Country_Id"; ddlCountry.DataBind();
ddlCountry.Items.Insert(0, new ListItem("Select"));
grdState.Columns[0].Visible = false; }
I want list of countries exactly once in both the dropdownlist (ddlCountry & ddlSelectCountry). But is giving the list of countries twice.
View 1 Replies