Hello!
I'm facing an error that I'm loading items from a Query in a Database using TableAdapter method. A list of items loads in the CB and data is updated by selecting from the CB. When last item is left in CB, by selecting the item, it don't trigger the index and the application (item) in CB don't loads the data. So, for this, I've decided to add new Empty or Dummy row in CB that it able to trigger index change and load the data.
My Code is:
Private
Sub
FwdDocQuery_SelectedIndexChanged(sender
As
Object
, e
As
EventArgs)
Handles
FwdDocQuery.SelectedIndexChanged
StatusIDRadTextBox1.Text =
"2"
If
Not
String
.IsNullOrWhiteSpace(FwdDocQuery.Text)
Then
Dim
index
As
Integer
= ApplicationsBindingSource.Find(
"ID"
, FwdDocQuery.Text)
If
index > -1
Then
ApplicationsBindingSource.Position = index
End
If
End
If
If
DocTypeIDRadTextBox1.Text =
"1"
Then
DocTypeTBFWD.Text =
"Transcript"
ElseIf
DocTypeIDRadTextBox1.Text =
"2"
Then
DocTypeTBFWD.Text =
"Degree"
ElseIf
DocTypeIDRadTextBox1.Text =
"3"
Then
DocTypeTBFWD.Text =
"NOC"
End
If
End
Sub