MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.
Public Function InsertNewClient( _ ByVal CustomerID As String, _ ByVal CustomerName As String, _ ByVal AddressLineOne As String, _ ByVal AddressLineTwo As String, _ ByVal AddressLineThree As String, _ ByVal AddressLineFour As String, _ ByVal TelephoneNumber As String, _ ByVal FaxNumber As String, _ ByVal WebsiteAddress As String) As Int32 If CustomerName Is Nothing Then CustomerName = DBNull.Value If AddressLineOne Is Nothing Then AddressLineOne = DBNull.Value If AddressLineTwo Is Nothing Then AddressLineTwo = DBNull.Value If AddressLineThree Is Nothing Then AddressLineThree = DBNull.Value If AddressLineFour Is Nothing Then AddressLineFour = DBNull.Value If TelephoneNumber Is Nothing Then TelephoneNumber = DBNull.Value If FaxNumber Is Nothing Then FaxNumber = DBNull.Value If WebsiteAddress Is Nothing Then WebsiteAddress = DBNull.Value ' Setting the initial value of RowsAffected to 0 Dim RowsAffected As Nullable(Of Integer) = 0 ' Once this is called the method for the OUTPUT parameter is ByRef ' thus returning the OUTPUT paramter value Adapter.InsertNewClient(CustomerID, CustomerName, AddressLineOne, AddressLineTwo, AddressLineThree, AddressLineFour, TelephoneNumber, FaxNumber, WebsiteAddress, RowsAffected) ' We then return the RowsAffected value returned ' when our stored procedure above was called. Return RowsAffected End Function
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.