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")




Reply With Quote