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)
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.