•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the C# section within the Software Development category of DaniWeb, a massive community of 455,976 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,797 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our C# advertiser: Programming Forums
Views: 7230 | Replies: 29
 |
•
•
Join Date: Nov 2007
Posts: 40
Reputation: 
Rep Power: 0
Solved Threads: 0
Light Poster
hi
i want to populate country's name in 1st dropdownlist and their states should be placed in the 2nd dropdownlist, if we select any state it should place the name of the capital in the textbox besides that and so on.....
If possible send me code
thank you in advance
raghu
i want to populate country's name in 1st dropdownlist and their states should be placed in the 2nd dropdownlist, if we select any state it should place the name of the capital in the textbox besides that and so on.....
If possible send me code
thank you in advance
raghu
•
•
Join Date: Nov 2006
Location: Bonners Ferry, ID
Posts: 280
Reputation:
Rep Power: 3
Solved Threads: 39
Posting Whiz in Training
Simply write an event handler on the SelectedIndex change of the combobox to adjust the item for the second. On the second, have another event handler that sets the textbox value. You can populate a Combo using objects that contain the matching information to go into the text box.
Is this a homework assignment ?
Is this a homework assignment ?
•
•
Join Date: Nov 2007
Posts: 40
Reputation:
Rep Power: 0
Solved Threads: 0
Light Poster
thank you or ypur advice
but i am developing web application using C#,just look at my code which is giving error message...
If i want to select any country from 1st dropdownlist then,2nd dropdownlist should populate with all the state of that paticular country only and if we select any state from 2nd dropdown then the capital should be placed in text box beside that and so on...
but i am developing web application using C#,just look at my code which is giving error message...
if (Page.IsPostBack == false)
{
SqlConnection con = new SqlConnection("user id=sa;password=vubrain;database=raghu;data source=vubrain4");
SqlDataAdapter da = new SqlDataAdapter("select countyr_id,countryname from country_master", con);
DataSet ds1 = new DataSet();
da.Fill(ds1, "country_master");
dd1.DataSource = ds1.Tables["country_master"];
dd1.DataTextField = "countryname";
dd1.DataValueField = "countyr_id";
dd1.DataBind();
}
}
protected void dd1_SelectedIndexChanged(object sender, EventArgs e)
{
string countryid;
countryid = dd1.SelectedValue;
SqlConnection con = new SqlConnection("user id=sa;password=vubrain;database=raghu;data source=vubrain4");
SqlDataAdapter da1 = new SqlDataAdapter("SELECT stateid,statename FROM countrystate");
DataSet ds1 = new DataSet();
da1.Fill(ds1, "countrystate");
dd2.DataSource = ds1.Tables["countrystate"];
dd2.DataTextField = "statename";
dd2.DataValueField = "stateid";
dd2.DataBind();
}
protected void dd2_SelectedIndexChanged(object sender, EventArgs e)
{
string stateid;
stateid = dd2.SelectedValue;
} Last edited by cscgal : Dec 4th, 2007 at 3:07 am. Reason: Added code tags
•
•
Join Date: Nov 2007
Posts: 40
Reputation:
Rep Power: 0
Solved Threads: 0
Light Poster
how many tables should we have to create
•
•
Join Date: Nov 2006
Location: Bonners Ferry, ID
Posts: 280
Reputation:
Rep Power: 3
Solved Threads: 39
Posting Whiz in Training
You need to specify what country to use when you pull the data for the second drop down.
This way it will only contain the states for that country.
string sql = "SELECT stateid,statename FROM countrystate where country_id='{0}' ";
SqlDataAdapter da1 = new SqlDataAdapter( string.Format(sql,countryid) );This way it will only contain the states for that country.
•
•
Join Date: Nov 2007
Posts: 40
Reputation:
Rep Power: 0
Solved Threads: 0
Light Poster
i am no geting in that way
will you please explain what are the table are to be created..
please send posr my reply its very important
thank you in advance
will you please explain what are the table are to be created..
please send posr my reply its very important
thank you in advance
•
•
Join Date: Nov 2006
Location: Bonners Ferry, ID
Posts: 280
Reputation:
Rep Power: 3
Solved Threads: 39
Posting Whiz in Training
Your code should work fine as is, you just need to give the Where Country_id= ... in the query so that it returns the states for that country.
protected void dd1_SelectedIndexChanged(object sender, EventArgs e)
{
string countryid;
countryid = dd1.SelectedValue;
SqlConnection con = new SqlConnection("user id=sa;password=vubrain;database=raghu;data source=vubrain4");
SqlDataAdapter da1 = new SqlDataAdapter(string.Format("SELECT stateid,statename FROM countrystate where country_id='{0}' ",countryid) );
DataSet ds1 = new DataSet();
da1.Fill(ds1, "countrystate");
dd2.DataSource = ds1.Tables["countrystate"];
dd2.DataTextField = "statename";
dd2.DataValueField = "stateid";
dd2.DataBind();
} •
•
Join Date: Nov 2007
Posts: 40
Reputation:
Rep Power: 0
Solved Threads: 0
Light Poster
I wrote the code as you said, but it showing two error in sqldataAdapter
1.Argument '1': cannot convert from 'string'to 'System.Data.SqlClient.SqlCommand'
2.The best overloaded method match for 'System.Data.SqlClient.SqlDataAdapter.SqlDataAdapt er
please sought this problem
1.Argument '1': cannot convert from 'string'to 'System.Data.SqlClient.SqlCommand'
2.The best overloaded method match for 'System.Data.SqlClient.SqlDataAdapter.SqlDataAdapt er
please sought this problem
•
•
Join Date: Nov 2006
Location: Bonners Ferry, ID
Posts: 280
Reputation:
Rep Power: 3
Solved Threads: 39
Posting Whiz in Training
ok, I will write the code example, and post it here in the next few minutes.
•
•
Join Date: Nov 2006
Location: Bonners Ferry, ID
Posts: 280
Reputation:
Rep Power: 3
Solved Threads: 39
Posting Whiz in Training
Attached is a Windows Application project that demos what you are looking for,
I am using my own server (connection string), and it uses two tables. Read the top of the form.c to see my comments.
You should have no problem converting this to asp.
Good luck,
J
I am using my own server (connection string), and it uses two tables. Read the top of the form.c to see my comments.
You should have no problem converting this to asp.
Good luck,
J
|
•
•
•
•
•
•
•
•
DaniWeb C# Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
Similar Threads
- SelectedIndexChanged in DropDownList won't trigger (VB.NET)
- asynchronous dropdownlist any idea (ASP.NET)
- Dropdownlist.... please help (C#)
- dropdownlist not firing (VB.NET)
- dropdownlist not firing (ASP.NET)
- please anybody to help Dropdownlist selected index problem (ASP.NET)
- POpulate DataGrid (VB.NET)
- retrieving ids from dynamically created controls in asp.net (ASP)
- DataGrid: Edit mode, the index of a dropdownlist does not start at the right Value (ASP.NET)
Other Threads in the C# Forum
- Previous Thread: Highlight the data in the DataGrid when it is searched...
- Next Thread: need help for distributed Application
