62,268
社区成员
发帖
与我相关
我的任务
分享
protected void btnLogin_Click(object sender, EventArgs e)
{
string name = txtMemberName.Text;
string password = txtPassword.Text;
string connstr = ConfigurationSettings.AppSettings["databaseconn"];
SqlConnection conn = new SqlConnection(connstr);
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT COUNT(*) FROM Member WHERE name=@vname AND password=@vpassword";
cmd.Parameters.Add("@vname", SqlDbType.Char);
cmd.Parameters["@vname"].Value = name;
cmd.Parameters.Add("@vpassword", SqlDbType.Char);
cmd.Parameters["@vpassword"].Value = password;
try
{
conn.Open();
int count = 0;
count = (int)cmd.ExecuteScalar();
if (count != 0)
{
//是本站用户,则进入到浏览界面
Response.Write("<script>alert('是本站用户!')</script>");
Response.Redirect("\\Browse\\AllInformation.aspx");
}
else
{
//不是进入注册用户界面
Response.Write("<script>('不是本章用户 ,请注册!')</scrt>");
Response.Redirect("\\MemberRegister.aspx");
}
}
catch (Exception exp)
{
Response.Write("<script>alert('数据库连接异常')</script>");
Response.Write(exp.ToString());
}
finally
{
conn.Dispose();
}
}
}(1)insert into Member(m_id,password,company,memberType,comPerson,mobilephone,telephone,email,address,postmail,question,answer,remark,name)"+
"values(@vm_id,@vpassword,@vcompany,@vmemberType,@vcomPerson,@vmobilephone,@vtelephone,@vemail,@vaddress,@vpostmail,@vquestion,@vanswer,@vrmark,@vname)
//查找记录
(2)select * from student;
//更新记录
(3)update student set sno=@sno_p,name=@name_p where id=@id_p;
(4)删除记录,
delete from student where id=@id_p;