public void TestInsert()
{
string sql = @"INSERT INTO [PersonInfo$](姓名, 籍贯)
VALUES(@Name, @Home)";
OleDbParameter[] para =
{
new OleDbParameter("@Name", "王五"),
new OleDbParameter("@Home", "绵阳")
};
try
{
int result = ExcelDBHelper.ExecuteCommand(sql, para);
}
catch (Exception ex)
{
string str = ex.ToString();
}
finally
{
}
}
public void TestMethod1()
{
//
// TODO: 在此 添加测试逻辑
//
try
{
string sql = "select * from [PersonInfo$]";
DataSet ds = ExcelDBHelper.GetReader(sql);
if (ds != null && ds.Tables.Count > 0)
{
List <string> list = new List <string>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
string str = dr[0].ToString() + dr[1].ToString();
list.Add(str);
}
}
}
catch (Exception ex)
{
string str = ex.ToString();
}
}