Dim dr As SqlDataReader
stra = "SELECT * from wlxx"
sqlcmd = New SqlCommand(stra, CONN)
CONN.Open()
dr = sqlcmd.ExecuteReader
I = 0
While dr.Read
strb = "insert into wlxx1 values('" & dr(0) & "','" & dr(1) & "','" & dr(2) & "','" & dr(3) & "','" & dr(4) & "'"
sqlcm = New SqlCommand(strb, CONN) sqlcm.ExecuteNonQuery() I = I + 1
Label1.Text = "有" & I & "条数据复制"
End While CONN.Close()提示“已有打开的与此命令相关联的DATAREADER” 错误,是那错误了,晕
stra = "SELECT * from wlxx"
sqlcmd = New SqlCommand(stra, CONN)
CONN.Open()
dr = sqlcmd.ExecuteReader
I = 0
While dr.Read
strb = "insert into wlxx1 values('" & dr(0) & "','" & dr(1) & "','" & dr(2) & "','" & dr(3) & "','" & dr(4) & "'"
sqlcm = New SqlCommand(strb, CONN) sqlcm.ExecuteNonQuery() I = I + 1
Label1.Text = "有" & I & "条数据复制"
End While CONN.Close()提示“已有打开的与此命令相关联的DATAREADER” 错误,是那错误了,晕
http://www.cnblogs.com/liaojunbo/archive/2008/04/26/1172348.html
using (SqlConnection cn = new SqlConnection(“”))
{
SqlCommand cmd1 = new SqlCommand("", cn);
cn.Open();
using (SqlDataReader dr1 = cmd1.ExecuteReader())
{
while (dr1.Read())
{
string sql= "";
SqlConnection conn2 = new SqlConnection("");
SqlCommand cmd2 = new SqlCommand(sql, conn2 );
cmd2.ExecuteNonQuery();
}
} }