Hello All,

   I have created a Stored Procedure to pull back some data that I need. I use a SQLDataAdapter and generate a data set. I then go through the process of binding textboxes to my dataset. However when I run the page I get the error that 'Tables[dbo.' is not a valid indexed expression. I did not change anything, this is the table name created when generating the dataset. ( here is the code from the HTML view

Text='<%# DataBinder.Eval(DsPatientDetails1, "Tables[dbo.CaseManagementCMSGetPatientDetails].DefaultView.[0].HICNumber") %>'

What is the problem?
Can I change the default table name when I create the dataset?

Thanks...

dbo.CaseManagementCMSGetPatientDetails needs to be quoted... maybe this works?

Text='<%# DataBinder.Eval(DsPatientDetails1, "Tables['dbo.CaseManagementCMSGetPatientDetails'].DefaultView.[0].HICNumber") %>'


Peter
------------------------------------------------------
Work smarter, not harder.

Just realized, you could use a table index to avoid needing to quote a string inside a quoted string...

Text='<%# DataBinder.Eval(DsPatientDetails1, "Tables[0].DefaultView.[0].HICNumber") %>'


Peter
------------------------------------------------------
Work smarter, not harder.

Well I am using their wizard and that is what they gave me, and it dosen't work. Suprise!..lol

so I stripped off the dbo. and just used the table name.... I didn't get an error, but got no data back ....

So, using your advice and someone else's.. I used Table[0], and that worked.....

the wonderful workings of MS....

Thanks for your help!!!!!