Add partial class to TableAdapter

Question

I use Visual Studio 2008, .NET 3.5

In my project I have a DataSet called SubCategory. In it is a SubCategoryTableAdapter, with some methods, added in designer with right click -> add query. I can use these methods on my page in a ObjectDataSource object.

Now I would like to add my own method (for select) so that I could use it in ObjectDataSource object. I want to write this method by my self (and not in designer with right click -> add query). If I look into the code of SubCategory dataset, I can create partial class for SubCategory dataset but not for SubCategoryTableAdapter.

How can I make partial class for SubCategoryTableAdapter?

(I'd like to write my own select method because I'd like to show at least one record in my datagrid, even if there is no rows in the table. So if select statement returns 0 rows I want to just add new row with null values in it).

Answer 1

In the DataSet designer, right-click a TableAdapter and choose "View Code".