怎么让登陆成功加1？？？

[zcw199043]

登陆代码
if (RadioButton2.Checked)
{

SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=b;Integrated Security=True");
conn.Open();
string sql = "select name,pwd from stu";
SqlCommand com = new SqlCommand(sql, conn);
SqlDataReader dr = com.ExecuteReader();
dr.Read();
if (dr.HasRows)
{
Response.Write("dengluchenggong");
}
}

[xiaoaldawn]

我觉得可以 写个存储过程

[zcw199043]

写在哪里？if (dr.HasRows) 这个里面？

[hu_qian]

[Quote=引用 1 楼 xiaoaldawn 的回复:]
我觉得可以 写个存储过程
[/Quote]

+1

[champagne_bin]

哪里加1啊？

[newdigitime]

  if (dr.HasRows)
  {
  dr.Close();
  sql = "update tb set num=num+1";
  com.CommandText=sql;
  com.ExecuteNonQuery();
  Response.Write("dengluchenggong");
  }

[huangwenquan123]

create proc Login
(
  @uname varchar(50),
  @pwd varchar(30)
)
declare @count int
set @count = (select count(1) from table where username=@uname and password=@pwd)
if(@count>0)
   begin
       update table set logincount=logincount+1 where username=@uname
       return 1
   end
else
   return -1

[zcw199043]

[Quote=引用 5 楼 newdigitime 的回复:]
C# code

if (dr.HasRows)
{
dr.Close();
sql = "update tb set num=num+1";
com.CommandText=sql;
com.ExecuteNonQuery();
Response.Write("dengluchenggong");
}
[/Quote]



这个可以，谢谢