*salah eddine bekhouche*

This was great and to the point.  Would you be willing to make something like this that shows how to create and use datasets that involve more than one (preferrably 3 or more) table with relationships.  Also, would you be able to address whether it is worth using a dataset for an entire Database, or a different dataset for each table or relationship aspect, etc.

I always see everyone creating one table examples, but nobody seems to address multiple tables with relationships.  It would be a great help to many I'm sure.

Thanks again for all you do!  I'm a big fan of your videos.

Thank you

Thanks... and really looking forward to more on this series - probably a huge series like the one u have on Ajax. :)

But what if I extracted only one record and I want to save its attributes in variables..

thanks again

Scenario: I am using ASP .Net 3.5, I made up Form, where I have Textbox (txtDeptID and txtDeptName) and I have Table Department in Department Table I have two fields (DeptID and DeptName).. Now I want to Connect txtDeptID and txtDeptName and perform simple operation Add Record, Delete Record, Update Record

help will be appreciable

Regard

yamu

I always enjoy your tutorials, thanks, I looked at your data access (the 3 videos), scott's tutorial on Data Access (<a rel="nofollow" target="_new" href="http://www.asp.net/learn/data-access">www.asp.net/.../data-access</a>) and LINQ video tutorials (<a rel="nofollow" target="_new" href="http://www.asp.net/learn/linq-videos">www.asp.net/.../linq-videos</a>). It seems that there are many ways to achieve data access, and this is good, but some times you need to know which fits better, why would I use LINQ to SQL data models, or why to use strongly typed data sets, there is also (still in work) Dynamic data, we need to know how to build an ARCHITECTURE.

I am now looking at Enterprise Library and just trying to decide if this is good for me, or should I go to strongly typed data sets and custom BLL or the mighty LINQ.

Regards,

Nader