Dmitry,

>I kind of sort of (with my limited knowledge) thought that Web Service is often used in WinForm.net applications where the application is not on the server. Thanks you for confirming it.

It's not that you *can't* do it from a webform, but it's more like why would you *want* to do it. <g> The only scenario where it would make sense to do this is if the SQL Server is on a totally different network and not available from the server you're currently running on (like maybe you're accessing a SQL Server hosted by another company and they provide web service access to it).

>I will read the tutorial recommended by Dorin that covers creating a DAL for ASP.NET application.

I haven't taken the time to go and look at that tutorial, but Dorin mentioned TableAdapters. As you have seen from several threads in the not too distant past, you want to avoid TableAdapters. They cause more trouble than they're worth, IMHO.

And then see if I can restart my learning of SQL Server stored procedures. I have written one stored procedure about 2 years ago; this is how much experience I have <g>

Awww, they're not that bad. <g>

>Thank you for your 2 cents <g> (actually it is much more though).

You're welcome (and thank *you*).

~~Bonnie