Recent Posts

Friday, July 24, 2015

How to use multiple Kendo UI Grid MVC in single view page that has export facility using free version

Kendo UI for MVC is paid version and since i was exploring the free version of the Kendo UI grid in MVC. I figured out this code that grabs data from the controller and displays multiple grid in the view and can export data from both the grids to excel with desired file name.

To do this I am not going to show how you are going to grab the data from the database but i will only display the controller code and the view code...
... 1. First of all include the .js and .css file in _Layout.cshtml page
2. Controller code
        1. First thing is to reference DocumentFormat.OpenXml.Packaging you can install it via NuGet Packages (right click on your solution and select Manage NuGet Packages and search for DocumentFomat.OpenXML and install it.




2. Next thing to note is you must return the view else if you just return the data then it will only display json result on the screen


         3. Return json result for the data for two grids I have GetCars and GetOtherCars here in my code
       4. Now insert the code to render the excel file (full code is found in the full working project attached at the bottom of this blog post)
       5. Now in the View (Index.cshtml) insert two grids where you should note is disable odata and mention excel export (full code is found in the full working project attached at the bottom of this blog post)
                           //  type: "odata",



Download Full Source code to display multiple Kendo UI MVC Grid in same View page using free version of Kendo UI





Read more!

Loading bar is not displayed in kendo UI grid while not setting default height

When i removed the default height of Kendo UI Grid to "Increase the height of kendo UI grid to full page to display all records of grid" I faced another problem.

The loading image in Kendo UI grid was not displaying and the grid initially collapsed. This created the impression that the Kendo UI Grid was not loading at all so there was a great chance that users were distracted from the page.

To fix this issue I figured out just place one css code mentioned below that sets the min height of the grid so the Kendo UI grid displays the loading bar and after the data is loaded everything is all good..

Css Code to set min height of the Kendo Ui Grid is as follows:
  .k-grid-content {
        /*For setting min height to see the loader so that user are not distracted if the grid is loading or not*/
    min-height: 200px;
}


Read more!

Increase the height of kendo UI grid to full page to display all records of grid

First of Kendo UI grid is set to fixed height and when you have enabled paging then say it will show 5,10,15 or All records when selecting on the drop down list.

When we select the number from the list and the records are more than the height of the grid then the records move inside the scroll bar which was not my option for the grid.

I wanted to display all the records without the scroll bar appearing and expand the grid to show all the records selected without the scroll bar. Say if i select "All" then the grid should expand vertically to full length of the page.

To achieve this you must do following for your grid
1. Remove the height of the grid
   _grid = $("#grid").kendoExcelGrid({
               // height: $(document).height()-100,
2. Since the grid should expand and contract based on the number of rows we don't need vertical scroll bar to do this use the following css:
#grid .k-grid-header
    {
      padding: 0 !important;
    }

    #grid .k-grid-content
    {
        /*don't show the disabled scollbar at the right to make grid look clean*/
        overflow-y: visible;
    }
Now you are able to expand Kendo UI grid vertically when you select all records


Read more!

Thursday, July 23, 2015

How to Find the Wi-Fi Password of your Current Network



Sometimes you forget your own wi-fi password when it has been setup for very long time in the past and it would be very uncomfortable if someone asks for password to connect to their mobile and you say "mmm I don't remember".

I have forgotten wi-fi password for many time and this situation has come to me many times.

Now i luckily found out the blog by Amit Agrawal (thanks to him) that has solved this problem.

To Find the Wi-Fi password on windows do following 


  1. Go to Start and type cmd on search and when cmd.exe appears right click and click Run as Administrator
  2. Type the following text: netsh wlan show profile name=myWLan key=clear
  3. Then press Enter and you will see your password in the field called Key Content

( "myWLan" is the Wi-Fi network you are connected in)

For more.. and lean how to retrieve wi-fi password in MAC please refer to Amit's Blog in following link:
http://www.labnol.org/software/find-wi-fi-network-password/28949/


Read more!

Tuesday, March 26, 2013

How to extract Sharepoint list using SQL Query

I was searching for Sql query to be able to extract the list from Sharepoint database and found a good link that helped me fix the issue

Querying Sharepoint List Item Versions using SQL

Which actually gives the info on list and full sql query to get the list is here:
Hope this helps... enjoy


Declare @ListID as uniqueidentifier

SET @ListID =(SELECT tp_id FROM dbo.AllLists WHERE tp_title ='New User Request')
   --select @ListID
   
   
SELECT      dbo.UserData.tp_ID,
  dbo.UserData.tp_ListId,
  dbo.UserData.tp_Author,
  dbo.UserData.nvarchar1,
                dbo.UserData.nvarchar2,
  dbo.UserData.nvarchar3,
  dbo.UserData.nvarchar4,
  dbo.UserData.nvarchar5,
                dbo.UserData.nvarchar6,
  dbo.UserData.nvarchar7,
  dbo.UserData.nvarchar8,
  dbo.UserData.nvarchar9 ,
                dbo.UserData.nvarchar10,
  dbo.UserData.nvarchar11,
  dbo.UserData.nvarchar12,
  dbo.UserData.*                  --dont forget to modify this to snatch only the columns you need
FROM            dbo.Lists
INNER JOIN
                dbo.UserData ON dbo.Lists.tp_ID = dbo.UserData.tp_ListId
               
               
WHERE  
(dbo.UserData.tp_ListId =@ListID)


Read more!