Hi I've got a problem when following the book "Beginning Visual Basic .NET"

In chapter 15, which I was looking for, the auther goes through how to work with databases and goes through how to create one in access (I already knew how so...) afterwards he writes on how to connect this one to a new empty windows application but somehow I can't seem to get it to work.

I'll outline what I've done below so you maybe can tell me whats wrong

* Created a new windows application
* Added a OleDbDataAdapter and in the wizard that followed did the following:
  - New connection, Provider, Microsoft JET 4.0 OLE DB Provider
  - Looked up my database
  - Pressed ok
  - Could only select Use SQL statements so picked that one
  - In the Advanced Options unchecked everything (only the first two were checked)
  - Generated a simple SQL statement using the Query Builder
  - Pressed next (No errors: Generated SELECT statement, Generated table mappings)

* Entered menu Data and selected Generate DataSet...
* Accepted everything as it was (New: DataSet1, checked for my created table using OleDbAdapter, checked the bottom checkbox)
* Pressed Ok (ERROR: "There were prolems generating Binding_Data.DataSet1. To resolve this problem, build the project, fix any errors, and then generate the dataset again.")
* Tried to build the project, no problems
* Generated the dataset again but same thing happened

Is there anybody who might be able to help me out here? I really want to be able to start using SQL databases but until I figure out whats wrong I can't

Hi

assuming you can connect to the database, you can preview the dataset and so on, the only thing I can think of at the top of my head is a situation I had a year ago. I am not sure if it still applies.

Sometimes, if your field names (the ones returned from the query) are keywords or duplicate field names as in the case where you do a join.
As an example if your field name was Me, it would clash with the VB.NET keyword. If you get a keyword that the compiler thinks is ok (type wise or implicit conversion yields a value deemed ok by the compiler), it may compile but will not work correctly. Now most of the time you will not be able to generate a dataset if the sql is like this, however I have seen cases.

Please check this, and let me know.
behind the generated xsd file there is a .vb file containing the code for your dataset.

if you don't see this file, make sure that you can see all files in the solution explorer by clicking on the Show all files button in the Solution explorer.

Inside this vb code file you will see the DataSet implementation.

Let me know if this helps or not.

Jonathan


Jonathan Crossland
http://www.jonathancrossland.com

I'm not sure what you mean that I should do. The vbx and the vb file looks ok to me but then again I've never played around with databases in visual basic before either. You asked (indirect) if I could connect to the database and when I press the button labled test connection it works fine.

The table I'm using is made up as following:
Name: Customer
Fields: Customer ID(key), Customer Credit ID, Customer Name, Contact First Name, Contact Last Name, Contact Title, Contact Postion......
There are lots of other fields too. This is the xtreme.mdb that are included as an example in the .NET bundle.

The SQL statement I want to generate same as the book does is:
SELECT
    [Customer Name],
    [Contact First Name],
    [Contact Last Name],
    [Contact Position],
    [Customer ID]
FROM
    Customer ORDER BY [Customer Name]

I don't understand what is wrong. If this is a hard example to understand I would be very happy if you or somebody else could create a small example (database, base code and connection) Either write to me at [email protected] or type in the operations I should include here. One example should solve this mess.