Checking for records before trying to fill datagrid
I want to check for matching records in my table before I try to fill the datagrid. Basicaly I don't want to open up a blank grid. How can I do this? Here is my String:
VB Code:
Try
Dim Data_Adapter As SqlDataAdapter
Data_Adapter = New SqlDataAdapter("Select " & _
"Job," & _
"Employee," & _
"Phase," & _
"PostDate," & _
"Rate," & _
"Hours," & _
"Amt," & _
"EarnCode," & _
"InsCode," & _
"PRDept, " & _
"BatchSeq " & _
"From aTable Where Employee='" & _
(strEmp) & "' " & "Order by BatchSeq DESC", strCONN)
Data_Adapter.TableMappings.Add("Table", "Stuff")
m_DataSet = New DataSet
Data_Adapter.Fill(m_DataSet)
DataGrid3.DataSource = m_DataSet.Tables("Stuff")