Click here to Skip to main content
15,895,142 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
CSS
I have 3 comboboxcolumn in datagridview.I want to display its value in grid if its value in database table is not null.Eg one column is caste.if this is null in my databse table then combobox column should be added to grid else caste value shold be seen in combobox when datagridview loads..Can any1 help me.
Below is my code:

VB
Dim cast As Integer = 0
            Dim con As OdbcConnection = New OdbcConnection
            sql = "Select d.caste from datafile d where d.AC_NO = " & cmbVidhanNo.Text & " " + searchstring
            If rs.State = 1 Then rs.Close()
            rs.Open(sql, MainCon, 1, 3)
            Do While Not rs.EOF
                If Not IsDBNull(rs.Fields(0).Value) Then
                    cast = rs.Fields(0).Value
                End If
                If Not IsDBNull(cast) Then
                    With col_Caste
                        .Name = "Caste"
                        .HeaderText = "Caste"
                        .DataPropertyName = cast
                        .ReadOnly = False
                    End With
    
                Else
                    sql = "Select Desc from Category where Catgry = 1"
                    con.ConnectionString = connstring
                    If con.State = ConnectionState.Open Then con.Close()
                    con.Open()
                    Dim da As OdbcDataAdapter = New OdbcDataAdapter(sql, con)
                    da.Fill(ds, "Caste")
    
                    With col_Caste
                        .Name = "Caste"
                        .HeaderText = "Caste"
                        .DataSource = ds.Tables("Caste")
                        .DisplayMember = "Desc"
                        .ReadOnly = False
                    End With
    
                End If
                rs.MoveNext()
            Loop
    
            dgvUserDetails.Columns.Add(col_Caste)
Posted

1 solution

you need to put
SQL
"Select d.caste from datafile d where d.AC_NO = " & cmbVidhanNo.Text & " "and d.caste is not null +  searchstring "


try that
 
Share this answer
 
Comments
Rachna0309 24-Dec-12 7:05am    
this will retrieve only those records where caste is not null..What I need is if it is not null,its value should be displayed in combobox when DGV loads else if it is null then all values from table should be filled in combobox to select.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900