日期:2014-05-17 浏览次数:21102 次
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; mso-outline-level: 1" align=center><B style="mso-bidi-font-weight: normal"><SPAN lang=EN-US style="FONT-SIZE: 42pt"><FONT face="Times New Roman">
conTo.Open();//打开数据库连接
SqlCommand cmd = new SqlCommand();
cmd.Connection = conTo;//设置连接属性
//遍历dataset (名称为ds)里旧数据表的每一行
foreach (DataRow dr in ds.Tables["旧数据"].Rows)
{
cmd.CommandText = @"insert into article (Title,Content) values ('" + dr["title"].ToString() + "','" + dr["content"].ToString() + "')";
cmd.ExecuteNonQuery();
}
conTo.Close();//关闭数据库连接