Here is the problem:
I am using Visual Studio 2010 and I have SQL Server 2005 as database, I have binded the combobox with a table column from the Dataset.
Dim a As New SqlDataAdapter("Select * from TotTab", My.Settings.Equation1ConnectionString)
Dim ds As New DataSet
a.Fill(ds, "tot")
With NameCand
.DataSource = ds.Tables("tot")
.DisplayMember = "Name"
End With
NameCand
is a combobox which is binded to
Name
column of
TotTab
.
The main problem is after binding the first record of column
"Name"
is automatically visible on the combobox, I need the combobox visible text to be empty and use the database Column
"Name"
just for suggesting the names that are already in database.
May be the problem is small but I am not able to figure out where I am wrong.
If there is any other way of achieving the above goal so please suggest.
Thank You in advance.
I guess I didn't made my question Clear
I have a combobox which has all the records of
Name
column and the 1st record of this column is visible when i run the project,I want the default text to be empty..
Can it be done with binding or I have to remove binding to achieve the above task.