Jackwong0099

Hey guys, something went really really wrong in the DataGridView with my final project :( it doesn't work the way I want it to be. I'm not sure what's going on please help me... I'm in really desperate need or else I might have to redo everything again. I'm currently …

[CODE] Private Sub btnedit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnedit.Click 'check for the selected item in list If Me.dgvData.Rows.Count > 0 Then If Me.dgvData.SelectedRows.Count > 0 Then Dim intStdID As Integer = Me.dgvData.SelectedRows(0).Cells("id").Value 'get data from database followed by id 'open connection If Not cnn.State = ConnectionState.Open …

Help me check? I think there's something wrong with these codes especially to the date of birth(chodob) when i start debugging the database don't have any columns :( Customer name = txtstdid Name = txtstdname Gender/Sex = cbosex Date of Birth = chodob1, chodob2, chodob3 Identification card number = txtic …

How do I fix this: Me.dgvData.DataSource = dt, there are three date of birth dropdown list [CODE] Private Sub RefreshData() If Not cnn.State = ConnectionState.Open Then 'open connection cnn.Open() End If Dim da As New OleDb.OleDbDataAdapter("SELECT txtstdid as [ID], " & _ "txtstdname as [Name], cbosex as [Gender], chodob1 as …