Loading

tableadapter GetData() query returns zero rows

Andy

Hi all,

I can't figure this out. I added a dataset to my project. It has one table. Why doesn't this code work?
If I test the GetData() query inside the designer, it returns 1 row. But here, the rows returned are zero. Anybody know what I am missing?

myTableAdapter ta = new myTableAdapter();
myDataTable dt = new myDataTable();
dt = ta.GetData();
int numRows = dt.Rows.Count;

Thanks,

Andy

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

sai babu19y ago
you are using dataset and table adaptors, if you are getting the data using dataset you need to return the tableadaptor

that means

means if it should return some thing

return tableadaptor.getdata();

Regards

sai