DAL(Data Access Layer)

Question

Hii,

 

I am very new to ASP.NET. I followed the instructions given here https://msdn.microsoft.com/en-us/library/aa581778.aspx

 

I was able to create Typed data sets and table Adapter, but when I moved to the next step of displaying the information it shows multiple errors in the .cs file. Th errors are highlighted in the ss below. Any help would be appreciated.

 

 

 

Answer 1

what is the access modifier of your GetProducts() method? Make sure it's public and not protected.

Answer 2

I re did it. All is ok but it shows error for GridView1.DataSource = productsAdapter.GetProducts();

 

It says GetProducts () is not accessible. I have added the method GetProducts () in TypedDataset but it doesn't work.

Answer 3

You may need to recreate your web form again and grab a new GridView control from the toolbox. This could sometimes happen if you directly copy and pasted codes/html in your code behind in which the designer cannot register the controls for you. 

 

So try generate back your page and then step back through the article you referred. 

Answer 4

Yes I did use the ID GridView1 in aspx.cs but still it's showing the same error . Also I did what u suggested but now the method GetProducts() shows error and says it is not accessible due to protection level.

Answer 5

In the first error make sure that you have a GridView control in your ASPX.CS file with ID "GridView1"

 

In your second error make sure that you declare the namespace where the ProductTableAdapter class was defined. Or simply use the fully qualified name like NameSpaceName.ProductTableAdapater

Answer 6

Thank you for answering. The errors are:

 

The name GridView1 doesn't contain in the current context. And ProductTableAdapter is missing a namespace.

Answer 7

What's the actual error you get?

 

Typed DataSets are kinda obsolete and since you are new to ASP.NET I would suggest you to take a look at Entity Framework instead as your Data Access mechanism.

 

http://geekswithblogs.net/dotNETvinz/archive/2011/04/04/entity-framework----inserting-data-to-database.aspx 

 

And if I may add. Start learning MVC instead of WebForms :)