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 GOSqlCommand cmd=new SqlCommand("dbo.sel",conn); cmd.CommandType=CommandType.StoredProcedure; cmd.Parameters.Add("@PAT_NRIC",txtNRIC.Text.Trim()); Try { conn.open(); cmd.ExecuteNonQuery(); } catch {} finally { conn.close(); }
(--@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
GOSqlCommand cmd=new SqlCommand("dbo.sel",conn);
cmd.CommandType=CommandType.StoredProcedure;
cmd.Parameters.Add("@PAT_NRIC",txtNRIC.Text.Trim());
Try
{
conn.open();
cmd.ExecuteNonQuery();
}
catch
{}
finally
{
conn.close();
}