I have a combobox on a form that I am filling by setting the Datasource Property. I want to be able to add a row to the start of the Datatable to display at the top of the combobox that has a 0 Value but instructs the user to select an Option ie: Select Customer....
I have managed to add a row to the datatable, but I don't know how to index it as the first row.
Dim sCustomers As String = "SELECT * FROM tCustomers"
Dim daCustomers As New SqlClient.SqlDataAdapter(sCustomers, myConn.sqlConn)
Dim newCustomersRow As DataRow = dsCustomers.Tables("dtCustomers").NewRow()
newCustomersRow("ID") = "0"
newCustomersRow("sName") = "Select Customer...."
cboCustomerName.DataSource = dsCustomers.Tables("dtCustomers")
cboCustomerName.DisplayMember = "sName"
cboCustomerName.ValueMember = "ID"