如何使用3层体系结构将图像插入文件夹 [英] How To Insert Image to folder using 3 tier architecture

问题描述

您好

我想将图像路径插入数据库&图像到文件夹。我为此做了代码。



我的sp

  USE  [LAXMI] 
  GO  
  / *   *****对象：StoredProcedure [dbo]。[InsertData]脚本日期：03/06/2014 12:49:56 ****** /  
  SET   ANSI_NULLS   ON  
  GO  
  SET   QUOTED_IDENTIFIER   ON  
  GO  
  ALTER   PROCEDURE  [dbo]。[InsertData] 
（
  @project_name   varchar （ 50 ），
  @ project_subtitle   varchar （ 50 ），
  @total_plots   varchar （ 50 ），
  @ main_image   nchar （ 500 ）
）
  AS  
  DECLARE   @ Count   int  
  IF   @ Count  =  0  
  BEGIN  
  INSERT   INTO  add_project（project_name，project_subtitle，total_plots，main_image）
  VALUES  
（ @ project_name ， @ project_subtitle ， @ total_plots ， @ main_image ）
  END  
  RETURN   @ Count  
 返回 

我的Add_project.cs文件

 a_project.a_project_name = TextBox1.Text; 
 a_project.a_project_subtitle = TextBox2.Text; 
 a_project.a_total_plots = TextBox3.Text; 
  a_project.a_main_image = FileUpload1.SaveAs（MapPath（ 〜/ admin / + FileUpload1.FileName））;  //  我应该通过什么  
 
 尝试 
 {
 intResult = pBAL.Insert（a_project）; 
  if （intResult >   0 ）
 TextBox1.Text =  成功插入新记录。; 
  else  
 lblMessage.Text =   FirstName [ + txtFirstName.Text +   ] alredy存在，尝试另一个名字; 
 
} 
 

Plz帮助我。我想在数据库和数据库中存储完整路径文件夹

解决方案

试试这个：

  string  filename = Path。用GetFileName（FileUpload1.PostedFile.FileName）; 
 FileUpload1.SaveAs（Server.MapPath（  ../ admin / + filename） ）; 
 
 a_project.a_project_name = TextBox1.Text; 
 a_project.a_project_subtitle = TextBox2.Text; 
 a_project.a_total_plots = TextBox3.Text; 
 a_project.a_main_image =   ../ admin / + filename; 
 
 
  //   insert  
 

Hello
I want to Insert Image Path to database & Image to Folder. I did code for this.

my sp

USE [LAXMI]
GO
/****** Object:  StoredProcedure [dbo].[InsertData]    Script Date: 03/06/2014 12:49:56 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[InsertData]
	(
		@project_name varchar(50),
		@project_subtitle varchar(50),
		@total_plots varchar(50),
		@main_image nchar(500)
	)
AS
	DECLARE @Count int
	IF @Count = 0 
		BEGIN
				INSERT INTO add_project (project_name,project_subtitle, total_plots,main_image) 
				VALUES 
				(@project_name,@project_subtitle,@total_plots,@main_image)
		END 
		RETURN @Count
	RETURN	

My Add_project.cs file

a_project.a_project_name = TextBox1.Text;
          a_project.a_project_subtitle = TextBox2.Text;
          a_project.a_total_plots = TextBox3.Text;
          a_project.a_main_image = FileUpload1.SaveAs(MapPath("~/admin/" +FileUpload1.FileName)); // What I should Pass here  

          try
          {
              intResult = pBAL.Insert(a_project);
              if (intResult > 0)
                TextBox1.Text = "New record inserted successfully.";
              else
                  lblMessage.Text = "FirstName [" + txtFirstName.Text + "] alredy exists, try another name";

          }

Plz help me. I want to store full path in databse & Image in folder

解决方案

Try this:

 string filename = Path.GetFileName(FileUpload1.PostedFile.FileName);
 FileUpload1.SaveAs(Server.MapPath("../admin/" + filename));

a_project.a_project_name = TextBox1.Text;
a_project.a_project_subtitle = TextBox2.Text;
a_project.a_total_plots = TextBox3.Text;
a_project.a_main_image = "../admin/" + filename;


 //insert

这篇关于如何使用3层体系结构将图像插入文件夹的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！