如何在数据库中存储图像使用存储过程的3tier体系结构中的文件夹 [英] how to store images in database & folder in 3tier architecture using stored procedure

问题描述

大家好，

如何通过3tier体系结构中的存储过程将图像存储在数据库和应用程序文件夹中.

我能够从具有图像路径的sql查询中插入图像，但我不知道该如何通过3层体系结构来做到这一点.

请提供一些帮助来执行此代码.

在此先感谢

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

推荐答案

嗨....
此链接可能对您有帮助...

http://www.codeproject.com/KB/web-image/PicManager.aspx [ ^ ]

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

http://www.codeproject.com/KB/web-image/PicManager.aspx[^]

我能够从具有图像路径的sql查询中插入图像，但我不知道如何通过3层体系结构来做到这一点.
好吧，如果您直接知道3层，那么您需要的是:

创建一个类库-BusinessLogic
创建一个类库-DataAccess

现在，从您的UI，使用对象模型并传递给BusinessLogic项目类.此类是业务逻辑类.在此处根据您的需要进行更改.
现在，将更改后的数据从业务逻辑类传递到dataAccess项目类.在此类中，使用ADO.NET并将所需的值传递给存储过程.

为了获取数据，数据将从DA传输到BL层，然后再从BL传输到UI层.
看看这些，用示例进行解释:
C#中的3层体系结构 [ 3-层架构示例 [使用C#的ASP.NET中的3层体系结构 [

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#[^]

这篇关于如何在数据库中存储图像使用存储过程的3tier体系结构中的文件夹的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！