Question

C#如何读取ACCESS某个数据并显示在文本框？

谁帮我写一句话，可以吗？
让SQL读到的数据显示到文本框，怎么写？

string Conn = "provider=microsoft.jet.oledb.4.0;data source=AutoDesk.mdb";
OleDbConnection myCon = new OleDbConnection(Conn); //连接到数据库
myCon.Open();
string Str = " select [title] as titlex from [Note] where ID=25";
OleDbCommand myCmd = new OleDbCommand(Str, myCon);
myCmd.ExecuteNonQuery();
carserial.Text = Str;
myCon.Close();

Answer 1

参考代码：
String Str = " select [title] as titlex from [Note] where ID=25";
OleDbCommand command = new OleDbCommand(Str);
command.Connection = conn;
OleDbDataReader dr = null;
conn.Open();
dr = command.ExecuteReader();
while (dr.Read())
{
carserial.Text = (dr["carserial"].ToString());

}
conn.Close();