Support forums - Upload photo to database?

Support forums » Products » Ajax Uploader » Re: Upload photo to database?

Upload photo to database?

Last post 02-11-2009, 9:01 PM by cutechat. 33 replies.

Page 1 of 2 (34 items) 1 2 Next >
	Sort Posts: Previous Next

08-11-2008, 4:01 PM 42892

mainship
Joined on 05-15-2008
Posts 11

Upload photo to database?

Reply Quote

Can I upload a photo into a SQL Server 2005 photo field? Is there an example of how to do that?

Diane

08-11-2008, 4:43 PM 42895 in reply to 42892

Adam
Joined on 09-23-2003
Aurora, ON
Posts 18,678

Re: Upload photo to database?

Reply Quote

Diane,

1. Store the content of the uploaded file in the Byte buffer.

byte[] data = new byte[args.FileSize];

using(Stream stream=args.OpenStream())

{

stream.Read(data,0,data.Length);
}

2. Store the buffer in the Database, and it is very easy as long as you have the database table and you know some SQL Statments.

asp.net Chat http://cutesoft.net/ASP.NET+Chat/default.aspx
Web Messenger: http://cutesoft.net/Web-Messenger/default.aspx
asp.net wysiwyg editor: http://cutesoft.net/ASP.NET+WYSIWYG+Editor/default.aspx
asp wysiwyg html editor: http://cutesoft.net/ASP
asp.net Image Gallery: http://cutesoft.net/ASP.NET+Image+Gallery/default.aspx
Live Support: http://cutesoft.net/live-support/default.aspx

12-16-2008, 11:53 AM 46978 in reply to 42895

pat333
Joined on 04-22-2004
Posts 20

Re: Upload photo to database?

Reply Quote

Is it possible to do this without saving the file to disc first?

12-16-2008, 3:59 PM 46989 in reply to 46978

Adam
Joined on 09-23-2003
Aurora, ON
Posts 18,678

Re: Upload photo to database?

Reply Quote

pat333,

If you don't use the .CopyTo method to copy the uploaded files , the file will not be saved to disc first.

void Uploader_FileUploaded(object sender, UploaderEventArgs args)
        {
            Uploader uploader = (Uploader)sender;
            InsertMsg("File uploaded! " + args.FileName + ", " + args.FileSize + " bytes.");

            //Copies the uploaded file to a new location.
            //args.CopyTo("c:""temp"""+args.FileName);
            //You can also open the uploaded file's data stream.
            //System.IO.Stream data = args.OpenStream();
        }

12-17-2008, 4:30 AM 47012 in reply to 46989

pat333
Joined on 04-22-2004
Posts 20

Re: Upload photo to database?

Reply Quote

Hi,

I have an empty FileUploaded() method and no explicit copyto anywhere but the uploader always says "unable to find the uploaded file in the directory .../UploaderTemp" on an attempted upload

Control is just:

<CuteWebUI:Uploader ID="ctlFormUpload"
          OnFileUploaded="ctlFormUpload_FileUploaded" runat="server"
          FileTypeNotSupportMsg="Please upload only .doc or .docx files"
   >
   <validateoption maxsizekb="10240" AllowedFileExtensions="doc,docx" />
    </CuteWebUI:Uploader>

12-18-2008, 8:54 AM 47082 in reply to 47012

cutechat
Joined on 07-22-2004
Posts 2,332

Re: Upload photo to database?

Reply Quote

Hi,

Do you have a folder website/UploaderTemp , and does it has permission to write file?

Please try this way , maybe you can get error details:

<CuteWebUI:Uploader ID="ctlFormUpload"
          OnFileUploaded="ctlFormUpload_FileUploaded" runat="server"
          FileTypeNotSupportMsg="Please upload only .doc or .docx files"

UploadType="IFrame"
>

Regards,

Terry

12-18-2008, 9:35 AM 47087 in reply to 47082

pat333
Joined on 04-22-2004
Posts 20

Re: Upload photo to database?

Reply Quote

No. I don't want to store the file to disc - I want to upload directly to database without saving to disc (this is an environment where we don't have any disc write permissions).

12-18-2008, 11:00 AM 47090 in reply to 47087

cutechat
Joined on 07-22-2004
Posts 2,332

Re: Upload photo to database?

Reply Quote

Hi,

In that case you need use another 'UploaderProvider' , and register the class name to web.config appSettings:

Here is the provider implementation code :

-old code deleted-see other reply-

Regards,

Terry

12-18-2008, 11:16 AM 47098 in reply to 47090

pat333
Joined on 04-22-2004
Posts 20

Re: Upload photo to database?

Reply Quote

Great thanks will give this a go.

01-05-2009, 4:31 AM 47399 in reply to 47090

pat333
Joined on 04-22-2004
Posts 20

Re: Upload photo to database?

Reply Quote

I got this working great with a single upload but is it possible to do this with multiple uploads enabled? That seems to require at least the AppendData method which isn't supplied in the code.

01-05-2009, 7:59 PM 47430 in reply to 47399

cutechat
Joined on 07-22-2004
Posts 2,332

Re: Upload photo to database?

Reply Quote

Hi,

Oh yes.

Since we changed the uploader recently ,

we forgot to implement this sample method.

the AppendData method should be:

-old code deleted-see the following reply-

Please test it and reply me if you get more problem.

Regards,

Terry.

01-15-2009, 6:35 PM 47795 in reply to 47430

pat333
Joined on 04-22-2004
Posts 20

Re: Upload photo to database?

Reply Quote

Thanks. I am testing this now and it seems to cut files off at 65536 bytes. It apparently uploads fine (no errors, progress goes to 100%) but when looking at what's in the database table, all files uploaded greater than 65536 bytes are reporting just that amount in filesize column. Anything smaller than this is working fine. Is there a configuration setting I'm missing?

01-15-2009, 7:10 PM 47796 in reply to 47795

pat333
Joined on 04-22-2004
Posts 20

Re: Upload photo to database?

Reply Quote

On investigation, it's only doing this when uploadtype="auto" which I think in this case is silverlight. If I manually set the uploadtype to either iframe or flash, it works ok?

01-15-2009, 9:38 PM 47799 in reply to 47796

cutechat
Joined on 07-22-2004
Posts 2,332

Re: Upload photo to database?

Reply Quote

Hi,

-old code deleted-

Regards,

Terry

01-16-2009, 4:21 AM 47803 in reply to 47799

pat333
Joined on 04-22-2004
Posts 20

Re: Upload photo to database?

Reply Quote

Thanks, that seems to have fixed the problem.

01-16-2009, 11:38 AM 47818 in reply to 47803

pat333
Joined on 04-22-2004
Posts 20

Re: Upload photo to database?

Reply Quote

Actually, sorry - the file size is reporting correct but the larger files are being corrupted when in silverlight mode. Other modes work ok.

01-30-2009, 6:08 AM 48222 in reply to 47818

pat333
Joined on 04-22-2004
Posts 20

Re: Upload photo to database?

Reply Quote

We have still not managed to get this working.

For all larger files (small files work in all modes) :

- In silverlight mode, uploads go up without error but are corrupted.

- In flash mode, get the message "unable to find the file in custom provider"

- In iframe mode get message 'cannot access uploadtemp'

This is in multiple or single upload mode. Please help.

02-03-2009, 2:08 AM 48280 in reply to 48222

cutechat
Joined on 07-22-2004
Posts 2,332

Re: Upload photo to database?

Reply Quote

Hi,

Please check this code , we have already tested it :

using System;
using System.Data;
using System.Data.SqlClient;
using CuteWebUI;
namespace UploaderDatabaseProvider
{
/// <summary>
/// UploaderSqlServerProvider
/// </summary>
public class UploaderSqlServerProvider : CuteWebUI.UploaderProvider
{
const int BUFFERSIZE = 204800;
SqlConnection _conn;
public override void Init(UploaderBase uploader, System.Web.HttpContext context)
{
string connectionstring = System.Configuration.ConfigurationSettings.AppSettings["UploaderDatabase"];
if (connectionstring == null) throw (new Exception("appSettings:UploaderDatabase not found."));
_conn = new SqlConnection(connectionstring);
_conn.Open();
}
public override void Dispose()
{
if (_conn != null)
_conn.Close();
base.Dispose();
}
private SqlCommand CreateCommand(string commandtext)
{
if (_conn == null) throw (new Exception("Not init yet."));
SqlCommand cmd = new SqlCommand();
cmd.Connection = _conn;
cmd.CommandText = commandtext;
return cmd;
}
public override bool SupportFS
{
get
{
return false;
}
}
public override string GetFSPath(Guid guid)
{
throw (new NotSupportedException());
}
public override void Maintain()
{
SqlCommand cmd = CreateCommand("DELETE [AjaxUploaderTempFiles] WHERE FileTime<@Time");
cmd.Parameters.Add("@Time", SqlDbType.DateTime).Value = DateTime.Now.AddHours(-1);
cmd.ExecuteNonQuery();
}
public override bool GetInfo(Guid guid, out string filename, out int filesize, out bool persist)
{
SqlCommand cmd = CreateCommand("SELECT [FileName],[FileSize],[IsPersist] FROM [AjaxUploaderTempFiles] WHERE FileGuid=@Guid");
cmd.Parameters.Add("@Guid", SqlDbType.UniqueIdentifier).Value = guid;
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (reader.Read())
{
filename = reader.GetString(0);
filesize = reader.GetInt32(1);
persist = reader.GetBoolean(2);
return true;
}
else
{
filename = null;
filesize = 0;
persist = false;
return false;
}
}
}
public override void Delete(Guid guid)
{
SqlCommand cmd = CreateCommand("DELETE [AjaxUploaderTempFiles] WHERE FileGuid=@Guid");
cmd.Parameters.Add("@Guid", SqlDbType.UniqueIdentifier).Value = guid;
cmd.ExecuteNonQuery();
}
public override void Persist(Guid guid)
{
SqlCommand cmd = CreateCommand("UPDATE [AjaxUploaderTempFiles] SET IsPersist=1 WHERE FileGuid=@Guid");
cmd.Parameters.Add("@Guid", SqlDbType.UniqueIdentifier).Value = guid;
cmd.ExecuteNonQuery();
}
public override void UnPersist(Guid guid)
{
SqlCommand cmd = CreateCommand("UPDATE [AjaxUploaderTempFiles] SET IsPersist=0 WHERE FileGuid=@Guid");
cmd.Parameters.Add("@Guid", SqlDbType.UniqueIdentifier).Value = guid;
cmd.ExecuteNonQuery();
}
public override void Save(Guid guid, string filename, System.IO.Stream stream)
{
int stepsize = BUFFERSIZE;
long filesize = stream.Length;
byte[] data = new byte[Math.Min(stepsize, filesize)];
stream.Read(data, 0, data.Length);
SqlCommand cmd = CreateCommand("INSERT INTO [AjaxUploaderTempFiles] ([FileGuid],[FileTime],[FileName],[FileSize],[FileData],[IsPersist]) VALUES (@Guid,@Time,@Name,@Size,@Data,0)");
cmd.Parameters.Add("@Guid", SqlDbType.UniqueIdentifier).Value = guid;
cmd.Parameters.Add("@Time", SqlDbType.DateTime).Value = DateTime.Now;//for Maintain
cmd.Parameters.Add("@Name", SqlDbType.NVarChar, 255).Value = filename;
cmd.Parameters.Add("@Size", SqlDbType.Int).Value = filesize;
cmd.Parameters.Add("@Data", SqlDbType.Image).Value = data;
cmd.ExecuteNonQuery();
if (filesize <= stepsize)
return;
int sentsize = stepsize;
try
{
while (true)
{
int readsize = stream.Read(data, 0, data.Length);
if (readsize <= 0)
return;
cmd = CreateCommand("DECLARE @ptrval binary(16) ; SELECT @ptrval = TEXTPTR([FileData]) FROM [AjaxUploaderTempFiles] WHERE [FileGuid]=@Guid ; UPDATETEXT [AjaxUploaderTempFiles].[FileData] @ptrval "
+ sentsize + " 0 @Data");
cmd.Parameters.Add("@Guid", SqlDbType.UniqueIdentifier).Value = guid;
if (readsize != data.Length)
{
byte[] newdata = new byte[readsize];
Buffer.BlockCopy(data, 0, newdata, 0, readsize);
data = newdata;
}
cmd.Parameters.Add("@Data", SqlDbType.Image).Value = data;
cmd.ExecuteNonQuery();
sentsize += readsize;
}
}
catch (Exception)
{
Delete(guid);
throw;
}
}
public override void AppendData(Guid guid, string filename, System.IO.Stream stream)
{
int stepsize = BUFFERSIZE;
long filesize = stream.Length;
byte[] data = new byte[stepsize];
SqlCommand cmd = CreateCommand("SELECT [FileSize] FROM [AjaxUploaderTempFiles] WHERE [FileGuid]=@Guid ; UPDATE [AjaxUploaderTempFiles] SET [FileSize]=[FileSize]+@Size WHERE [FileGuid]=@Guid");
cmd.Parameters.Add("@Size", SqlDbType.Int).Value = filesize;
cmd.Parameters.Add("@Guid", SqlDbType.UniqueIdentifier).Value = guid;
int sentsize = Convert.ToInt32(cmd.ExecuteScalar());
try
{
while (true)
{
int readsize = stream.Read(data, 0, data.Length);
if (readsize <= 0)
break;
cmd = CreateCommand("DECLARE @ptrval binary(16) ; SELECT @ptrval = TEXTPTR([FileData]) FROM [AjaxUploaderTempFiles] WHERE [FileGuid]=@Guid ; UPDATETEXT [AjaxUploaderTempFiles].[FileData] @ptrval "
+ sentsize + " 0 @Data");
cmd.Parameters.Add("@Guid", SqlDbType.UniqueIdentifier).Value = guid;
if (readsize != data.Length)
{
byte[] newdata = new byte[readsize];
Buffer.BlockCopy(data, 0, newdata, 0, readsize);
data = newdata;
}
cmd.Parameters.Add("@Data", SqlDbType.Image).Value = data;
cmd.ExecuteNonQuery();
sentsize += readsize;
}
}
catch (Exception)
{
Delete(guid);
throw;
}
}
public override System.IO.Stream OpenStream(Guid guid)
{
SqlCommand cmd = CreateCommand("SELECT DATALENGTH([FileData]) FROM [AjaxUploaderTempFiles] WHERE FileGuid=@Guid");
cmd.Parameters.Add("@Guid", SqlDbType.UniqueIdentifier).Value = guid;
object val = cmd.ExecuteScalar();
if (val == null || Convert.IsDBNull(val))
throw (new Exception("File not found."));
int filesize = Convert.ToInt32(val);
int stepsize = BUFFERSIZE;
if (filesize <= stepsize)
{
cmd = CreateCommand("SELECT [FileData] FROM [AjaxUploaderTempFiles] WHERE FileGuid=@Guid");
cmd.Parameters.Add("@Guid", SqlDbType.UniqueIdentifier).Value = guid;
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (reader.Read())
{
byte[] data = (byte[])reader.GetValue(0);
return new System.IO.MemoryStream(data);
}
}
throw (new Exception("File not found."));
}
ReadStream readstream = new ReadStream();
readstream.provider = this;
readstream.guid = guid;
readstream.filesize = filesize;
return readstream;
}
class ReadStream : System.IO.Stream
{
public UploaderSqlServerProvider provider;
public Guid guid;
public int filesize;
long pos = 0;
byte[] _tempbuff = null;
long _tempstart = -1;
public override long Length
{
get
{
return filesize;
}
}
public override long Position
{
get
{
return pos;
}
set
{
if (value < 0) throw (new ArgumentOutOfRangeException("Position"));
if (value >= filesize) throw (new ArgumentOutOfRangeException("Position"));
pos = value;
_tempbuff = null;
_tempstart = -1;
}
}
public override int Read(byte[] buffer, int offset, int count)
{
int readsize = 0;
while (true)
{
if (_tempstart != -1 && _tempbuff != null)
{
int start = (int)(pos - _tempstart);
if (start >= 0 && start < _tempbuff.Length)
{
int copysize = Math.Min(count, _tempbuff.Length - start);
Buffer.BlockCopy(_tempbuff, start, buffer, offset, copysize);
pos += copysize;
readsize += copysize;
offset += copysize;
count -= copysize;
if (count <= 0)
return readsize;
}
}
if (pos >= filesize)
return readsize;
using (SqlCommand cmd = provider.CreateCommand("DECLARE @ptrval binary(16) ; SELECT @ptrval = TEXTPTR([FileData]) FROM [AjaxUploaderTempFiles] WHERE [FileGuid]=@Guid ; READTEXT [AjaxUploaderTempFiles].[FileData] @ptrval "
+ pos + " " + Math.Min(BUFFERSIZE, filesize - pos)))
{
cmd.Parameters.Add("@Guid", SqlDbType.UniqueIdentifier).Value = guid;
_tempbuff = (byte[])cmd.ExecuteScalar();
_tempstart = pos;
}
}
//return readsize;
}
public override bool CanRead
{
get
{
return true;
}
}
public override bool CanWrite
{
get
{
return false;
}
}
public override bool CanSeek
{
get
{
return true;
}
}
public override void Close()
{
}
public override void Flush()
{
}
public override long Seek(long offset, System.IO.SeekOrigin origin)
{
long oldpos = pos;
if (origin == System.IO.SeekOrigin.Begin)
{
Position = offset;
}
if (origin == System.IO.SeekOrigin.Current)
{
Position += offset;
}
if (origin == System.IO.SeekOrigin.End)
{
Position = filesize + offset;
}
return oldpos;
}
public override void SetLength(long value)
{
throw (new NotSupportedException());
}
public override void Write(byte[] buffer, int offset, int count)
{
throw (new NotSupportedException());
}
}
}
}

The old issue is that the offset of append data is wrong. Sorry for the inconvenience.

Regards,

Terry

02-03-2009, 2:16 AM 48281 in reply to 48280

cutechat
Joined on 07-22-2004
Posts 2,332

Re: Upload photo to database?

Reply Quote

Web.config :

Sql Schema:

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AjaxUploaderTempFiles]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AjaxUploaderTempFiles]
GO

CREATE TABLE [dbo].[AjaxUploaderTempFiles] (
[FileGuid] [uniqueidentifier] NOT NULL ,
[FileTime] [datetime] NOT NULL ,
[FileName] [nvarchar] (255)
[FileSize] [int] NOT NULL ,
[FileData] [image] NOT NULL ,
[IsPersist] [bit] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[AjaxUploaderTempFiles] WITH NOCHECK ADD
CONSTRAINT [PK_AjaxUploaderTempFiles] PRIMARY KEY CLUSTERED
(
[FileGuid]
) ON [PRIMARY]
GO

02-03-2009, 5:29 AM 48290 in reply to 48281

pat333
Joined on 04-22-2004
Posts 20

Re: Upload photo to database?

Reply Quote

With your updated code this is working in silverlight mode now (for files that weren't before), but not in flash or iframe mode. In flash mode, get the message "cannot find the file in custom provider" and iframe get the message "Access to the path C:\....\UploaderTemp is denied"

Page 1 of 2 (34 items) 1 2 Next >