大家给点资料,这是存储过程,我怎么在c#中使用它呢?
CREATE PROCEDURE dbo.sel
(--@dept_ID int,
@name_ID char(10),
@psw_ID char(10))
AS
begin
declare @dept_ID int
set @dept_ID=1
begin tran
begin
select * from login_db
set @dept_ID=@dept_ID+1
end
if @@error<>0
begin
rollback tran
end
else
commit tran
end
GO
CREATE PROCEDURE dbo.sel
(--@dept_ID int,
@name_ID char(10),
@psw_ID char(10))
AS
begin
declare @dept_ID int
set @dept_ID=1
begin tran
begin
select * from login_db
set @dept_ID=@dept_ID+1
end
if @@error<>0
begin
rollback tran
end
else
commit tran
end
GO
Dim Connstring As New SqlClient.SqlConnection(strConnection)
Connstring.Open()Dim objCmd As New SqlCommand("dbo.GCCSP_ADDNEW_PAT_DEMO", Connstring)
With objCmd
.CommandType = CommandType.StoredProcedure
.Parameters.Add("@PAT_NRIC", Trim(txtNRIC.Text))
.Parameters.Add("@PAT_ALT_ID", Trim(txtAlterNateId.Text))
.Parameters.Add("@PAT_FIRST_NAME", Trim(txtFirstName.Text))
.Parameters.Add("@RETURNVALUE", SqlDbType.Int)
.Parameters("@RETURNVALUE").Direction = ParameterDirection.Output
.ExecuteNonQuery()
End With
iReturnPatientId = (objCmd.Parameters("@RETURNPAT_ID").Value)
iRetVal = (objCmd.Parameters("@RETURNVALUE").Value)
Connstring.Close()
objCmd = Nothing
cmd.CommandType=CommandType.StoredProcedure;
cmd.Parameters.Add("@PAT_NRIC",txtNRIC.Text.Trim());
Try
{
conn.open();
cmd.ExecuteNonQuery();
}
catch
{}
finally
{
conn.close();
}