Sample code for Connecting and Executing a stored procedure is SQL server using ASP.NET

Dear All,

Can you one give me some sample code for connecting to the SQL server DB and
executing a stored procedure in the SQL server using ASP.NET ?

I also need to display the result set in the datagrid. Can anyone help me
out with a sample code ?

Thanks and Regards,

Peri


.

Relevant Pages

  • Re: Need general guidance about deployent and database access
    ... I have no doubt the data structure could be replicated ... B> that would allow the program to create either a SQL Server or Access ... B> with Dot Net program deployment. ... B> this and does anyone have any advice or sample code they'd like to ...
    (microsoft.public.dotnet.framework)
  • RE: Replication Problem
    ... I have now changed the sample code once more a little bid in that way: ... A call to SQL Server Reconciler failed. ... Source: Merge Replication Provider ... doc-file and in the quoted url at the top of my posting. ...
    (microsoft.public.sqlserver.replication)
  • Re: Output Parameter To Global Variable (DTS)
    ... >article and used the dummy code. ... >end of the stored procedure thereby having the SP return a result set. ... Sorry, I am at a loss, as the sample code I posted previously works fine ... DTS - http://www.sqldts.com PASS - the definitive, global community for SQL Server professionals ...
    (microsoft.public.sqlserver.dts)
  • Re: Replication problems
    ... I have now changed the sample code once more a little bid in that way: ... A call to SQL Server Reconciler failed. ... Source: Merge Replication Provider ... doc-file and in the quoted url at the top of my posting. ...
    (microsoft.public.sqlserver.ce)
  • Re: DTS Package Object
    ... to run the object to perform this operation" Occurs When You Run a DTS ... Package in Microsoft Visual Basic Code ... There some sample code that uses events here, ... Is SQL Server installed on your local machine? ...
    (microsoft.public.sqlserver.dts)