<rt id="bn8ez"></rt>
<label id="bn8ez"></label>
  • 

    • <span id="bn8ez"></span>
    

    <label id="bn8ez"><meter id="bn8ez"></meter></label>
    

    
    

    




    







												


        

    
	

    love fish大鵬一曰同風(fēng)起，扶搖直上九萬里
    

    

    


    
	
		

    常用鏈接
    

		

    統(tǒng)計
    
	
		

    積分與排名
    


		
		
    friends
    
		
				
			
	
		
    link
    
		
				
			
	

		

    最新評論
	
    

    
	
			
		

    
		
	

    

    
	
					
	
    
		
    
			ASP.NET2.0中將文件上傳到數(shù)據(jù)庫
		
    
		
    此問題經(jīng)常被人問，本文列出將文字和圖片上傳到數(shù)據(jù)庫的方法。包括Access數(shù)據(jù)庫和SQL Server數(shù)據(jù)庫。
    

    Access數(shù)據(jù)庫代碼
    

    <%&#64; Page Language="C#" EnableViewState="true" %>
<%&#64; Import Namespace="System.Data.OleDb" %>
<!doctype html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server">

  protected void Button1_Click( object sender, EventArgs e )
  {
    System.IO.Stream fileDataStream = FileUpload1.PostedFile.InputStream;

    if (fileDataStream.Length < 1)
    {
      Msg.Text = "請選擇文件。";
      return;
    }

    //得到文件大小
    int fileLength = FileUpload1.PostedFile.ContentLength;

    //創(chuàng)建數(shù)組
    byte[] fileData = new byte[fileLength];
    //把文件流填充到數(shù)組
    fileDataStream.Read(fileData, 0, fileLength);
    //得到文件類型
    string fileType = FileUpload1.PostedFile.ContentType;

    //構(gòu)建數(shù)據(jù)庫連接，SQL語句，創(chuàng)建參數(shù)
    string strCnn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("Image2Access.mdb");
    OleDbConnection myConnection = new OleDbConnection(strCnn);
    OleDbCommand command = new OleDbCommand("INSERT INTO Person (PersonName,PersonEmail,PersonSex,PersonImageType,PersonImage)" +
    "VALUES (&#64;PersonName,&#64;PersonEmail,&#64;PersonSex,&#64;PersonImageType,&#64;PersonImage)", myConnection);

    command.Parameters.AddWithValue("&#64;PersonName",TextBox1.Text);
    command.Parameters.AddWithValue("&#64;PersonEmail", "mengxianhui&#64;dotnet.aspx.cc");
    command.Parameters.AddWithValue("&#64;paramPersonSex", "男");
    command.Parameters.AddWithValue("&#64;PersonImageType", fileType);
    command.Parameters.AddWithValue("&#64;PersonImage", fileData);


    //打開連接，執(zhí)行查詢
    myConnection.Open();
    command.ExecuteNonQuery();
    myConnection.Close();
    Response.Redirect(Request.RawUrl);
  }


  protected void Page_Load( object sender, EventArgs e )
  {

    if (!Page.IsPostBack)
    {
      BindGrid();
    }
  }

  private void BindGrid( )
  {
    string strCnn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
    + Server.MapPath("Image2Access.mdb");
    OleDbConnection myConnection = new OleDbConnection(strCnn);
    OleDbCommand myCommand = new OleDbCommand("SELECT * FROM Person", myConnection);

    try
    {
      myConnection.Open();
      GridView1.DataSource = myCommand.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
      GridView1.DataBind();
    }
    catch (OleDbException SQLexc)
    {
      Response.Write("提取數(shù)據(jù)時出現(xiàn)錯誤：" + SQLexc.ToString());
    }
  }
  protected string FormatURL( object strArgument )
  {
    return "ReadImage.aspx?id=" + strArgument.ToString();
  }  

</script>
<html xmlns="http://www.w3.org/1999/xhtml">
    <head runat="server">
        <title>上傳文件到數(shù)據(jù)庫</title>
    </head>
    <body>
        <form id="MengXianhui" runat="server">
            <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false">
            <columns>
            <asp:TemplateField>
            <itemtemplate>
            <%#Eval("PersonName") %>
            </itemtemplate>
            </asp:TemplateField>
            <asp:TemplateField>
            <itemtemplate>
            <%#Eval("PersonEmail") %>
            </itemtemplate>
            </asp:TemplateField>
            <asp:TemplateField>
            <itemtemplate>
            <%#Eval("PersonSex") %>
            </itemtemplate>
            </asp:TemplateField>
            <asp:TemplateField>
            <itemtemplate>
            <img src="<%#FormatURL(Eval("PersonID")) %  alt="" />" /></itemtemplate>
            </asp:TemplateField>
            </columns>
            </asp:GridView>
            <br />
            <br />
            姓名：<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
            <br />
            照片：<asp:FileUpload ID="FileUpload1" runat="server" />
            <asp:Button ID="btnUpload" runat="server" Text="上傳" OnClick="Button1_Click"></asp:Button>
            <p>
            <asp:Label ID="Msg" runat="server" ForeColor="Red"></asp:Label></p>
        </form>
    </body>
</html>


     
    

    SQL Server數(shù)據(jù)庫代碼
    

    <%&#64; Page Language="C#" EnableViewState="true" %>
<%&#64; Import Namespace="System.Data.SqlClient" %>
<!doctype html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server">
  string strCnn = "Persist Security Info=False;User ID=sa;Password=;Initial Catalog=Book;Server=(local);";
  protected void Button1_Click( object sender, EventArgs e )
  {
    System.IO.Stream fileDataStream = FileUpload1.PostedFile.InputStream;

    if (fileDataStream.Length < 1)
    {
      Msg.Text = "請選擇文件。";
      return;
    }

    //得到文件大小
    int fileLength = FileUpload1.PostedFile.ContentLength;

    //創(chuàng)建數(shù)組
    byte[] fileData = new byte[fileLength];
    //把文件流填充到數(shù)組
    fileDataStream.Read(fileData, 0, fileLength);
    //得到文件類型
    string fileType = FileUpload1.PostedFile.ContentType;

    //構(gòu)建數(shù)據(jù)庫連接，SQL語句，創(chuàng)建參數(shù)

    SqlConnection myConnection = new SqlConnection(strCnn);
    SqlCommand command = new SqlCommand("INSERT INTO UserPhoto (UserName,ContentType,Photo)" +
    "VALUES (&#64;UserName,&#64;ContentType,&#64;Photo)", myConnection);

    command.Parameters.AddWithValue("&#64;UserName", TextBox1.Text);
    command.Parameters.AddWithValue("&#64;ContentType", fileType);
    command.Parameters.AddWithValue("&#64;Photo", fileData);

    //打開連接，執(zhí)行查詢
    myConnection.Open();
    command.ExecuteNonQuery();
    myConnection.Close();
    Response.Redirect(Request.RawUrl);
  }


  protected void Page_Load( object sender, EventArgs e )
  {

    if (!Page.IsPostBack)
    {
      BindGrid();
    }
  }

  private void BindGrid( )
  {
    SqlConnection myConnection = new SqlConnection(strCnn);
    SqlCommand myCommand = new SqlCommand("SELECT * FROM UserPhoto Order By id DESC", myConnection);

    try
    {
      myConnection.Open();
      GridView1.DataSource = myCommand.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
      GridView1.DataBind();
    }
    catch (Exception SQLexc)
    {
      Response.Write("提取數(shù)據(jù)時出現(xiàn)錯誤：" + SQLexc.ToString());
    }
  }
  protected string FormatURL( object strArgument )
  {
    return "ReadImage.aspx?id=" + strArgument.ToString();
  }  

</script>
<html xmlns="http://www.w3.org/1999/xhtml">
    <head id="Head1" runat="server">
        <title>上傳文件到數(shù)據(jù)庫</title>
    </head>
    <body>
        <form id="MengXianhui" runat="server">
            <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false">
            <columns>
            <asp:TemplateField>
            <itemtemplate>
            <%#Eval("UserName") %>
            </itemtemplate>
            </asp:TemplateField>
            <asp:TemplateField>
            <itemtemplate>
            <img src="<%#FormatURL(Eval("id")) %  alt="" />" /></itemtemplate>
            </asp:TemplateField>
            </columns>
            </asp:GridView>
            <br />
            <br />
            姓名：<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
            <br />
            照片：<asp:FileUpload ID="FileUpload1" runat="server" />
            <asp:Button ID="btnUpload" runat="server" Text="上傳" OnClick="Button1_Click"></asp:Button>
            <p>
            <asp:Label ID="Msg" runat="server" ForeColor="Red"></asp:Label></p>
        </form>
    </body>
</html>


     
    

    顯示圖片
    

    <%&#64; Page Language="C#" %>
<%&#64; Import Namespace="System.Data.OleDb" %>
<%&#64; Import Namespace="System.Data.SqlClient" %>
<script runat="server">

  protected void Page_Load( object sender, EventArgs e )
  {
    ////構(gòu)建數(shù)據(jù)庫連接，SQL語句，創(chuàng)建參數(shù)
    //ACCESS數(shù)據(jù)庫使用本注釋部分
    //string strCnn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("Image2Access.mdb");
    //OleDbConnection myConnection = new OleDbConnection(strCnn);
    //OleDbCommand command = new OleDbCommand("select * from Person Where PersonID =" + Request.QueryString["id"], myConnection);
    //myConnection.Open();
    //OleDbDataReader dr = command.ExecuteReader();
    //if (dr.Read())
    //{
    //  Response.Clear();
    //  Response.AddHeader("Content-Type", dr["PersonImageType"].ToString());
    //  Response.BinaryWrite((byte[])dr["PersonImage"]);
    //}
    //dr.Close();
    //myConnection.Dispose();

    //構(gòu)建數(shù)據(jù)庫連接，SQL語句，創(chuàng)建參數(shù)
    string strCnn = "Persist Security Info=False;User ID=sa;Password=;Initial Catalog=Book;Server=(local);";
    SqlConnection myConnection = new SqlConnection(strCnn);
    SqlCommand command = new SqlCommand("select * from UserPhoto Where id =" + Request.QueryString["id"], myConnection);
    myConnection.Open();
    SqlDataReader dr = command.ExecuteReader();
    if (dr.Read())
    {
      Response.Clear();
      Response.AddHeader("Content-Type", dr["ContentType"].ToString());
      Response.BinaryWrite((byte[])dr["Photo"]);
    }
    dr.Close();
    myConnection.Dispose();
  }
</script>


     
    

    創(chuàng)建SQL數(shù)據(jù)表語句
    

    CREATE TABLE [UserPhoto] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[UserName] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ContentType] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Photo] [image] NOT NULL ,
CONSTRAINT [PK_UserPhoto] PRIMARY KEY  CLUSTERED
(
[id]
)  ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO


		
    
			posted on 2008-02-05 08:54 liaojiyong 閱讀(1163) 評論(0)  編輯  收藏  所屬分類: Dot Net 
		
    
	
    
	
	


	


    
	    
    




    





    


    

	
    
		
    
				
		
	
		
    
		
		
    只有注冊用戶登錄后才能發(fā)表評論。
    
		
    
			
		
    
			
		
    
		
		
    
		


    

		    		
		
    
		
    			
		
		
		
		
    
		
    
		
		
    
		
    
			網(wǎng)站導(dǎo)航:
		
		
    
		
    
			


		
    	
		
    
			 
		
    
		
    
			
		
    
		
    
			
				
		
    		
	
    	

    



    

				

    




    







    
        
	



主站蜘蛛池模板：
久9这里精品免费视频|
青青青国产免费一夜七次郎|
亚洲国产高清在线精品一区|
啦啦啦www免费视频|
巨胸狂喷奶水视频www网站免费|
日韩免费在线中文字幕|
好看的亚洲黄色经典|
国产成人AV片无码免费|
亚洲GV天堂GV无码男同|
久久91亚洲人成电影网站|
成人毛片免费在线观看|
免费看黄的成人APP|
亚洲欧好州第一的日产suv|
亚洲欧洲精品无码AV|
成人免费一区二区无码视频|
中国在线观看免费的www|
亚洲熟女综合色一区二区三区|
四虎成年永久免费网站|
精品一区二区三区无码免费直播|
手机在线毛片免费播放|
国产成人精品免费久久久久|
免费看内射乌克兰女|
亚洲人成在线中文字幕|
国产精品亚洲玖玖玖在线观看|
国产高清对白在线观看免费91
|
亚洲一区免费视频|
黄页网址大全免费观看12网站|
国产在线19禁免费观看|
67pao强力打造国产免费|
久久国产福利免费|
亚洲欧美国产欧美色欲|
亚洲理论精品午夜电影|
亚洲午夜福利AV一区二区无码|
99久久免费国产特黄|
亚洲精品色在线网站|
亚洲制服丝袜中文字幕|
久久亚洲AV成人出白浆无码国产|
久久99国产综合精品免费|
日韩a毛片免费观看|
亚洲欧洲精品成人久久奇米网|
亚欧国产一级在线免费|