Posts

Showing posts from 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.




SharePoint Server features and differences

SP FOUNDATION SERVER SP STANDARD SERVER SP ENTERPRISE SERVER
Accessibility Blogs Browser-based Customizations Business Connectivity Services Business Data Connectivity Service Claims-Based Authentication Client Object Model (OM) Configuration Wizards Connections to Microsoft Office Clients Connections to Office Communication Server and Exchange Cross-Browser Support Developer Dashboard Discussions Event Receivers External Data Column External Lists High-Availability Architecture Improved Backup and Restore Improved Setup and Configuration Language Integrated Query (LINQ) for SharePoint Large List Scalability and Management Managed Accounts Mobile Connectivity Multilingual User Interface Multi-Tenancy Out-of-the-Box Web Parts Patch Management Permissions Management Photos and Presence Quota Templates Read-Only Database Support Remote Blob Storage (SQL Feature) REST and ATOM Data Feeds Ribbon and Dialog Framework Sandboxed Solutions SharePoint Designer SharePoint Health Analyzer SharePoint Lists SharePoint Ribbon SharePoint…

Search SharePoint list or library using Jquery

Image
In this post I will be detailing on how to achieve the search inside a SharePoint list or document library using jquery in simple steps.
Step 1) Download these two files from the below link Click here to download jquery.min.js Click here to download jsapi.js
Step 2) Upload these two files in your SharePoint site’s document library.



Step 3) Now go to the list or library where search functionality needs to be added. And Click Site settings > Edit Page In the SP ribbon click on Insert > web Part In the categories of webpart select Media and content In webparts select Content Editor webpart and Click Add finally.


Step 4) Click on the Content Editor webpart and in the ribbon its properties are added.   Under format Text > Click HTML and click Edit HTML Source, a modal box opens up.


Step 5) Add the following code in the HTML source modal box and click OK.
<script src="YOUR SITE LINK TO jsapi.js"></script>
<script>

google.load("jquery", "1.2.6&quo…