如何操作SQL数据库表中标志列的Update

[干爹]

我现在有个表，ID为自动增长、标志列，怎么写Update都没办法插入，大家怎么做撒，给点力

[孟子E章]

ID为自动增长的不能修改插入的，把这个字段去掉，
如
Update table Set xx = '' Where id=xxxxx
而不是
Update table Set xx = '' ,id =xxxx

[TONG_先生]

update 是更新，不是插入啊。insert 才是插入、

[若-相惜]

lz到底是更新还是插入呀
插入 insert into table(colum 这里id自增不用指明) values(...);

更新 Update table Set colum=" .." Where id="......."

[干爹]

我现在是读出来了，想改动一些信息然后X回去，这应该是进行一次insert?

[若-相惜]

update啊 修改用update

[a13971240]

update set 值 where 条件

[干爹]

但是update 了我的ID改不了
看看这个有什么错吗？
create proc customerinfo_update(
@ID int,
@address [varchar](100),
@email [varchar](100),
@contactor[varchar](100),
@company [varchar](100),
@telephone [varchar](100),
@fax [varchar](100),
@costomertype [varchar](100),
@companytype [varchar](100),
@area [varchar](100),
@zipcode [varchar](100),
@industry [varchar](100),
@product [varchar](100),
@response [varchar](100),
@representative [varchar](100),
@companysize [varchar](100),
@fund [varchar](100),
@status [varchar](100),
@website[varchar](100),
@contactrecord [varchar](100),
@visitplan [varchar](100),
@remark [varchar](100),
@customervisitedtime [varchar](100),
@nexttimecontent [varchar](100)
)
as
update Customer
set
ID=@ID,address=@address,
email=@email,
contactor=@contactor,
company=@company,
telephone=@telephone,
fax=@fax,
costomertype=@costomertype,
companytype=@companytype,
area=@area,
zipcode=@zipcode,
industry=@industry,
product=@product,
response=@response,
representative=@representative,
companysize=@companysize,
fund=@fund,
status=@status,
website=@website,
contactrecord=@contactrecord,
visitplan=@visitplan,
remark=@remark,
customervisitedtime=@customervisitedtime,
nexttimecontent=@nexttimecontent
where
ID=@ID

红色的是不可以改的，如果把红色的去掉存储过程没有错，
当点击页面按钮提交时出现这样的错：
过程或函数 'customerinfo_update' 需要参数 '@ID'，但未提供该参数。
下面是CS文件里的程序

SqlParameter[] prams = {
new SqlParameter("@address",SqlDbType.VarChar,100),
new SqlParameter("@email",SqlDbType.VarChar,100),
new SqlParameter("@contactor",SqlDbType.VarChar,100),
new SqlParameter("@company",SqlDbType.VarChar,100),
new SqlParameter("@telephone",SqlDbType.VarChar,100),
new SqlParameter("@fax",SqlDbType.VarChar,100),
new SqlParameter("@costomertype",SqlDbType.VarChar,100),
new SqlParameter("@companytype",SqlDbType.VarChar,100),
new SqlParameter("@area",SqlDbType.VarChar,100),
new SqlParameter("@zipcode",SqlDbType.VarChar,100),
new SqlParameter("@industry",SqlDbType.VarChar,100),
new SqlParameter("@product",SqlDbType.VarChar,100),
new SqlParameter("@response",SqlDbType.VarChar,100),
new SqlParameter("@representative",SqlDbType.VarChar,100),
new SqlParameter("@companysize",SqlDbType.VarChar,100),
new SqlParameter("@fund",SqlDbType.VarChar,100),
new SqlParameter("@status",SqlDbType.VarChar,100),
new SqlParameter("@website",SqlDbType.VarChar,100),
new SqlParameter("@contactrecord",SqlDbType.VarChar,100),
new SqlParameter("@visitplan",SqlDbType.VarChar,100),
new SqlParameter("@remark",SqlDbType.VarChar,100),
new SqlParameter("@customervisitedtime",SqlDbType.VarChar,100),
new SqlParameter("@nexttimecontent",SqlDbType.VarChar,100)
};
prams[0].Value = customercomefrom.Text;
prams[1].Value = customeremail.Text;
prams[2].Value = customercontator.Text;
prams[3].Value = customername.Text;
prams[4].Value = customertel.Text;
prams[5].Value = customerfax.Text;
prams[6].Value = customertype.SelectedValue.ToString();
prams[7].Value = companytype.SelectedValue.ToString();
prams[8].Value = customerarea.SelectedValue.ToString();
prams[9].Value = customerzip.Text;
prams[10].Value = customerindustry.SelectedValue.ToString();
prams[11].Value = customerproduct.Text;
prams[12].Value = customerresponse.Text;
prams[13].Value = customerrepresentative.Text;
prams[14].Value = customercompanysize.Text;
prams[15].Value = customerfund.Text;
prams[16].Value = costomerstatus.SelectedValue.ToString();
prams[17].Value = customerwebsite.Text;
prams[18].Value = costomerrecord.Text;
prams[19].Value = lb_nexttime.Text;
prams[20].Value = costomerremark.Text;
prams[21].Value = customervisitedtime.Text;
prams[22].Value = lb_nextcontent.Text;


还用把ID也完上去？

[干爹]

还用把ID也写上去？

[若-相惜]

lz ID是不能改的

update table book set bookname=@name,price=@price where id=@id

[干爹]

那这个错误怎么办哦

过程或函数 'customerinfo_update' 需要参数 '@ID'，但未提供该参数。

我在哪里提供这个参数

[若-相惜]

SqlParameter[] prams = {
new SqlParameter("@address",SqlDbType.VarChar,100),
new SqlParameter("@email",SqlDbType.VarChar,100),
new SqlParameter("@contactor",SqlDbType.VarChar,100),
new SqlParameter("@company",SqlDbType.VarChar,100),
new SqlParameter("@telephone",SqlDbType.VarChar,100),
new SqlParameter("@fax",SqlDbType.VarChar,100),
new SqlParameter("@costomertype",SqlDbType.VarChar,100),
new SqlParameter("@companytype",SqlDbType.VarChar,100),
new SqlParameter("@area",SqlDbType.VarChar,100),
new SqlParameter("@zipcode",SqlDbType.VarChar,100),
new SqlParameter("@industry",SqlDbType.VarChar,100),
new SqlParameter("@product",SqlDbType.VarChar,100),
new SqlParameter("@response",SqlDbType.VarChar,100),
new SqlParameter("@representative",SqlDbType.VarChar,100),
new SqlParameter("@companysize",SqlDbType.VarChar,100),
new SqlParameter("@fund",SqlDbType.VarChar,100),
new SqlParameter("@status",SqlDbType.VarChar,100),
new SqlParameter("@website",SqlDbType.VarChar,100),
new SqlParameter("@contactrecord",SqlDbType.VarChar,100),
new SqlParameter("@visitplan",SqlDbType.VarChar,100),
new SqlParameter("@remark",SqlDbType.VarChar,100),
new SqlParameter("@customervisitedtime",SqlDbType.VarChar,100),
new SqlParameter("@nexttimecontent",SqlDbType.VarChar,100),
new SqlParameter(这里提供) };
prams[0].Value = customercomefrom.Text;
prams[1].Value = customeremail.Text;
prams[2].Value = customercontator.Text;
prams[3].Value = customername.Text;
prams[4].Value = customertel.Text;
prams[5].Value = customerfax.Text;
prams[6].Value = customertype.SelectedValue.ToString();
prams[7].Value = companytype.SelectedValue.ToString();
prams[8].Value = customerarea.SelectedValue.ToString();
prams[9].Value = customerzip.Text;
prams[10].Value = customerindustry.SelectedValue.ToString();
prams[11].Value = customerproduct.Text;
prams[12].Value = customerresponse.Text;
prams[13].Value = customerrepresentative.Text;
prams[14].Value = customercompanysize.Text;
prams[15].Value = customerfund.Text;
prams[16].Value = costomerstatus.SelectedValue.ToString();
prams[17].Value = customerwebsite.Text;
prams[18].Value = costomerrecord.Text;
prams[19].Value = lb_nexttime.Text;
prams[20].Value = costomerremark.Text;
prams[21].Value = customervisitedtime.Text;
prams[22].Value = lb_nextcontent.Text;
prams[23].Value =id；

[wuyq11]

自增列不用修改
updatw tb set name=@name where id=@id
new SqlParameter("@ID",SqlDbType.Int),

[zsc970]

1\储存过程把红色的去掉,2\在页面参数列表中增加ID,SqlParameter[] prams = {"这里增加" }.3\还要增加prams[23].Value = lb_ID.Text;

[干爹]

成功了哥们，谢谢你们