Friday, December 30, 2016

Wednesday, December 28, 2016

Jquery DataTable paging Sorting and Multi search with datepicker in MVC server side

Previously I had shown how to use Jquery DataTable in MVC and Asp.Net

MVC:
Asp.Net:

The specified type member 'Date' is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported.

As the ERROR says:

The specified type member 'Date' is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported.

Error:
  

var CustomersLst = (from a in entities.Customers
    .Where(x => x.FirstName.Contains("VARA") &&
    x.LastName.Contains("REDDY") &&    
    x.JoiningDate.Date >= JDate.Date)    
    select
    {
     FirstName = a.FirstName,
     LastName = a.LastName,
     CreatedDate = a.CreatedDate
    });

Solution:

Monday, December 26, 2016

Asp.Net MVC with MongoDB

In the Previous Posts I had shown
Now in this post I will show how to Connect with MongoDB using MongoDBCSharpDriver in Asp.Net MVC and retrieve data from MongoDB.

OutPut:














Saturday, December 24, 2016

Error during serialization or deserialization using the JSON JavaScriptSerializer.

Error during serialization or deserialization using the JSON JavaScriptSerializer. The length of the string exceeds the value set on the maxJsonLength property.
























Friday, December 23, 2016

How to Display HTML Tags in BlogPosts

In this Post I will show how to Display HTML tags in the Blog Posts.

To Display the tags just replace them as shown below.


  1. Replace & character with &
  2. Replace < character with &lt;
  3. Replace > character with &gt;

Jquery DataTable in MVC

In the previous Posts I had shown how to use Jquery DataTable plugin in Asp.Net.


In this Post I will show how to populate Items in MVC with multi column search using Jquery DataTable.
To get the out put as shown below I used VS 2015, SQL server, Entity framework  and Jquery DataTable plugin.

OutPut :




















Friday, December 16, 2016

How to check mongodb is running or not

In the previous 2 POSTS we had shown


In this post we will show How to Check if MongoDB is running or not

Continuing the above 2 posts....

open command prompt and run the below command as shown below.

Then you can find its Shell Version, Server Version and Running Port.

Run MongoDB as Windows service

In the previous POST we had shown How to install MongoDB in Windows

http://reddyinfosoft.blogspot.in/2016/12/mongodb-installation-on-windows.html

Now in this post I will show how to ADD MongoDB as Service in windows



















Continuing the previous post...

GO to C:\MongoDB,  press "Shift Key and Right Click on Bin Folder",
Select Open command window here in the context menu and use the command as shown below.

MongoDB Installation on Windows

Here I am going to show you, how to Install MongoDB in Windows.

Go to MongoDB download Center as shown in the below link

https://www.mongodb.com/download-center#community

and select Windows Server 2008 R2 64-bit and later, with SSL support x64 from dropdown and download as shown in the below image.