public static MySqlDataReader ceshi()
{
string connString = "server=localhost;User Id=root;database=restaurant";
MySqlConnection conn = new MySqlConnection(connString);
string sql = "Select state from desk where _index=5";
conn.Open();
MySqlCommand command = new MySqlCommand(sql, conn);
MySqlDataReader dr;
dr = command.ExecuteReader(CommandBehavior.Default);
conn.Close();
return dr;
}如上代码,查询返回的是一个对象,如果我查询的到一个值,并把值放进textBox中显示,该如何做?
返回的是第一行的数据 转个类型就行了