Question

Access中表的Id是自动编号。update语句如何更新。

UPDATE zuanqian SET Txt='" + TextBox1.Text + "',Time='" + times + "' where Id= '" + num + "'"
是呀我不更新Id，语句也没更新Id呀，只更新其他的，但这语句总抱错
我是用C#呀，错误 4 运算符“&”无法应用于“string”和“string”类型的操作数 C:\Documents and Settings\Administrator\桌面\ws\admin\zuanqian.aspx.cs 34 45 C:\...\ws\

Answer 1

自动编号是无法更改。
看你的sql，ID是做条件，更新应该没有问题啊。
UPDATE zuanqian SET Txt='" & TextBox1.Text & "',Time=#" & times & "# where Id= " & num

Answer 2

自动编号是系统提供的，不能改变，你只能更新id编号的数据。

Answer 3

自动编号是不能更新的

Answer 4

select userid,max(balance) as maxbalance from account group by userid
union all
select userid,max(balance) from account where userid+cast(balance as varchar(50)) not in (select userid+cast(max(balance) as varchar(50)) as maxbalance from account group by userid) group by userid order by userid,maxbalance

Answer 5

链接符号错误
"update zuanqian SET Txt='"&TextBox1.Text&"',Time=now() where Id= "&num