Hi,
I have a listbox, and when i populate it from my sqldatasource, i get some blank item in listbox,
but in my db i have no blank item. This happens when i use "xxx as expr1" thing in my sql
command, i'm not sure how to solve this.
aaaSqlDataSource.SelectCommand = ("SELECT *, (firstname + ' ' + lastname + ' | ' + username) identifierr FROM dbo.usercontactinfo where " & searchbyDropDownList.SelectedValue.ToString & " LIKE '%" & ToSearchTextBox.Text & "%' Order by " & orderbyDropDownList.SelectedValue.ToString)
ListBox1.DataSourceID = "aaaSqlDataSource"
ListBox1.DataTextField = "identifierr"
ListBox1.DataValueField = "identifierr"
thanks ...
Go to the complete details ...