Click here to Skip to main content
15,888,802 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: site navigation Pin
sashidhar26-Dec-09 22:36
sashidhar26-Dec-09 22:36 
Questioncaching best architecture [modified] Pin
Amr M. K.25-Dec-09 5:53
Amr M. K.25-Dec-09 5:53 
AnswerRe: caching best architecture Pin
Abhijit Jana25-Dec-09 6:07
professionalAbhijit Jana25-Dec-09 6:07 
GeneralRe: caching best architecture Pin
Amr M. K.25-Dec-09 9:45
Amr M. K.25-Dec-09 9:45 
GeneralRe: caching best architecture Pin
Abhijit Jana26-Dec-09 0:39
professionalAbhijit Jana26-Dec-09 0:39 
GeneralRe: caching best architecture Pin
Amr M. K.26-Dec-09 0:44
Amr M. K.26-Dec-09 0:44 
GeneralRe: caching best architecture Pin
Abhijit Jana26-Dec-09 0:55
professionalAbhijit Jana26-Dec-09 0:55 
QuestionLayered web project with ASP.NET Pin
mrkeivan25-Dec-09 4:39
mrkeivan25-Dec-09 4:39 
Hey guys, I have searched about this on the new and here but I'm still confused, so I'm gonna lay out this and hopefully with your help I can get it over with.

I'm trying to design and implement a 3 layer web application,
I want to fetch the info(fields such as name, email, ... ) for a student from Student table in my database:
(consequently I want to do update, delete and insert as well)

In my DAL class I fetch the record from database and return a dataset:

    public DataSetFetchProfile(string UserName)<br />
{     <br />
        DataSet ThisDataSet = new DataSet();<br />
        ThisAd.SelectCommand = new SqlCommand("Profile_FetchStudentInfo", ThisConnection);<br />
        ThisAd.SelectCommand.CommandType = CommandType.StoredProcedure;<br />
        ThisAd.SelectCommand.Parameters.Add("@UserName", SqlDbType.NVarChar, 256).Value = UserName;<br />
        ThisAd.Fill(ThisDataSet, "StudentT");<br />
        return ThisDataSet;<br />
}


and I have this function in my BLL class calling this one:
public DataSet ReturnProfileInfo(string UserName)<br />
{<br />
    return ThisStudent.FetchProfile(UserName);<br />
}


There are two things I might do in my presentaion layer (webpage),
1- populate some text boxes (fields of the record which was fetched)
I use the following code:
foreach (DataRow row in ThisDataSet.Tables["StudentT"].Rows)<br />
{<br />
    //ThisStudent.FirstName = row["FirstName"].ToString();<br />
}

2- populate a grid view ( which is easy by assigning its datasourse to the dataset which was returned)

one thing is that the point of having 3 layered is not having any codes related to database, but I have to have a dataset in my page !
I have read a lot that this isn't such a good way of implementing 3 layer architecture, I'm working on my final project and I need something not too much confusing.

I would really appreciate it if you could send me a sample of redirect me to a page ( again as I mentioned before, I 'm looking for something less confusing and easy to implement), so I can finish it and also learn something.


Regards,
K
AnswerRe: Layered web project with ASP.NET Pin
Gamzun25-Dec-09 20:18
Gamzun25-Dec-09 20:18 
QuestionWhy ms office dlls should not be there on the server Pin
vnr25-Dec-09 3:40
vnr25-Dec-09 3:40 
AnswerRe: Why ms office dlls should not be there on the server Pin
Abhijit Jana25-Dec-09 4:30
professionalAbhijit Jana25-Dec-09 4:30 
GeneralRe: Why ms office dlls should not be there on the server Pin
vnr27-Dec-09 3:12
vnr27-Dec-09 3:12 
Questionpostback event in cloud computing Pin
krishnaveer25-Dec-09 1:10
krishnaveer25-Dec-09 1:10 
AnswerRe: postback event in cloud computing Pin
Abhijit Jana25-Dec-09 1:32
professionalAbhijit Jana25-Dec-09 1:32 
GeneralRe: postback event in cloud computing Pin
krishnaveer25-Dec-09 1:42
krishnaveer25-Dec-09 1:42 
Questionnavigation Pin
mylogics24-Dec-09 22:58
professionalmylogics24-Dec-09 22:58 
AnswerRe: navigation Pin
Aman Bhullar24-Dec-09 23:13
Aman Bhullar24-Dec-09 23:13 
GeneralRe: navigation Pin
mylogics24-Dec-09 23:22
professionalmylogics24-Dec-09 23:22 
AnswerRe: navigation Pin
keyur satyadev25-Dec-09 2:30
keyur satyadev25-Dec-09 2:30 
AnswerRe: navigation Pin
AmosDai28-Dec-09 15:06
AmosDai28-Dec-09 15:06 
QuestionCombobox in gridview Pin
Bob From Accountemps24-Dec-09 14:14
Bob From Accountemps24-Dec-09 14:14 
AnswerRe: Combobox in gridview Pin
Abhijit Jana24-Dec-09 18:20
professionalAbhijit Jana24-Dec-09 18:20 
GeneralRe: Combobox in gridview Pin
Bob From Accountemps25-Dec-09 9:57
Bob From Accountemps25-Dec-09 9:57 
Questionno ajax call after the session remove Pin
Pankaj Saha24-Dec-09 3:34
Pankaj Saha24-Dec-09 3:34 
Questioncalender Pin
baselanfouqa24-Dec-09 1:25
baselanfouqa24-Dec-09 1:25 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.