Help on dropdown list [Resolved]

ID	Name

1	INDIA

2	USA

ID	Name		CountryID

1	Orissa		1

2	Karnataka	1

3	NewYork		2

4	Mexico		2

Select ID,Name,CountryID from [State]

UNION 

Select 0 as ID,Name,ID as CountryID from Country

order by CountryID,ID

//Populate some country

            DataTable cntry = new DataTable();

            cntry.Columns.Add("CntryID");

            cntry.Columns.Add("Name");

            cntry.Rows.Add(new object[] { 1, "India" });

            cntry.Rows.Add(new object[] { 2, "USA" });



            //Populate some states

            DataTable state = new DataTable();

            state.Columns.Add("SateID");

            state.Columns.Add("Name");

            state.Columns.Add("CntryID");



            state.Rows.Add(new object[] { 1, "AP",1 });

            state.Rows.Add(new object[] { 2, "UP",1 });

            state.Rows.Add(new object[] { 3, "UP", 1 });

            state.Rows.Add(new object[] { 4, "NY",2 });

            state.Rows.Add(new object[] { 5, "MEXICO", 2 });



            List<object> MyCustomState = new List<object>();

            //for each country add states if any states present

            foreach (DataRow item in cntry.Rows)

            {

                MyCustomState.Add(item["Name"]);

                foreach (DataRow sitem in state.Rows.Cast<DataRow>().Where(s => s["CntryID"].Equals(item["CntryID"])))

                {

                    MyCustomState.Add(sitem["Name"]);

                }

            }

vijaya

sqry = "SELECT a.states+' '+b.country as statecountry FROM state a left outer join country b on a.countryid=b.countryid" 

sqcom = New SqlCommand(sqry, sqcon) 

da.SelectCommand = sqcom  ds.Clear() 

da.Fill(ds) 

ddl_adv.DataSource = ds 

ddl_adv.DataTextField = "emp_fullname"

 ddl_adv.DataValueField = "emp_no"  

ddl_adv.DataBind() 

sqcon.Close()

Mark this as answer, if it is.....

With regards
Nishithraj Narayanan

vijaya

vijaya