Question

标准表达式中数据类型不匹配.

public int update(Model model, int cno)
{
string Cstr = ConfigurationManager.ConnectionStrings["ACCESSCONNECTION"].ToString();
using (OleDbConnection cnn = new OleDbConnection(Cstr))
{
cnn.Open();
string acc = "update Cultureinfo set Title='" + model.Title + "',Ctext='" + model.Text + "'where Cno='" + cno + "'";
OleDbCommand cmd = new OleDbCommand(acc , cnn);
OleDbDataAdapter adp = new OleDbDataAdapter(cmd);
DataSet ds = new DataSet();
adp.Fill(ds,"cul"); 这句错误是。。。标准表达式中数据类型不匹配.
int ans = Convert.ToInt32(cmd.ExecuteNonQuery ());
return ans;
}
}

Answer 1

JAVA中的Date类型往往跟数据库的Date不匹配，mysql、sqlserver也是如此，一般都需要format一下才行