Hi

I am trying to do a 3-teir architecture. So I been following along with this tutorial http://www.asp.net/learn/data-access...ial-01-cs.aspx

I am now trying to do my own and having trouble getting started.

 Currently I have a database with a Characters Table. It has like 218 rows in there. In each row there is a CharacterID(PK), CharacterName(used for the checkbox ID), CharacterImage(the path to the image) and a SortOrder. Now these 218 rows get divided into 6 tables. Each table varies of data. The data that gets put in the table varies too. Like the first table will have 6 cells(the first cell is not part of the database. It selects the row and was made on the fly when I was looping around and grabbing the values out of the database). The 3rd table for instance has 4 cells.


If that did not make sense or if your having trouble visualizing it here are screen shots of how the final tables look like(Basically the other 3 tables not show just repeat the format of these 3 just with different data)

http://img401.imageshack.us/img401/4...shot001rx6.jpg

http://img525.imageshack.us/img525/6...shot002yv9.jpg

http://img181.imageshack.us/img181/5...shot003zt9.jpg

 So those screenshots are from my old version what I did with all inline sql. Now I am trying to get practice with the 3-teir arch.

So I am not sure how I am to do this in the 3-teir architecture.

The only thing I can think of is something like this.

    public japanese.CharactersDataTable GetCharcters(int start, int end)
    {
        return CharacterAdapter.getCharacters(start, end);

    }

So I then would pass what Id the table should start filtering at. So like the first table its start would be 1 and its end 51. Then for the next table I would start at 52 and end at 76.

 But I still don't know how to hook that up all to the table since I can't pass a table object back otherwise that breaks the rule of dividing presentation and data layers apart.


So I am not sure how to get that data back and put it into a table.

Perhaps I'm confused, but the problem you're describing seems to be a data structures issue, not a "tier" issue.

A 3-tier model usually has the following generic form:

       Client <---> Business Rules <---> Server

The Client provides the user interface and generates requests for data and displays or otherwise uses the data returned to it from the Business Rules tier. The Business Rules tier is responsible for enforcing the rules applied to the data (e.g., who has the right to read the data, modify it, write new data, etc.) The Server is really just a tier that responds to the requests that have been approved by the Business Rules. Your question seems to be one of how the Server data should be organized, which is an entirely different issue.

Dr. Purdum