how to use stored procedure in a asp.net

[sridhar21]

Hai to all

i am sridhar


i have one doubt

how to use stored procedure in a asp.net

wait for your reply

[shweta123]

Hi,

This is the example of how you can call the procedure-
Lets say procedure is Proc1(p1 nvarchar(50),p2 int out)

Dim con as New OleDb.OleDbConnection
Dim com As New OleDb.OleDbCommand

con.ConnectionString="SQLOLEDB.1;Persist Security Info=True;User ..........."

con.open


'Declare the parameters
Dim pin As New OleDb.OleDbParameter 'Input Parameter
Dim pout As New OleDb.OleDbParameter 'Output Parameter

pin.Direction = ParameterDirection.Input
pin.ParameterName = "p1"
pin.Size = 50
pin.DbType = DbType.String

pout.Direction = ParameterDirection.Output
pout.ParameterName = "p2"
pout.DbType = DbType.Int32

com.Parameters.Add(pin)
com.Parameters.Add(pout)

com.CommandType = CommandType.StoredProcedure

'Here give the procedure Name
com.CommandText = "Proc1"
com.ExecuteNonQuery()

'Get the value from pout as pout.Value

Shweta