![]() ConnectionStrings( "reportfeedRequirementsConnectionString" ).ConnectionStringĭim con As New SqlConnection (strConnString) Public Function GetData( ByVal cmd As SqlCommand ) As DataTableĭim strConnString As String = System.Configuration. Protected Sub Page_Load( ByVal sender As Object, ByVal e As System. What else is needed.ĭim strQuery As String = "insert into Requestdocs(rid, Name, ContentType, Data) values cmd As New SqlDbType.Int).Value =, SqlDbType.VarChar).Value = ntType", SqlDbType.VarChar).Value() =, SqlDbType.Binary).Value = bytes The fact I've been able to get this far is a testament to Experts Exchange. Any suggestions will likely have to be spelled or written out for me. I can read code on a intermediate level but writing it is totally different. Please don't make the assumption that I know code syntax because I don't. I tried a lot of things but mostly what I get is (Failed to convert parameter value from a HiddenField to a String.). ![]() I am binding the hidden field which is named rid to the value from the SQL datasource. ![]() Instead it is a hidded field with the value being assigned that is derived from an SQLDataSource. However, this is not going to be a hardcoded value but instead is going to be a dynamic value. In this line, SqlDbType.Int).Value = xxxxx, if I replace the xxxxxx with a hardcoded value of 1, 2 or 3 or any int value everything works fine. The actual id field is named rid in the table. The last and absolute final problem I have is the need to add an id value to the same table. I am also now able to retrieve and display the the binary image without any problems. #How to add a9l2 into binary editor pdfI am able to insert word, excel and pdf MIMEtypes to a table in a sql server 2008 database. Question: The code listed a cut from an asp.net VB code behind page.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |