Kindly tell me how can I insert data from a bi-dimensional array ex. array1(10,10) to a DataGrid/DBGrid and visa-versa.
Please explain with a sample source code.
RahulV 16 Junior Poster in Training
debasisdas 580 Posting Genius Featured Poster
Do you know how to populate data from/to a DB into/from a DataGrid/DBGrid ?
Database table is a 2D array only.
RahulV 16 Junior Poster in Training
Yes Sir, I know how to populate data from DB to DataGrid/DBGrid but I'm trying to create a bi-dimensional array which will pass data to the grids but Im unsuccessfull so far.
Hence pls help.
RahulV 16 Junior Poster in Training
Using FlexGrid's TextMatrix property I could insert data into each cell but how can the similar be done in DataGrid/DBGrid ?
But I think using DataGrid/DBGrid requires DataSource, RecordSet, or DataMember and complete the connection. Is that the case?
QVeen72 104 Posting Shark
Hi,
As the name Indicates, DataGrid and DBGrid need to be bound to a database Recordset object. You cannot bind a LocalArray to db grid.. If at all you want to bind the array, Save the Array in some temp table in database and open the recordset and Bind..
If you can do using MSFlexGrid, then why are you so much wanting to bind it to DataGrid/DBGrid....?
Regards
Veena
vb5prgrmr 143 Posting Virtuoso
Ya know Queen, not that I have ever tried it, but would not a disconnected ado recordset be sufficient as a data source?
Just a thought from left field, if not from beyond... :)
Good Luck
QVeen72 104 Posting Shark
Hi vb5prgmr,
Actually Disconnected Datasets are once, wherein you actually connect recordset to the database table (as usual normal procedure),
and then disconnect the active connection of the recordset by setting it to nothing.. Again a database table required...
binding array/system table/datatable to datagrid can be easily done in VB.net, but not sure of vb6...
I still feel, FlexGrid is most appropriate control in such situations...
Regards
Veena
ankush.mukherje 0 Junior Poster
As far as I think FlexGrid is most appropriate control in such situations as said by QVeen
RahulV 16 Junior Poster in Training
Hi vb5prgmr,
Actually Disconnected Datasets are once, wherein you actually connect recordset to the database table (as usual normal procedure),
and then disconnect the active connection of the recordset by setting it to nothing.. Again a database table required...binding array/system table/datatable to datagrid can be easily done in VB.net, but not sure of vb6...
I still feel, FlexGrid is most appropriate control in such situations...
Regards
Veena
I have some thoughts,...
1) Recordsets are multi-dimensional Array/similar to multi-dimensional array containing collection of records
2) If Yes, then why cant arrays b bound to DBGrid/DataGrid, the way we usually do with Recordsets?
3) Also, can we insert/append a multi-dimensional array to any RecordSet?
If Im wrong pls correct me and/or share your thoughts.
Thank you.
pankaj7040 0 Newbie Poster
Do you know how to populate data from/to a DB into/from a DataGrid/DBGrid ?
Database table is a 2D array only.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.