Hi,
How to load data in dropdownlist based on other without refreshing the page and without using Ajax?....

I too have that doubt.
While selecting an item from a dropdownlist box,the page was refreshed and i had to loss the selected data and the first element was automatically selected.
If you get the answer for this then please reply me.
-Kirubha

Hi,
We can avoid full page refreshment while loading data in dropDownlist using XML.For this u need the XML File to be generated for ur table.
Here i used countryContent.xml which contains both country and its related state.
protected void Page_Load(object sender, EventArgs e)
{
DataTable dataTable = new DataTable();
DataRow dr;
dataTable.Columns.Add("countryName",typeof(string) );
if (!IsPostBack)
{
XmlDocument xdoc = new XmlDocument();
XmlTextReader xtr = new XmlTextReader(Server.MapPath("countryContent.xml") );
xdoc.Load(xtr);
XmlNodeList xnl = xdoc.DocumentElement.SelectNodes("country");
foreach (XmlNode xnode in xnl)
{
dr = dataTable.NewRow();
dr[0] = xnode.Attributes[0].Value;
dataTable.Rows.Add(dr);
}
countryDropDownList.DataSource = dataTable;
countryDropDownList.DataValueField = "countryName";
countryDropDownList.DataBind();
}
}

protected void countryDropDownList_SelectedIndexChanged(object sender, EventArgs e)
{
stateDropDownList.Items.Clear();
GetStateFromCountry();

}
public void GetStateFromCountry()
{
int flag = 0;
DataTable dataTable = new DataTable();
DataRow dr;
dataTable.Columns.Add("stateName", typeof(string));
XmlDocument xdoc = new XmlDocument();
XmlNode snode=null;
XmlTextReader xtr = new XmlTextReader(Server.MapPath("countryContent.xml") );
xdoc.Load(xtr);
XmlNodeList xnl = xdoc.DocumentElement.SelectNodes("country");
foreach (XmlNode xnode in xnl)
{
if (xnode.Attributes[0].Value == countryDropDownList.SelectedItem.Text)
{
flag = 1;
snode = xnode;

}
}
if (flag == 1)
{
XmlNodeList stateNodeList = snode.ChildNodes;
foreach (XmlNode xsnode in stateNodeList)
{
dr = dataTable.NewRow();
dr[0] = xsnode.Attributes[1].Value;
dataTable.Rows.Add(dr);
}
}

stateDropDownList.DataSource = dataTable;
stateDropDownList.DataTextField = "stateName";
stateDropDownList.DataBind();
}

try this..only partial refresh is there..That is u cant get whole page refreshed instead u will have min refreshment.I hope this helps to avoid full page refreshment.