asp.net 登陆问题

来源：百度知道 编辑：UC知道 时间：2024/06/06 08:58:03
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Collections;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page
{
private SqlConnection conn;
private SqlCommand cmd;
private string strsql="server=.;database=loginFrom;uid=;";

protected void Page_Load(object sender, EventArgs e)
{
conn = new SqlConnection(strsql);

}
protected void btnLogin_Click(object sender, EventArgs e)
{

string sql = "select usename,pwd from loginFrom where usename="+txtName.Text+" or pwd="+txtPwd.Text+" ";
cmd = new SqlCommand(sql, conn);
c

public DataTable getRecord(string strSQL)
{
SqlConnection SqlConn = new SqlConnection(StrConn);
SqlConn.Open();
SqlDataAdapter Sqlda = new SqlDataAdapter(strSQL, SqlConn);
DataTable datatable = new DataTable();
Sqlda.Fill(datatable);
SqlConn.Close();
return datatable;
}
public bool Is_yn() {
DataTable data = sqldh.getRecord("select usename,pwd from loginFrom where usename='"+ txtName.Text.Trim() +"' and pwd = '"+ txtPwd.Text.Trim() +"'");
if (data.Rows.Count > 0)
{
return true;
}
else
{
return false;
}
}

tring sql = "select usename,pwd from loginFrom where usename="+txtName.Text.Tostring()+" and pwd="+txtPwd.Text.Tostring()+" ";