ASP.NET

How to get the SelectCommand value of a TableAdapter? RSS

6 replies

Last post Apr 22, 2012 12:49 AM by Decker Dong - MSFT

‹ Previous Thread|Next Thread ›

- Reply
vchany

Member

23 Points

32 Posts
How to get the SelectCommand value of a TableAdapter?

Apr 20, 2012 07:51 AM|LINK
Lets say if we have:
```
UserAccountsTableAdapter UserAccountsAdapter = new UserAccountsTableAdapter();
UserDataSet.UserAccountsDataTable UserAccountsDataTable = UserAccountsAdapter.GetUserAccounts();
UserDataSet.UserAccountsRow UserAccountsRowRow;
UserAccountsRowRow = UserAccountsDataTable.FindByUSER_IDExpr1(Int32.Parse(1), Int32.Parse(1));
```
I want to be able to get the SelectCommand generated from the TableAdapter. This seemed possible in VB.Net (see link below) but how can we do this in C#?
http://www.windowsdevelop.com/windows-forms-data-controls-databinding/tableadapter-select-command-26113.shtml
- Reply
mm10

Contributor

6399 Points

1184 Posts

Re: How to get the SelectCommand value of a TableAdapter?

Apr 20, 2012 08:13 AM|LINK

The TableAdapter hides its dataadapter in a private variable but you can extend it to add a SelectCommand property to return the command:

public string SelectQuery
{
get
{
return this.CommandCollection[0].CommandText;
}
}

Please 'Mark as Answer' if this post helped you.
- Reply
vchany

Member

23 Points

32 Posts

Re: How to get the SelectCommand value of a TableAdapter?

Apr 20, 2012 08:24 AM|LINK

Thanks mm10.

Do we need the Microsoft.AnalysisServices.dll for enable this CommandCollection?
http://msdn.microsoft.com/en-us/library/microsoft.analysisservices.commandcollection(v=sql.100).aspx
- Edited by vchany on Apr 20, 2012 08:24 AM
- Reply
mm10

Contributor

6399 Points

1184 Posts

Re: How to get the SelectCommand value of a TableAdapter?

Apr 20, 2012 08:32 AM|LINK

No, there is no need to add any additional references for implementing this property. The CommandCollection already exists in the TableAdapter and holds a collection of System.Data.SqlClient.SqlCommand objects.

Please 'Mark as Answer' if this post helped you.
- Reply
vchany

Member

23 Points

32 Posts

Re: How to get the SelectCommand value of a TableAdapter?

Apr 20, 2012 08:43 AM|LINK

I don't know why I am getting a 'Page.aspx' does not contain a definition for 'CommandCollection' and no extension method 'CommandCollection' accepting a first argument of type 'Page.aspx' could be found. (Are you missing a using directive or assembly reference?)
- Reply
mm10

Contributor

6399 Points

1184 Posts

Re: How to get the SelectCommand value of a TableAdapter?

Apr 20, 2012 09:00 AM|LINK

You must implement the property in the TableAdapter class, not on your page.

Please 'Mark as Answer' if this post helped you.
- Marked as answer by decker dong - msft on Apr 26, 2012 02:07 AM
- Reply
Decker Dong ...

All-Star

118619 Points

18779 Posts
Re: How to get the SelectCommand value of a TableAdapter?

Apr 22, 2012 12:49 AM|LINK
Hello vchany：）

If you want to get the instance of a certain SqlCommand from a certain TableAdapter，you can just fetch from that directly：
```
UserAccountsTableAdapter UserAccountsAdapter = new UserAccountsTableAdapter();
UserAccountsAdapter.SelectCommand;  //Get from this……
```
- Marked as answer by decker dong - msft on Apr 26, 2012 02:07 AM