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