Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click
names.Text = cbb1.Text
sql = String.Format("select docid,names,billtotal from customer where dgetreport Between '" & dtp1.Value.ToString("yyyy-MM-dd") & "' AND '" & dtp2.Value.ToString("yyyy-MM-dd") & "' AND statusqc like '%" & cbb2.Text & "%' AND teamasset1 like '%" & cbb1.Text & "%' ")
DGV1.DataSource = cmd_dataTable()
If DGV1.RowCount > 1 Then
Dim iTax As Integer = 0
For index As Integer = 0 To DGV1.RowCount - 1
iTax += Convert.ToInt32(DGV1.Rows(index).Cells(2).Value)
Next
Label19.Text = iTax
End If
End Sub