Home | Forums | Contact | Search | Syndication  
 
 [login] [create account]   Friday, March 29, 2024 
 
View User Profile  

 User Profile - Steve Holstad  
Steve Holstad
Clarity Consulting

fjrigjwwe9r1SiteUser:UserBio
fiogf49gjkf0d


Log in to send this member a message!
 


 Steve Holstad's Contributions
Steve Holstad has contributed 3 comments and 0 articles.
 
Select to view:    
Comment: Re: The ADO.NET Primer
fiogf49gjkf0d
Here is the vb.net version I used, based on Ryan's C# function mentioned earlier....


Private Function getTableID(ByVal table As String) As String
Dim configurationAppSettings As System.Configuration.AppSettingsReader = New System.Configuration.AppSettingsReader
Dim slxConnString As String = CType(configurationAppSettings.GetValue("SLXConnString", GetType(System.String)), String)
Dim conn As OleDbConnection

Try

If table.Equals(String.Empty) Then Throw New Exception("Table name missing")

conn = New OleDbConnection(slxConnString)

conn.Open()
Dim cmd As New OleDbCommand(String.Format("slx_dbids('{0}', 1)", table), conn)
Return cmd.ExecuteScalar().ToString

Catch ex As Exception
Throw
Finally
conn.Dispose()
conn = Nothing

End Try

End Function

Author: Steve Holstad - 9/21/2004

 
Comment: Re: The ADO.NET Primer
fiogf49gjkf0d
Odd. I converted your function to vb.net, and it looked pretty much like the one I had that was failing. I must have had something wrong with the formatting of the parameter. Anyway, its working perfectly now, which is just another reason Mr. Farley is the SLX Man!

thanks a ton,

steve

Author: Steve Holstad - 9/20/2004

 
Comment: Using OLEDB and the slx stored procs
fiogf49gjkf0d
Has anyone had luck using vb.net to create new IDs through the SLX 6.1 provider? I am having a tough time getting .net to see the slx stored procs, and ran into issues using the saleslogix com classes. any thoughts?

-steve

Author: Steve Holstad - 9/20/2004

 


 
 slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation.
 This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.

code of conduct | Subscribe to the slxdeveloper.com Latest Article RSS feed
   
 
page cache (param): 3/29/2024 1:46:36 AM