how to create pdf viewer in c# : Copy text from pdf with formatting SDK control service wpf azure web page dnn MapInfoProUserGuide18-part1778

CreatingaDataSourceConnectiontoSQLServer
CreatingaDataSourceConnectiontoPostGIS
CreatingaDataSourceConnectiontoOracle
Whenyouconnecttoadataserver,youwillhavetwochoices:tousewindowsauthentication
ortoprovideausernameandpassworduniquetothedataserver.Windowsauthenticationis
theusernameandpasswordyouusetologintoyournetwork.Dependingonhowyourdatabase
serverissetup,youmayonlyrequireyourwindowsauthenticationtologin.Otherwise,you
wouldprovideausernameandpasswordthatisuniquetotheserver.Yourdatabase
administratorwilltellyouwhetherornotyoucanuseyourwindowsauthenticationorausername
andpasswordspecifictotheserver.
2. CreatingaMapCatalogintheDBMStoWorkwithData
Yourdatabaseadministratormayneedtograntyouspecificaccessprivilegestothedatabase
toworkwiththedata.Thefollowingsectiongivesdetails:
BeforeyouBeginCreatingaMapCatalogTable.
3. AddingaSpatialPrimaryKeytoaDBMSTable
ToviewyourdataonamapinMapInfoProitmustcontaingeometrydata(polygonregions)or
XandYdata(coordinates,suchasLatitudeandLongitudevalues).Thisiswhatdisplaysonthe
mapasregionsorpoints.ThegeometrycolumnorXandYcolumnsmusthavespecificnames
forMapInfoProtorecognizethem,andthetablerequiresauniquespatialprimarykeyforMapInfo
Protoreferencethedataonamap.
4. MakingaDBMSTableMappabletoDisplayitonaMap
AccessyourData
Aftersettingupyourdatabaseconnection,youarereadytoworkwithyourdatainMapInfoPro,
seeOpeningaDBMSTableinMapInfoPro.
Fordetails,see:
WorkingwithSQLServerTables
WorkingwithPostGISTables
WorkingwithOracleSpatialTables
Ifyourdataincludesspatialdata,whichcanbecolumnsholdingXandYvalues,suchas
Latitude/Longitude,oracolumnholdingsptialdataintheformatspecifiedbythedatabasesystem.
Withnospatialinformation,youcanworkwithyourdatainatablebrowser(aBrowserwindow)in
MapInfoPro.
Ifyourdatadoesnotincludecoordinateinformation,thenconsidergeocoding,addingthecoordinate
information,usingaPitneyBowesSoftwareproduct,suchasMapMarkerorSpectrum.
181
MapInfoPro15.0
MapInfoProUserGuide
WorkingwithDatainaDBMS
Copy text from pdf with formatting - extract text content from PDF file in C#.net, ASP.NET, MVC, Ajax, WinForms, WPF
Feel Free to Extract Text from PDF Page, Page Region or the Whole PDF File
cut and paste pdf text; extract text from image pdf file
Copy text from pdf with formatting - VB.NET PDF Text Extract Library: extract text content from PDF file in vb.net, ASP.NET, MVC, Ajax, WinForms, WPF
How to Extract Text from PDF with VB.NET Sample Codes in .NET Application
get text from pdf into excel; edit pdf replace text
Requirements
Whenaccessingremotedatasources:
•ThetableyouaccessmusthaveaspatialcolumnortwonumericcolumnstoholdXandY
coordinatevalues.
•TheviewmusthaveakeycolumnnamedMI_PRINXtomaketheviewmappable.
PostGISusers:MapInfoProtreatsallviewsinaPostGISdatabaseasreadonly,becausethere
isnowaytodetermineiftheviewcanbeusedforupdate.
Creating a Data Source Connection
ThefirststeptoworkingwithdatainaDBMSissettingupadatasourceconnectiononyourmachine
totheDBMS.ThisisnecessaryforaDBMSinstalledontoyourmachineoronthenetwork.SQL
ServerandPostGISrequireanOpenDatabaseConnectivity(ODBC)connectionandOracleSpatial
requiresanOracleCallInterface(OCI)connection.
UseanOCIconnectiontoOracleforspatialdata.YoucanuseanODBCconnectiontoany
ODBCcompatibledatabaseandtoolderversionsofOraclewithnon-spatialdata.
Note:
YoumusthavetheODBCdriverorOCIinstalledonyourmachinebeforecreatingadatasource
connection.MapInfoProinstallsorupdatesWindowsODBCdriversiftheyareolderthantheversion
thatMapInfoProsupports.Fornon-Windowsdatabases,suchasOracleandPostgreSQLwith
PostGIS,consultwithyourdatabaseadministratorforinformationonhowtoobtainandinstallthe
driverprovidedwithyourdatabase.
Youcancreateadatasourceconnection:
•ThroughMapInfoPro'sinterface.
•ThroughEasyLoader'sinterface,seetheEasyLoaderUserGuide.
•FromyourMicrosoftStartmenu,byselectingStart>ControlPanel>AdministrativeTools>
DataSources(ODBC).
YoumustsetupadatasourceconnectionforeachDBMSthatyouplantoworkwith.
CreatingaDataSourceConnectiontoSQLServer
Beforeyoubegin,youneedaSQLServerdriverinstalledonyourmachine.Checkwithyourdatabase
administratortoinstallthedriverforyourdatabase.
YouneedtoknowtheSQLServername,andtheloginIDandpasswordifrequired.
TocreateanewSQLServerdatasourceconnection:
182
MapInfoPro15.0
MapInfoProUserGuide
WorkingwithDatainaDBMS
C# PDF Convert to Text SDK: Convert PDF to txt files in C#.net
other C# .NET PDF to text conversion controls, RasterEdge C# PDF to text converter control toolkit can convert PDF document to text file with good formatting.
copy text pdf; copy text from pdf with formatting
VB.NET Create PDF from Excel Library to convert xlsx, xls to PDF
pages edit, C#.NET PDF pages extract, copy, paste, C# NET rotate PDF pages, C#.NET search text in PDF all Excel spreadsheet into high quality PDF without losing
export highlighted text from pdf; copy text from scanned pdf to word
1. FromtheFilemenu,selectOpenDBMSConnection.
2. IftheOpenDBMSConnectiondialogboxdisplays,selectODBCfromthelistandthenclick
New.
3. IntheSelectDataSourcedialogbox,selecteithertheFileDataSourceortheMachineData
SourcetabandthenclickNew.
Youcansharetheconnectioninformationforafiledatasourcewithotherusersonthenetwork
iftheyhavethenecessarydrivers,becauseitisstoredinafile.Youcannotsharetheconnection
informationforamachinedatasource,becauseitisstoredintheregistryonthelocalcomputer.
4. IntheCreateNewDataSourcewizard:
183
MapInfoPro15.0
MapInfoProUserGuide
WorkingwithDatainaDBMS
C# PDF Convert to HTML SDK: Convert PDF to html files in C#.net
file. Besides, the converted HTML webpage will have original formatting and interrelation of text and graphical elements of the PDF.
cut text from pdf document; get text from pdf online
VB.NET PDF Convert to Word SDK: Convert PDF to Word library in vb.
application. In addition, texts, pictures and font formatting of source PDF file are accurately retained in converted Word document file.
copy highlighted text from pdf; extract text from pdf c#
Selectthetypeofdatasourcetocreate:UserDataSourceorSystemDataSource.Make
aselectiontodisplaythedescriptionforitinthewizard.ClickNexttocontinue.
a.
b.Fromthedrivernamelist,selecttheSQLServerdriveryouhaveinstalledforthedatabase
andthenclickNext.
c. ClickFinish.
5. IntheCreateaNewDataSourcetoSQLServerwizardsetthefollowing.Ifyouareunsureof
thesettingstouseforyourdatabase,consultwithyourdatabaseadministrator.
a. Inthefirstscreenprovidethefollowinginformation:
Description-Optionally,typeadescriptionifyouplanonconnectingtomorethanone
databaseandwouldlikeadescriptionforthisconnection.
FromtheServerlisteitherselectfromthelistortypethenameoftheSQLServertoconnect
to.
ClickNext.
b.Inthenextscreen,selecthowSQLServerwillverifytheauthenticityoftheloginID.
OptionallyselecttoconnecttoSQLServertoobtaindefaultsettingsformoreconfiguration
options.
ClickNext.
c. Keepthedefaultsettings(checkwithyourdatabaseadministrator)andclickNext.
d.Keepthedefaultsettings(checkwithyourdatabaseadministrator)andclickFinish.
184
MapInfoPro15.0
MapInfoProUserGuide
WorkingwithDatainaDBMS
C# Create PDF from Word Library to convert docx, doc to PDF in C#.
A convenient C#.NET control able to turn all Word text and image content into high quality PDF without losing formatting. Convert
copy text from protected pdf to word; get text from pdf image
C# Create PDF from PowerPoint Library to convert pptx, ppt to PDF
Excellent .NET control for turning all PowerPoint presentation into high quality PDF without losing formatting in C#.NET Class. Convert
copy text from pdf without formatting; cut text pdf
6. IntheODBCMicrosoftSQLServerSetupdialogbox,clickTestDataSource.
7. IntheSQLServerODBCDataSourceTestdialogbox,clickOK.
Iftherewereerrors,clickOKtoreturntotheODBCMicrosoftSQLServerSetupdialogbox.
ClickCanceltoreturntotheCreateaNewDataSourcetoSQLServerwizardandusethe
Backbuttontoviewyoursettingsandmakechanges.Returntostep5.
8. IntheODBCMicrosoftSQLServerSetupdialogbox,clickOK.
9. IntheSelectDataSourcedialogbox,undertheMachineDataSourcetab,yournewSQLServer
connectiondisplaysinthelistofavailabledatasourceconnections.ClickOK.
10.IntheSQLServerLogindialogbox,typeyourloginIDandpasswordifrequiredandclickOK.
Youmustnowcreateamapcatalogforthedatabase,continuetoCreatingaMapCatalogTable
UsingEasyLoader.
CreatingaDataSourceConnectiontoPostGIS
Beforeyoubegin,youneedaPostgreSQLANSIODBCdriver(psqlODBC)installedonyourmachine.
Checkwithyourdatabaseadministratortoinstallthedriverforyourdatabase.Ensurethatyour
databaseadministratoraddsyourmachineIPaddresstothepg_hba.conffileforthedatabaseyou
wanttoconnectto.
Youneedtoknowthedatabasename,servername,usernameandpasswordtothedatabase,and
whetherornotyouneedaspecificSSLModeorPortnumber.
TocreateanewPostgreSQLPostGISdatasourceconnection:
1. FromtheFilemenu,selectOpenDBMSConnection.
2. IftheOpenDBMSConnectiondialogboxdisplays,selectODBCfromthelistandthenclick
New.
185
MapInfoPro15.0
MapInfoProUserGuide
WorkingwithDatainaDBMS
C# Create PDF from Excel Library to convert xlsx, xls to PDF in C#
Turn all Excel spreadsheet into high quality PDF without losing formatting. Evaluation library and components for PDF creation from Excel in C#.NET framework.
cut and paste text from pdf; extract text from pdf
VB.NET Create PDF from PowerPoint Library to convert pptx, ppt to
Remove Image from PDF Page. Image: Copy, Paste, Cut PDF, VB.NET convert PDF to text, VB.NET all PowerPoint presentation into high quality PDF without losing
copy text from pdf in preview; extract text from pdf file using java
3. IntheSelectDataSourcedialogbox,selecteithertheFileDataSourceortheMachineData
SourcetabandthenclickNew.
Youcansharetheconnectioninformationforafiledatasourcewithotherusersonthenetwork
iftheyhavethenecessarydrivers,becauseitisstoredinafile.Youcannotsharetheconnection
informationforamachinedatasource,becauseitisstoredintheregistryonthelocalcomputer.
4. IntheCreateNewDataSourcewizard:
a. Selectthetypeofdatasourcetocreate:UserDataSourceorSystemDataSource.Make
aselectiontodisplaythedescriptionforitinthewizard.ClickNexttocontinue.
b.Fromthedrivernamelist,selectthePostgreSQLANSIdriverandthenclickNext.
c. ClickFinish.
186
MapInfoPro15.0
MapInfoProUserGuide
WorkingwithDatainaDBMS
VB.NET Create PDF from Word Library to convert docx, doc to PDF in
Image to PDF. Image: Remove Image from PDF Page. Image: Copy, Paste, Cut Export all Word text and image content into high quality PDF without losing
a pdf text extractor; export text from pdf to excel
VB.NET Word: Extract Text from Microsoft Word Document in VB.NET
time and effort compared with traditional copy and paste VB.NET. Apart from extracting text from Word powerful & profession imaging controls, PDF document, tiff
delete text from pdf; delete text from pdf preview
5. InthePostgreSQLANSIODBCDriver(psqlODBC)Setupdialogbox,setthefollowing.Ifyou
areunsureofthesettingstouseforyourdatabase,consultwithyourdatabaseadministrator.
•DataSource-Provideanameforthisdatasource.Thisisthenameyouwillseeaftersetting
upthisconnectionintheSelectDataSourcedialogbox.
•Database-ThenameofthePostGISdatabasethatyouwanttoconnectto.
•Server-ThenameofthemachinewherePostGISisinstalled.
•UserName-Theusernameforaccessingthedatabase.
•Password-Thepasswordforaccessingthedatabase.
•Description-Optionally,typeadescriptionifyouplanonconnectingtomorethanonedatabase
andwouldlikeadescriptionforthisconnection.
•SSLMode-Usethedefaultvalue.
•Port-Usethedefaultvalue.
ClickTesttoensurethatyourconnectionworks.
ClickDatasource(orConnectiondependingonthePostGISdriver).
6. IntheAdvancedOptionsdialogbox,selecttheUseDeclare/Fetchcheckboxandthenclick
OK.
Selectingthisoptionimprovestheprocessingtimewhenconnectingtolargerdatabases.
7. InthePostgreSQLANSIODBCDriver(psqlODBC)Setupdialogbox,clickSavetosetyour
connection.
8. IntheSelectDataSourcedialogbox,undertheMachineDataSourcetab,yournewPostGIS
connectiondisplaysinthelistofavailabledatasourceconnections.ClickOK.
Youmustnowcreateamapcatalogforthedatabase,continuetoCreatingaMapCatalogTable
UsingEasyLoader.
187
MapInfoPro15.0
MapInfoProUserGuide
WorkingwithDatainaDBMS
CreatingaDataSourceConnectiontoOracle
Beforeyoubegin,youwillneedthefollowinginstalledonyourmachine:
•OracleClient-connectstoanOracledatabase.
•TCP\IP-acommunicationsprotocolrequiredbyOracleClienttocommunicateonthenetwork
•OracleSQL*Net-forperformingSQLqueriestothedatabase(optional).
Haveyourdatabaseadministratorcheckthatthe:
•tnsnames.orafileiscorrectlyconfiguredonyourmachinefortheserveryouwanttoconnectto.
•Servicetothedatabaseisconfigured-theymayneedtoruntheNetConfigurationAssistantutility
thatOracleprovidestoconfiguretheservice.
•TCP\IPworkingproperly(usingping.exe).
•EnvironmentvariableTNS_ADMINiscorrectlysettoyourclient_1path(theOracleClientinstallation
directory).
TocreateanewOracleSpatialdatasourceconnection,setupyourOracleDriver:
1. OntheStartmenu,pointtoAllPrograms,clickOracle...,clickConfigurationandMigration
Tools,andthenclickMicrosoftODBCAdministrator.
2. IntheODBCDataSourceAdministrator,undertheUserDSNtab,clickAdd.
3. IntheCreateNewDataSourcewizard:
a. Fromthedrivernamelist,selecttheOracleinOraClientdriverandthenclickNext.
b.ClickFinishtoinstallthedriver.
4. IntheODBCTextSetupdialogbox,setthefollowing:
•DataSourceName-Provideanameforthisdatasource.Thisisthenameyouwillseeafter
settingupthisconnectionintheSelectDataSourcedialogbox.
•Description-Optionally,typeadescriptionifyouplanonconnectingtomorethanonedatabase
andwouldlikeadescriptionforthisconnection.
ClickOK.
TosetupyourOracleSpatialconnectioninMapInfoPro:
1. FromtheFilemenu,selectOpenDBMSConnection.
2. IntheOpenDBMSConnectiondialogbox,selectOracleSpatialfromthelistandthenclick
New.
3. IntheMapInfoOracleConnectdialogboxenterthefollowinginformation:
•UserName-Theusernameforaccessingthedatabase.
•Password-Thepasswordforaccessingthedatabase.
•ServerName-ThenameoftheOracledatabasethatyouwanttoconnectto.
Optionally,checktheUseOperatingSystemAuthenticationcheckboxtouseyourWindows
authenticationwhenaccessingthisOracledatabase.
188
MapInfoPro15.0
MapInfoProUserGuide
WorkingwithDatainaDBMS
ClickOK.
YouhaveanactiveconnectiontoyourOracledatabase.Youmustnowcreateamapcatalogfor
thedatabase,continuetoCreatingaMapCatalogTableUsingEasyLoader.
IntheMapInfoOracleConnectdialogbox,youhavetheoptiontochecktheUseOperatingSystem
Authenticationcheckbox.WithOSauthentication,yourdatabasereliesontheunderlyingoperating
systemtorestrictaccesstodatabaseaccounts.Adatabasepasswordisnotusedforthistypeof
login.Foradditionalinformation,refertoOracleOperatingSystemAuthenticationand
Configuration.
CreatingaDataSourceConnectiontoMicrosoftAccess
YoucanworkwithyourMicrosoftAccessdatabasefromMapInfoProthroughanODBCconnection.
MicrosoftAccessdoesnotallowspatialdata,butyoucandisplayinMapInfoProdatathathasX
andYcoordinatevaluesassociatedwithit.
BeforeyouBegin
Beforeyoubegin,youmusthavetheMicrosoftAccessDriverinstalledonyourmachine-thedriver
isinstalledbydefaultwithyourMicrosoftAccess.ThedriverisnecessaryforestablishinganODBC
connectiontothedatasource.
Tocheckthatthedriverisinstalledonyourmachine,runtheODBCAdministrator:
1. OpentheControlPanel;fromtheStartmenuselectControlPanel.
2. IntheControlPanel,intheClassicView,selectAdministrativeToolsandthenDataSources
ODBC(ODBC).
3. IntheDataSourcesODBCAdministratordialogbox,selecttheUserDSNtab.
4. Inthelist,locateandselecttheMSAccessDatabase.Or,ifyoudonotseethisname,then
undertheDriverlistlookforMicrosoftAccessDriver(.mdbor.accdb).
5. ClickConfiguretoensurethatitisproperlysetup.
Ifthedriverisnotthere,thenclickAddtocheckiftheAccessdriverisinstalled.Youmayneedto
installtheMicrosoftAccessdrivers.TheseareincludedwithMicrosoftAccess,MicrosoftOffice
Professional,ODBCSDK,VisualC++,MapInfoPro,orpurchasedseparately.
Toverifyifthisistherequiredversionofthisdriver,selecttheDriverstabintheODBCAdministrator.
LocatetheMSAccessDriver(.MDBor.ACCDB)andcheckthatitisthelatestversion.
ToaddanewMicrosoftAccessDataSource:
1. RuntheODBCAdministrator.
2. UndertheUserDSNtab,clickAdd.
3. IntheCreateNewDataSourcewizard,selectMSAccessDriver(.MDBor.ACCDB)fromthe
listandclickFinish.
189
MapInfoPro15.0
MapInfoProUserGuide
WorkingwithDatainaDBMS
4. IntheODBCMicrosoftAccessSetupdialogbox,intheDataSourceNamebox,typeina
nameforthedatasource.(Thisisthenamethatappearsinthelistwhenyouconnectfrom
MapInfoPro.)ClickSelect.
5. IntheSelectDatabasedialogbox,selecttheMicrosoftAccessdatabaseyouwishtouseand
thenclickOK.
Ifyoudonotselectadatabaseforthisdatasource,apromptdisplaysduringtheconnectionto
doso.MapInfoProprovidesasampleMicrosoftAccessdatabase.
Limitation
inMicrosoftAccess,ifthekeyissettocharacter,thenitdoesnotdisplayrowswhenthekeyvalue
islessthanthefullcolumnwidth:forexample,ifthekeyissettochar(5),thenthevalue`aaaa'looks
likeadeletedrow.
Reconnecting to your Data Source after Startup
EachtimeyoustartMapInfoPro,youmustsettheconnectiontoyourdatabasebeforeyoucanwork
withtables.TheconnectionremainsactivewhileMapInfoProisopen.Theconnectioncloseswhen
youexitMapInfoPro.
ThefollowinginstructionsareapplicabletoSQLServerandPostGISusers.Oracleusers,see
ConnectingtoOracleafterRe-StartingMapInfoPro.
Toopenaconnectiontoyourdatabase:
1. FromtheFilemenu,selectOpenDBMSConnection.
2. IftheOpenDBMSConnectiondialogboxdisplays,selectODBCfromthelistandthenclick
New.
3. IntheSelectDataSourcedialogbox:
a. SelecttheMachineDataSourcetab.
b.FromtheDataSourcenamelist,selectyourconnectionname.
c. ClickOK.
Youmayseealogindialogboxforyourdatabaseconnection.Ifyouseethisdialog,then
providetheinformationrequired,suchasusernameandpasswordforthedatabase.For
example,SQLServerusersmayseethefollowing:
190
MapInfoPro15.0
MapInfoProUserGuide
WorkingwithDatainaDBMS
Documents you may be interested
Documents you may be interested