If e.ColumnIndex = 9 Then If Me.dgvUserDetails.Rows(e.RowIndex).Cells(9).Value.ToString <> "" Then caste = Me.dgvUserDetails.Rows(e.RowIndex).Cells(9).Value.ToString sql = "Select ID from Category where Desc = '" & caste & "'" If rs.State = 1 Then rs.Close() rs.Open(sql, MainCon, 1, 3) If Not rs.EOF Then C_Id = rs.Fields(0).Value End If End If ElseIf e.ColumnIndex = 10 Then If Me.dgvUserDetails.Rows(e.RowIndex).Cells(10).Value.ToString <> "" Then prof = Me.dgvUserDetails.Rows(e.RowIndex).Cells(10).Value.ToString sql = "Select ID from Category where Desc = '" & prof & "'" If rs.State = 1 Then rs.Close() rs.Open(sql, MainCon, 1, 3) If Not rs.EOF Then P_Id = rs.Fields(0).Value End If End If ElseIf e.ColumnIndex = 11 Then If Me.dgvUserDetails.Rows(e.RowIndex).Cells(11).Value.ToString <> "" Then degree = Me.dgvUserDetails.Rows(e.RowIndex).Cells(11).Value.ToString sql = "Select ID from Category where Desc = '" & degree & "'" If rs.State = 1 Then rs.Close() rs.Open(sql, MainCon, 1, 3) If Not rs.EOF Then D_Id = rs.Fields(0).Value End If End If End If
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)