strExcel = "select * from [Recovered_Sheet1$]";
myCommand = new OleDbDataAdapter(strExcel, strConn);
ds = new DataSet();
myCommand.Fill(ds);
return ds;
}
/// <summary>
/// 写入Excel文档
/// </summary>
/// <param name="Path">文件名称</param>
//public bool SaveFP2toExcel(string Path)
//{
// try
// {
// string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + Path + ";" + "Extended Properties=Excel 8.0;";
// OleDbConnection conn = new OleDbConnection(strConn);
// conn.Open();
// System.Data.OleDb.OleDbCommand cmd = new OleDbCommand();
// cmd.Connection = conn;
// //cmd.CommandText ="UPDATE [sheet1$] SET 姓名='2005-01-01' WHERE 工号='日期'";
// //cmd.ExecuteNonQuery ();
// for (int i = 0; i < fp2.Sheets[0].RowCount - 1; i++)
// {
// if (fp2.Sheets[0].Cells[i, 0].Text != "")
// {
// cmd.CommandText = "INSERT INTO [sheet1$] (工号,姓名,部门,职务,日期,时间) VALUES('" + fp2.Sheets[0].Cells[i, 0].Text + "','" +
// fp2.Sheets[0].Cells[i, 1].Text + "','" + fp2.Sheets[0].Cells[i, 2].Text + "','" + fp2.Sheets[0].Cells[i, 3].Text +
上一篇:最详细的SQL注入相关的命令整理
下一篇:怎样将Excel中的数据导入到SQLServer2000数据库中
|
精品推荐