代码如下:
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("Re = " + myDataRow["re"]);
Console.WriteLine("Grade = " + myDataRow["grade"]);
}以上语句在执行到foreach的时候出了一个异常,说是Object reference not set to an instance of an object.出错的代码是myDtaTable.Rows.烦请高人指点!
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("Re = " + myDataRow["re"]);
Console.WriteLine("Grade = " + myDataRow["grade"]);
}以上语句在执行到foreach的时候出了一个异常,说是Object reference not set to an instance of an object.出错的代码是myDtaTable.Rows.烦请高人指点!
da.Fill(ds,"Grade");
DataTable myDataTable = ds.Tables["Grade"];
{
Console.WriteLine("Name = " + myDataTable.Rows["name"]);
Console.WriteLine("Sex = " + myDataTable.Rows["sex"]);
Console.WriteLine("Re = " + myDataTable.Rows["re"]);
Console.WriteLine("Grade = " + myDataTable.Rows["grade"]);
}
lz再试试看。