First : Create Table -- ================================== -- ================================== -- TABLE NAME: E_PHOTO -- AUTHOR:XIAOPENG CHENG -- CREATE DATE: 2006-11-1 -- DESCRIPTION:SAVE PHTO INFORMATION -- ================================== -- ================================== if exists ( select * from sysobjects where id = object_id ( ' dbo.E_PHOTO ' )) drop table dbo.E_PHOTO GO create table E_PHOTO( USER_NAME NVARCHAR ( 40 ) NOT NULL , -- USER NAME PHOTO_TYPE_ID int NOT NULL , -- PHOTO TYPE PHOTO_ID NVARCHAR ( 30 ) NOT NULL , -- PHOTO NAME PHOTO IMAGE NOT NULL , -- PHOTO INFORMATION PHOTO_DESC NVARCHAR ( 3000 ), -- PHOTO DESCRIPTION INFORMATION UPLOAD_DATE SMALLDATETIME , -- UPLOAD DATE CONSTRAINT PHOTO PRIMARY KEY ( USER_NAME ,PHOTO_ID,PHOTO_TYPE_ID) -- PRIMARY KEY ) GO Second : add Button Events protected void btnUPLoad_Click( object sender, EventArgs e) ... { PhotoManage manage = new PhotoManage("zhang"); string info; manage.photo_desc = this.txtDesc.Text; manage.upload_date = Convert.ToDateTime(System.DateTime.Now.ToShortDateString()); //manage.PhotoID = manage.GetPhotoID("zhang"); manage.photo_type_id = Convert.ToInt32(this.ddlPhotoType.SelectedValue); manage.UserName = "zhang"; HttpPostedFile file = this.fileLoad.PostedFile; int fileLength = file.ContentLength; string fileType = file.ContentType;