Connecting ASP.NET to SQLServer,Somebody,Please!

It is now 3 months that we are trying to connect ASP.NET to a SQLServer loca
ted on another system.
However we act,we get a fatal error.
We need someone to explain the way of connecting to SQLServer step by step f
rom either VisualStudio.NET or FrontPage 2003.
Our goal is to retrieve records from SQLServer and display them in ASP.NET p
ages,edit them,and return them to SQLServer.
Thanx in advance.Mohammad,
in Server Explorer, register the other sql server. Once it is registered, na
vigate to a table on this server and drag and drop a small table from this s
erver to an aspx page. This will create a sqldataconnection and sqldataadapt
er. Right-click the sqldata
adapter and select generate dataset. This dataset now needs matching to eg a
datagrid, using the dataadpater.fill method and datagrid.bind method. There
are loads of examples of this type of thing on the net and in books. Which
part in particular do you h
ave problems with? Making the grid editable is more tricky as you'll need to
use command objects. If you email me on my address here, I'll post you an e
xample you can use against the northwind database to see how it works.
HTH,
Paul Ibison