I have datalist bind with sql datasource
I have update command
Protected Sub DataList1_UpdateCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataListCommandEventArgs)
Dim ID As String = DataList1.DataKeys(e.Item.ItemIndex).ToString()
Dim title As TextBox = CType(e.Item.FindControl("textCategoryName"), TextBox)
Dim image As FileUpload = CType(e.Item.FindControl("FileUpload1"), FileUpload)
SqlDataSource1.UpdateParameters("ID").DefaultValue = ID
SqlDataSource1.UpdateParameters("title").DefaultValue = title.Text
SqlDataSource1.UpdateParameters("image").DefaultValue = image.FileBytes
SqlDataSource1.Update()
DataList1.EditItemIndex = -1
DataList1.DataBind()
End Sub
It shows the error in the line
SqlDataSource1.UpdateParameters("image").DefaultValue = image.FileBytes
Value of byte can not be connverted to string
I also change the sql datasource parameters for image from object to byte
<UpdateParameters>
<asp:Parameter Name="title" Type="String" />
<asp:Parameter Name="image" Type="byte" />
<asp:Parameter Name="ID" Type="Int32" />
</UpdateParameters>