Recent content by Brenden

  1. B

    Arrrgg...why can I load this datatable??

    Learn the difference between a dataset and datatable, and not bothering to copy the records again into the datatable, I'm use to using the old VB6 recordsets...bloody much easier :rolleyes:
  2. B

    Arrrgg...why can I load this datatable??

    hmm...isn't..QuestionDS ("questions") a dataset, I thought you needed to put all the records in a dataset first and then fill up a datatable. Are dataset and datatable the same thing?? :confused:
  3. B

    Arrrgg...why can I load this datatable??

    Hmm sorry for the confusion....and I'm a newbie when it comes to vb.net but the sample code which I posted...it that of ONE datatable which I'm having problems to load data into. I did try using two datatables before however to no success. (I seriously do not explain complex things to well lol)...
  4. B

    Arrrgg...why can I load this datatable??

    The error occurs I think when it trys to add the Quest_ID to the datatable, because it knows Question_ID in the Question table has a relationship with the Quest_ID in the Answers table. So it breaks at: QuestionNewRow("Quest_ID") = QuestionDSRow("Quest_ID") I've tried using...
  5. B

    Arrrgg...why can I load this datatable??

    Forgot to add, I'm doing this as a mobile application...which means using the Compact Framework. Run the SQL and here is the data: Question_ID Question Answer_ID Answer CorrectAnswer Quest_ID 1 What is OOP? 1 Object oriented programming allows...
  6. B

    Arrrgg...why can I load this datatable??

    I have a small problem, which I've spend the whole day trying to work out, and need some help on. I'm retrieving data from two tables, and putting into a datatable. Heres the code: Try 'Open up the connection object SQLtestconn = New SqlConnection...
Top Bottom