Click here to Skip to main content
15,878,748 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I am populating datagridview with 9 columns through dataset. After this I add 4 comboboxes programatically. Now for the first time form loads, everything goes well. But if I change selected value in combobox from FORM,grid does not gets value and it shows error "Column cannot be added because it is unfrozen and placed before a frozen column."..In my datagridview ,columns 1 to 8 are frozen..Below is my code to add combobox in grid at runtime.
VB
sql = "Select Description from Category where Catgry = 1"
        If rs.State = 1 Then rs.Close()
        rs.Open(sql, MainCon, 1, 3)
        Do While Not rs.EOF
            cmbCaste.Items.Add(rs.Fields(0).Value)
            rs.MoveNext()
        Loop
        cmbCaste.HeaderText = "jaita"
        cmbCaste.Name = "Caste"
        dgvUserDetails.Columns.Add(cmbCaste)
        dgvUserDetails.Columns("Caste").DisplayIndex = 10
        rs.Close()


It gives me error at line "dgvUserDetails.Columns.Add(cmbCaste)" second time when I change value in comboxbox of FORM.Please help me its urgent.
Posted

1 solution

Please help me its urgent.

Why is everything everyone does in India "urgent"??

Sorry, but we're all volunteers here answering question in our own spare time, not when you demand.

If it was that urgent, you should have been reading the documentation on the DGV and its Columns collection class. In there, you would have noticed that instead of Add, you can use an Insert method to put the column anywhere you want into the Columns collection and avoid the error you got.
 
Share this answer
 
Comments
Adam R Harris 18-Jan-13 12:18pm    
LMFAO - excellent, my 5
Rachna0309 18-Jan-13 12:22pm    
I tried using Insert too....But it shows same error...
Dave Kreskowiak 18-Jan-13 12:31pm    
Without seeing the Insert code, it's impossible to help you out.
Rachna0309 18-Jan-13 23:06pm    
sql = "Select Description from Category where Catgry = 1"
If rs.State = 1 Then rs.Close()
rs.Open(sql, MainCon, 1, 3)
Do While Not rs.EOF
cmbCaste.Items.Add(rs.Fields(0).Value)
rs.MoveNext()
Loop
cmbCaste.HeaderText = "jaita"
cmbCaste.Name = "Caste"
dgvUserDetails.Columns.Insert(10, cmbCaste)


I have tried using the above code...But it gives me same error...
Dave Kreskowiak 19-Jan-13 0:40am    
This code has nothing to do with insert and is exactly the same as above.

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