Question

access数据库 用C#如何根据一个字段的值获取到另一个字段的值

Answer 1

object o=null;
using (OleDbConnection con = new OleDbConnection(connectionStr))
{
string query = string.Format("select top 1 STUname from form1 where username = '{0}',username);

using(OleDbCommand cmd = new OleDbCommand(query,con)
{
con.Open();
object o = cmd.ExecuteScalar();//根据你的STUname
数据类型，再将 o 转换成相应的类型，比如 是字符串 就可以 string s = o.ToString();

}