Hi All

Just to let you know that any questions posted here will be looked at :)

Hope you all enjoy the book



Jonathan Crossland
http://www.jonathancrossland.com

__________________
Jonathan Crossland
http://www.jonathancrossland.com

NOT a Wiley/Wrox employee

I just finished doing the Try It Out - DataSet Examples in Chapter 16, and I am getting this error. I searched everywhere to see if anyone else in the world got this error, and I found a handful, so i figured, why not ask the authors for help :)

Here is the error

"An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll

Additional information: System error.
"

When I Debug, It highlights this line:
 'Fill the dataset object with data...
        myDataAdapter.Fill(myDataSet, "authors")

Any help will be very much appreciated, please!

-Jovenal

Whoops, I copied the wrong line of code that was giving me the error.

Here is the line that gets highlighted:

        'Now execute the command...
        myDataAdapter.SelectCommand.ExecuteNonQuery()

Sorry for the confusion.

Hi JovenaL

This sounds like your SQL Select statement is incorrect.
The error you get likely occurs because the name of a table or field
is incorrect.
I have pasted the code from my version of the code. Look for the difference between yours and the code below.


'Start ................

  objDataAdapter.SelectCommand.CommandText = _
            "SELECT au_lname, au_fname, title, price " & _
            "FROM authors " & _
            "JOIN titleauthor ON authors.au_id = titleauthor.au_id " & _
            "JOIN titles ON titleauthor.title_id = titles.title_id " & _
            "ORDER BY au_lname, au_fname"
        objDataAdapter.SelectCommand.CommandType = CommandType.Text


'end ..............

I think its very likely that it is an error caused by a typo.

Please Let me know if this is the case.




Jonathan Crossland
http://www.jonathancrossland.com

Doh.....i forgot an underscore hahah
THanks for the quick reply...

question.
I need to make a function that deletes a row from an existing SQL Server 2000 Database.
I know I need to implement an SQL DataAdapter, as well as New Dataset.
My syntax for the SQL is correct, but I am getting the same error I got with my first question.

Error on this line
myDataAdapter.SelectCommand.ExecuteNonQuery()

Please help!

If you have SQL tools, it may be helpful to write your sql in Query Analyzer. Then you will be sure that the statement works.

Then when you put the statement into your code, you will know whether the error is in the syntax of your SQL or in your code.

I suspect, that you have another tpyo :)
Assuming of course that the code is right.

After checking your syntax, if you are still getting the error, post the bit of source code up here so that I can see it. It will help in trying to help you get round this problem.




Jonathan Crossland
http://www.jonathancrossland.com