OleDbConnection myConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=mctest.MDB"); OleDbCommand CMD = myConn.CreateCommand();
CMD.CommandText = "SELECT * FROM Developer";
myConn.Open();
DataSet dtSet = new DataSet();
myCmd.Fill( dtSet, "Developer" );
DataTable dTable = dtSet.Tables["Developer"];
foreach( DataRow dtRow in dTable.Rows )
{
listBox1.Items.Add( "Name:\t" + dtRow["Name"].ToString());
listBox1.Items.Add( "Address:\t" + dtRow["Address"].ToString());
} myConn.Close();
CMD.CommandText = "SELECT * FROM Developer";
myConn.Open();
DataSet dtSet = new DataSet();
myCmd.Fill( dtSet, "Developer" );
DataTable dTable = dtSet.Tables["Developer"];
foreach( DataRow dtRow in dTable.Rows )
{
listBox1.Items.Add( "Name:\t" + dtRow["Name"].ToString());
listBox1.Items.Add( "Address:\t" + dtRow["Address"].ToString());
} myConn.Close();
2、你可以用
Try
myCmd.Fill( dtSet, "Developer" )
catch(e as exception)
trace.writeline(e.tostring)
end try我是用vb.net写的
在输出窗体看到错误信息,帮助你解决问题,如不明白,还可发给我给你看看。
其次,出现的异常是:未处理的“System.Data.OleDb.OleDbException”类型的异常出现在 system.data.dll 中。 在这一行myCmd.Fill( dtSet, "Developer" );
如果是权限的问题,应该怎么改?
{
myConn.Open();
myCmd.Fill( dtSet, "Developer" ); catch(Exception ex)
{
MessageBox.Show(ex.ToString());
}