Saving image file using Fileupoad Control and sqldatasource

Question

I want to add a image file to my database using sqldatasource .

steps that i have taken

1.Coverting image to Byte[] array.

Stream fs = FileUpload1.PostedFile.InputStream; 
BinaryReader br = new BinaryReader(fs); 
Byte[] bytes = br.ReadBytes((Int32)fs.Length);

2.Setting the update parameter type as Object

<UpdateParameters>       
<asp:Parameter Name="File" Type="Object" /> 
</UpdateParameters>

3.Adding byte array as update parameter in SqlDataSource control.

sqlDataSource.UpdateParameters["File"].DefaultValue = bytes;

but when i compile this code it is giving me a error "is giving me a error

"Cannot Implicitly convert byte[] to string" at third step

Renatas M. · Accepted Answer · 2011-07-05 09:18:14Z

3

Try to set parameter in Updating event

private void sqlDataSource_Updating(object sender, SqlDataSourceCommandEventArgs e)
{
    e.Command.Parameters["File"].Value = bytes;
}

answered Jul 5, 2011 at 9:18

Renatas M.

11.8k1 gold badge45 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

SMK · Accepted Answer · 2011-07-05 08:59:52Z

0

you should make data type varbinary

and made datatype varbinary(max) in your database

answered Jul 5, 2011 at 8:59

SMK

2,1682 gold badges13 silver badges23 bronze badges

you can only enter string type value to the DefaultValue .