| Author: Rajaraman 26 Sep 2006 | Member Level: Diamond | Rating:  Points: 2 |
http://databases.aspfaq.com/database/using-stored-procedures.html
http://www.asp101.com/articles/wrox/asp30/26100903.asp
|
| Author: SUBRAMANIAN 26 Sep 2006 | Member Level: Silver | Rating: Points: 2 |
hai Friends
/* I have put some sample coding, I hope this is useful for u*/
imports system.data.sqlclient
Button_Click Event
Dim con as new sqlconnection("data source=sys1;uid=sa;pwd=sql;initial catalog=northwind")
dim da as new sqldataadapter("usp_customers",con)
da.selectcommand.commantype=commandtype.storedprocedure
dim ds as new dataset
da.fill(ds,"DataSetName")
me.datagrid1.datasource=ds
please Run this query in northwind database
use northwind
go
create procedure usp_customers
as
begin
select * from customers
end
|