How to insert an image in database SQL Server with VB.NET.

In this article you will learn how to insert an image from database SQL Server

Inserting an image in database

Creating a table in SQL Server.

Table name student and database name master.

use master

go

create table student

(

name varchar(20),

rollno int,

photo image

);

go

select * from student;

go

Table has created in SQL Server.

Now come to the front end window forms application in VB.NET.

Taking two level, two textbox and three button and one picture box and opendialog control on the form.

Figure 1.

Now double click on the button named browse and add the following code in c#.

private void button1_Click(object sender, EventArgs e)

        {

            openFileDialog1.Filter = "Image Files|*.gif;*.jpg;*.png;*.bmp";

            openFileDialog1.ShowDialog();

            pictureBox1.Image = Image.FromFile(openFileDialog1.FileName);

        }

code in visual Basic.

private void button1_Click(object sender, EventArgs e)
{
openFileDialog1.Filter = "Image Files|*.gif;*.jpg;*.png;*.bmp";
openFileDialog1.ShowDialog();
pictureBox1.Image = Image.FromFile(openFileDialog1.FileName);
}

Now double click on the button save and add the following c# code.

private void button2_Click(object sender, EventArgs e)

        {

            string str = "Data Source=.;uid=sa;pwd=wintellect;database=master";

            SqlConnection con = new SqlConnection(str);

            con.Open();

            string sql = "INSERT INTO student VALUES(@rollno,@name,@photo)";

            SqlCommand cmd = new SqlCommand(sql, con);

            cmd.Parameters.AddWithValue("@rollno", textBox1.Text);

            cmd.Parameters.AddWithValue("@name", textBox2.Text);

            MemoryStream ms = new MemoryStream();

            pictureBox1.Image.Save(ms, pictureBox1.Image.RawFormat);

            byte[] data = ms.GetBuffer();

            SqlParameter p = new SqlParameter("@photo", SqlDbType.Image);

            p.Value = data;

            cmd.Parameters.Add(p);

            cmd.ExecuteNonQuery();

            MessageBox.Show("record has been saved","Save", MessageBoxButtons .OK);

            con.Close();

        }

code in visual Basic.

Dim str As String = "Data Source=.;uid=sa;pwd=wintellect;database=master"

        Dim con As New SqlConnection(str)

        con.Open()

        Dim sql As String = "INSERT INTO student VALUES(@rollno,@name,@photo)"

        Dim cmd As New SqlCommand(sql, con)

        cmd.Parameters.AddWithValue("@rollno", textBox1.Text)

        cmd.Parameters.AddWithValue("@name", textBox2.Text)

        Dim ms As New MemoryStream()

        pictureBox1.Image.Save(ms, pictureBox1.Image.RawFormat)

        Dim data As Byte() = ms.GetBuffer()

        Dim p As New SqlParameter("@photo", SqlDbType.Image)

        p.Value = data

        cmd.Parameters.Add(p)

        cmd.ExecuteNonQuery()

        MessageBox.Show("record has been saved", "Save", MessageBoxButtons.OK)

        con.Close()

    End Sub

Now execute the application press ctrl+F5.

Figure 2.

Now click on the save button message will be display.

Now open the sql server record has been saved with the image