我应该如何以实际有效的方式写这个？ [英] How should I write this in a way that actually works?

问题描述

string query =（" SELECT * FROM wp_users WHERE user_login ='{user}'和user_pass ='{pass}';"）;

string query = ("SELECT * FROM wp_users WHERE user_login='{user}' and user_pass= '{pass}';");

推荐答案

你好泰勒，

           与
sql 数据库进行通信：//www.tutlane.com/tutorial/csharp"title ="学习C＃">
c＃您需要编写如下所示的代码。

           To communicate with sql database from c# you need write a code like as shown below.

DataSet ds = new DataSet();
using (SqlConnection con = new SqlConnection("Data Source=Suresh;Integrated Security=true;Initial Catalog=MySampleDB"))
{
con.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM wp_users WHERE user_login=@uname and user_pass= @upwd;", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
cmd.Parameters.AddWithValue("@uname", username);
cmd.Parameters.AddWithValue("@upwd", password);
DataTable dt = new DataTable();
da.Fill(dt);
con.Close();

gvDetails.DataSource = dt;
gvDetails.DataBind();
}
}

在这里，我在
c＃与数据库进行通信。

Here, i mentioned simple ADO.NET technique in c# to communicate with database.

这篇关于我应该如何以实际有效的方式写这个？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！