Connecting ASP.NET to SQLServer,Somebody,Please!!

Discussion in 'microsoft.public.sqlserver.connect' started by Mohammad-Reza, Apr 20, 2004.

  1. 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-Reza, Apr 20, 2004
    #1
    1. Advertisements

  2. Mohammad-Reza

    Paul Ibison Guest

    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 sqldataadapter 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 have 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
     
    Paul Ibison, Apr 20, 2004
    #2
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.