tableadapter GetData() query returns zero rows

Question

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 my TableAdapter (); myDataTable dt = new myDataTable(); dt = ta.GetData(); int numRows = dt.Rows.Count; Thanks Andy

sai babu · Answer

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