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
-- ==================================
-- 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;
... {
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;