Create and run the stored procedure

Hai to all

I wish to know how to connect the Stored Procedure(SQL Server) with ASP.net.

[QUOTE=sm_amuda;8245]Hai to all

I wish to know how to connect the Stored Procedure(SQL Server) with ASP.net.[/QUOTE]
Please read ADO.NEt book before asking such simple questions...

here are few tutorials that might help...

[url]http://www.exforsys.com/content/category/17/221/266/[/url]

[url]http://www.exforsys.com/content/category/17/270/356/[/url]

[url]http://www.exforsys.com/content/category/17/269/354/[/url]

I am giving an example to use a stored procedure in ASP.NET.
Assume that I have written a SELECT command in a STORED PROCEDURE. By using DataAdapter in ASP.NET I want to display the data from the database table on to the datagrid.
SqlConnection con=new SqlConnection(write servername,database name,uid,pwd);
SqlDataAdapter cmd=new SqlDataAdapter("records",con);
cmd.SelectCommand.CommandType=CommandType.StoredProcedure;
Where "records" is a StoredProcedure.