/****** Object:  Table [dbo].[BinaryData]    Script Date: 02/28/2009 10:47:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[BinaryData](
   [ID] [bigint] IDENTITY(1,1) NOT NULL,
   [filename] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
   [mime] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
   [date] [datetime] NULL,
   [binarydata] [varbinary](max) NULL
) ON [PRIMARY]
 
GO
SET ANSI_PADDING OFF

protected void btn_Upload_Click(object sender, EventArgs e)
{
if (FileToUpload1.PostedFile == null || string.IsNullOrEmpty(FileToUpload1.PostedFile.FileName) || FileToUpload1.PostedFile.InputStream == null)
{
lit_Status.Text = "<b>Error!!!</b>";
return;
}
else
{
//lblMsg.Text = "";
string extension = Path.GetExtension(FileToUpload1.PostedFile.FileName).ToLower();
// Response.Write(extension);
string filetype = null;
switch (extension)
{
case ".gif":
filetype = "image/gif";
break;
 
case ".jpg":
case ".jpeg":
case "jpe":
filetype = "image/jpeg";
break;
 
case ".png":
filetype = "image/png";
break;
 
default:
lit_Status.Text = "<b>Invalid Extension</b>";
return;
}
using(SqlConnection con=new SqlConnection(ConfigurationManager.ConnectionStrings["Strcon"].ConnectionString))
{
try{
const string strSQL="insert into dbo.BinaryData(filename, mime, date, binarydata) values(@filename, @mime, @date, @binarydata)";
SqlCommand cmd=new SqlCommand(strSQL,con);
cmd.Parameters.AddWithValue("@filename",FileName.Text);
cmd.Parameters.AddWithValue("@mime", filetype);
 
byte[] imagebytes = new byte[FileToUpload1.PostedFile.InputStream.Length +1];
FileToUpload1.PostedFile.InputStream.Read(imagebytes, 0, imagebytes.Length);
 
cmd.Parameters.AddWithValue("@date",DateTime.Now);
cmd.Parameters.AddWithValue("@binarydata",imagebytes);
 
con.Open();
cmd.ExecuteNonQuery();
con.Close();
 
}
catch
{
con.Close();
}
 
}
 
 
 
}
}