如何按字段名取数据
如何按字段名取数据
部分代码
sql="select nickname,title,addtime,message from message where id="+id;
OleDbConnection myConnection = new OleDbConnection("Provider="+provider+" Data Source="+ Server.MapPath(db));
OleDbCommand myCommand = new OleDbCommand(sql , myConnection);
myConnection.Open();
myReader = myCommand.ExecuteReader();
if (myReader.Read()) {
//主要看这,怎么按字段名取数据啊,按索引不太方便,如果sql改了,还得改这,不太方便啊
title=myReader.GetString(1);
}