没有合适的资源?快使用搜索试试~ 我知道了~
在Winform中把导入的Excel转成list传入数据库
资源推荐
资源详情
资源评论
private void btn_excel_import_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
List<string> Taskidpasser = new List<string>();
OpenFileDialog import1 = new OpenFileDialog();
if (import1.ShowDialog() == DialogResult.OK)
{
try{
DataTable ExcelTable;
DataTable ExcelTableCargo;
DataTable ExcelTableContainer;
//String[] tableNameCollect = new String[3];
string excelfilename = import1.FileName;
string tableName,tableNameCargo,tableNameContainer;
DataSet ds = new DataSet();
//Excel的连接
using (OleDbConnection objConn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + excelfilename + ";" + "Extended Properties='Excel 8.0';"))
{
objConn.Open();
DataTable excelTable = objConn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, null);
tableName = "任务信息$";
tableNameCargo = "任务货物信息$";
tableNameContainer = "任务容器信息$";
string strSql = "select * from [" + tableName + "]";
string strSqlCargo = "select * from [" + tableNameCargo + "]";
string strSqlContainer = "select * from [" + tableNameContainer + "]";
OleDbCommand objCmd = new OleDbCommand(strSql, objConn);
OleDbCommand objCmdCargo = new OleDbCommand(strSqlCargo, objConn);
{
List<string> Taskidpasser = new List<string>();
OpenFileDialog import1 = new OpenFileDialog();
if (import1.ShowDialog() == DialogResult.OK)
{
try{
DataTable ExcelTable;
DataTable ExcelTableCargo;
DataTable ExcelTableContainer;
//String[] tableNameCollect = new String[3];
string excelfilename = import1.FileName;
string tableName,tableNameCargo,tableNameContainer;
DataSet ds = new DataSet();
//Excel的连接
using (OleDbConnection objConn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + excelfilename + ";" + "Extended Properties='Excel 8.0';"))
{
objConn.Open();
DataTable excelTable = objConn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, null);
tableName = "任务信息$";
tableNameCargo = "任务货物信息$";
tableNameContainer = "任务容器信息$";
string strSql = "select * from [" + tableName + "]";
string strSqlCargo = "select * from [" + tableNameCargo + "]";
string strSqlContainer = "select * from [" + tableNameContainer + "]";
OleDbCommand objCmd = new OleDbCommand(strSql, objConn);
OleDbCommand objCmdCargo = new OleDbCommand(strSqlCargo, objConn);
OleDbCommand objCmdContainer = new OleDbCommand(strSqlContainer, objConn);
OleDbDataAdapter myData = new OleDbDataAdapter(strSql, objConn);
OleDbDataAdapter myDataCargo = new OleDbDataAdapter(strSqlCargo, objConn);
OleDbDataAdapter myDataContainer = new OleDbDataAdapter(strSqlContainer, objConn);
myData.Fill(ds, tableName);//填充数据
myDataCargo.Fill(ds, tableNameCargo);
myDataContainer.Fill(ds, tableNameContainer);
ExcelTable = ds.Tables[tableName];
ExcelTableCargo = ds.Tables[tableNameCargo];
ExcelTableContainer = ds.Tables[tableNameContainer];
int iColums = ExcelTable.Columns.Count;//列数
int iRows = ExcelTable.Rows.Count;//行数
if (iRows == 0)
MessageBox.Show("Excel任务表中没有数据!", "提示:", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
else
this.getuser(ExcelTable,Taskidpasser);
int iColumsCargo = ExcelTableCargo.Columns.Count;//列数
int iRowsCargo = ExcelTableCargo.Rows.Count;//行数
if (iRowsCargo == 0)
MessageBox.Show("Excel货物表中没有数据!", "提示:", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
else
this.getcargo(ExcelTableCargo, Taskidpasser);
int iColumsContainer = ExcelTableContainer.Columns.Count;//列数
int iRowsContainer = ExcelTableContainer.Rows.Count;//行数
if (iRowsContainer == 0)
MessageBox.Show("Excel容器表中没有数据!", "提示:", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
else
this.getcontainer(ExcelTableContainer, Taskidpasser);
OleDbDataAdapter myData = new OleDbDataAdapter(strSql, objConn);
OleDbDataAdapter myDataCargo = new OleDbDataAdapter(strSqlCargo, objConn);
OleDbDataAdapter myDataContainer = new OleDbDataAdapter(strSqlContainer, objConn);
myData.Fill(ds, tableName);//填充数据
myDataCargo.Fill(ds, tableNameCargo);
myDataContainer.Fill(ds, tableNameContainer);
ExcelTable = ds.Tables[tableName];
ExcelTableCargo = ds.Tables[tableNameCargo];
ExcelTableContainer = ds.Tables[tableNameContainer];
int iColums = ExcelTable.Columns.Count;//列数
int iRows = ExcelTable.Rows.Count;//行数
if (iRows == 0)
MessageBox.Show("Excel任务表中没有数据!", "提示:", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
else
this.getuser(ExcelTable,Taskidpasser);
int iColumsCargo = ExcelTableCargo.Columns.Count;//列数
int iRowsCargo = ExcelTableCargo.Rows.Count;//行数
if (iRowsCargo == 0)
MessageBox.Show("Excel货物表中没有数据!", "提示:", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
else
this.getcargo(ExcelTableCargo, Taskidpasser);
int iColumsContainer = ExcelTableContainer.Columns.Count;//列数
int iRowsContainer = ExcelTableContainer.Rows.Count;//行数
if (iRowsContainer == 0)
MessageBox.Show("Excel容器表中没有数据!", "提示:", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
else
this.getcontainer(ExcelTableContainer, Taskidpasser);
剩余9页未读,继续阅读
资源评论
我爱鸽子
- 粉丝: 0
- 资源: 1
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功