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

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 then select the table inside database.. Click next





10) Finish the data connection wizard.


Read the remaining post in Part two....!

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.