Set parameter value to "Insert Parameters"

[calvin]

Hi,

 

I am using objectdatasource as datasource in page. I use the "File Upload" control to get the image and save to database. Within the database table, there are a lot of datafield. I got the problem of setting the parameter value for the image. I use three datafield to store the image relevant data.

 

Datafield DataType

1. imgName (nvarchar 50)

2. imgData (Image)

3. imgType (nvarchar 50)

Try
           Dim imgName As String
           Dim imgContentType As String
           Dim imgLen As Int32
           Dim imgbin() As Byte

If Me.FileUpload.HasFile = True Then
  If Me.FileUpload.PostedFile.FileName.Trim.Length > 0 And  Me.FileUpload.PostedFile.ContentLength > 0 Then
                   Dim imgStream As Stream = Me.FileUpload.PostedFile.InputStream()
                   imgLen = Me.FileUpload.PostedFile.ContentLength
                   imgContentType = Me.FileUpload.PostedFile.ContentType
                   imgName = Me.FileUpload.PostedFile.FileName.Substring(Me.FileUpload.PostedFile.FileName.LastIndexOf("\") + 1)
                   Dim imgBinaryData(imgLen) As Byte
                   'Dim n As Int32 = imgStream.Read(imgBinaryData, 0, imgLen)
                   imgbin = imgBinaryData

ObjectDataSource.InsertParameters("imgName") = imgName
ObjectDataSource.InsertParameters("imgData") = imgbin
ObjectDataSource.InsertParameters("imgType") = imgContentType 
ObjectDataSource.Insert()

Question

1: How can I set the "value" to the parameter?

2. Do I make mistake to the image field, since declare in database is "Image" datatype and use "Byte" in codebehind?

3: For next time if user want to retrieve the image, can it be "restore" as "image file"?

4. Can I use the "File Upload" control in "DetailsView" with objectdatasource? Because I have try to do it, but unsuccessful. Since I use the "Template Field" and drag the "File Upload" control to the "InsertItemTemplate", but there is no bound property of "text" which to bound to the "field binding". So, is this possible to use "file upload" control in DetailsView?? If so, how to do It.

5. With the approach in question 4, the DetailsView was include in the "atlas:UpdatePanel", will this make error?

 

Appreciate for those giving solution and help.

 

Calvin

Edited May 16, 2006 by PlausiblyDamp

[calvin]

Get Solution from others

 

Q_Quek wrote:

1: How can I set the "value" to the parameter?

 

You can set the value in the Selecting event handler of the ObjectDataSource control.

 

Q_Quek wrote:

2. Do I make mistake to the image field, since declare in database is "Image" datatype and use "Byte" in codebehind?

 

No.

 

Q_Quek wrote:

3: For next time if user want to retrieve the image, can it be "restore" as "image file"?

 

Yes. You simply create a seperate web page or custom http handler for showing up an image store in DB, you can search for the sample code out there or on this site.

 

Q_Quek wrote:

4. Can I use the "File Upload" control in "DetailsView" with objectdatasource? Because I have try to do it, but unsuccessful. Since I use the "Template Field" and drag the "File Upload" control to the "InsertItemTemplate", but there is no bound property of "text" which to bound to the "field binding". So, is this possible to use "file upload" control in DetailsView?? If so, how to do It.

 

Yes, you can. You can define a select parameter for the ObjectDataSource control like this:

 

<asp:Parameter Name="imgData" Type="Object" />

In the Selecting event handler of the ObjectDataSource, you can get the binary data of the uploaded image from the FileUpload control, then set it to the select parameter in the InputParameters collection:

 

protected void ObjectDataSource1_Inserting(object sender, ObjectDataSourceMethodEventArgs e) { FileUpload upload = DetailsView1.FindControl("FileUpload") as FileUpload; using (BinaryReader reader = new BinaryReader(upload.PostedFile.InputStream)) { byte[] bytes = new byte[upload.PostedFile.ContentLength]; reader.Read(bytes, 0, bytes.Length); e.InputParameters["imgData"] = bytes; } }

 

Q_Quek wrote:

5. With the approach in question 4, the DetailsView was include in the "atlas:UpdatePanel", will this make error?

 

Yes, it may raise the error since the file does not get uploaded when you make an out-of-band request with Atlas, you need to submit the form to upload the image.