topic Re: Update stand alone sql table in ArcGIS Pro SDK Questions

Update stand alone sql table

helenchu — Tue, 21 Jul 2020 18:09:55 GMT

Hi,

I'd like to update my stand alone sql table base on values returned from my selection set. I was able to get the selection part but I couldn't find any snippets for updating sql table. Thank you for your help. Your help is greatly appreciated.

Re: Update stand alone sql table

RichRuh — Tue, 21 Jul 2020 23:09:58 GMT

Hi Helen,

Just to clarify, when you say "stand alone sql table base" are you referring to a table in a database and not a geodatabase? That is, a database that has not been registered as a geodatabase?

--Rich

Re: Update stand alone sql table

helenchu — Wed, 22 Jul 2020 13:14:58 GMT

Correct it's just a sql table in database NOT a geodatabase. My end goal to to have a sql table with a common field with my feature layer and the two joined so I can label my feature layer using a field from the sql table since I'm not allowed to edit the feature layer.

Or is there a better way to achieve what I need to do? Thank you Rich.

Re: Update stand alone sql table

RichRuh — Wed, 22 Jul 2020 23:32:09 GMT

The Pro SDK doesn't allow you to edit non-geodatabase tables. You could either add that SQL table to a geodatabase, or edit it using non-ArcGIS routines.

The easiest solution would be to register the table with a geodatabase? Is there a reason you cannot do this?

--Rich

p.s. Technically, you can also edit a non-geodatabasea table if it is published as part of a feature service, but that seems like using a sledgehammer to hang a picture frame.

Re: Update stand alone sql table

helenchu — Thu, 23 Jul 2020 15:36:25 GMT

Hi Rich,

I'm a little confused here so let's clarify more about my table.

Yes I can have my table live inside a geodatabase but my table is just a tabular table.

In ArcObjects for Arcmap addin, I used these codes to update a sql table doesn't matter where my table is. So you say in ProSDK I can no longer do that? Thanks Rich!

Dim sqlConnection As New SqlConnection(sConStr)

Dim cmdUpdate As New SqlCommand

cmdUpdate.Connection = sqlConnection

cmdUpdate.CommandType = CommandType.StoredProcedure

cmdUpdate.CommandText = "sp_CalculateRate"

cmdUpdate.Parameters.Add(New SqlParameter With {.ParameterName = "@ABCD", .SqlDbType = SqlDbType.VarChar, .Value = strABCD})

cmdUpdate.Parameters.Add(New SqlParameter With {.ParameterName = "@EFGH", .SqlDbType = SqlDbType.VarChar, .Value = strEFGH})

sqlConnection.Open()

cmdUpdate.ExecuteNonQuery()

cmdUpdate.Dispose()

sqlConnection.Close()

Re: Update stand alone sql table

RichRuh — Thu, 23 Jul 2020 16:13:28 GMT

Helen,

The code you have listed, using the SqlConnection and SqlCommand classes, comes from a Microsoft library, not from ArcObjects. You can continue to use it just fine.

--Rich

Re: Update stand alone sql table

helenchu — Fri, 24 Jul 2020 15:43:03 GMT

Thanks Rich!