Ad:

ASP.NET Discussion Thread
Marked Solved
Views: 3087

You are currently viewing page 2 of this multi-page discussion thread; Jump to the first page

Dec 10th, 2008

Re: Master/Detail DropDownList and DataGrid

i have two drop downlist wen i select india the partcular states shld come....but my selected index function is different from urs....is it correct

divyasrinivasan

Reputation Points: 7

Solved Threads: 0

Newbie Poster

Offline

21 posts
since Dec 2008

Permalink

Dec 10th, 2008

Re: Master/Detail DropDownList and DataGrid

Is your DDL filled with each country?

Traicey

Reputation Points: 26

Solved Threads: 19

Posting Whiz in Training

Offline

283 posts
since Mar 2008

Permalink

Dec 10th, 2008

Re: Master/Detail DropDownList and DataGrid

hi myrequirement is i have two dropdownlist one is country n other is statename.....wen i selelc india corresponding states shls come...but i see my selected index function is different from urs...pls explain tat...n is my code right..iam not getting the output....

one more thing how did u create the table for tat category..like i inserted 79 countries.....with id...now in state table i need to insert 28 states for india..
stateid statename countryid.....or i need to have stateid statename1........statename28 countryid

divyasrinivasan

Reputation Points: 7

Solved Threads: 0

Newbie Poster

Offline

21 posts
since Dec 2008

Permalink

Dec 10th, 2008

Re: Master/Detail DropDownList and DataGrid

ya i got all the countries wic i inserted into ddllcountryname

divyasrinivasan

Reputation Points: 7

Solved Threads: 0

Newbie Poster

Offline

21 posts
since Dec 2008

Permalink

Dec 10th, 2008

Re: Master/Detail DropDownList and DataGrid

I had the same problem my DDL doesnt talk to me back if I just select and do nothing, I couldnt figure out what was the problem because I had selectedChanged event but then until I had a button which I named to go and I didnt code anything on the button I just drag and dropped it so I select something from the DDL and click in the button and it worked just try that to see if its working then u will fix that problem later

Traicey

Reputation Points: 26

Solved Threads: 19

Posting Whiz in Training

Offline

283 posts
since Mar 2008

Permalink

Dec 10th, 2008

Re: Master/Detail DropDownList and DataGrid

its registration form ..i cant keep button na...u find this in many site select country n corresponidng states will come in another dropdownlist...but the code iam not finding

divyasrinivasan

Reputation Points: 7

Solved Threads: 0

Newbie Poster

Offline

21 posts
since Dec 2008

Permalink

Dec 10th, 2008

Re: Master/Detail DropDownList and DataGrid

U jst need to make sure that the countryID on the state table is corresponding to the one on the country name, then you can have a select stateme like this on ur dataadpater

SQL Syntax (Toggle Plain Text)
SELECT * FROM State
WHERE CountryID = ddlCountries.selectedValue;
Select * from State
where CountryID = ddlCountries.selectedValue;

Im sory I cant read your code can u edit it and make it C# instead of just text, its killing me

[ Code=C# ]
Paste code here dont leave
[ /Code ]
there souldnt be any space in between ur square brackets

Traicey

Reputation Points: 26

Solved Threads: 19

Posting Whiz in Training

Offline

283 posts
since Mar 2008

Permalink

Dec 10th, 2008

Re: Master/Detail DropDownList and DataGrid

I think at the moment u can use that to debug and see whats working and what's not working then after that u can fix ur selectedindexchanged event on DDL

Traicey

Reputation Points: 26

Solved Threads: 19

Posting Whiz in Training

Offline

283 posts
since Mar 2008

Permalink

Dec 10th, 2008

Re: Master/Detail DropDownList and DataGrid

C# Syntax (Toggle Plain Text)
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();
}
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();
}

Last edited by peter_budo; Dec 10th, 2008 at 6:50 am. Reason: Correcting closing tag from [\code] to [/code]

divyasrinivasan

Reputation Points: 7

Solved Threads: 0

Newbie Poster

Offline

21 posts
since Dec 2008

Permalink

Dec 10th, 2008

Re: Master/Detail DropDownList and DataGrid

SqlDataAdapter da1=new SqlDataAdapter("select stateid,statename from statename where countryid=' country_id'",cn);
Why your country_ID which you declared as a string is within single and double qoutation marks

Try this and see if it helps
SqlDataAdapter da1=new SqlDataAdapter("select stateid,statename from statename where countryid = " + country_id ,cn);

Last edited by Traicey; Dec 10th, 2008 at 5:57 am.

Traicey

Reputation Points: 26

Solved Threads: 19

Posting Whiz in Training

Offline

283 posts
since Mar 2008

Previous
1
Page 2

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ASP.NET Forum Timeline: How to Send email using asp.net with C#

Next Thread in ASP.NET Forum Timeline: how to print the contents of text box

DaniWeb Message

Cancel Changes

User Name
Password