Question

因此,仅仅简单地简单地简单地简单地简单地简单地看着编号和ql数据库,我建立了一个数据库,其表格有两栏,一栏是用户名称,一栏是密码,我想知道,如何看用户名上下哪一行,并找到相应的密码(左边的人物),以便我可以比较一个日像页。

Answer 1

This is a question that is going to take you doing a bit of research. There are a plethora of tutorials on the internet on how to access data. Below I ve included one way that you can return a single value for you to get started with. You ll need to include System.Data.SqlClient.

// See http://www.connectionstrings.com/ for how to build your connection string
SqlConnection sqlConnection1 = new SqlConnection("Your Connection String");
SqlCommand cmd = new SqlCommand();
Object returnValue;

cmd.CommandText = "SELECT COUNT(*) FROM Customers";
cmd.CommandType = CommandType.Text;
cmd.Connection = sqlConnection1;

sqlConnection1.Open();

returnValue = cmd.ExecuteScalar();

sqlConnection1.Close();

我从

Answer 2

错误做法。收集用户名称和密码,看看数据库是否有对应数据。

How to do it in C#? I like LINQ to SQL, even thought Microsoft recommends otherwise. Create a LINQ to SQL classes object in a C# project, call it MyContextClass, drop your database objects onto it. Then, in your code behind, write something like:

using (MyContextClass ctx = new MyContextClass) {
    if (ctx.SingleOrDefault(f => f.Username == txtUsername.Text && f.Password == txtPassword.Text) != null) {
        // The user got it right.
    }
}

然而,上述评论意见中储存密码的所有警告确实适用。将这些内容综合起来,留给用户使用。

友情链接