读写Access数据库的问题?
请问为什么不能把数据写到数据库里,olead_Ad.Update(ds_u8,"UFPrn");这里要出错?
--------------------------------------------------------
string m_strSql="select * from test";
m_strPath = m_strPath + @"\InputFile\U8\U8.mdb";
OleDbConnection oleconn_Conn = new OleDbConnection("PROVIDER=Microsoft.jet.OLEDB.4.0;data source=" + m_strPath);
oleconn_Conn.Open();
OleDbDataAdapter olead_Ad = new OleDbDataAdapter(m_strSql,oleconn_Conn);
DataSet ds_u8 = new DataSet();
olead_Ad.Fill(ds_u8,"UFPrn");
ds_u8.Tables[0].Rows.Clear();
DataRow dr;
dr = ds_u8.Tables[0].NewRow();
dr[0] = "资产";
dr[1] = "负债";
dr[2] = "权益";
dr[3] = "成本";
dr[4] = "损益";
ds_u8.Tables[0].Rows.Add(dr);
olead_Ad.Update(ds_u8,"UFPrn");
oleconn_Conn.Close();