Scott on Writing

# re: Three New "Working with Data in ASP.NET 2.0" Tutorials Available 11/16/2006 7:55 AM Dario

Hi Scott,
I love your tutorials, what I would like to see added to your tutorials is more examle of editing data using standard controls , text boxes, check boxes etc.. also in combinatioin with the Wizard Control, instead of using the Grid.
The GridView is fantastic to present data and to use with table with a moderate number of fields, but is not really suitable adopting the GridView to Insert/Update in tables with a lot of fields.

Thank you, keep up the good work

# re: Three New "Working with Data in ASP.NET 2.0" Tutorials Available 11/16/2006 6:39 PM Patrick

Thanks your greet job!

# re: Three New "Working with Data in ASP.NET 2.0" Tutorials Available 12/4/2006 7:46 PM loon

Great... i like the way the guide us step by step... thanks for sharing. I will link this in webhostforasp.net.

# re: Three New "Working with Data in ASP.NET 2.0" Tutorials Available 12/15/2006 11:55 PM el_nino

Thank you

# re: Three New "Working with Data in ASP.NET 2.0" Tutorials Available 1/23/2007 12:45 PM Dmitry

I have read your article "Creating a Business Logic Layer" (http://www.asp.net/learn/dataaccess/tutorial02cs.aspx?tabid=63)
I have two tables in database, Users & Groups

[Users]
int user_id (PK)
int group_id (FK to groups by group_id)
varchar(50) uname

[Groups]
int group_id
varchar(50) gname

I have created dataset and two table adapters UsersTableAdapter & GroupsTableAdapter based on sql query:

[UsersTableAdapter]
SELECT user_id, group_id, uname FROM Users;

[GroupsTableAdapter]
SELECT group_id, gname FROM Groups;

This is my DAL and now I creating BLL.

My BLL consist of two classes UsersBLL & GroupsBLL

[DataObject]
public class UsersBLL
{
public UsersBLL()
{
}

[DataObjectMethodAttribute(DataObjectMethodType.Select, true)]
public UG.UsersDataTable GetUsers()
{
return UsersAdapter.GetUsers();
}

protected UsersTableAdapter UsersAdapter
{
get
{
if(_UsersAdapter == null)
_UsersAdapter = new UsersTableAdapter();
return _UsersAdapter;
}
}

private UsersTableAdapter _UsersAdapter; }

And GroupsBLL like UsersBLL.

And when I using this pattern I have a problem with presentation layer based on GridView.
I need to show user_id, uname and gname in GridView.
For example query like this "SELECT u.user_id, g.gname, u.uname FROM Users u, Groups g WHERE u.group_id = g.group_id";

How can I implement this using created TableAdapters (UsersTableAdapter & GroupsTableAdapter) without creating new TableAdapter; Is it really?