'System.Data.Da taRowView' does not contain a property ......

[etropic]

I am trying to bind two tables to two different list boxes

Ther tables are working as I use them on another page wth no problems

The code is as follows...

private void Page_Load(objec t sender, System.EventArg s e

oleDbDataAdapte r2.Fill( dataSet1)
oleDbDataAdapte r4.Fill( dataSet1)

listVersion.Dat aSource = dataSet1
listVersion.Dat aTextField = "version"
listVersion.Dat aValueField = "version"
listVersion.Dat aBind()

listMerchant.Da taSource = dataSet1
listMerchant.Da taTextField = "merchant"
listMerchant.Da taValueField = "merchant"
listMerchant.Da taBind()
the merchant one works fine, the versions one returns..

DataBinder.Eval : 'System.Data.Da taRowView' does not contain a property with the name version.

both adapters are created the same way and work fine on another page (the versions table is working as expected). I don't think its a problem with the db. If I remove the listVersion.Bin d(); it will compile and run loading only the merchants list of course..

I know this is probably not enough info, but maybe other people have seen this and can point to the right direction

thanks so much !!

[Teemu Keiski]

Hi,

the data is in two separate tables in the DataSet. You need to distinguish
the table to use when databinding. For example:

listVersion.Dat aSource = dataSet1.Tables[0];
....
listMerchant.Da taSource = dataSet1.Tables[1];

not sure which way it should be as I know nothing about your data/database.
You can give tables a name when calling Fill method and access table with
that name via DataSet's Tables property.

oleDbDataAdapte r2.Fill( dataSet1,"Table 1");
oleDbDataAdapte r4.Fill( dataSet1,"Table 2");

and then respectively:

listVersion.Dat aSource = dataSet1.Tables["Table1"];
....
listMerchant.Da taSource = dataSet1.Tables["Table2"];

--
Teemu Keiski
MCP, Microsoft MVP (ASP.NET), AspInsiders member
ASP.NET Forum Moderator, AspAlliance Columnist
http://blogs.aspadvice.com/joteke
"etropic" <an*******@disc ussions.microso ft.com> wrote in message
news:3B******** *************** ***********@mic rosoft.com...

I am trying to bind two tables to two different list boxes.

Ther tables are working as I use them on another page wth no problems.

The code is as follows....

private void Page_Load(objec t sender, System.EventArg s e)
{
oleDbDataAdapte r2.Fill( dataSet1);
oleDbDataAdapte r4.Fill( dataSet1);

listVersion.Dat aSource = dataSet1;
listVersion.Dat aTextField = "version";
listVersion.Dat aValueField = "version";
listVersion.Dat aBind();

listMerchant.Da taSource = dataSet1;
listMerchant.Da taTextField = "merchant";
listMerchant.Da taValueField = "merchant";
listMerchant.Da taBind();
}
the merchant one works fine, the versions one returns...

DataBinder.Eval : 'System.Data.Da taRowView' does not contain a property with the name version.
both adapters are created the same way and work fine on another page (the versions table is working as expected). I don't think its a problem with the
db. If I remove the listVersion.Bin d(); it will compile and run loading
only the merchants list of course...
I know this is probably not enough info, but maybe other people have seen this and can point to the right direction ?
thanks so much !!

[etropic]

great ! I will look into that

I thought though that was only true with UNTyped dataSet, and I am using a Typed DataSet

thanks again !