Dropdown List

Question

Hi

   I have below code & i want on the basis of StateCollection , i want to display Locations in another dropdown

private void GetData()
        {
            string StateCollection = "";
            //List<string> StateCollection = new List<string>();
            if (lstState.Items.Count > 0)
            {
                for (int i = 0; i < lstState.Items.Count; i++)
                {
                    if (lstState.Items[i].Selected)
                    {
                        StateCollection += lstState.Items[i].Value.ToString() + ",";
                    }
                }
            }
        }

 

In Location i have below fields

LocationId = int

StateCode = int

LocationName = varchar(30)

Thanks