inserting photo into sqlserver with c#

Hello!

Try this:

1) You need to know everything about a file you a trying to upload
Use this(BellUpload is a asp:FileUpload control name):

FileInfo fi = new FileInfo(BellUpload.FileName);

2) You need a memory buffer:

Byte[] buffer = new Byte[BellUpload.PostedFile.ContentLength];

3) You need to read the file in to the memory buffer

file.InputStream.Read(buffer, 0, BellUpload.PostedFile.ContentLength);

4) You need to create a table in mssql
5) I'm using stored procedure to load a file:

ALTER PROCEDURE [dbo].[UploadFile]
@WPS nvarchar(50),
@FileName nvarchar(255),
@FileType nvarchar(50),
@FileContent varbinary(MAX),
@FileSize bigint
AS
BEGIN
insert into Files ([WPS],[FileName], [FileType], [FileContent])
values (@WPS, @FileName, @FileType, @FileContent)
END

6)Finally you need to upload it by SQL classes

using (SqlConnection _con = new SqlConnection("Data Source=....."))

                using (SqlCommand _cmd = new SqlCommand("UploadFile", _con))
                {
                    _cmd.CommandType = CommandType.StoredProcedure;
                    _cmd.Parameters.AddWithValue("@WPS", WPSfield.Text.Trim());
                    _cmd.Parameters.AddWithValue("@FileName", fi.Name);
                    _cmd.Parameters.AddWithValue("@FileType", file.ContentType);
                    _cmd.Parameters.AddWithValue("@FileContent", buffer);
                    _cmd.Parameters.AddWithValue("@FileSize", BellUpload.PostedFile.ContentLength);

                    _con.Open();
                    _cmd.ExecuteNonQuery();
                    _con.Close();

                }

Hope it helps.