upload and delete image

protected void btndelete_Click(object sender, EventArgs e)

{

string connectionString = WebConfigurationManager.ConnectionStrings["connectionString"].ConnectionString;

string filename = FileUpload1.FileName;

FileUpload1.PostedFile.Equals(Server.MapPath("~\\Uploads\\" + filename));

string path = "~\\Uploads\\" + filename;

SqlConnection cnn = new SqlConnection(connectionString);

try

{

cnn.Open();

SqlCommand cmd = new SqlCommand();

cmd.CommandText = "delete from emp ";

cmd.CommandType = CommandType.Text;

cmd.Connection = cnn;

cmd.ExecuteNonQuery();

if (File.Exists(path))

{

File.Delete(path);

}

cnn.Close();

}

catch (Exception ex)

{

Response.Write(ex.ToString());

}

finally

{

lblinfo2.Text = "";

lblinfo2.Text= " Deleted Successfully ";

}

protected void btnUpload_Click(object sender, EventArgs e)

{

Stream imgStream = fuImage.PostedFile.InputStream;

int imgLen = fuImage.PostedFile.ContentLength;

string imgName = txtImageName.Text;

byte[] imgBinaryData = new byte[imgLen];

int n = imgStream.Read(imgBinaryData,0,imgLen);

//use the web.config to store the connection string

SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString);

SqlCommand command = new SqlCommand("INSERT INTO Image (imagename,image) VALUES ( @img_name, @img_data)", connection);

SqlParameter param0 = new SqlParameter("@img_name", SqlDbType.VarChar, 50);

param0.Value = imgName;

command.Parameters.Add(param0);

SqlParameter param1 = new SqlParameter("@img_data", SqlDbType.Image);

param1.Value = imgBinaryData;

command.Parameters.Add(param1);

connection.Open();

int numRowsAffected = command.ExecuteNonQuery();

connection.Close();

}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Raj Kumar13y ago
see this also...

http://www.developerstation.org/2009/04/upload-images-onto-sql-server-using.html
Raj Kumar13y ago
protected void btndelete_Click(object sender, EventArgs e)
{
string connectionString = WebConfigurationManager.ConnectionStrings["connectionString"].ConnectionString;

string filename = FileUpload1.FileName;
FileUpload1.PostedFile.Equals(Server.MapPath("~\\Uploads\\" + filename));
string path = "~\\Uploads\\" + filename;

SqlConnection cnn = new SqlConnection(connectionString);
try
{
cnn.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "delete from emp ";

cmd.CommandType = CommandType.Text;
cmd.Connection = cnn;
cmd.ExecuteNonQuery();

if (File.Exists(path))
{
File.Delete(path);

}

cnn.Close();
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
finally
{
lblinfo2.Text = "";
lblinfo2.Text= " Deleted Successfully ";
}

}

protected void btnUpload_Click(object sender, EventArgs e)
{
Stream imgStream = fuImage.PostedFile.InputStream;
int imgLen = fuImage.PostedFile.ContentLength;
string imgName = txtImageName.Text;
byte[] imgBinaryData = new byte[imgLen];
int n = imgStream.Read(imgBinaryData,0,imgLen);

//use the web.config to store the connection string
SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString);
SqlCommand command = new SqlCommand("INSERT INTO Image (imagename,image) VALUES ( @img_name, @img_data)", connection);

SqlParameter param0 = new SqlParameter("@img_name", SqlDbType.VarChar, 50);
param0.Value = imgName;
command.Parameters.Add(param0);

SqlParameter param1 = new SqlParameter("@img_data", SqlDbType.Image);
param1.Value = imgBinaryData;
command.Parameters.Add(param1);

connection.Open();
int numRowsAffected = command.ExecuteNonQuery();
connection.Close();
}