Insert Image in Sql Database

This code will convert your image to proper format by which you can save your image to the database.

private void btnBrowse_Click(object sender, EventArgs e)
        {   
            
                OpenFileDialog openFileDialog1 = new OpenFileDialog();
 
                openFileDialog1.InitialDirectory = @"C:\";
                openFileDialog1.Title = "Select Ur Image File";
                
                openFileDialog1.Filter = "All Files (*.*)|*.*";
                openFileDialog1.FilterIndex = 2;
                openFileDialog1.RestoreDirectory = true;
 
                openFileDialog1.ReadOnlyChecked = true;
                openFileDialog1.ShowReadOnly = true;
             
                if (openFileDialog1.ShowDialog() == DialogResult.OK)
                {
                    tbUpload.Text = openFileDialog1.SafeFileName;
string FilePath;
                    FilePath = openFileDialog1.FileName;
                    if (openFileDialog1.FileName != null)    
                    {
                        
System.IO.FileStream fs = new System.IO.FileStream(FilePath, System.IO.FileMode.Open, System.IO.FileAccess.ReadWrite);
                        System.IO.BinaryReader binaryReader = new System.IO.BinaryReader(fs);
                        long byteLength = new System.IO.FileInfo(FilePath).Length;
byte[] Attachmnt;
                        Attachmnt = binaryReader.ReadBytes((Int32)byteLength);
                        fs.Close();
                        fs.Dispose();
                        binaryReader.Close();
                    }                    
                }
               
             }

Now you can store the value of Attachmnt through stored procedure or query into the database, but the column where you want to put your image Attachmnt should be type "image"

Here I explained it through openfiledialog by Browse button, where you will select your image.

Hi,

Its advised to avoid storing the images in the database.
Please verify the following link you will get your answer too.
Images in the database

Thanks