It is now 3 months that we are trying to connect ASP.NET to a SQLServer located 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 from either VisualStudio.NET or FrontPage 2003.
Our goal is to retrieve records from SQLServer and display them in ASP.NET pages,edit them,and return them to SQLServer.
Thanx in advance.
Mohammad,
in Server Explorer, register the other sql server. Once it is registered, navigate to a table on this server and drag and drop a small table from this server to an aspx page. This will create a sqldataconnection and sqldataadapter. 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 example you can use against the northwind database to see how it works.
HTH,
Paul Ibison
Showing posts with label act. Show all posts
Showing posts with label act. Show all posts
Friday, February 17, 2012
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
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
Subscribe to:
Posts (Atom)