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