Insert Image to MS-SQL

melvik · October 4th, 2003, 06:14 AM

Hi there:
Im going to insert an Image into MS-SQL Server 2000, could anyone give me a sample!

I use the code that I've useing for other tables but I guess I need something more for inserting Images to Database!
Bye the way Im using DataSet & DataAdapter.

Any help is appreciated.

Always:),
Hovik Melkomian.

melvik · October 11th, 2003, 12:59 AM

I found my amswer guys!!!

Always:),
Hovik Melkomian.

vivi · October 30th, 2003, 10:20 PM

Hi melvik,

I trying to do the same: inserting an image into MS-SQL.
Can you show me your sample code?

Yeah, i follow the instructions on
http://www.developerfusion.com/show/3905/1/

But I stumble on it. Here is the error message that I got:
-------------------------------------------------------------------
Object reference not set to an instance of an object.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.

Source Error:

Line 68: imgStream = UploadFile.PostedFile.InputStream;
-----------------------------------------------------------------

I can't figure what I miss. Can anyone help?

Thanks.

rodmcleay · October 30th, 2003, 10:24 PM

I am new to C# also but I think you need to use the datatype "Stream".

Stream imgStream = UploadFile.PostedFile.InputStream;

======================================
They say, best men are moulded out of faults,
And, for the most, become much more the better
For being a little bad.
======================================

melvik · November 1st, 2003, 12:49 AM

All r the same as u do for ur text fields but Image part! Here u will just need to change the format of Image to Bitmap Object.
Anyway its what I've done for adding a pic to my dataset using DataAdapter & StoredProcedure on SQL-Server 2000.

Code:

        private void buttonScan_Click(object sender, System.EventArgs e)
        {
            if( DialogResult.OK == FileOpenDlg.ShowDialog() )
            {
                string file = FileOpenDlg.FileName;
                System.IO.FileStream stream = new System.IO.FileStream(file, System.IO.FileMode.Open, System.IO.FileAccess.Read);
                byte[] buffer = new byte[stream.Length];
                stream.Read(buffer, 0, (int)stream.Length);
                stream.Close();
                string strName = System.IO.Path.GetFileNameWithoutExtension(file);

                //SavePic
                DataRow PicRow;
                PicRow = dsDabir1.Tables["Images"].NewRow();
                PicRow["IId"] = 22;
                PicRow["ImgPage"] = 1;
                PicRow["ImgPic"] = buffer;
                dsDabir1.Tables["Images"].Rows.Add(PicRow);
                sqlDataAdapterPix.Update(dsDabir1, "Images");
                buffer = null;

                //ShowPic
            }//if
        }

Always:),
Hovik Melkomian.

uponline_aom · November 3rd, 2003, 09:13 PM

Up

vivi · November 9th, 2003, 01:56 AM

Hi Melvik,

I got it now.
Thanks for your help.

Vivi

melvik · November 9th, 2003, 02:32 AM

pleasure 2 be useful.

Always:),
Hovik Melkomian.

jon.kress · June 15th, 2006, 09:04 AM

Quote:

quote:Originally posted by rodmcleay
I am new to C# also but I think you need to use the datatype "Stream".

Stream imgStream = UploadFile.PostedFile.InputStream;

======================================
They say, best men are moulded out of faults,
And, for the most, become much more the better
For being a little bad.
======================================

I'm running into the same type of problem but I do have my code with the Stream in it.

I'm getting a System.NullReferenceException: Object reference not set to an instance of an object.

I'd put all my code here but you guys would probably die trying to read it all. I did use the reference link to get my code (http://www.developerfusion.com/show/3905/5/) and even though I used that code I'm still getting the error.

Here's my click function (and yes my item is named BtnUpload not UploadBtn

any suggestions??
        public void BtnUpload_Click(object sender, EventArgs e)
        {
            if (Page.IsValid) //Save Image
            {
                Stream imgStream = UploadFile.PostedFile.InputStream;
                int imgLen = UploadFile.PostedFile.ContentLength;
                string imgContentType = UploadFile.PostedFile.ContentType;
                string imgName = txtAdCode.Value;
                byte[] imgBinaryData = new byte[imgLen];

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

                int RowsAffected = SaveToDB(imgName, imgBinaryData, imgContentType);
                if (RowsAffected > 0)
                {
                    Response.Write("<br />Image Saved<br />");
                }
                else
                {
                    Response.Write("<br />An error has occurred, please upload again<br />");
                }
            }
        }