Datagrid Problem- column not found

[lucky13]

Dear All,

i m using the Datagrid , in which two columns data i called from database & two columns data is user going to write.
but after writing data when i move to next column it show the error "Column Not Found |1"

the data in which user is going to write data the index no is 2 & 3.

Please help me.


Regards
Lucky13

[shrimant]

Don't Bind the data grid, Get the data from the database and programatically stuff the Two columns of data into the grid using a loop. Use Msflexgrid rather

[lucky13]

Don't Bind the data grid, Get the data from the database and programatically stuff the Two columns of data into the grid using a loop. Use Msflexgrid rather

Hello,

i tired by using loop with datagrid but data is not displaying in datagrid

Do While Not rsdetails.EOF
           With rsdetails

''----------------- if this portion is using the loop is moving but Data is not displaying in the Grid ---------------

'                    dgpaydetails.DataBindings(0) = rsdetails!ADA_No
'                    dgpaydetails.DataBindings(1) = rsdetails!ToolBreak
'                    dgpaydetails.DataBindings(2) = rsdetails!TicketBreak

'---------------------------------------------------------------------------------------------------------------------

'----------------- if i m using this then i am geeting Error "Rowset Not Available"----------
'                   dgpaydetails.Columns(0) = rsdetails!ADA_No
'                   dgpaydetails.Columns(1) = rsdetails!ToolBreak
'                   dgpaydetails.Columns(2) = rsdetails!TicketBreak
'----------------------------------------------------------------------------------------------
                    
                    MSHFlexGrid1.ColData(0) = !ADA_No
                    MSHFlexGrid1.ColData(1) = !ToolBreak
                    MSHFlexGrid1.ColData(2) = !TicketBreak
                    
                    
                rsdetails.MoveNext
           End With
        Loop

            End If

     rsdetails.Close

\

please help me.....