dropdown display like ABC-12012000.xml i want to remove (.xml ) and display to Dropdown list
If you cannot handle it in query itself, then before binding the datasource table to dropdown, loop though it and set the text as per need.
Try:
foreach(DataRow dr in myDataSourceTable.Rows)
{
string currentDisplayText = dr["displayColumn"].ToString();
dr["displayColumn"] = currentDisplayText.Substring(0, currentDisplayText.IndexOf('.'));
}
myDropDown.Datasource = myDataSourceTable;