很简单的查询

[qinghaoqi]

学了新的，忘了旧的，很简答的执行查询我竟然忘记了

select UserPassword from Users where UserName=@name
就这样的查询执行方法该怎么写。。今天怎么写都有错。。
关键代码贴出就可

[hen_ai_hen_ai_ni]

居然还有问这问题的，这种问题应该baidu，而不是来这发帖子

[避风港]

4楼写的好

[弘白]

用了个SqlHelper类

string sql="select UserPassword from Users where UserName=@name"
SqlParameter[] sp = new SqlParameter[] { 
  new SqlParameter("@UserID",SqlDbType.VarChar),
  new SqlParameter("@Password",SqlDbType.VarChar)
};
sp[0].Value = UserID;
sp[1].Value = Password;

SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sql, sp);
if(dr.Read())
{
....
}

[MSDNXGH]

哦，忘了就忘了

[qinghaoqi]

帮忙看看我写的代码哪儿里有错？谢谢 ：3楼

[qinghaoqi]

[Quote=引用 7 楼 amoon_bool 的回复:]
foreach (DataRow reader in table.Rows)
{
UserPeople users = new UserPeople();
users.UserName = reader["UserName"].ToString();

password = users.UserName;
}


应该加个判断，是不是标题行
[/Quote]
标题行是什么概念，给俺举个例子

[ohkuy]

string name="你要查询的名字";
string sql=select UserPassword from Users where UserName='"+name+"';

[qinghaoqi]

伙计，是执行语句的方法。。。。。。

[qinghaoqi]

string password = "";
string sql = "select UserPassword from Users where UserName=@name";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@name",name)
};
DataTable table = DBHelper.GetDataSet(sql, param);
foreach (DataRow reader in table.Rows)
{
UserPeople users = new UserPeople();
users.UserName = reader["UserName"].ToString();

password = users.UserName;
}

return password;
这个是我写的， 但是他提示UserName不属于表Table

[gdstfox]

SqlCommand cmd = ...略;
cmd.Parameters.AddRange(new SqlParameter[]{
    new System.Data.SqlClient.SqlParameter("@name",SqlDbType.NVarChar)
});
cmd.ExecuteNonQuery();

[kavilee]

private static void ReadOrderData(string connectionString)
{
    string queryString = 
        "SELECT OrderID, CustomerID FROM dbo.Orders;";
    using (SqlConnection connection = new SqlConnection(
               connectionString))
    {
        SqlCommand command = new SqlCommand(
            queryString, connection);
        connection.Open();
        SqlDataReader reader = command.ExecuteReader();
        try
        {
            while (reader.Read())
            {
                Console.WriteLine(String.Format("{0}, {1}",
                    reader[0], reader[1]));
            }
        }
        finally
        {
            // Always call Close when done reading.
            reader.Close();
        }
    }
}

[风之影子]

建议用4楼的参数化写法。

[amoon_bool]

foreach (DataRow reader in table.Rows)
{
UserPeople users = new UserPeople();
users.UserName = reader["UserName"].ToString();

password = users.UserName;
}


应该加个判断，是不是标题行