会员
周边
众包
新闻
博问
闪存
所有博客
当前博客
我的博客
我的园子
账号设置
简洁模式
...
退出登录
注册
登录
yongwnet
博客园
首页
新随笔
联系
订阅
管理
Table To Table
OleDbConnection conn
=
new
OleDbConnection();
DataTable mydt
=
new
DataTable(
"
mydt
"
);
DataColumn dc
=
new
DataColumn();
dc.DataType
=
System.Type.GetType(
"
System.String
"
);
dc.ColumnName
=
"
id
"
;
//
dc.DefaultValue = "11";
mydt.Columns.Add(
"
id
"
);
dc.DataType
=
System.Type.GetType(
"
System.String
"
);
dc.ColumnName
=
"
name
"
;
//
dc.DefaultValue = "myname";
mydt.Columns.Add(
"
name
"
);
dc.DataType
=
System.Type.GetType(
"
System.String
"
);
dc.ColumnName
=
"
pwd
"
;
//
dc.DefaultValue = "mypwd";
mydt.Columns.Add(
"
pwd
"
);
DataRow dr
=
null
;
dr
=
mydt.NewRow();
dr[
"
id
"
]
=
"
11
"
;
dr[
"
name
"
]
=
"
myname11
"
;
dr[
"
pwd
"
]
=
"
mypwd11
"
;
mydt.Rows.Add(dr);
dr
=
mydt.NewRow();
dr[
"
id
"
]
=
"
22
"
;
dr[
"
name
"
]
=
"
myname22
"
;
dr[
"
pwd
"
]
=
"
mypwd22
"
;
mydt.Rows.Add(dr);
dr
=
mydt.NewRow();
dr[
"
id
"
]
=
"
33
"
;
dr[
"
name
"
]
=
"
myname33
"
;
dr[
"
pwd
"
]
=
"
mypwd33
"
;
mydt.Rows.Add(dr);
this
.dataGridView2.DataSource
=
mydt;
MessageBox.Show(
"
create ok
"
);
conn.Open();
OleDbCommand cmd
=
null
;
string
id
=
null
;
string
name
=
null
;
string
pwd
=
null
;
string
strSql
=
null
;
for
(
int
i
=
0
; i
<=
mydt.Rows.Count
-
1
; i
++
)
{
id
=
mydt.Rows[i][
0
].ToString();
name
=
mydt.Rows[i][
1
].ToString();
pwd
=
mydt.Rows[i][
2
].ToString();
//
删除重复记录
strSql
=
"
delete from MyTable2 where id='
"
+
id
+
"
' and name = '
"
+
name
+
"
' and pwd='
"
+
pwd
+
"
'
"
;
cmd
=
new
OleDbCommand(strSql, conn);
cmd.ExecuteNonQuery();
//
插入记录
strSql
=
"
insert into MyTable2 (id,name,pwd) values('
"
+
id
+
"
','
"
+
name
+
"
','
"
+
pwd
+
"
')
"
;
cmd
=
new
OleDbCommand(strSql, conn);
cmd.ExecuteNonQuery();
}
OleDbDataAdapter da3
=
new
OleDbDataAdapter(
"
select * from MyTable2
"
, conn);
DataSet ds3
=
new
DataSet();
da3.Fill(ds3,
"
ds3
"
);
this
.dataGridView2.DataSource
=
ds3.Tables[
"
ds3
"
];
conn.Close();
posted @
2007-06-01 14:46
yongwnet
阅读(
298
) 评论(
0
)
编辑
收藏
举报
会员力量,点亮园子希望
刷新页面
返回顶部
公告