Thursday, April 22, 2010

Filter in List View using Query String

Filter in List View using Query String

It’s very easy to filter in built list view web part OR SPList in UI.
Below query string is filter list.
?FilterField1=[Internal Field Name]&FilterValue1=[Value of Filter Field]
For more understanding let’s take one example.
Here I created one sample List which contains Title, Date, City and Country Columns as per below.

Now I want to filter on Country Column so query string looks like
?FilterField1=Country&FilterValue1=USA
Happy Coding !!!

Monday, April 12, 2010

SharePoint Site Cannot connect to configuration database


Error Message : Cannot connect to configuration database


Cause : When you try to open SharePoint site below error fire on your screen that means your Site can't connect SQL Server Database.




Resolution : Check your SQL instance Service from MS Services. If stopped SQL instance Service then Start it.

Example: Start > type this in RUN "services.msc " > as per below SQL Instance Start it from property.

Happy Coding !!!