请帮忙解决标准表达式中数据类型不匹配！

[figoxf]

string strCon = "provider=microsoft.jet.oledb.4.0;";
strCon += @"data source=GtestCheckPrice.mdb";
OleDbConnection conn = new OleDbConnection();
conn = new OleDbConnection(strCon);
string seleSql = "select ID from zhangdan where CustomerID='" + textBox1.Text + "'";
//OleDbDataReader dr = new OleDbDataReader();
//OleDbDataReader dr;
//dr.Read();
//textBox1.Text = (string)dr["CustomerName"];

conn.Open();
OleDbDataAdapter da = new OleDbDataAdapter(seleSql, conn);
DataSet ds = new DataSet();
da.Fill(ds);
conn.Close();
da.Dispose();

textBox2.Text = ds.Tables[0].Rows[0]["ID"].ToString();

数据库ID为自动编号类型
CustomerID为数字类型

[ACMAIN_CHM]

string seleSql = "select ID from zhangdan where CustomerID=" + textBox1.Text ;

估计CustomerID是数字型吧。

[figoxf]

这样的表达式：
OleDbCommand aCommand = new OleDbCommand("Update zhangdan a set a.CustomerID='" + CustomerID + "',a.DeviceName='" + DeviceName + "',a.count='" + count
+ "',a.UnitPrice=" + decimal.Parse(UnitPrice) + ",a.AllUnitPrice=" + decimal.Parse(AllUnitPrice) + ",DataTime=#" + DataTime + "# where a.ID=" + ID, aConnection);
DataTime=#" + DataTime + "# 这样的表达格式是怎么样的？

[ACMAIN_CHM]

调试中看下 "Update zhangdan a set a.CustomerID='" + CustomerID + "',a.DeviceName='" + DeviceName + "',a.count='" + count
+ "',a.UnitPrice=" + decimal.Parse(UnitPrice) + ",a.AllUnitPrice=" + decimal.Parse(AllUnitPrice) + ",DataTime=#" + DataTime + "# where a.ID=" + ID

看看结果是什么。学会调试程序很重要。