ADO.NET菜鸟请你帮忙

[xiaoshi21]

string strCon ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\xss\\user.mdb";
OleDbConnection myConn=new OleDbConnection(strCon);
string strCom="SELECT * FROM USER";
myConn.Open();
OleDbDataAdapter myCommand=new OleDbDataAdapter(strCom,myConn);


DataSet myDataSet=new DataSet();

myCommand.Fill(myDataSet,"user");<----运行到这出错（库和表的名称都为user）

[bigrongshu]

string strCon ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\xss\\user.mdb";
OleDbConnection myConn=new OleDbConnection(strCon);
string strCom="SELECT * FROM USER";
OleDbDataAdapter myCommand=new OleDbDataAdapter(strCom,myConn);
DataSet myDataSet=new DataSet();
myConn.Open();
myCommand.Fill(myDataSet,"user");

[duebbin]

string strCon ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\xss\\user.mdb";
OleDbConnection myConn=new OleDbConnection(strCon);
string strCom="SELECT * FROM USER";
//
OleDbDataAdapter myda=new OleDbDataAdapter();
myda.TableMappings.Add("Table", "user");
myConn.Open();
//
OleDbCommand myCmd = new OleDbCommand(strCom,myConn);
myCmd.CommandType = CommandType.Text;
myda.SelectCommand = myCmd;
//
DataSet myDataSet=new DataSet();
myda.Fill(myDataSet,"user");
myConn.Close();

[kuailexq2000]

Dim ConnStr As String
Dim Conn As System.Data.OleDb.OleDbConnection
Dim Comd As System.Data.OleDb.OleDbCommand
Dim Adapter As System.Data.OleDb.OleDbDataAdapter
Dim ds As DataSet
Conn = New System.Data.OleDb.OleDbConnection()
Conn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;Initial Catalog=Northwind;Data Source=PC05;User id=sa;password="
Conn.Open()
Comd = New System.Data.OleDb.OleDbCommand("select * from Employees", Conn)
Adapter = New System.Data.OleDb.OleDbDataAdapter()
Adapter.SelectCommand = Comd
ds = New DataSet()
Adapter.Fill(ds, "table")
Me.DataGrid1.DataSource = ds.Tables("table")
我是这样写得可以通过
OleDbDataAdapter myCommand=new OleDbDataAdapter(strCom,myConn);
？？？？？？？？？？///不明白，是不是这里引起的？
myCommand.Fill(myDataSet,"user");<----运行到这出错（库和表的名称都为user）