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:
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)
"Select d.caste from datafile d where d.AC_NO = " & cmbVidhanNo.Text & " "and d.caste is not null + searchstring "
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)