public int UpdateFinance(int FinanceID, string FinanceData, int ArchivesNum, int FileNum, string Department, string FileTitle, string Sort, int Amount, int OrderNum, string FileStyle)
{
strOleDb = new StringBuilder();
strOleDb.Append("update Finance set");
strOleDb.Append(" FinanceData'" + FinanceData + "', ArchivesNum=" + ArchivesNum + ", FileNum=" + FileNum + ", Department='" + Department + "', FileTitle='" + FileTitle + "', Sort='" + Sort + "', Amount=" + Amount + ", OrderNum=" + OrderNum + ", FileStyle='" + FileStyle + "'");
strOleDb.Append(" where FinanceID=" + FinanceID + ""); int i = DB.DB_ExecuteNonQuery(strOleDb.ToString());
return i;
}UPDATE 语句的语法错误。大虾帮忙
{
strOleDb = new StringBuilder();
strOleDb.Append("update Finance set");
strOleDb.Append(" FinanceData'" + FinanceData + "', ArchivesNum=" + ArchivesNum + ", FileNum=" + FileNum + ", Department='" + Department + "', FileTitle='" + FileTitle + "', Sort='" + Sort + "', Amount=" + Amount + ", OrderNum=" + OrderNum + ", FileStyle='" + FileStyle + "'");
strOleDb.Append(" where FinanceID=" + FinanceID + ""); int i = DB.DB_ExecuteNonQuery(strOleDb.ToString());
return i;
}UPDATE 语句的语法错误。大虾帮忙
UPDATE 语句的语法错误 就这个啊
每次都支持我