数据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
在数据库中有张表，有id,name两列，id 是主键,没有设置自增属性,在程序中取出这张表放入datatable，在这个datatable中插入一条记录，当更新数据库时提示id列不能为空，请问该怎么解决？
给它一个值！！主键不能为空 ......
