Re: populate two dropdownlist
 

thank you very much i will go through that
i will be in touch with you after going through that

Re: populate two dropdownlist
 

hi jerry,sorry to say that the attachment you send to me is not opeaning it showing some error

Re: populate two dropdownlist
 

hi jerry i got your attachment, in that you created tables but,while insering the values it showing some error message as

An explicit value for the identity column in table 'countrymaster88' can only be specified when a column list is used and IDENTITY_INSERT is ON.

Re: populate two dropdownlist
 

where can i get bindingsource components

Re: populate two dropdownlist
 

hi jerry i got your attachement and i build my own application just like yours but i gettin error message, just go through my my coding .


protected void Page_Load(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("user id=sa;password=vubrain;database=raghu;data source=vubrain4");
SqlDataAdapter da = new SqlDataAdapter("select county_id,countryname from country_master88", con);
DataSet ds1 = new DataSet();
da.Fill(ds1, "country_master88");
dd1.DataSource = ds1.Tables["country_master88"];
dd1.DataTextField = "countryname";
dd1.DataValueField = "countyr_id";



}

protected void dd1_SelectedIndexChanged(object sender, EventArgs e)
{
DataRowView drv;
string countryid;
if (dd1.SelectedValue == null) return;
if (dd1.SelectedValue is DataRowView)
{
drv = (DataRowView)dd1.SelectedValue;
countryid = drv["country_id"].ToString();
}
else
countryid = dd1.SelectedValue.ToString();
if (countryid == string.Empty) return;
string sql = string.Format("SELECT stateid,statename FROM countrystate88 where county_id={0}", countryid);
SqlConnection con = new SqlConnection("user id=sa;password=vubrain;database=raghu;data source=vubrain4");
SqlDataAdapter da1 = new SqlDataAdapter(sql, con);
DataSet ds1 = new DataSet();
da1.Fill(ds1, "countrystate");
dd1.DataSource = ds1.Tables["countrystate88"];
dd2.DataTextField = "statename";
dd2.DataValueField = "stateid";
dd2.SelectedIndexChanged(null, null);
}
protected void DropDownList2_SelectedIndexChanged(object sender, EventArgs e)
{
DataRowView drv;
string countryid;
string stateid;
if (dd2.SelectedValue == null) return;
if (dd2.SelectedValue is DataRowView)
{
drv = (DataRowView)dd2.SelectedValue;
stateid = drv["stateid"].ToString();
}
else
stateid = dd2.SelectedValue.ToString();
if (dd1.SelectedValue is DataRowView)
{
drv = (DataRowView)dd1.SelectedValue;
countryid = drv["county_id"].ToString();
}
else
countryid = dd1.SelectedValue.ToString();
if (countryid == string.Empty || stateid == string.Empty) return;
string sql = string.Format("SELECT capital FROM countrystate where county_id={0} and stateid={1}", countryid, stateid);
SqlConnection con = new SqlConnection("user id=sa;password=vubrain;database=raghu;data source=vubrain4");
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
SqlDataReader rdr = cmd.ExecuteReader();
rdr.Read();
t1.Text = rdr[0].ToString();
con.Close();
}
}

Re: populate two dropdownlist
 

errors for the above codding is
1. it shows error in the both dropdownlist_selectedchange
near "if (dd2.SelectedValue is DataRowView)"
the message is : The given expression is never of the provided ('System.Data.DataRowView') type

2.next error shows at "drv = (DataRowView)dd1.SelectedValue"
the message Error is: Cannot convert type 'string' to 'System.Data.DataRowView'

3.next error showas at
"dd2.SelectedIndexChanged(null, null)"
the error message is: The event 'System.Web.UI.WebControls.ListControl.SelectedIndexChanged' can only appear on the left hand side of += or -=

and the same errors for all the dropdownlist_selectedindexcanged..


just solve my problem its very urgent

thank you
raghu

Re: populate two dropdownlist
 

rahgu,

What version of c# are you using ?
There are some differences that can cause these problems.

I know you are in dire need of this, but I have to go to work in a few minutes. If you are willing to wait until tonight (California time) I will write it as an ASP application to get rid of the problems you are seeing.

In the mean time, you can modify the code I sent to be used as a Windows Application so you can see how it works. Works flawlessly here.
That may help you get it working in ASP.

I will post the APS version in about 10 hours.

--Jerry

Re: populate two dropdownlist
 

Attached is a simple ASP.net project that demonstrates the double drop-down.
Now this is not real efficient. If this were to be used for a production site, you should cache the information, and use JavaScript or AJAX methods to display the information rather than return to the server side.

Jerry

Re: populate two dropdownlist
 

thanks jerry i am using C# 2.0 version and asp.net 2005

Re: populate two dropdownlist
 

thanks jerry i got through the coding
but the values in dropdown list i am not getting the exact way what i want,i will explain you again that if we select any country from 1stdropdownlist then it should place only selected country's states in the second dropdownlist and so on...
just tell me how many tables should i have to prepare in sql server..

thanku you jerry for your replies, i do consider tha as my best part of my job