access sql语句问题

[phzhenghao]

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类型了，不是参数数组问题.
执行提示语法错误，求助！！！

[bullion]

你全给改成 真实值试试， 再一个一个替换过去， 就知道哪个出错了

[phzhenghao]

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

ACCESS执行正常

[Iovswety]

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();

[MSDNXGH]

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