Hi Friends

I want to display the data of two fields of two different table in a dropdown list collectively.
Just give mr rough idea.

Thanks

Hi, first you must iterate through the retrieved data

ArrayList arrayListTableONE = new ArrayList();
ArrayList arrayListTableTWO = new ArrayList();


while(readerONE.Read())
{
  arrayListTableONE.Add(reader["fieldName"].ToString());
}

while(readerTWO.Read())
{
  arrayListTableTWO.Add(reader["fieldName"].ToString());
}

then use the for loop and iterate through the data from two lists
and joint its string data:

for(int i = 0; i<arrayListTableTWO.Length; i++)
{
  dropDownList.Items.Add(arrayListTableONE[i].ToString() + "---" + arrayListTableTWO.ToString());
}

I hope it helps!