Search results

  1. B

    Data Set/ Data reader problems.

    Ok, I am writing a program where I am sadly having to mix datasets with datareaders..at least that's the aim. I finally got it to get past the fillign the data table (I Think) but now it's failignon the execution of the data reader. Dim VHSData As New DataSet Dim Findrow As DataRow Dim...
  2. B

    Use of ' in a query.

    Ok, made a program, ti works fine 90 percent of the time. It is designed to INSERT NEW RECORDS into a database that holds video tape data. Here is the problem, some of the video titles contain an apostrophe, or single quote (') The same char that is used int eh SQL INSERT query to denote start...
  3. B

    Possible Query structure problem.

    Possible Query structure problem.[RESOLVED] I had hoped to not have to use this forum again (no offense) but I cannot figure out why (and yes, I checked all the sources I coudl find, help, MSDN, etc etc) this query doesn't seem to return the proper results. Query Format: VideoQuery =...
  4. B

    Distinct in SQL Query

    Distinct in SQL Query-Problem Resolved I am writing a more ecomplex program than my previous one, one requiring parsing out dinstinct entries from a table (there are about 5 distinct values in on column across 36000 records). Here is my question. I am using the OleDbDataReader to retrieve the...
  5. B

    Nesting DataReaders?

    Ok, all the help I've gotten ehre has been of tremendous aide to me. This one I thought would work, but I think I'm goofing someplace, and I can't wrap my head around datagrids enough yet to even attempt them, doubly since I'm just looking for display. The aim is to pull a range of records from...
  6. B

    Forgive a dumb Newbie, special character help [RESOLVED]

    Once more, please forgive the rantings of a dumb newbie. I have tried searching the MSDN library, and here, and some some of my other online resources. I am trying to find out what the characters are I need to append to the end of a string to force a carrige return for a textbox. I am returning...
  7. B

    Query Quandries

    I would like to thank all fo you who helped me get my other problem fixed first of all. Now I am in the process of optimizing it, and looking into how to do thigns more efficently for that code, and another project. This time, I am trying to build a Query for the OleDB that will pull the records...
  8. B

    General Question - Newbie [RESOLVED]

    Forgive the post if this is the wrong forum. I am new to .NET studio. I was self learning VB6, but had a major comp crash, and now only have .NET studio. My question is this. I am trying to complete a very very simple Access Database project. I was able in VB6 to use the .seek and .find to read...
Top Bottom