insert document in vb.net RSS

• • Reply
  Capricon Use...

  Member

  239 Points

  1074 Posts

  insert document in vb.net

  Dec 29, 2016 09:07 AM|Capricon User|LINK

  try to upload document and then i try to insert document in table for this i try this code on button click

  For i As Integer = 0 To ListBox1.Items.Count - 1
  
          Dim DocumentName As String = ListBox1.Items.Item(i).Text
  
          'Dim Docextension As String = ""
          'Docextension = Path.GetExtension(fileUpEx.PostedFile.FileName)
  
          Dim Docextension As String = System.IO.Path.GetExtension(DocumentName)
          Label4.Text = Convert.ToString("Uploaded File Extension: ") & Docextension
  
  
          Dim Document As Byte() = New Byte(fileUpEx.PostedFile.ContentLength - 1) {}
          Document = DocumentName.FileBytes
  
          Dim strKeyName() As String = {"DocumentName", "DocType", "Document", "DocExtension"}
          Dim objKeyVal() As Object = {DocumentName, 7, Document, Docextension}
          structDb = objDataSet.ExecSP("tbl", "spupload_file", strKeyName, objKeyVal)
  
      Next

  i try above code but document  not inserted... what should i do ?

  table in data what i want

  ID documentname document           docextension 
  1   abb.docx    xxkdkfexcdd234       .docx

  table in data what current is

  ID documentname  document           docextension 
  1   abb.docx                          .docx

  sp

  ALTER procedure [dbo].[spupload_file]
  @DocumentName varchar(100),
  @Doctype tinyint,
  @Document image,
  @DocExtension varchar(6)
  as
  
  
  insert into DocDownloads (DocumentID,DocumentName,DocType,Document,DocExtension)
  
  select (select max(DocumentID) from DocDownloads )+ROW_NUMBER()  over(order by @DocumentName),
  @DocumentName,7,@Document,@DocExtension

• • Reply
  oned_gk

  All-Star

  52523 Points

  15676 Posts

  Re: insert document in vb.net

  Dec 30, 2016 02:30 AM|oned_gk|LINK

  You have set Document from DocumenName that is a string containing listbox item text.

  I guess, you should get the filebytes from fileUpEx.FileBytes or PostedFule.Content or from file based DocumentName

  If the document is based listbox item, why you declare document based fileUpEx?

  I guess the problem becouse FileUpEx is empty.

  Programming to simplify, don't look for difficult way
  Suwandi - Non Graduate Programmer