/// <summary>

/// 数据操作

/// </summary>

/// <param name="fileName"></param>

/// <param name="savePath"></param>

private void DataOperator(string fileName, string savePath)

{

string myString = "Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = " + savePath + fileName + ";Extended Properties='Excel 8.0;HDR=False;IMEX=1'";

OleDbConnection oconn = new OleDbConnection(myString);

oconn.Open();

DataSet ds = new DataSet();

OleDbDataAdapter oda = new OleDbDataAdapter("select * from [Sheet1$]", oconn);

oda.Fill(ds);

oconn.Close();

DataSetOperator(ds, savePath + fileName);

}

/// <summary>

/// 数据集操作

/// </summary>

/// <param name="ds"></param>

private void DataSetOperator(DataSet ds, string filePath)

{

string sqlStr = "";

int k = 0;

try

{

for (int i = 0; i < ds.Tables[0].Rows.Count; i++)

{

 

try

{

k++;

}

catch

{

continue;

}

}

}

catch (Exception ex)

{

// Response.Write("发生异常,数据已回滚/n信息/n" + ex.Message);

}

finally

{

Response.Write(sqlStr + "共转换" + k + "条");

}

}

#endregion