Posts

Showing posts from December, 2012

Display SQL table in InfoPath form - Part Two

Image
To display SQL tables in read only format inside an browser enabled infopath form , follow the below steps. The Article is divided into 2 parts of posts.  1) Part One 2) Part Two Continuing from Part One.... 11) Select the fields to display in the infopath and click next and next to finish the wizard. 12) Go to data → And click Show Fields 13) In the Fields , Select the database fields which we added now. Step 14) After selecting the database fields , Click the repeating table (in our case d.emp) and drag it to the design form step 15) After drag and dropping select the Repeating Table Step 16) All the database columns are displayed in the repeating table format step 17) Select the Name text field and click properties and in properties click on the display tab. Under display tab make it read only. Like wise do the same to the remaining filelds. ...

Display SQL table in InfoPath form - Part One

Image
To display SQL tables in read only format inside an browser enabled infopath form , follow the below steps. The Article is divided into 2 parts of posts.  1) Part One 2) Part Two 1) Create a database and create table in SQL server. I have create a sample employee table 2) Entered the sample values to the SQL table 3) Now backend work is done. We need to design the infopath form. Open the Infopath designer Go to Data → Data Connections → Add new Connection → Check on receive data and click next 4) Select the source as database and click next 5) In the data connection wizard click on Select Database. 6)       In Select data source click on New Source. 7) In Data Connection Wizard Select the Microsoft SQL server and click next 8) Mention the database Server details and click next 9) Select the database name and click th...

Display PDF icon in Sharepoint 2010

Image
In sharepoint 2010 we will not get the PDF symbol as type for PDF files. This looks odd. To avoid this follow the below steps. 1) Download a 16X16 icon image for PDF. And paste this icon image in the SharePoint server inside the below given path of folder. C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\IMAGES\ 2) Open the DOCICON.xml file from the XML folder . Path: C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\XML\ Open in Notepad.     3) Inside the DOCICON file find the below </ByExtension> and update this <Mapping Key="pdf" Value="iconPDF.gif"/> above the <ByExtension> 4) Reset the IIS. And see the results for PDF icons.