Access读取报错,普通窗体就ok,但Mdi子窗体就报错 conn.Open("", "", "", -1); *****未指定的错误****我在普通窗体中使用就没问题,在Mdi子窗体里面就报错了,但有时候又能成功运行,晕死~~~ public Table query(string tableName,string sqlStr) //tableName 数据库名 ,sqlStr sql语句。
{
string tempConnStr = connStr + "\\" + tableName; //路径
ADODB.Connection conn = new ADODB.Connection();
ADODB.Command command = new ADODB.Command(); conn.ConnectionString = tempConnStr; conn.Mode = ADODB.ConnectModeEnum.adModeRead;
conn.Open("", "", "", -1); command.let_ActiveConnection(conn);
command.CommandType = ADODB.CommandTypeEnum.adCmdText;
command.CommandText = sqlStr; Table table = new Table();
table.Command = command; return table;
}
{
string tempConnStr = connStr + "\\" + tableName; //路径
ADODB.Connection conn = new ADODB.Connection();
ADODB.Command command = new ADODB.Command(); conn.ConnectionString = tempConnStr; conn.Mode = ADODB.ConnectModeEnum.adModeRead;
conn.Open("", "", "", -1); command.let_ActiveConnection(conn);
command.CommandType = ADODB.CommandTypeEnum.adCmdText;
command.CommandText = sqlStr; Table table = new Table();
table.Command = command; return table;
}
public Table query(string tableName,string sqlStr) //tableName 数据库名 ,sqlStr sql语句。
{
string tempConnStr = connStr + "\\" + tableName; //路径
ADODB.Connection conn = new ADODB.Connection();
ADODB.Command command = new ADODB.Command(); conn.ConnectionString = tempConnStr; conn.Mode = ADODB.ConnectModeEnum.adModeRead;
conn.Open("", "", "", -1); command.let_ActiveConnection(conn);
command.CommandType = ADODB.CommandTypeEnum.adCmdText;
command.CommandText = sqlStr; Table table = new Table();
table.Command = command; return table;
}