Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
C# - Add and Update Records
Message
From
11/04/2008 16:48:10
Timothy Bryan
Sharpline Consultants
Conroe, Texas, United States
 
General information
Forum:
ASP.NET
Category:
Coding, syntax and commands
Miscellaneous
Thread ID:
01309187
Message ID:
01310089
Views:
41
>Ok, I made some progress, but now I have a question.
>
>I created a Typed DataSet and I wrote a simple data access class which returns an instance of the
>data set.
>
>When I look at it in the DataSet Visualizer I see 2 tables - the Typed Dataset and the underlying table.
>The DataSet has no data, but the table does. I'm not sure this is right, and I surely don't understand
>it.
>
>Can you provide some insight?
>

I can tell you what I do. I create a typed Data set TruckDataSet for instance but the table name I created inside there is "Trucks" which matches the table name I am going to fill it with. All the fields I create in there are also a match for type and name as the actual columns in the table.

I put an instance on the form where I need to use the data. My DataAccess Layer in this older app has a general routine where I fill the dataSet passed into it.

So When I call it this way:
DataAccess data = DataAccess.Instance; // I am using a singleton pattern

data.GetAllTrucks(dsTrucks);

The dsTrucks is the name of the dataset I dropped on the form. This way I am passing in the actual dataset I need filled to the data access layer.

Now, I wouldn't do it this way necessarily now because I also have a business layer in the middle. But I think Kevin probably what you are seeing is possibly an issue with the names of the table you added to the DataSet. It needs to match your actual table I think as do the columns.

Try that and see if that is what you see. The layers you will see are a DataSet, a DataTable in there, Rows in the table, and each row will have columns.

See if any of that helps you out.
Tim
Timothy Bryan
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform