Click here to Skip to main content
15,886,773 members
Please Sign up or sign in to vote.
5.00/5 (1 vote)
See more:
Hi All,

How to store images in database and in application folder by stored procedure in 3tier architecture.

I am able to insert images from sql query with image path , but i dont know, that how to do this by 3 tier architecture.

Please some one help to do this code.

Thanks in Advance
Posted
Updated 5-Jun-11 21:23pm
v2

hi....
This link may be help to you...

http://www.codeproject.com/KB/web-image/PicManager.aspx[^]
 
Share this answer
 
v3
I am able to insert images from sql query with image path , but i dont know, that how to do this by 3 tier architecture.
Well, if you know directly then for 3 tier, all you need is:

Create a class library - BusinessLogic
Create a class library - DataAccess

Now, from your UI, use the object model and pass on to BusinessLogic project class. This class is a Business logic class. Do the changes as per your need here.
Now, pass on the changed data from business logic class to dataAccess project class. In this class, use ADO.NET and pass on the needed values to Stored Procedure.

For getting back data, it will be transferred from DA to BL and then BL to UI layer.
Have a look at these, explaination with samples:
3-tier architecture in C#[^]
3-Tier Architecture Examples[^]
3-Tier Architecture in ASP.NET with C#[^]
 
Share this answer
 
Comments
thatraja 6-Jun-11 23:31pm    
Fine answer.

OT: Did you find my thread("finally") in GIT?
Sandeep Mewara 7-Jun-11 1:40am    
Thanks.

Well, just a little too busy these days to go through all the places! :(
If you would have noticed, not much active in Q&A either.

Tell me what is the "finally" block?
thatraja 7-Jun-11 1:46am    
/*If you would have noticed, not much active in Q&A either.*/
Yeah, I have noticed that later because also I was inactive yesterday.
/*Tell me what is the "finally" block?*/
Looks like you are tired today, Ok here you go Clickety
Sandeep Mewara 8-Jun-11 0:42am    
Not tired. Just too busy! :)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900