ASP.NET

ASP.NET RSS

on selecting country from one dropdownlist ...states of selected country is not getti

Please support our ASP.NET advertiser: Intel Parallel Studio Home

Thread Solved

•

Join Date: Dec 2008

Posts: 21

Reputation: divyasrinivasan is an unknown quantity at this point

Solved Threads: 0

divyasrinivasan divyasrinivasan is offline

Offline

Newbie Poster

on selecting country from one dropdownlist ...states of selected country is not getti

Dec 9th, 2008

pls give me the complete code for it ..i tryed but not getting the output..pls help..iam pasting the code here but no output

 Help with Code Tags 
 aspnet Syntax (Toggle Plain Text) 
 SqlConnection cn = new SqlConnection(ConfigurationSettings.AppSettings["con"].ToString());
 
    protected void Page_Load(object sender, EventArgs e)
    {
 
 
        Response.Write("sql is connected");
        SqlDataAdapter da = new SqlDataAdapter("select countryid,countryname from countryname", cn);
        DataSet ds = new DataSet();
        da.Fill(ds,"countryname");
        ddlcountryname.DataSource = ds.Tables["countryname"];
        ddlcountryname.DataTextField = "countryname";
        ddlcountryname.DataValueField = "countryid";
        ddlcountryname.DataBind();
 
 
    }
    protected void ddlcountryname_SelectedIndexChanged(object sender, EventArgs e)
    {
        string country_id;
        country_id = ddlcountryname.SelectedValue.ToString();
        SqlDataAdapter da1=new SqlDataAdapter("select stateid,statename from statename where countryid=' country_id'",cn);
        DataSet ds1 = new DataSet();
        da1.Fill(ds1, "statename");
        ddlstatename.DataSource = ds1.Tables["statename"];
        ddlstatename.DataTextField = "statename";
        ddlstatename.DataValueField = "stateid";
        ddlstatename.DataBind();
    }
 SqlConnection cn = new SqlConnection(ConfigurationSettings.AppSettings["con"].ToString());
   
    protected void Page_Load(object sender, EventArgs e)
    {
       
        
        Response.Write("sql is connected");
        SqlDataAdapter da = new SqlDataAdapter("select countryid,countryname from countryname", cn);
        DataSet ds = new DataSet();
        da.Fill(ds,"countryname");
        ddlcountryname.DataSource = ds.Tables["countryname"];
        ddlcountryname.DataTextField = "countryname";
        ddlcountryname.DataValueField = "countryid";
        ddlcountryname.DataBind();
        

    }
    protected void ddlcountryname_SelectedIndexChanged(object sender, EventArgs e)
    {
        string country_id;
        country_id = ddlcountryname.SelectedValue.ToString();
        SqlDataAdapter da1=new SqlDataAdapter("select stateid,statename from statename where countryid=' country_id'",cn);
        DataSet ds1 = new DataSet();
        da1.Fill(ds1, "statename");
        ddlstatename.DataSource = ds1.Tables["statename"];
        ddlstatename.DataTextField = "statename";
        ddlstatename.DataValueField = "stateid";
        ddlstatename.DataBind();
    }

my database is something like this...i have two tables countryname(countryid identity(1,1),countryname) and statename(stateid identity(100,1),statename,countryid)

so i have inserted 78 countries in country table in tat 73rd is india...
n i have inserted states of india in statename table(28)..how to get india's states wen india in selected

Last edited by cscgal; Dec 9th, 2008 at 1:16 pm. Reason: Added code tags

•

Join Date: Dec 2007

Posts: 34

Reputation: vizy is an unknown quantity at this point

Solved Threads: 6

vizy

Offline

Light Poster

Re: on selecting country from one dropdownlist ...states of selected country is not getti

Dec 9th, 2008

Hi..

Put all the code in Page load event in !IspostBack like below..

protected void Page_Load(object sender, EventArgs e)
{
if(!IsPostback)
{
// your code here
}
}

Njoy koding... >>>

•

Join Date: Apr 2007

Posts: 370

Reputation: greeny_1984 is an unknown quantity at this point

Solved Threads: 29

greeny_1984 greeny_1984 is offline

Offline

Posting Whiz

Re: on selecting country from one dropdownlist ...states of selected country is not getti

Dec 10th, 2008

hi,
did u set autopsotback to true for u r country dropdown .

If u r query is achieved,mark the thread as solved

Live and Let Live

•

Join Date: Dec 2008

Posts: 21

Reputation: divyasrinivasan is an unknown quantity at this point

Solved Threads: 0

divyasrinivasan divyasrinivasan is offline

Offline

Newbie Poster

Re: on selecting country from one dropdownlist ...states of selected country is not getti

Dec 10th, 2008

if i keep autopostback to tru ...if i select some country say america...iam getting the first country selected ..tat is afganisthan....
i have
afganisthan
america
india
say if i select india afganisthan is only coming.....n i want databasee like how to insert states for country india....like i said i have 3 fields...but i have 28 states....how to write table...
lot of confusion

•

Join Date: Apr 2007

Posts: 370

Reputation: greeny_1984 is an unknown quantity at this point

Solved Threads: 29

greeny_1984 greeny_1984 is offline

Offline

Posting Whiz

Re: on selecting country from one dropdownlist ...states of selected country is not getti

Dec 10th, 2008

hi,
inoder to get states its compulsory that u set autopostback to true.The Reply u gave is confusing to me.
can u be eloborate .

coming to creating table

table1

countryid

country name

table 2

id

country_id

state_id

state_name

when u select a country

the query for u r state would be

select state_id,state_name from table2 where country_id="+int.parse(ddlcountry.selectedvalue)+"

If u r query is achieved,mark the thread as solved

Live and Let Live

•

Join Date: Dec 2008

Posts: 21

Reputation: divyasrinivasan is an unknown quantity at this point

Solved Threads: 0

divyasrinivasan divyasrinivasan is offline

Offline

Newbie Poster

Re: on selecting country from one dropdownlist ...states of selected country is not getti

Dec 10th, 2008

the query u gave me i wrote it ..u can see tat...but there is no output...
like
stateis statename countryid
100 Ahmedabad 1
101 guntur 2
103 -----

see these r alll same for india ..wat i shld do but country id 1 ,2 ,3

•

Join Date: Dec 2008

Posts: 21

Reputation: divyasrinivasan is an unknown quantity at this point

Solved Threads: 0

divyasrinivasan divyasrinivasan is offline

Offline

Newbie Poster

Re: on selecting country from one dropdownlist ...states of selected country is not getti

Dec 10th, 2008

country table...
countryid countryname
1 america
2 brazil
3 india

•

Join Date: Mar 2008

Posts: 268

Reputation: Traicey is an unknown quantity at this point

Solved Threads: 19

Traicey

Offline

Posting Whiz in Training

Re: on selecting country from one dropdownlist ...states of selected country is not getti

Dec 10th, 2008

SqlDataAdapter da1=new SqlDataAdapter("select stateid,statename from statename where countryid=' country_id'",cn);
Try and fix this line cos you dont need to put the country_id within single and Double qoutations marks which u have declared and set its value to the one selected on DDL

The better sollution will be
SqlDataAdapter da1=new SqlDataAdapter("select stateid,statename from statename where countryid = " + country_id ,cn);

Some people get so rich they lose all respect for humanity. That's how rich I want to be.

•

Join Date: Apr 2007

Posts: 370

Reputation: greeny_1984 is an unknown quantity at this point

Solved Threads: 29

greeny_1984 greeny_1984 is offline

Offline

Posting Whiz

Re: on selecting country from one dropdownlist ...states of selected country is not getti

Dec 10th, 2008

did u declare int for countryid ,if so u r storing string in int column

try to convert string to int
using

int.parse(ddlcountry.selectedvalue.tostring())

If u r query is achieved,mark the thread as solved

Live and Let Live

•

Join Date: Dec 2007

Posts: 34

Reputation: vizy is an unknown quantity at this point

Solved Threads: 6

vizy

Offline

Light Poster

Re: on selecting country from one dropdownlist ...states of selected country is not getti

#10

Dec 10th, 2008

Hi

did you tried doing this.. ?

 Help with Code Tags 
 asp.net Syntax (Toggle Plain Text) 
protected void Page_Load(object sender, EventArgs e)
{
     if(!IsPostback)
     {
            // your complete Country code here
     }
}
protected void Page_Load(object sender, EventArgs e)
{
     if(!IsPostback)
     {
            // your complete Country code here
     }
}

I think this is the only thing u are missing...
bocz after the country is selected the page gets PostBack to server
and execute the Page_Load everytime.. that's the reason u are getting "Afghanistan" selected even after selecting "America" as it is getting bind everytime

Last edited by peter_budo; Dec 12th, 2008 at 6:56 am. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

Njoy koding... >>>