附:
public static string Username = "";//保存用户登录名,以便以后使用
public static bool loginOrnot;//判断用户是否登录
private string strconn;//查询更新数据库字符
private string connstr = "Data Source=localhost;Initial Catalog=lifeline;Integrated Security=True";//连接数据库字符串
private SqlDataAdapter sqlda;//
private SqlConnection myconn;//数据库连接
private DataTable mytable;//返回的数据表
private DataRow Userrows;//表中的行
public static string Username = "";//保存用户登录名,以便以后使用
public static bool loginOrnot;//判断用户是否登录
private string strconn;//查询更新数据库字符
private string connstr = "Data Source=localhost;Initial Catalog=lifeline;Integrated Security=True";//连接数据库字符串
private SqlDataAdapter sqlda;//
private SqlConnection myconn;//数据库连接
private DataTable mytable;//返回的数据表
private DataRow Userrows;//表中的行
使用SqlDataReader
{
这里有问题
Userrows是行对象
改成:
if (Userrows[0]["列名"].ToString().Trim() == this.User_Name.Text.ToString().Trim()&&
Userrows[1]["列名"].ToString().Trim() == this.Password.Text.ToString().Trim())
strconn = "select * from Login where User_Name=" + this.User_Name.Text.ToString().Trim(); 改为:strconn = "select * from Login where User_Name='" + this.User_Name.Text.ToString().Trim()+"'";