Hi,
I have two forms.Both having DatagridView.There are two comboboxes to filter the record from Database and fill in Datagridview.My requirement is when all the data is populated in DataGrid after selecting the comboboxes and when the user clicks on Delete.
The comboboxes and Datagrid on second form should have the same values as that was on first form.The names of my Comboboxes and Datagridview are same on both the forms
Below is the code my Datagrid view getting populated in First Form.
Sub GetData(ByVal StrQuery As String)
If CBMedium.Text <> "" And CBClass.Text <> "" Then
DGVStudRecord.Rows.Clear()
con = DBConnect()
cmd = New SqlCommand(StrQuery, con)
dr = cmd.ExecuteReader
If dr.HasRows Then
While dr.Read
DGVStudRecord.Rows.Add(dr(0), dr(1), dr(2), dr(3), dr(4), dr(5))
End While
End If
con.Close()
End If
End Sub
Please suggest how can i populate my datagrid in second form by using the Data populated in Datagrid of Firrt Form