忘记写上了中间还有一句 cmdTable.ExecuteNonQuery();
程序是这样的
string strsql;
string conn;
strsql = "insert into nngz (title,stat,end,code,url,zz,zz1,zd,urlqj,zzbd,s1,s2,fyth,urllist,zjbc,nn_id) select title,stat,end,code,url,zz,zz1,zd,urlqj,zzbd,s1,s2,fyth,urllist,zjbc,nn_id from nngz where nn_id=3";
conn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=E:\\My Documents\\Visual Studio 2005\\Projects\\WindowsApplication3\\WindowsApplication3\\data\\db1.mdb";
System.Data.OleDb.OleDbConnection sqlconn = new System.Data.OleDb.OleDbConnection(conn);
System.Data.OleDb.OleDbCommand cmdTable = new System.Data.OleDb.OleDbCommand(strsql, sqlconn);
cmdTable.CommandType = CommandType.Text;
sqlconn.Open();
cmdTable.ExecuteNonQuery();
sqlconn.Close();
程序是这样的
string strsql;
string conn;
strsql = "insert into nngz (title,stat,end,code,url,zz,zz1,zd,urlqj,zzbd,s1,s2,fyth,urllist,zjbc,nn_id) select title,stat,end,code,url,zz,zz1,zd,urlqj,zzbd,s1,s2,fyth,urllist,zjbc,nn_id from nngz where nn_id=3";
conn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=E:\\My Documents\\Visual Studio 2005\\Projects\\WindowsApplication3\\WindowsApplication3\\data\\db1.mdb";
System.Data.OleDb.OleDbConnection sqlconn = new System.Data.OleDb.OleDbConnection(conn);
System.Data.OleDb.OleDbCommand cmdTable = new System.Data.OleDb.OleDbCommand(strsql, sqlconn);
cmdTable.CommandType = CommandType.Text;
sqlconn.Open();
cmdTable.ExecuteNonQuery();
sqlconn.Close();
strsql=@"insert into nngz (title,stat,end,code,url,zz,zz1,zd,urlqj,zzbd,s1,s2,fyth,urllist,zjbc,nn_id) select title,stat,end,code,url,zz,zz1,zd,urlqj,zzbd,s1,s2,fyth,urllist,zjbc,nn_id from nngz where nn_id=3";
你那眼个写是肯定不行的.貌似只能先从ACCESS中读取数据出来然后存在DataSet中,然后再把DataSet中的数据存到SQL中去.
另,SQL的连接字符串应该这样写:"server=localhost;database=你的SQL数据库;uid=sa;pwd=密码"