日期:2014-05-17 浏览次数:21106 次
<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();//关闭数据库连接