数据10W条以上,wm6.5平台,内存有限
C# code:
private void connserver()
{
Cursor.Current = Cursors.WaitCursor;
try
{
DataSet ds = new DataSet();
SqlCeConnection conn = new SqlCeConnection(constr);
SqlCeCommand cmd = new SqlCeCommand("select vcbarcode,cdeptid,citemid,cbaseitemid,cname,cmeasure,cmodel,funitqty,fnowinprice,fsellprice from vco_items ", conn);
SqlCeDataAdapter clientda = new SqlCeDataAdapter();
SqlCeCommand insert = new SqlCeCommand("insert into vco_items(vcbarcode,cdeptid,citemid,cbaseitemid,cname,cmeasure,cmodel,funitqty,fnowinprice,fsellprice) select @vcbarcode,@cdeptid,@citemid,@cbaseitemid,@cname,@cmeasure,@cmodel,@funitqty,@fnowinprice,@fsellprice");
insert.Parameters.Add("@vcbarcode", SqlDbType.NVarChar, 30, "vcbarcode");
insert.Parameters.Add("@cdeptid", SqlDbType.NChar, 4, "cdeptid");
insert.Parameters.Add("@citemid", SqlDbType.NChar, 6, "citemid");
insert.Parameters.Add("@cbaseitemid", SqlDbType.NChar, 6, "cbaseitemid");
insert.Parameters.Add("@cname", SqlDbType.NVarChar, 50, "cnam
ERP软件的数据库是SQLSERVER2000的，公司让我做个网站，其中有些数据是调用ERP里的，我想用PHP做网站，但是不知道PHP访问SQLSERVER库好实现不，再就速度方面影响不会太大吧？跟ASP访问SQLSERVER相比速度变化大不？（ ......
