Reading data to populate in a Textboxt RSS

• • Reply
  isi_rajah19

  None

  0 Points

  4 Posts

  Reading data to populate in a Textboxt

  Jun 12, 2012 09:00 AM|isi_rajah19|LINK

  Hi

  So i have two tables 1 Reserves which has reserveID,SellerID,ReserveLetter,description.

  And the second is AuctionRoll which has a Description,sellerId etc.

  I need to select the data from the reserves table,to populate data into the Description column on the Roll

  The workflow is as such the user will enter products into the reserves table and for each seller if the seller has more than 1 item will be given a letter(4products= 1a,1b,1c,1d) seller ID will be the number and a will be the letter in the reserves.

   

  Then if the user enters 1a under the sellerID in the AuctionRoll it must select the description in the Reserves for that record.

   

  Please help.

• • Reply
  sen338

  Member

  670 Points

  281 Posts

  Re: Reading data to populate in a Textboxt

  Oct 21, 2014 04:57 PM|sen338|LINK

  I think based on the Enter Text(ReserveID + SellerId) , get those id and write a query like below

  select * from Reserves where (reserveID + SellerID)  = '1a'

  this will pull the data, which u need .

  I am just giving you the idea, i think you can implement by yourself

  Please mark the replies as answers if they help or unmark if not.
  
• • Reply
  JohnBert

  Member

  320 Points

  111 Posts

  Re: Reading data to populate in a Textboxt

  Mar 23, 2015 08:23 PM|JohnBert|LINK

  Hey,

  If My.Computer.FileSystem.FileExists("path_to_file") Then
    Dim ioFile As New System.IO.StreamReader("path_to_file" + "filename")

  should be

  If My.Computer.FileSystem.FileExists(OpenFileDialog2.FileName) Then
    Dim ioFile As New System.IO.StreamReader(OpenFileDialog2.FileName)

  ASP.NET Hosting
  Visit My Site