关于SqlDataAdapter和DataSet的问题请教！

[fire_in_wind]

有如下的代码：

Sql="SELECT * FROM [User]";

SqlDataAdapter Da=new SqlDataAdapter (Sql,Conn);

DataSet ds=new DataSet ();
Da.Fill (ds,"myUser");
SqlCommandBuilder cmdBuilder=new SqlCommandBuilder (Da);

Da.UpdateCommand =cmdBuilder.GetUpdateCommand ();

for(int i=0;i<ds.Tables ["myUser"].Rows.Count;i++){
if (ds.Tables["myUser"].Rows [i]["UserID"].ToString ()==UserID){
if(TrueName!=null&&TrueName!=""){
ds.Tables["myUser"].Rows [i]["TrueName"]=TrueName.Trim ();

}

break;
}
}

Da.Update (ds,"myUser");



为什么在运行的时候会出现：

关键字 'User' 附近有语法错误。
说明: 执行当前 Web 请求期间，出现未处理的异常。请检查堆栈跟踪信息，以了解有关该错误以及代码中导致错误的出处的详细信息。

异常详细信息: System.Data.SqlClient.SqlException: 在关键字 'User' 附近有语法错误。

源错误:


行 167： }
行 168：
行 169： Da.Update (ds,"myUser");
行 170：
行 171：

显示行169。


有哪位朋友能详细的讲讲用SqlDataAdapter和DataSet怎么更新数据库里的数据，谢谢了！

[saucer]

1. it is a bad idea to use a keyword as table name

2. what happens if you remove this line:

Da.UpdateCommand =cmdBuilder.GetUpdateCommand ();

3. check Da.UpdateCommand.CommandText and add [] around "User" manually

[BenZ004]

这个SQL语句：
Sql="SELECT * FROM [User]";
[user]是表名还是user啊？
[]应该去掉把。
还有：
updatecommand里的commandtext是什么？

[fire_in_wind]

谢谢我知道了！

[fire_in_wind]

To:saucer

1.when I change the table name to something else,will it be solved the problem?Is the "User" a keyword in Dotnet framework?

2.It showed that the SqlDataAdapeter need an UpdateCommand.

3.The CommandText of the CommandBuilder automatic created is in below:

UPDATE User SET UserName = @p1 , UserPassword = @p2 , TrueName = @p3 , Tel = @p4 , MobileTel = @p5 , BankCardID = @p6 , UserClass = @p7 , UserEmail = @p8 , UserPic = @p9 WHERE ( (UserID = @p10) AND ((@p11 = 1 AND UserName IS NULL) OR (UserName = @p12)) AND ((@p13 = 1 AND UserPassword IS NULL) OR (UserPassword = @p14)) AND ((@p15 = 1 AND TrueName IS NULL) OR (TrueName = @p16)) AND ((@p17 = 1 AND Tel IS NULL) OR (Tel = @p18)) AND ((@p19 = 1 AND MobileTel IS NULL) OR (MobileTel = @p20)) AND ((@p21 = 1 AND BankCardID IS NULL) OR (BankCardID = @p22)) AND ((@p23 = 1 AND UserClass IS NULL) OR (UserClass = @p24)) AND ((@p25 = 1 AND UserEmail IS NULL) OR (UserEmail = @p26)) AND ((@p27 = 1 AND UserPic IS NULL) OR (UserPic = @p28)) )


you sugguested that I get this string and add a [] around "User",and then let it to the SqlDataAdapeter as an UpdateCommand?

[fire_in_wind]

BTW:

Can you give me an ensample for updating data to a database using DataSet and SqlDataAdapter?

[panyee]

user在sql server中是关键字, 它作为表名时,sql语句中都要写成 [user]

你的查询语句是已经写成了select * from [user]

update语句也要写成 update [user] set ......

[qiuji]

user是关键字，改一下表的名称。

[guoyan19811021]

user是关键字