Home » » How to find Country, State, City by dropdown selection using Ajax in C#?

How to find Country, State, City by dropdown selection using Ajax in C#?

No comments
................................source code..............................

 <%@ Page Language="C#" AutoEventWireup="true" CodeFile="countrystatecity.aspx.cs" Inherits="countrystatecity" Title="kul" %>

 <%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

 <html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
 
    <asp:ScriptManager ID="ScriptManager1" runat="server">
    </asp:ScriptManager>

     <asp:MultiView ID="MultiView1" runat="server">
    <asp:View ID="View1" runat="server">
    <div>
    <table>
    <tr>
    <td>Name</td>
    <td>
    <asp:TextBox ID="TextBox1" runat="server" Width="150px"> </asp:TextBox>
        <cc1:TextBoxWatermarkExtender ID="TextBox1_TextBoxWatermarkExtender"  WatermarkText="pls enter name"
            runat="server" Enabled="True" TargetControlID="TextBox1">
        </cc1:TextBoxWatermarkExtender>
        <td>
            <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server"
                ControlToValidate="TextBox1" ErrorMessage="RequiredFieldValidator">*</asp:RequiredFieldValidator>
        </td>
    </td>
    </tr>
 
    <tr>
    <td>
    Age
    </td>
    <td>
    <asp:TextBox ID="TextBox2" runat="server" Width="150px"></asp:TextBox>
        <cc1:TextBoxWatermarkExtender ID="TextBox2_TextBoxWatermarkExtender" WatermarkText="pls enter ur age"
            runat="server" TargetControlID="TextBox2">
        </cc1:TextBoxWatermarkExtender>
        <td>
       <asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server"
                ControlToValidate="TextBox2" ErrorMessage="Please enter Age">*</asp:RequiredFieldValidator>
            <asp:RangeValidator ID="RangeValidator1" runat="server"
                ControlToValidate="TextBox2" ErrorMessage="RangeValidator" MaximumValue="30"
                MinimumValue="20">*</asp:RangeValidator>
 
 
    <tr>
    <td>
    Mobile
    </td>
    <td>    <asp:TextBox ID="TextBox3" runat="server" Width="150px"></asp:TextBox>
        <cc1:TextBoxWatermarkExtender ID="TextBox3_TextBoxWatermarkExtender"
            runat="server" TargetControlID="TextBox3" WatermarkText="pls enter ur mobile no">
        </cc1:TextBoxWatermarkExtender>
        </td>
    <td><asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server"
            ControlToValidate="TextBox3">*</asp:RequiredFieldValidator>
            <asp:RegularExpressionValidator ID="RegularExpressionValidator6"
            runat="server" ControlToValidate="TextBox3" ValidationExpression="\d{10}">*</asp:RegularExpressionValidator>
            </td>

     </tr>
 
       
 
 
 
    </td>
    </td>
    </tr>
    </table>

     <asp:UpdatePanel ID="UpdatePanel1" runat="server" >
 
    <ContentTemplate>
    <table>
    <tr>
    <td>    <span><strong>Country</strong></span></td>
    <td>

     <asp:DropDownList ID="ddlcountry" runat="server" AutoPostBack="true" Width="150px"
            BackColor="yellow" AppendDataBoundItems="true"
            onselectedindexchanged="ddlcountry_SelectedIndexChanged"
            DataTextField="country" DataValueField="country_code" ></asp:DropDownList></td>

     </tr>
    </table>
    </ContentTemplate>
 
    <Triggers>
 
    <asp:AsyncPostBackTrigger ControlID="ddlcountry" />
    </Triggers>
    </asp:UpdatePanel>

     <asp:UpdatePanel ID="UpdatePanel2" runat="server" >
 
    <ContentTemplate>
   <table>
    <tr>
    <td>
    <span>
    <strong>State</strong>
    </span>
    </td>

     <td>
    <asp:DropDownList ID="ddlstate" runat="server" AutoPostBack="true" Width="150px"
            BackColor="Aqua" DataTextField="state" DataValueField="state_code"
            onselectedindexchanged="ddlstate_SelectedIndexChanged"></asp:DropDownList>
    </td>
    </tr></table>
    </ContentTemplate>

     <Triggers>
    <asp:AsyncPostBackTrigger ControlID="ddlstate" />
    </Triggers>
    </asp:UpdatePanel>

    <asp:UpdatePanel ID="UpdatePanel3" runat="server" >
   <ContentTemplate>

    <tr>
   <td>
   <td>
   City
   </td>
 
   <asp:DropDownList ID="ddlcity" runat="server" AutoPostBack="true" Width="150px"  BackColor="AppWorkspace"></asp:DropDownList>
   </td>

    </tr>

    </ContentTemplate>
   <Triggers>
   <asp:AsyncPostBackTrigger ControlID="ddlcity" />
   </Triggers>
 
   </asp:UpdatePanel>
 
   <td>
 
   </td>
   <td>
   <asp:Button ID="Button1" runat="server" Text="Submit" Width="150px" onclick="Button1_Click" />
   </td>
    </div>
    </asp:View>

     <asp:View ID="View2" runat="server">
    <center><asp:Image ID="Image1" runat="server"  ImageUrl="done/done.jpg" /></center>
    </asp:View>
    </asp:MultiView>
    </form>
</body>
</html>
........................end source code....................
...............................code behind...............................
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
public partial class countrystatecity : System.Web.UI.Page
{
    SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ToString());

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            MultiView1.ActiveViewIndex = 0;
            country();
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        con.Open();
        string str = "insert into details values('"+TextBox1.Text+"',"+TextBox2.Text+",'"+ddlcountry.SelectedItem+"','"+ddlstate.SelectedItem+"','"+ddlcity.SelectedItem+"')";
        SqlCommand cmd = new SqlCommand(str,con);
        
        cmd.ExecuteNonQuery();
        con.Close();
        MultiView1.ActiveViewIndex = 1;
}
    protected void country()

    {
        con.Open();
        SqlCommand cmd = new SqlCommand("select country_code,country from country",con);
        SqlDataReader dr = cmd.ExecuteReader();
        ddlcountry.DataSource = dr;
        ddlcountry.Items.Clear();
        ddlcountry.Items.Add("--Please Select country--");
        ddlcountry.DataTextField = "Country";
        ddlcountry.DataValueField = "country_code";
        ddlcountry.DataBind(); ;
        con.Close();
    }

    public void State()
    {
        con.Open();

        SqlCommand cmd = new SqlCommand("select State_code,State from Statecountry where Country_code='" + ddlcountry.SelectedValue + "'", con);

        SqlDataReader dr = cmd.ExecuteReader();
        ddlstate.DataSource = dr;
        ddlstate.Items.Clear();
        ddlstate.Items.Add("--Please Select state--");
        ddlstate.DataTextField = "State";
        ddlstate.DataValueField = "State_code";
        ddlstate.DataBind();
        con.Close();
    }
    protected void ddlcountry_SelectedIndexChanged(object sender, EventArgs e)
    {
        State();
    }

    protected void city()
    {
        con.Open();
        SqlCommand cmd = new SqlCommand("select *from citystate where state_code ='"+ddlstate.SelectedValue+"'",con);
        SqlDataReader dr = cmd.ExecuteReader();
        ddlcity.DataSource = dr;
        ddlcity.DataTextField = "city"; ;
        ddlcity.DataValueField = "city_code";
        ddlcity.DataBind();
        ddlcity.Items.Insert(0, new ListItem("--select city--","0"));
        con.Close();

    }
    protected void ddlstate_SelectedIndexChanged(object sender, EventArgs e)
    {
        city();
    }
}

.......................code behind...............................
Share:

No comments:

Post a Comment

Sunday, 16 December 2012

How to find Country, State, City by dropdown selection using Ajax in C#?

................................source code..............................

 <%@ Page Language="C#" AutoEventWireup="true" CodeFile="countrystatecity.aspx.cs" Inherits="countrystatecity" Title="kul" %>

 <%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

 <html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
 
    <asp:ScriptManager ID="ScriptManager1" runat="server">
    </asp:ScriptManager>

     <asp:MultiView ID="MultiView1" runat="server">
    <asp:View ID="View1" runat="server">
    <div>
    <table>
    <tr>
    <td>Name</td>
    <td>
    <asp:TextBox ID="TextBox1" runat="server" Width="150px"> </asp:TextBox>
        <cc1:TextBoxWatermarkExtender ID="TextBox1_TextBoxWatermarkExtender"  WatermarkText="pls enter name"
            runat="server" Enabled="True" TargetControlID="TextBox1">
        </cc1:TextBoxWatermarkExtender>
        <td>
            <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server"
                ControlToValidate="TextBox1" ErrorMessage="RequiredFieldValidator">*</asp:RequiredFieldValidator>
        </td>
    </td>
    </tr>
 
    <tr>
    <td>
    Age
    </td>
    <td>
    <asp:TextBox ID="TextBox2" runat="server" Width="150px"></asp:TextBox>
        <cc1:TextBoxWatermarkExtender ID="TextBox2_TextBoxWatermarkExtender" WatermarkText="pls enter ur age"
            runat="server" TargetControlID="TextBox2">
        </cc1:TextBoxWatermarkExtender>
        <td>
       <asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server"
                ControlToValidate="TextBox2" ErrorMessage="Please enter Age">*</asp:RequiredFieldValidator>
            <asp:RangeValidator ID="RangeValidator1" runat="server"
                ControlToValidate="TextBox2" ErrorMessage="RangeValidator" MaximumValue="30"
                MinimumValue="20">*</asp:RangeValidator>
 
 
    <tr>
    <td>
    Mobile
    </td>
    <td>    <asp:TextBox ID="TextBox3" runat="server" Width="150px"></asp:TextBox>
        <cc1:TextBoxWatermarkExtender ID="TextBox3_TextBoxWatermarkExtender"
            runat="server" TargetControlID="TextBox3" WatermarkText="pls enter ur mobile no">
        </cc1:TextBoxWatermarkExtender>
        </td>
    <td><asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server"
            ControlToValidate="TextBox3">*</asp:RequiredFieldValidator>
            <asp:RegularExpressionValidator ID="RegularExpressionValidator6"
            runat="server" ControlToValidate="TextBox3" ValidationExpression="\d{10}">*</asp:RegularExpressionValidator>
            </td>

     </tr>
 
       
 
 
 
    </td>
    </td>
    </tr>
    </table>

     <asp:UpdatePanel ID="UpdatePanel1" runat="server" >
 
    <ContentTemplate>
    <table>
    <tr>
    <td>    <span><strong>Country</strong></span></td>
    <td>

     <asp:DropDownList ID="ddlcountry" runat="server" AutoPostBack="true" Width="150px"
            BackColor="yellow" AppendDataBoundItems="true"
            onselectedindexchanged="ddlcountry_SelectedIndexChanged"
            DataTextField="country" DataValueField="country_code" ></asp:DropDownList></td>

     </tr>
    </table>
    </ContentTemplate>
 
    <Triggers>
 
    <asp:AsyncPostBackTrigger ControlID="ddlcountry" />
    </Triggers>
    </asp:UpdatePanel>

     <asp:UpdatePanel ID="UpdatePanel2" runat="server" >
 
    <ContentTemplate>
   <table>
    <tr>
    <td>
    <span>
    <strong>State</strong>
    </span>
    </td>

     <td>
    <asp:DropDownList ID="ddlstate" runat="server" AutoPostBack="true" Width="150px"
            BackColor="Aqua" DataTextField="state" DataValueField="state_code"
            onselectedindexchanged="ddlstate_SelectedIndexChanged"></asp:DropDownList>
    </td>
    </tr></table>
    </ContentTemplate>

     <Triggers>
    <asp:AsyncPostBackTrigger ControlID="ddlstate" />
    </Triggers>
    </asp:UpdatePanel>

    <asp:UpdatePanel ID="UpdatePanel3" runat="server" >
   <ContentTemplate>

    <tr>
   <td>
   <td>
   City
   </td>
 
   <asp:DropDownList ID="ddlcity" runat="server" AutoPostBack="true" Width="150px"  BackColor="AppWorkspace"></asp:DropDownList>
   </td>

    </tr>

    </ContentTemplate>
   <Triggers>
   <asp:AsyncPostBackTrigger ControlID="ddlcity" />
   </Triggers>
 
   </asp:UpdatePanel>
 
   <td>
 
   </td>
   <td>
   <asp:Button ID="Button1" runat="server" Text="Submit" Width="150px" onclick="Button1_Click" />
   </td>
    </div>
    </asp:View>

     <asp:View ID="View2" runat="server">
    <center><asp:Image ID="Image1" runat="server"  ImageUrl="done/done.jpg" /></center>
    </asp:View>
    </asp:MultiView>
    </form>
</body>
</html>
........................end source code....................
...............................code behind...............................
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
public partial class countrystatecity : System.Web.UI.Page
{
    SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ToString());

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            MultiView1.ActiveViewIndex = 0;
            country();
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        con.Open();
        string str = "insert into details values('"+TextBox1.Text+"',"+TextBox2.Text+",'"+ddlcountry.SelectedItem+"','"+ddlstate.SelectedItem+"','"+ddlcity.SelectedItem+"')";
        SqlCommand cmd = new SqlCommand(str,con);
        
        cmd.ExecuteNonQuery();
        con.Close();
        MultiView1.ActiveViewIndex = 1;
}
    protected void country()

    {
        con.Open();
        SqlCommand cmd = new SqlCommand("select country_code,country from country",con);
        SqlDataReader dr = cmd.ExecuteReader();
        ddlcountry.DataSource = dr;
        ddlcountry.Items.Clear();
        ddlcountry.Items.Add("--Please Select country--");
        ddlcountry.DataTextField = "Country";
        ddlcountry.DataValueField = "country_code";
        ddlcountry.DataBind(); ;
        con.Close();
    }

    public void State()
    {
        con.Open();

        SqlCommand cmd = new SqlCommand("select State_code,State from Statecountry where Country_code='" + ddlcountry.SelectedValue + "'", con);

        SqlDataReader dr = cmd.ExecuteReader();
        ddlstate.DataSource = dr;
        ddlstate.Items.Clear();
        ddlstate.Items.Add("--Please Select state--");
        ddlstate.DataTextField = "State";
        ddlstate.DataValueField = "State_code";
        ddlstate.DataBind();
        con.Close();
    }
    protected void ddlcountry_SelectedIndexChanged(object sender, EventArgs e)
    {
        State();
    }

    protected void city()
    {
        con.Open();
        SqlCommand cmd = new SqlCommand("select *from citystate where state_code ='"+ddlstate.SelectedValue+"'",con);
        SqlDataReader dr = cmd.ExecuteReader();
        ddlcity.DataSource = dr;
        ddlcity.DataTextField = "city"; ;
        ddlcity.DataValueField = "city_code";
        ddlcity.DataBind();
        ddlcity.Items.Insert(0, new ListItem("--select city--","0"));
        con.Close();

    }
    protected void ddlstate_SelectedIndexChanged(object sender, EventArgs e)
    {
        city();
    }
}

.......................code behind...............................
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Popular

Blog Archive

Total Pageviews

Archive