mysql2005安装asp_sql server2005在安装是提示asp.net32位在64位需注册

展开全部

文字和文件32313133353236313431303231363533e58685e5aeb931333262373263名放在数据库表里面，文件放在服务器文件夹下，然后用img标签显示图片之类的

CREATE TABLE [dbo].[Person]( [PersonID] [int] IDENTITY(1,1) NOT NULL, [PersonEmail] [varchar](255) COLLATE Chinese_PRC_CI_AS NULL, [PersonName] [varchar](255) COLLATE Chinese_PRC_CI_AS NULL, [PersonDOB] [datetime] NULL, [PersonImage] [image] NULL, [PersonImageType] [varchar](255) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] 存入图片和文字-----

---------AddAddressList.aspx %@ Page Language="C#" AutoEventWireup="true" CodeFile="AddAddressList.aspx.cs" Inherits="AddAddressList" % !DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" " "> html xmlns=" " head runat="server" title无标题页 /title /head body form id="form1" runat="server" div asp:Table Runat="server" Width="100%" BorderWidth="1" BackColor="Beige" ID="Table1" Font-Name="宋体" Font-Size="9pt" Height="150%" asp:TableRow ID="TableRow1" runat="server" asp:TableCell ID="TableCell1" ColumnSpan="2" BackColor="Red" runat="server" asp:Label ForeColor="White" font-bold="True" Runat="server" Text="添加新同学" ID="Label1" / /asp:TableCell /asp:TableRow asp:TableRow ID="TableRow2" runat="server" asp:TableCell ID="TableCell2" HorizontalAlign="Right" runat="server" asp:Label Runat="server" Text="姓名" ID="Label2" / /asp:TableCell asp:TableCell ID="TableCell3" runat="server" asp:TextBox id="txtPersonName" Runat="server" / /asp:TableCell /asp:TableRow asp:TableRow ID="TableRow3" runat="server" asp:TableCell ID="TableCell4" HorizontalAlign="Right" runat="server" asp:Label Runat="server" Text="电子邮件" ID="Label3" / /asp:TableCell asp:TableCell ID="TableCell5" runat="server" asp:TextBox id="txtPersonEmail" Runat="server" / /asp:TableCell /asp:TableRow asp:TableRow ID="TableRow4" runat="server" asp:TableCell ID="TableCell6" HorizontalAlign="Right" runat="server" asp:Label Runat="server" Text="电话号码" ID="Label7" / /asp:TableCell asp:TableCell ID="TableCell7" runat="server" asp:TextBox id="TextBox1" Runat="server" / /asp:TableCell /asp:TableRow asp:TableRow ID="TableRow6" runat="server" asp:TableCell ID="TableCell10" HorizontalAlign="Right" runat="server" asp:Label Runat="server" Text="出生日期" ID="Label5"/ /asp:TableCell asp:TableCell ID="TableCell11" runat="server" asp:TextBox id="txtPersonDOB" Runat="server" / /asp:TableCell /asp:TableRow asp:TableRow ID="TableRow7" runat="server" asp:TableCell ID="TableCell12" HorizontalAlign="Right" runat="server" asp:Label Runat="server" Text="照片" ID="Label6"/ /asp:TableCell asp:TableCell ID="TableCell13" runat="server" input type="file" id="PersonImage" runat="server" / /asp:TableCell /asp:TableRow asp:TableRow ID="TableRow8" runat="server" asp:TableCell ID="TableCell14" ColumnSpan="2" HorizontalAlign="Center" runat="server" asp:Button Text=" 添 加 " OnClick="AddPerson" Runat="server" ID="Button1"/ /asp:TableCell /asp:TableRow asp:TableRow ID="TableRow9" runat="server" asp:TableCell ID="TableCell15" ColumnSpan="2" HorizontalAlign="Center" runat="server" asp:Button Text=" 返 回 " OnClick="Return" Runat="server" ID="Button2"/ /asp:TableCell /asp:TableRow /asp:Table /div /form /body /html ----

--------------------------------------CS代码 using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.SqlClient; using System.IO; public partial class AddAddressList : System.Web.UI.Page { public void AddPerson(object sender, System.EventArgs e) { Int64 intImageSize; string strImageType; Stream ImageStream; //获得图片的大小 intImageSize = PersonImage.PostedFile.ContentLength; //获得图片类型 strImageType = PersonImage.PostedFile.ContentType; //读取图片 ImageStream = PersonImage.PostedFile.InputStream; byte[] ImageContent = new byte[intImageSize]; int intStatus; intStatus = ImageStream.Read(ImageContent, 0, Convert.ToInt32(intImageSize)); string strCnn = "Data Source=.;Initial Catalog=Phone;Integrated Security=True;"; SqlConnection conn = new SqlConnection(strCnn); SqlCommand insertCmd = new SqlCommand("insert into Person(PersonEmail,PersonName ,PersonDOB ,PersonImage ,PersonImageType ) values(@PersonEmail,@PersonName ,@PersonDOB ,@PersonImage ,@PersonImageType)", conn); insertCmd.Parameters.Add("@PersonEmail", SqlDbType.VarChar, 225); insertCmd.Parameters.Add("@PersonName", SqlDbType.VarChar, 225); insertCmd.Parameters.Add("@PersonDOB", SqlDbType.DateTime); insertCmd.Parameters.Add("@PersonImage", SqlDbType.Image); insertCmd.Parameters.Add("@PersonImageType", SqlDbType.VarChar, 225); insertCmd.Parameters["@PersonEmail"].Value = txtPersonEmail.Text; insertCmd.Parameters["@PersonName"].Value = txtPersonName.Text; insertCmd.Parameters["@PersonDOB"].Value = txtPersonDOB.Text; insertCmd.Parameters["@PersonImage"].Value = ImageContent; insertCmd.Parameters["@PersonImageType"].Value = strImageType; try { conn.Open(); int flag = insertCmd.ExecuteNonQuery(); if (flag 0) { //Response.Write(" script language=javascriptalert('成功添加好友记录！') /script"); Label1.Text = "成功添加好友记录！"; } else { //Response.Write(" script language=javascriptalert('添加好友记录失败，查看输入是否正确！') /script"); Label1.Text = "添加好友记录失败，查看输入是否正确！"; } } catch (System.Exception ee) { //Response.Write(" script language=javascriptalert('" + ee.Message.ToString() + "') /script"); Label1.Text = ee.Message.ToString(); } finally { //conn.Close(); } } public void Return(object sender, System.EventArgs e) { Response.Redirect("~/DataGridShowImage.aspx"); } }

已赞过

已踩过<

你对这个回答的评价是？

评论

收起