VB.NET:
Try
CCNameSearchTable.Show()
'Search by Ware House Only When Text Not Equal to "ALL"
If Me.CCNSwarehouseComboBox.Text IsNot "ALL" And Me.CCNSindivBinComboBox.SelectedIndex = -1 Then
CCNameSearchTable.CC_NAME_SEARCHTableAdapter.FillByWareHouseOnly(CCNameSearchTable.PtmnDataSet.CC_NAME_SEARCH, Me.CCNSwarehouseComboBox.Text)
end if
Catch ex As Exception
MessageBox.Show("Failed! " & ex.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error)
End Try
Try
CCNameSearchTable.Show()
'Search by WareHouse (When warehouse text is not "ALL") and Date
If Me.CCNSwarehouseComboBox.Text IsNot "ALL" And Me.CCNSindivBinComboBox.SelectedIndex = -1 And Me.CCNSFrom_DateTxtBox.Text IsNot String.Empty And Me.CCNSTo_DateTxtBox.Text IsNot String.Empty Then
CCNameSearchTable.CC_NAME_SEARCHTableAdapter.FillByWareHouseDate(CCNameSearchTable.PtmnDataSet.CC_NAME_SEARCH, Me.CCNSwarehouseComboBox.Text, CType(Me.CCNSFrom_DateTxtBox.Text, Date), CType(CCNSTo_DateTxtBox.Text, Date))
End If
Catch ex As Exception
MessageBox.Show("Failed! " & ex.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error)
End Try
I have this code to handle my search, but the problem is whenever I click, It always said that error, cann't convert "" to Date?