PHP User Warning: fetch_template() calls should be replaced by the vB_Template class. Template name: bbcode_highlight in ..../includes/functions.php on line 4197 Datagrid connection with ADODB-VBForums

If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Re: Datagrid connection with ADODB

Here's one way... when a cell is entered, you could show a combobox (which was hidden until then) over the top of the cell. When a value is selected in the combobox, that value is copied to the cell, and the combobox is hidden again.

Originally Posted by DPSK

what is the real advantages and disadvantages of datagrid compared to flexgrid?

The big difference is that the DataGrid is bound (the data is filled automatically, and changes are written to the database), whereas the FlexGrid isn't (it needs to be filled using code, and does not update the database unless you write code to do that).

Obviously whether or not this is a good or bad thing depends on the situation.

Re: Datagrid connection with ADODB

Hey Si,

I've been trying out your possible solution and I really struggling, If you have coded something like this, please show me as its very important. I'll keep on trying. The problem I'm having is the combobox is not updating the field in the record.

Advertiser Disclosure:
Some of the products that appear on this site are from companies from which QuinStreet receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. QuinStreet does not include all companies or all types of products available in the marketplace.