Dimitry,
>Hi,
>
>I am beginning a process of moving my ASP.NET application from using VFP database to SQL Server. At this point I want to try a few things to see what I am most comfortable doing. In ASP.NET/VFP I was calling a VFP stored procedure passing an XML. I suppose with SQL Server I can/need to call SQL Server directly.
>
>I want to start with a page that allows user to enter some values in textboxes and drop down lists and the information is added to a table. I have been away from doing ASP.NET work for quite some time (as I was mainly maintaining my application). So now I need to learn from the beginning.
>
>If you know a basic article that covers this topic or are willing to provide conceptual guideline, I would appreciate very much.
I am wondering about where the SQL Server lives compared to where your Web application would live. In other words, would you use a direct connection to the SQL Server on the same network? Another idea to look at is creating a Data Access Web service (WCF Actually) to expose and control the access to the SQL Server. Then your web application becomes more flexible as well. If you were using a framework this might be pretty easy to get setup. I have done this inside of a days work for my current Web Application project with Mere Mortals framework.
Besides this, the other methods are not really that hard. Either way as exposed web service methods or direct connection to SQL I would recommend using Stored Procedures for the data access.
Tim
Timothy Bryan