access sql语句问题

phzhenghao 2010-10-18 12:56:22



sqlStr = "update [language] set language_name=@language_name,image=@image,"

                              + "directory=@directory,ordernumber=@ordernumber,"

                              + "state=@state,[default]=@default,updatatime=@updatatime where [ID]=@ID";



                SqlParameter[] param = new SqlParameter[8];

                param[0] = new SqlParameter("@language_name", SqlDbType.VarChar);

                param[0].Value = items[0];

                param[1] = new SqlParameter("@image", SqlDbType.VarChar);

                param[1].Value = items[2];

                param[2] = new SqlParameter("@directory", SqlDbType.VarChar);

                param[2].Value = items[1];

                param[3] = new SqlParameter("@ordernumber", SqlDbType.Int);

                param[3].Value = items[3] == "" ? 99 : Convert.ToInt32(items[3]);

                param[4] = new SqlParameter("@state", SqlDbType.Bit);

                param[4].Value = items[4] == "1" ? true : false;

                param[5] = new SqlParameter("@default", SqlDbType.Bit);

                param[5].Value = items[5] == "1" ? true : false;

                param[6] = new SqlParameter("@updatatime", SqlDbType.DateTime);

                param[6].Value = System.DateTime.Now;

                param[7] = new SqlParameter("@ID", SqlDbType.Int);

                param[7].Value = languageid == "" ? -1 : Convert.ToInt32(languageid);

param数组转成oledb类型了，不是参数数组问题.
执行提示语法错误，求助！！！

...全文

102 4 打赏收藏转发到动态举报

写回复

用AI写文章

4 条回复

切换为时间正序

请发表友善的回复…

发表回复

MSDNXGH 2010-10-18

打赏
举报

不是吧。这么复杂的么。。

Iovswety 2010-10-18

打赏
举报

SqlCommand insertRecord = new SqlCommand(
"INSERT INTO SOM_USER ("+
"USERNAME, PASSWORD) "+
"VALUES(@USERNAME, @PASSWORD)", myConnection);

insertRecord.Parameters.Add("@USERNAME", SqlDbType.NVarChar, 35).Value = username;

insertRecord.Parameters.Add("@PASSWORD", SqlDbType.VarBinary, password.Length).Value= password;
myConnection.Open();
insertRecord.ExecuteNonQuery();
myConnection.Close();

phzhenghao 2010-10-18

打赏
举报

update [language] set language_name='英文',image='country.png',directory='en',ordernumber='2',state=false,[default]=false,updatatime='2010-8-1' where [ID]=33

ACCESS执行正常

bullion 2010-10-18