删除excel表中指定的一行
//读取excel表中一个值,然后在dbf表中查询,如果在dbf表中不存在这个值,就把excel表中这一行删除
for (int excelRow = excel开始行; excelRow < excel总行; ++excelRow)
{
string excelData = myExcelDataSet.Tables["[Sheet1$]"].Rows[excelRow][Excel列].ToString();//读取excel表一个值
//在dbf表中核对
OleDbConnection conn = new OleDbConnection(@"Provider=vfpoledb;Data Source=" + Text.ToString() + ";Extended Properties=dBASW IV;User ID=;Password=");
conn.Open();
System.Data.OleDb.OleDbCommand cmd = new OleDbCommand("select * from '" + Text.ToString() + "' where " + DBFDN1 + "='" + excelData + "'", conn);
OleDbDataReader dr = cmd.ExecuteReader();
if (dr.HasRows == false)
{
从excel表中excelRow这一行数据删除
}
}
如何删除,请大侠们详细指点,谢谢!