CANNOT CREATE A DATAROW OBJECT FROM A DATASET OBJECT

brucechess · March 18th, 2009, 12:15 PM

Can some one HELP,

I am working in Chapter 10 of Beginning VB.NET Database Programming. I am calling a function from my business logic layer and it gets a dataset schema and I see that the dataset is not null\nothing. But once I come back to the calling routine and I try to initialize a datarow to the dataset that was just created in the function call it is empty and I get an error because of the the null\nothing object reference, in this case the datarow object here is the code I am using

Code:

[:confused:]
'Get a new Project DataSet
objDataSet = objProjects.GetNewProjectDS()
 
'Initialize a datarow object from the Project DataSet
Dim objDataRow As DataRow =  _
objDataSet.Tables("Project").NewRow

Thearon · March 20th, 2009, 06:29 AM

Please check your code against the downloaded code. I ran the project and got no such error. The datarow was properly initialized.

Thearon

brucechess · March 20th, 2009, 10:14 AM

Sorry,

I misspelled the Table Name in the dataset therefore the table was not found in the dataset and the object could not be initialized and I got an error. I was able to track this down by using an IF Block to test for the Table Name in the Dataset. Once I realized it was not there I checked the spelling and found the error. Thanks for your help....