HI ALL....

FRANKLY FIRST OF ALL I WANT TO TELL YOU THAT FOR LAST ONE WEEK I HAVE BEEN STUCKED WITH THE TWO DROPDOWN LISTs.......SERARCHED THE NET SO THROUGHLY BUT COULDN'T FIND ANY SOLUTION.........I HOPE ANY OF YOU MUST HAVE THE SOLUTION. THE PROBLEM IS..

I HAVE TWO DROPDOWNLISTS, ONE FOR THE COUNTRY AND THE OTHER FOR CITY. I AM ABLE TO POPULATE THE COUNTRY's DROPDOWNLIST FROM THE ACCESS DATABASE AND ALSO ABLE TO POPULATE THE CITY DROPDOWN LIST ON BEHALF OF THE FIRST SELECTED COUNTRY FROM COUNTRY'S DROPDOWNLIST USING THE SELECTEDINDEXCHAGED EVENT. BUT I AM NOT ABLE TO POPULATE THE OTHER COUNTRY'S CITY IN CITY DROPDOWNLIST, WHEN I CLICK THE SECOND COUNTRY IN COUNTRY'S DROPDOWNLIST, HOW CAN IT BE....

THE BROWSER DOESN'T THROUWS AN ERROR, BUT WHEN I SELECT THE SECOND COUNTRY , AFTER POSTBACK THE FIRST COUNTRY REMAINS HIGHLITED INSTEAD OF THE SECOND COUNTRY WHICH HAD BEEN CLICKED.

THE FOLLOWING IS THE CODE WHICH I AM EXECUTING:

private void Page_Load(object sender, System.EventArgs e)
{
string str;
str = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\wwwroot\dropdown1\database\users .mdb;Persist Security Info=False";
OleDbConnection strConnection = new OleDbConnection(str);
strConnection.Open();
OleDbCommand objCommand = new OleDbCommand("Select country from country", strConnection);
OleDbDataReader dr;
dr = objCommand.ExecuteReader();

DropDownList1.DataSource = dr;
DropDownList1.DataBind();


strConnection.Close();
}

private void DropDownList1_SelectedIndexChanged(object sender, System.EventArgs e)
{

string str;
str = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\wwwroot\dropdown1\database\users .mdb;Persist Security Info=False";
OleDbConnection strConnection = new OleDbConnection(str);
strConnection.Open();
OleDbCommand objCommand = new OleDbCommand("SELECT city FROM city where country='" + DropDownList1.SelectedItem.Text + "' " , strConnection);
OleDbDataReader dr;
dr = objCommand.ExecuteReader();


DropDownList2.DataSource = dr;
DropDownList2.DataBind();

strConnection.Close();

}

I HAVE USED THE DataTextField = " country " for first dropdownlist and DataTextField = " city " for the second dropdownlist in .aspx file.


Thank you in anticipation in advance for your reply...


Abdul Ghaffar

Hi,

I'm using double drop-down lists all throughout my application. I'm not really all that familiar with C# but in VB syntax I have to add the 'Handles' syntax for it to fire off and fill the second drop-down otherwise changing the selectedindex change for the first drop-down does nothing. I don't know if the syntax for C# is the same but I'm guessing there might be some kind of similar functionality. Also when declaring the variables they must be declared using WithEvents.

Private Sub ddlAreaID_SelectedIndexChanged(ByVal sender As Object, ByVal e As EventArgs) Handles ddlAreaID.SelectedIndexChanged

Hi...thanks for your reply.....but i don't have any idea about Handles in C#......

Abdul Ghaffar

Hello,

Pls check whether in DDL (Country)'s Autopostback property is set to 'True'. If it is false, your code may not work.



Tanakrit A.

Thanks Tanakrit A. for your reply.......

The DropdownList autopost back propery is already set to 'true'.

Abdul Ghaffar

Thanks all for you replies........

The Problem has been sorted out.....when i added if(!Page.IsPostBack) in my page-load

Bbye
A-Ghaffar

Thanks all for you replies........

The Problem has been sorted out.....when i added if(!IsPostBack)

in my page-load

Bbye
A-Ghaffar