SELECT * INTO newtable FROM OPENDATASOURCE ('Microsoft.Jet.OLEDB.4.0', 'Data Source="c:\DB.mdb";User ID=Admin;Password=' )...表名
//读取到TextBox1 OleDbConnection Conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;User ID='';Password=''Data Source="D:\A.mdb""); Conn.Open(); string sql="select C from B where ID=1" //假设B表中有个编号字段ID OleDbCommand Cmd= new OleDbCommand(sql, Conn); OleDbDataReader Dr=Cmd.ExecuteReader(); if (Dr.Read()) { TextBox1.Text=Dr["C"].ToString(); } Dr.Close(); Conn.Close(); //更新: string update="update B set C='"+TextBox1.Text.Trim()+"' where ID=1"; Conn.Open(); OleDbCommand Cmd1 = new OleDbCommand(update, Conn); Cmd1.ExecuteNonQuery(); Conn.Close();
select * INTO tab_DXPioint from OPENDATASOURCE('MICROSOFT.JET.OLEDB.4.0','d:\MineADS.mdb';'Admin';'','tab_DXPioint') 我这样写form语法错误 SELECT * FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0', 'Data Source="c:\DB.mdb";User ID=Admin;Password=' )...table这样也是from语法错误 着急求高手!!!!
INTO newtable
FROM OPENDATASOURCE ('Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\DB.mdb";User ID=Admin;Password=' )...表名
OleDbConnection Conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;User ID='';Password=''Data Source="D:\A.mdb"");
Conn.Open();
string sql="select C from B where ID=1" //假设B表中有个编号字段ID
OleDbCommand Cmd= new OleDbCommand(sql, Conn);
OleDbDataReader Dr=Cmd.ExecuteReader();
if (Dr.Read())
{
TextBox1.Text=Dr["C"].ToString();
}
Dr.Close();
Conn.Close(); //更新:
string update="update B set C='"+TextBox1.Text.Trim()+"' where ID=1";
Conn.Open();
OleDbCommand Cmd1 = new OleDbCommand(update, Conn);
Cmd1.ExecuteNonQuery();
Conn.Close();
我这样写form语法错误
SELECT * FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\DB.mdb";User ID=Admin;Password=' )...table这样也是from语法错误 着急求高手!!!!
不过,你为什么不用oledb呢?