CREATE PROCEDURE ErrorHandler
@ErrorCode INT OUTPUT,
@name varchar,
@password varchar
AS
SELECT
name,
password
FROM
tblSignup
WHERE
(name = @name and password=@password)
IF @@ERROR <> 0
SET @ErrorCode = @@ERROR
ELSE
IF @@ROWCOUNT <> 0
SET @ErrorCode = -1
GO
در متن برنامه تغییرات اعمال شد اما...
private void Button2_Click(object sender, System.EventArgs e)
{
string name = "";
//SqlConnection sqlConnection = new SqlConnection(ConfigurationSettings.AppSetting s["ConnectionString"]);
SqlConnection s=new SqlConnection("Server=(local);uid=sa;p wd=;database=AQCh08");
s.Open();
try
{
SqlParameter param;
SqlCommand cmd = new SqlCommand("ErrorHandler", s);
cmd.CommandType = CommandType.StoredProcedure;
param = cmd.Parameters.Add("@ErrorCode", SqlDbType.Int);
param.Direction = ParameterDirection.Output;
param = cmd.Parameters.Add("@name", SqlDbType.Int);
//param= cmd.Parameters.Add("@password",SqlDbType.Int&# 41;;
param.Value = name.ToString();
SqlDataReader reader = cmd.ExecuteReader();
int errorCode = (int) cmd.Parameters["@ErrorCode"].Value;
//DisplayResults();
}
finally
{
s.Dispose();
}
}