会员
周边
众包
新闻
博问
闪存
所有博客
当前博客
我的博客
我的园子
账号设置
简洁模式
...
退出登录
注册
登录
wucf2004的博客
asp.net和ajax
博客园
::
首页
::
新随笔
::
联系
::
订阅
::
管理
公告
从Excel中读出导入sql server
Posted on
2007-07-19 13:33
wucf2004
阅读(
463
) 评论(
0
)
编辑
收藏
举报
/**/
///
<summary>
///
从Excel读取后导入sql server
///
</summary>
public
void
ReadExcel()
{
string
sql
=
"
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=
"
+
Server.MapPath(
"
teachers.xls
"
)
+
"
;Extended Properties=Excel 8.0
"
;
OleDbConnection cnn
=
new
OleDbConnection(sql);
cnn.Open();
OleDbDataAdapter oda
=
new
OleDbDataAdapter(
"
select * from [教师$]
"
, cnn);
DataSet ds
=
new
DataSet();
oda.Fill(ds);
cnn.Close();
int
count
=
ds.Tables[
0
].Rows.Count;
for
(
int
i
=
0
; i
<
count; i
++
)
{
Jzgjbxx model
=
new
Jzgjbxx();
model.JZGID
=
ds.Tables[
0
].Rows[i][
"
JZGID
"
].ToString();
model.JZGBM
=
ds.Tables[
0
].Rows[i][
"
JZGBM
"
].ToString();
model.XXID
=
ds.Tables[
0
].Rows[i][
"
XXID
"
].ToString();
model.XM
=
ds.Tables[
0
].Rows[i][
"
XM
"
].ToString();
model.YHID
=
ds.Tables[
0
].Rows[i][
"
YHID
"
].ToString();
model.SFZH
=
ds.Tables[
0
].Rows[i][
"
SFZH
"
].ToString();
if
(ds.Tables[
0
].Rows[i][
"
CSRQ
"
].ToString()
!=
""
)
{
model.CSRQ
=
DateTime.Parse(ds.Tables[
0
].Rows[i][
"
CSRQ
"
].ToString());
}
else
{
model.CSRQ
=
DateTime.Now;
}
model.XBBM
=
ds.Tables[
0
].Rows[i][
"
XBBM
"
].ToString();
model.MZBM
=
ds.Tables[
0
].Rows[i][
"
MZBM
"
].ToString();
model.WHCDBM
=
ds.Tables[
0
].Rows[i][
"
WHCDBM
"
].ToString();
model.ZCBM
=
ds.Tables[
0
].Rows[i][
"
ZCBM
"
].ToString();
model.JSZGBM
=
ds.Tables[
0
].Rows[i][
"
JSZGBM
"
].ToString();
model.DYXLBM
=
ds.Tables[
0
].Rows[i][
"
DYXLBM
"
].ToString();
model.ZZMMBM
=
ds.Tables[
0
].Rows[i][
"
ZZMMBM
"
].ToString();
model.BZLBBM
=
ds.Tables[
0
].Rows[i][
"
BZLBBM
"
].ToString();
model.RKZKBM
=
ds.Tables[
0
].Rows[i][
"
RKZKBM
"
].ToString();
model.GWZYBM
=
ds.Tables[
0
].Rows[i][
"
GWZYBM
"
].ToString();
model.DZXX
=
ds.Tables[
0
].Rows[i][
"
DZXX
"
].ToString();
model.BZ
=
ds.Tables[
0
].Rows[i][
"
BZ
"
].ToString();
model.SCBZ
=
ds.Tables[
0
].Rows[i][
"
SCBZ
"
].ToString();
if
(ds.Tables[
0
].Rows[i][
"
CJNY
"
].ToString()
!=
""
)
{
model.CJRQ
=
DateTime.Parse(ds.Tables[
0
].Rows[i][
"
CJNY
"
].ToString());
}
else
{
model.CJRQ
=
DateTime.Now;
}
if
(ds.Tables[
0
].Rows[i][
"
CJGZNY
"
].ToString()
!=
""
)
{
model.CJGZRQ
=
DateTime.Parse(ds.Tables[
0
].Rows[i][
"
CJGZNY
"
].ToString());
}
else
{
model.CJGZRQ
=
DateTime.Now;
}
if
(ds.Tables[
0
].Rows[i][
"
LXNY
"
].ToString()
!=
""
)
{
model.LBXGZRQ
=
DateTime.Parse(ds.Tables[
0
].Rows[i][
"
LXNY
"
].ToString());
}
else
{
model.LBXGZRQ
=
DateTime.Now;
}
(
new
JzgjbxxBLL()).Create(model);
}
ds.Clear();
}
会员力量,点亮园子希望
刷新页面
返回顶部
Powered by:
博客园
Copyright © 2024 wucf2004
Powered by .NET 8.0 on Kubernetes