Sibeesh Passion

Monthly Archives: February 2016

Custom Deferred Grid Using MVC Web API And Angular JS

  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

         In this article we are going to see how to create a custom deferred grid in MVC using Web API and Angular JS. We will be creating a custom UI for the grid and using web API and angular JS $http services we will fetch the data from the database. Normally we uses ADO.Net Entity […]

Read More

Stored Procedure With Common Table Expression Or CTE

  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

         In this post we will see how to use common table expression or CTE in our SQL Server. There are so many situations that you may need to use a common table expression. I had a situation of returning ROW_NUMBER variable value for my paging query in SQL, for this I used CTE. A common […]

Read More

TagIt Control With Data From Database Using Angular JS In MVC Web API

  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

         In this article we will learn how to load the tags from database in MVC Web API using Angular JS. Here we are going to use a pretty control called tagIt which does the tag part easier with a lot of configuration options. This article use a normal MVC application which includes the Web API […]

Read More

jQuery Datatable With Server Side Data

  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

         In this article we will learn how we can work with jQuery Datatables with server side data. Here we are going to use a MVC application with jQuery and other required packages installed in it. If you are new to MVC, You can always get the tips/tricks/blogs about that hereMVC Tips, Tricks, Blogs. jQuery Datatables […]

Read More

Programmatically Extract or Unzip Zip,Rar Files And Check

  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

         In this pose we will see how we can extract or unzip the uploaded files and check for some files in it in a in a programmatic manner. We will use a normal MVC application to work with this demo. We will use Microsoft System.IO.Compression, System.IO.Compression.FileSystem namespaces and the classes, for example ZipArchive, in the […]

Read More

Change Page Layout Dynamically Using jQuery Layout Plug in

  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

         In this post we are going to see how we can change the layout a page dynamically, with out writing any CSS styles for the page. Sounds cool right? Are you afraid of writing the CSS styles which will suit for all the screens like Mobiles, Tabs, Monitors, High resolution? As I am not a […]

Read More

Find Datatype Of Each Measures In SSAS MDX Queries

  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

         In this post we will see how we can get the datatype of each measures we use in our SSAS MDX Queries. This post may be helpful if you are working with SSAS cubes especially you need to work with the data you gets from the cubes like formatting the data, assigning the data as […]

Read More

Generate Database Scripts With Data In SQL Server

  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

         In this post we will discuss about how we can generate SQL Server scripts of our database with existing data, once we generate the script, the result will give you all the insert query with other queries so that the data also will get inserted in your new database. We are going to use the […]

Read More

Dynamically Apply Colour Coding in Grid With Dynamic Headers And Data

  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

         In this post we will see how we can apply colour coding dynamically to jQWidgets jQXGrid. Normally a grid control can be used when you need to formulate the data either in row wise or column wise. Here in this pose we will discuss how to differentiate some rows of the grid from the other […]

Read More

How To Create Dynamic Angular JS Tabs In MVC

  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

         In this post we will see how we can create Angular JS dynamics tabs in MVC application. As you all are aware of that we have a tab control in Angular JS, here we are going to see how those tabs can be created dynamically with some dynamic data, these dynamic data can be fetched […]

Read More
Footer With Address And Phones