改了改代码,还是报错
public DataView ShowSelected(String strName)
{
OleDbConnection myConnection = new OleDbConnection(_connStr);
String strInsert = "Insert into Co (Name) VALUES (" + strName + ")";
OleDbDataAdapter myCommand = new OleDbDataAdapter ("select * from Co", myConnection); OleDbCommand myInsert = new OleDbCommand(strInsert, myConnection); myInsert.Connection.Open();
myInsert.ExecuteNonQuery();
myInsert.Connection.Close(); DataSet ds = new DataSet();
myCommand.Fill(ds, "AccessTest");
return ds.Tables["AccessTest"].DefaultView;
}报错信息:
异常详细信息: System.Data.OleDb.OleDbException: 至少一个参数没有被指定值。源错误:
行 64:
行 65: myInsert.Connection.Open();
行 66: myInsert.ExecuteNonQuery();
行 67: myInsert.Connection.Close();
行 68:
源文件: d:\inetpub\wwwroot\demoaccess\datalayer.cs 行: 66
public DataView ShowSelected(String strName)
{
OleDbConnection myConnection = new OleDbConnection(_connStr);
String strInsert = "Insert into Co (Name) VALUES (" + strName + ")";
OleDbDataAdapter myCommand = new OleDbDataAdapter ("select * from Co", myConnection); OleDbCommand myInsert = new OleDbCommand(strInsert, myConnection); myInsert.Connection.Open();
myInsert.ExecuteNonQuery();
myInsert.Connection.Close(); DataSet ds = new DataSet();
myCommand.Fill(ds, "AccessTest");
return ds.Tables["AccessTest"].DefaultView;
}报错信息:
异常详细信息: System.Data.OleDb.OleDbException: 至少一个参数没有被指定值。源错误:
行 64:
行 65: myInsert.Connection.Open();
行 66: myInsert.ExecuteNonQuery();
行 67: myInsert.Connection.Close();
行 68:
源文件: d:\inetpub\wwwroot\demoaccess\datalayer.cs 行: 66
String SqlCon=ConStr.SQLCon;
SqlConnection objConnect = new SqlConnection(SqlCon);
SqlCommand objCommand = new SqlCommand(strSql,objConnect);
objConnect.Open();
objCommand.ExecuteNonQuery();