.net 更新数据 ado.net parameter

 

UPDATE yborder_ordernotes SET recoder400= @FileAddress, havefile400 = 1 WHERE id = @OrderID

Maticsoft.DBUtility.SqlHelper.ExecuteNonQuery(ConStr, CommandType.Text, SQL, new SqlParameter("@FileAddress", localFilePath),
new SqlParameter("@OrderID", record.OrderID));