reza_majid68
یک شنبه 03 دی 1391, 20:54 عصر
سلام من میخوام صفحه لوگین بسازم و از پروسیجر استفاده کنم ولی جواب نمیده کدم هم اینه :
ALTER procedure [dbo].[tblogin] (@username nvarchar(50) ,@pass nvarchar)
as
begin
select COUNT(*) from login1 where username=@username and pass=@pass
return
end
کد سی شارپ :
int i = 4;
string con = ConfigurationManager.ConnectionStrings["asayesh"].ConnectionString;
SqlConnection cn = new SqlConnection(con);
SqlCommand cm = new SqlCommand();
cm.Connection = cn;
cm.CommandType = CommandType.StoredProcedure;
///// cm.CommandText = "select count(username) from login1 where username=@username and pass=@pass";
cm.CommandText = "tblogin";
cm.Parameters.AddWithValue("@username", RadTextBox1.Text);
cm.Parameters.AddWithValue("@pass", RadTextBox2.Text);
/// cm.Parameters.Add("@adad", sqlDbType: SqlDbType.Int);
cn.Open();
///cm.Parameters["@adad"].Direction = ParameterDirection.Output;
/// cm.ExecuteNonQuery();
/// i= int.Parse(cm.Parameters["@adad"].Value.ToString());
///
Response.Write(i.ToString());
i = (int) cm.ExecuteScalar();
cn.Close();
Response.Write(i.ToString());
if (i == 0)
Response.Write("no");
if (i == 1)
Response.Write("ok");
ALTER procedure [dbo].[tblogin] (@username nvarchar(50) ,@pass nvarchar)
as
begin
select COUNT(*) from login1 where username=@username and pass=@pass
return
end
کد سی شارپ :
int i = 4;
string con = ConfigurationManager.ConnectionStrings["asayesh"].ConnectionString;
SqlConnection cn = new SqlConnection(con);
SqlCommand cm = new SqlCommand();
cm.Connection = cn;
cm.CommandType = CommandType.StoredProcedure;
///// cm.CommandText = "select count(username) from login1 where username=@username and pass=@pass";
cm.CommandText = "tblogin";
cm.Parameters.AddWithValue("@username", RadTextBox1.Text);
cm.Parameters.AddWithValue("@pass", RadTextBox2.Text);
/// cm.Parameters.Add("@adad", sqlDbType: SqlDbType.Int);
cn.Open();
///cm.Parameters["@adad"].Direction = ParameterDirection.Output;
/// cm.ExecuteNonQuery();
/// i= int.Parse(cm.Parameters["@adad"].Value.ToString());
///
Response.Write(i.ToString());
i = (int) cm.ExecuteScalar();
cn.Close();
Response.Write(i.ToString());
if (i == 0)
Response.Write("no");
if (i == 1)
Response.Write("ok");