public static UserTest GetUserByLoginName(string name)
{
string sql = "SELECT * FROM nt_user WHERE name = @name"; try
{
SqlDataReader reader = DBconn.GetReader(sql, new SqlParameter("@name", name));
if (reader.Read())
{
UserTest user = new UserTest(); user.Id = (int)reader["id"];
user.Name = (string)reader["name"];
user.Password= (string)reader["password"];
reader.Close();
return user;
}
else
{
reader.Close();
return null;
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return null;
}
}我查寻不到值,是不是不能这样用????急
求一条查询语句
{
string sql = "SELECT * FROM nt_user WHERE name = @name"; try
{
SqlDataReader reader = DBconn.GetReader(sql, new SqlParameter("@name", name));
if (reader.Read())
{
UserTest user = new UserTest(); user.Id = (int)reader["id"];
user.Name = (string)reader["name"];
user.Password= (string)reader["password"];
reader.Close();
return user;
}
else
{
reader.Close();
return null;
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return null;
}
}我查寻不到值,是不是不能这样用????急
求一条查询语句
修改成 v_name看看
string sql = "SELECT * FROM nt_user WHERE name = @name"; 能查到数据
第二
string sql = "SELECT id,name,password FROM nt_user WHERE name = @name";
while (reader.Read())
第三 你的传参数语句对不对 测试下
SqlDataReader reader = DBconn.GetReader(sql, new SqlParameter("@name", name));
在 MySql.Data.MySqlClient.PacketReader.ReadHeader()
在 MySql.Data.MySqlClient.PacketReader.OpenPacket()
在 MySql.Data.MySqlClient.NativeDriver.Open()
在 MySql.Data.MySqlClient.Driver.Create(MySqlConnectionString settings)
在 MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
在 MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
在 MySql.Data.MySqlClient.MySqlPool.GetConnection()
在 MySql.Data.MySqlClient.MySqlPoolManager.GetConnection(MySqlConnectionString settings)
在 MySql.Data.MySqlClient.MySqlConnection.Open()
在 DAL.DBconn.get_Conn() 位置 E:\GeZiWang\WebSite\DAL\DBconn.cs:行号 31
在 DAL.DBconn.GetReader(String sql, SqlParameter[] values) 位置 E:\GeZiWang\WebSite\DAL\DBconn.cs:行号 96
在 DAL.UserTestService.GetUserByLoginName(String name) 位置 E:\GeZiWang\WebSite\DAL\UserTestService.cs:行号 56}
???这是什么错???如何解决...
{
SqlDataReader reader = DBconn.GetReader(sql, new SqlParameter("@name", name));
reader 没有值....不知哪里出错,数据库链接显示已经打开...(测试也通过了)
{
MySqlDataReader reader = DBconn.GetReader(sql, new MySqlParameter("@name",name));
if (reader.Read())
{
改成
string sql = "SELECT * FROM nt_user WHERE name = ?name";
{
MySqlCommand cmd = new MySqlCommand(sql, Conn);
cmd.Parameters.AddRange(values);
MySqlDataReader reader = cmd.ExecuteReader();
return reader;
}不好意思....请指教
SQL Server中用 @
MySQL中用 ?
Oracel中用 :
SQLite中用: @