Using vb.net to add a standalone table in a SQL database.

DavidKelly1 — Thu, 16 Sep 2010 16:24:31 GMT

I am using ArcGIS 9.2 and vb.net. I need to add a standalone table in SQL Server to ArcMap. I have the code to connect to the database but I am not sure how to get the table.

Here is the code for the connection string:

        Dim conn As New SqlConnection()

        conn.ConnectionString = "Data Source= EFRFBA-KELLYD-L;Initial Catalog = wts_rayonier;Persist Security Info=True;User ID=wts_rayonier;Password=wts_rayonier"

        conn.Open()

Thanks,

David Kelly

Re: Using vb.net to add a standalone table in a SQL database.

JamesMacKay — Thu, 16 Sep 2010 23:36:56 GMT

Hi David,

Take a look at the SqlCommand class. Once its properties are set correctly, you can use one of its methods (ExecuteNonReader or something like that I think) to execute DDL.

Cheers,
James

topic Re: Using vb.net to add a standalone table in a SQL database. in ArcObjects SDK Questions

Using vb.net to add a standalone table in a SQL database.

Re: Using vb.net to add a standalone table in a SQL database.