11/21/2024 4:50:37 PM
slxdeveloper.com
Now Live!
|
|
| |
|
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
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
|
|
|
|
|
|
|
|