c#读取access数据库
ascap 2009-11-18 04:39:22 代码如下:
OleDbDataAdapter da = new OleDbDataAdapter("Select * from Grade", objConnection);
DataSet ds = new DataSet();
DataTable myDataTable = ds.Tables["Grade"];
da.Fill(ds,"Grade");
foreach (DataRow myDataRow in myDataTable.Rows)
{
Console.WriteLine("Name = " + myDataRow["name"]);
Console.WriteLine("Sex = " + myDataRow["sex"]);
Console.WriteLine("Remark = " + myDataRow["remark"]);
Console.WriteLine("Grade = " + myDataRow["grade"]);
}
以上语句在执行到foreach的时候出了一个异常,说是Object reference not set to an instance of an object.出错的代码是myDtaTable.Rows.
烦请高人指点!