2024年6月7日发(作者：)
using System;
using c;
using entModel;
using ;
using g;
using ;
using ;
using ;
using ent;
using ;
using ;
using ;
//创建人内江师范学院牟鹏，2014-12，excel导入功能的实现
namespace WindowsFormsApplication1
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void btn_close_Click(object sender, EventArgs e)
{
();
}
///
/// 数据库插入数据操作
///
/// 用户名
/// 密码
/// 备注
///
public static bool DataCon(string username,string pwd,string
remark)
{
//数据库连接字符串
string sqlCon = "Server=192.168.1.19;
database=InDataOfExcel;Uid=sa;pwd=123;";
using (SqlConnection con = new SqlConnection(sqlCon))
{
//判断数据库连接状态
if ( != )
{
();
();
}
SqlCommand cmd = Command();
//数据操作字符串
string sqlText = "insert into userCon
(username,pwd,remark)values('"+username+"','"+pwd+"','"+remark+"')";
dText = sqlText;
//返回受影响的行数大于0表示插入成功
if (eNonQuery() > 0)
{
return true;
}
else
{
return false;
}
}
}
///
/// 导入Excel
///
/// dataGridView控件名
/// 路径名
public static void ReadingExcel(DataGridView gridView, string
fileName)
{
ation app = new
ation();
Workbook book = (fileName, g,
g, g, g, g, g,
g, g, g, g, g,
g, g, g);
Worksheet sheet = eets[1] as Worksheet;
();
();
//添加每一列的列标题
for (int i = 1; ; i++)
{
string value = ([1, i] as
Range).ng();//获得每列第一行数据。
if (value == )//如果为空则代表已无数据
{
break;
}
("", value);
}
//导入每一行的数据
for (int i = 2; ; i++)
{
string value = ([i, 1] as
Range).ng();//获得每行第一列数据。
if (value == )//如果为空则代表已无数据
{
break;
}
//获得EXCEL中每行上的每列数据
string ID = ([i, 1] as Range).ng();
string username = ([i, 2] as
Range).ng();
string pwd= ([i, 3] as Range).ng();
string remark = ([i, 4] as
Range).ng();
DataCon(username, pwd, remark);
(new object[] { ID, username, pwd,
remark });
}
(g, g, g);
();
();
("数据导入成功");
}
///
/// 导入数据事件
///
///
///
private void btn_inport_Click(object sender, EventArgs e)
{
//打开要导入的文件
OpenFileDialog open=new OpenFileDialog();
if (alog() == )
{
alog();
string fileName = me;
ReadingExcel(dataGridViewX1, fileName);
}
else
{
return;
}
}
}
}
发布评论