topic still confused please help. Connect to SDE and get access to table in ArcObjects SDK Questions https://community.esri.com/t5/arcobjects-sdk-questions/still-confused-please-help-connect-to-sde-and-get/m-p/16706#M372 <HTML><HEAD></HEAD><BODY><SPAN>Hi, I'm having trouble getting access to the tables in a SQL SDE database using c# .Net. Could anyone please post an example of a connection and then getting accessing a table. My main goal is to take a table from the database (which is a centerline shapefile I loaded) and change its projection. </SPAN><BR /><SPAN>And take a different table and make it a dataset using IDataset or the geodatabse equivalent.Thanks.</SPAN></BODY></HTML> Fri, 16 Mar 2012 14:50:20 GMT jamesborris 2012-03-16T14:50:20Z still confused please help. Connect to SDE and get access to table https://community.esri.com/t5/arcobjects-sdk-questions/still-confused-please-help-connect-to-sde-and-get/m-p/16706#M372 <HTML><HEAD></HEAD><BODY><SPAN>Hi, I'm having trouble getting access to the tables in a SQL SDE database using c# .Net. Could anyone please post an example of a connection and then getting accessing a table. My main goal is to take a table from the database (which is a centerline shapefile I loaded) and change its projection. </SPAN><BR /><SPAN>And take a different table and make it a dataset using IDataset or the geodatabse equivalent.Thanks.</SPAN></BODY></HTML> Fri, 16 Mar 2012 14:50:20 GMT https://community.esri.com/t5/arcobjects-sdk-questions/still-confused-please-help-connect-to-sde-and-get/m-p/16706#M372 jamesborris 2012-03-16T14:50:20Z Re: still confused please help. Connect to SDE and get access to table https://community.esri.com/t5/arcobjects-sdk-questions/still-confused-please-help-connect-to-sde-and-get/m-p/16707#M373 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive-quote">Hi, I'm having trouble getting access to the tables in a SQL SDE database using c# .Net. Could anyone please post an example of a connection and then getting accessing a table. My main goal is to take a table from the database (which is a centerline shapefile I loaded) and change its projection. <BR />And take a different table and make it a dataset using IDataset or the geodatabse equivalent.Thanks.</BLOCKQUOTE><BR /><BR /><SPAN>Get a table:</SPAN><BR /><SPAN> </SPAN><BR /><PRE class="plain" name="code">public ITable GetTable( string query, string keyFieldName ) {&nbsp; IWorkspaceFactory2 workspaceFactory2;&nbsp; IWorkspace workspace;&nbsp; ISqlWorkspace sqlWorkspace;&nbsp; ITable table;&nbsp; using ( ComReleaser comReleaser = new ComReleaser() )&nbsp; { &nbsp; // create types &nbsp; Type factoryType = Type.GetTypeFromProgID( "esriDataSourcesGDB.SqlWorkspaceFactory" ); &nbsp; workspaceFactory2 = Activator.CreateInstance( factoryType ) as IWorkspaceFactory2; &nbsp; workspace = workspaceFactory2.OpenFromString( this.connection, 0 ); &nbsp; sqlWorkspace = workspace as ISqlWorkspace; &nbsp; // manage releasable objects &nbsp; comReleaser.ManageLifetime( workspaceFactory2 ); &nbsp; comReleaser.ManageLifetime( sqlWorkspace ); &nbsp; // prepare query &nbsp; IQueryDescription queryDescription = sqlWorkspace.GetQueryDescription( query ); &nbsp; queryDescription.OIDFields = keyFieldName; &nbsp; // get a unique name &nbsp; string datasetName = "S"; &nbsp; sqlWorkspace.CheckDatasetName( "S", queryDescription, out datasetName ); &nbsp; // execute&nbsp; &nbsp; table = sqlWorkspace.OpenQueryClass( datasetName, queryDescription );&nbsp; }&nbsp; return table; }</PRE><DIV style="display:none;"> </DIV></BODY></HTML> Fri, 16 Mar 2012 17:30:08 GMT https://community.esri.com/t5/arcobjects-sdk-questions/still-confused-please-help-connect-to-sde-and-get/m-p/16707#M373 GeorgeFaraj 2012-03-16T17:30:08Z