Business里有这样的1个方法
public static bool update(string BC_Code,string BC_Name,string CustomerFlg,string SupplierFlg,string BC_PostalCd,string BC_Addr1,string BC_Addr2,float AR_Limit,string CustomerLank,string BC_StartYM,int UpdateCnt,DateTime UpdateDateTime,string UpdateDateMenber,string FreeForTest)
{
try
{
string sql = "update M_BusinessConnect set BC_Name='" + BC_Name + "',CustomerFlg='" + CustomerFlg + "',SupplierFlg='" + SupplierFlg + "',BC_PostalCd='" + BC_PostalCd + "',BC_Addr1='" + BC_Addr1 + "',BC_Addr2='" + BC_Addr2 +"',AR_Limit='" + AR_Limit + "',CustomerLank='" + CustomerLank + "',BC_StartYM='" + BC_StartYM + "',UpdateCnt='" + UpdateCnt + "',UpdateDateTime='" + UpdateDateTime + "',FreeForTest='" + FreeForTest + "'where BC_Code='" + BC_Code + "'";
DBManager db = new DBManager();
db.edit(sql);
return true;
}
catch
{
throw new Exception();
return false;
}
public static bool update(string BC_Code,string BC_Name,string CustomerFlg,string SupplierFlg,string BC_PostalCd,string BC_Addr1,string BC_Addr2,float AR_Limit,string CustomerLank,string BC_StartYM,int UpdateCnt,DateTime UpdateDateTime,string UpdateDateMenber,string FreeForTest)
{
try
{
string sql = "update M_BusinessConnect set BC_Name='" + BC_Name + "',CustomerFlg='" + CustomerFlg + "',SupplierFlg='" + SupplierFlg + "',BC_PostalCd='" + BC_PostalCd + "',BC_Addr1='" + BC_Addr1 + "',BC_Addr2='" + BC_Addr2 +"',AR_Limit='" + AR_Limit + "',CustomerLank='" + CustomerLank + "',BC_StartYM='" + BC_StartYM + "',UpdateCnt='" + UpdateCnt + "',UpdateDateTime='" + UpdateDateTime + "',FreeForTest='" + FreeForTest + "'where BC_Code='" + BC_Code + "'";
DBManager db = new DBManager();
db.edit(sql);
return true;
}
catch
{
throw new Exception();
return false;
}
try{
R01_Business.update("123332", "1", "1", "1", "1", "1", "1", 1.3f, "1", "1", 1, new DateTime(), "1", "1");
}catch(Exception x)
{
MessageBox.Show(x.ToString());
}
OracleCommand cmd=new OracleCommand("update studentDetails set sname=:Sname where sno=:Sno",con);
cmd.Parameters.AddWithValue("Sname","test");
cmd.Parameters.AddWithValue("Sno","aaa");
con.Open();
cmd.ExecuteNonQuery();
con.Close();
..UpdateCnt='" + UpdateCnt + "',UpdateDateTime='" + UpdateDateTime + "'..
你的这两个参数分别为int型和datetime型,所以在组织sql语句时不要用单引号...
后面还加了1串东西,太多了。。我单步看看==
你再多贴点错误信息出来。
string sql = "update M_BusinessConnect set BC_Name='" + BC_Name + "',CustomerFlg='" + CustomerFlg + "',SupplierFlg='" + SupplierFlg + "',BC_PostalCd='" + BC_PostalCd + "',BC_Addr1='" + BC_Addr1 + "',BC_Addr2='" + BC_Addr2 +"',AR_Limit='" + AR_Limit + "',CustomerLank='" + CustomerLank + "',BC_StartYM='" + BC_StartYM + "',UpdateCnt='" + UpdateCnt + "',UpdateDateTime='" + UpdateDateTime + "',FreeForTest='" + FreeForTest + "'where BC_Code='" + BC_Code + "'";
这个string sql改成:
With sql
.Remove(0, .Length)
.Append(" UPDATE ")
.Append(" M_BusinessConnect ")
.Append(" SET ")
.Append(" BC_Name = ")
.AppendFormat(" '{0}',", BC_Name)
.....
.Append(" UpdateDateTime = ")
.AppendFormat(" '{0}'", 把System.DateTime.Now转化为string型的)
.Append(" WHERE ")
.Append(" BC_Code = ")
.AppendFormat(" '{0}'", BC_Code) End With
试试看