how to upload a file in sqlserver 2000 databse

Question

User1513216887 posted

Hi,

 

how to upload a file in sqlserver 2000 databse using file uploadcontrol in asp.net.

 advance thanks.

Thanks

anitha

Answer 1

User1735976268 posted

The FileUpload control has a property called FileBytes. This will give you the byte[] for the image which can be stored in an SQL varbinary(MAX) field.

Answer 2

User2032571450 posted

check this:

http://www.eggheadcafe.com/tutorials/aspnet/aa36fbdd-b4be-4ecc-b9cd-7cc6fc1980a4/uploading--downloading-f.aspx

Answer 3

User-1734134863 posted

Hi,

Please try to run the following code  which I have written based on my understandings of your problem.

.cs file

      protected void Button4_Click(object sender, EventArgs e)
        {
            string picType = this.FileUpload1.PostedFile.ContentType;
            if (picType != "")
            {
                string picName = this.FileUpload1.FileName;
                SqlConnection conn = new SqlConnection("server=.;database=Test;uid=sa;pwd=issac");
                conn.Open();
                SqlCommand comm = new SqlCommand("insert into test(image) values(@image)", conn);
                comm.Parameters.Add("@image", SqlDbType.Image);      
                comm.Parameters[0].Value = this.FileUpload1.FileBytes;
                comm.ExecuteNonQuery();
                conn.Close();
        
            }
            else
            {

            }

        }

 Hope this helps.

Sincerely,
Zong-Qing Li
Microsoft Online Community Support
Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as
Answer” if a marked post does not actually answer your question.