On Fri, Feb 17, 2012 at 4:26 PM, Stephen Russell <[email protected]> wrote: > The power of dynamic SQL ? > That is running with scissors.
See "The Curse and Blessings of Dynamic SQL" http://www.sommarskog.se/dynamic_sql.html For what it's worth my C# code for saving a record is 95% the same as this. It looks auto-generated. Mine is too. > This is how I am handling an update in a VB.net project: > > Public Function Update(ByVal var As TradingPartnersInfo) As Boolean > > Dim sysEnc As New Ring.Encryption > > Try > Dim params() As SqlParameter = New SqlParameter(12) {} > params(0) = New SqlParameter("@TradingPartnerID", > var.TradingPartnerID) > params(1) = New > SqlParameter("@TradingPartnerQualifier", var.TradingPartnerQualifier) > params(2) = New SqlParameter("@TradingPartnerDesc", > var.TradingPartnerDesc) > params(3) = New SqlParameter("@Purpose", var.Purpose) > params(4) = New SqlParameter("@BaanInvLoc", var.BaanInvLoc) > params(5) = New SqlParameter("@FTPSiteInbound", > var.FTPSiteInbound) > params(6) = New SqlParameter("@FTPSiteOutbound", > var.FTPSiteOutbound) > params(7) = New SqlParameter("@FTPUser", var.FTPUser) > params(8) = New SqlParameter("@FTPPW", > sysEnc.EncryptValue(var.FTPPW)) > params(9) = New SqlParameter("@isSterlineCommerce", > var.isSterlineCommerce) > params(10) = New SqlParameter("@Active", var.Active) > params(11) = New SqlParameter("@dtmAdded", var.dtmAdded) > params(12) = New SqlParameter("@Contact", var.Contact) > SqlHelper.ExecuteNonQuery(My.Settings.cnRingEDIEngine, > CommandType.StoredProcedure, "TradingPartners_upd", params) > Catch ex As Exception > Dim s As String = ex.Message > Throw New ApplicationException(ex.Message) > End Try > End Function -- Paul _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cadwx0+kd7e4anqnuddp5n2se+_q+r5n7cafkv4xw+mscuuz...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
