Ok, im using vb.net and a DGV to open a access DB. On load im filtering out everything except what was created on the current date.
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the 'Database1DataSet.Table1' table. You can move, or remove it, as needed.
Me.Table1TableAdapter.Fill(Me.Database1DataSet.Table1)
AddNew.Close()
Dim filterString As String
Dim myView As DataView = New DataView()
myView.Table = Database1DataSet.Table1
filterString = ""
If filterString = "" Then
filterString = "[Date Time] LIKE '%" & DateTimePicker1.Value.Date & "%'"
Else
filterString = filterString & " AND [Date Time] like '%" & DateTimePicker1.Value.Date & "%'"
End If
myView.RowFilter = filterString
DataGridView1.DataSource = myView
End Sub
what im trying to do is count the number of "c""b""v""o""m" that are in the column name "Status" the problem is it counts the number of those characters in the whole DB not what was visible in the DGV. How do i count only what was left after the filter? i dont know much about SQL commands but someone meantioned using a WHERE query to load only the data i needed but i dont know where to start witht that