Posted on: 6/6/2011 1:42:00 AM | Views : 380

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 ...