static void Main()
{
//String sqltext = "select id, sex name from memcard";
// DataSet ds = ExecuteQuery(sqltext);
//testExport(ds, "c:/mem.xls");
ExcalHelper obj = new ExcalHelper(4);
DataTable _data = obj.ImportExcelFile("c:/mem.xls");
_data.TableName = "memcard";
if (_data != null && _data.Rows.Count > 0)
{
SqlBulkCopy bcp = new SqlBulkCopy("server=sql.w3249.vhostgo.com;database=vipsoft;uid=vipsoft;pwd=vip123456");
bcp.DestinationTableName = "memcard";
bcp.WriteToServer(_data);
bcp.Close();
}
}
