Upload image and save in database

Hi,

As per your request please find code below:

In aspx

Button1_Click" />

In aspx.cs

protected void Button1_Click(object sender, EventArgs e)

{

//Condition to check if the file uploaded or not

if (FileUpload1.HasFile)

{

//getting length of uploaded file

int length = FileUpload1.PostedFile.ContentLength;

//create a byte array to store the binary image data

byte[] imgbyte1 = new byte[length];

//store the currently selected file in memeory

HttpPostedFile img = FileUpload1.PostedFile;

//set the binary data

img.InputStream.Read(imgbyte1, 0, length);

length = FileUpload2.PostedFile.ContentLength;

//create a byte array to store the binary image data

byte[] imgbyte2 = new byte[length];

//store the currently selected file in memeory

HttpPostedFile img2 = FileUpload2.PostedFile;

//set the binary data

img2.InputStream.Read(imgbyte2, 0, length);

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

SqlConnection connection = new SqlConnection(strcon);

connection.Open();

SqlCommand cmd = new SqlCommand("INSERT INTO Image (Judgement_ID, Judgement, JudgementAppeal_ID, AppealedJudgement) VALUES (@Judgement_ID, @Judgement, @JudgementAppeal_ID, @AppealedJudgement)", connection);

cmd.Parameters.Add("@Judgement_ID", SqlDbType.VarChar, 50).Value = TextBox1.Text;

cmd.Parameters.Add("@JudgementAppeal_ID", SqlDbType.VarChar, 50).Value = TextBox2.Text;

cmd.Parameters.Add("@Judgement", SqlDbType.Image).Value = imgbyte1;

cmd.Parameters.Add("@AppealedJudgement", SqlDbType.Image).Value = imgbyte2;

int count = cmd.ExecuteNonQuery();

connection.Close();

if (count == 1)

{

//Display Success Message

}

1 Reply

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

Manas Mohapatra11y ago
Accepted answer
Hi,

As per your request please find code below:

In aspx
Button1_Click" />

In aspx.cs
protected void Button1_Click(object sender, EventArgs e)
{
   //Condition to check if the file uploaded or not
   if (FileUpload1.HasFile)
   {
   //getting length of uploaded file
   int length = FileUpload1.PostedFile.ContentLength;

   //create a byte array to store the binary image data
   byte[] imgbyte1 = new byte[length];
   //store the currently selected file in memeory
   HttpPostedFile img = FileUpload1.PostedFile;
   //set the binary data
   img.InputStream.Read(imgbyte1, 0, length);

   length = FileUpload2.PostedFile.ContentLength;
   //create a byte array to store the binary image data
   byte[] imgbyte2 = new byte[length];
   //store the currently selected file in memeory
   HttpPostedFile img2 = FileUpload2.PostedFile;
   //set the binary data
   img2.InputStream.Read(imgbyte2, 0, length);

   //use the web.config to store the connection string
   SqlConnection connection = new SqlConnection(strcon);
   connection.Open();
   SqlCommand cmd = new SqlCommand("INSERT INTO Image (Judgement_ID, Judgement,    JudgementAppeal_ID, AppealedJudgement) VALUES (@Judgement_ID, @Judgement,    @JudgementAppeal_ID, @AppealedJudgement)", connection);

   cmd.Parameters.Add("@Judgement_ID", SqlDbType.VarChar, 50).Value = TextBox1.Text;
   cmd.Parameters.Add("@JudgementAppeal_ID", SqlDbType.VarChar, 50).Value =    TextBox2.Text;
   cmd.Parameters.Add("@Judgement", SqlDbType.Image).Value = imgbyte1;
   cmd.Parameters.Add("@AppealedJudgement", SqlDbType.Image).Value = imgbyte2;

   int count = cmd.ExecuteNonQuery();
   connection.Close();

   if (count == 1)
   {
      //Display Success Message
   }
   }
}

More visit below link:
http://www.aspdotnet-suresh.com/2011/01/how-to-insert-images-into-database-and.html

Upload image and save in database

Create Court Judgement