Groups | Blog | Home
all groups > flash data integration > october 2005 >

flash data integration : Troubles with dataset and datagrid


sidsevensix
10/26/2005 7:50:56 PM

Hello, I was just wondering if anyone has a suggestion to resolving the
dataset-datagrid problem I have been having.

The dataset and datagrid are created dynamically in my application.

The dataset data-provider is filled with a reocord-set passed in from a flash
remoting procedure. (it is remoting with a c#.net library that interacts with a
SQL Database)

Mydataset.dataProvider = result;

The datagrid data-provider is equated to the data-provider of dataset

MydataGrid.dataProvider = Mydataset.dataProvider;


So the sequence is

Remoting-Result-RecordSet -> DataSet.dataProvider -> DataSet.dataGrid


The output of the datagrid has the correct header names for the columns (with
the addition of the __ID__ column name from the dataset) but the content of the
rows do not display. However the datagrid has empty active rows where the
content should be?

The same thing happens when I bind the two using a binding procedure.

Now If directly equate the Result-RecordSet with the datagrid?s dataprovider
It displays all records as it should.

Any ideas why the record content is going stealth in the datagrid when I bind
it to the dataset?
:confused;
sidsevensix
10/26/2005 9:02:57 PM
to answer my own question...

MAKE A SCHEMA FOR THE DATASET!
this will resolve the problems between the dataset and datagrid binding..
predefine your shema shema shema

you can make a schema dynamicaly ... check out the following
http://livedocs.macromedia.com/flash/mx2004/main_7_2/00002348.html
AddThis Social Bookmark Button