LINQ - Raj Kaimal

Browse by Tags

All Tags » LINQ (RSS)

Adding an expression based image in a client report definition file (RDLC)

In previous posts, I showed you how to create a report using Visual Studio 2010 and how to add a hyperlink to the report .  In this post, I show you how to add an expression based image to each row of the report. This is similar to displaying a checkbox...
Posted by rajbk | 1 comment(s)

Creating an ASP.NET report using Visual Studio 2010 - Part 3

We continue building our report in this three part series. Creating an ASP.NET report using Visual Studio 2010 - Part 1 Creating an ASP.NET report using Visual Studio 2010 - Part 2 Adding the ReportViewer control and filter drop downs. Open the source...

Creating an ASP.NET report using Visual Studio 2010 - Part 2

We continue building our report in this three part series. Creating an ASP.NET report using Visual Studio 2010 - Part 1 Creating an ASP.NET report using Visual Studio 2010 - Part 3 Creating the Client Report Definition file (RDLC) Add a folder called...
Posted by rajbk | 7 comment(s)
Filed under: , , , ,

ASP.NET MVC Paging/Sorting/Filtering using the MVCContrib Grid and Pager

This post walks you through creating a UI for paging, sorting and filtering a list of data items. It makes use of the excellent MVCContrib Grid and Pager Html UI helpers. A sample project is attached at the bottom. Our UI will eventually look like this...
Posted by rajbk | 11 comment(s)

ASP.NET MVC Paging/Sorting/Filtering a list using ModelMetadata

This post looks at how to control paging, sorting and filtering when displaying a list of data by specifying attributes in your Model using the ASP.NET MVC framework and the excellent MVCContrib library . Please see this post for a way of rendering the...
Posted by rajbk | 3 comment(s)
Filed under: , , , ,

Securing an ASP.NET MVC 2 Application

This post attempts to look at some of the methods that can be used to secure an ASP.NET MVC 2 Application called Northwind Traders Human Resources . The sample code for the project is attached at the bottom of this post. We are going to use a slightly...
Posted by rajbk | 4 comment(s)
Filed under: , , , ,

Joins in LINQ to SQL

The following post shows how to write different types of joins in LINQ to SQL . I am using the Northwind database and LINQ to SQL for these examples. NorthwindDataContext dataContext = new NorthwindDataContext(); Inner Join var q1 = from c in dataContext...
Posted by rajbk | 4 comment(s)
Filed under: , , ,

Uploading and storing files in SQL using ASP.NET

Version: VS2008 SP1 The sample code at the bottom of this post shows you how to upload files and store them in a binary column in SQL using ASP.net webforms and LINQ. S ee this post if you wish to upload an excel file, extract data from the cells and...
Posted by rajbk | 6 comment(s)
Filed under: , , , , ,

LINQ to SQL Paging Gotcha

.csharpcode, .csharpcode pre { font-size: small; color: black; font-family: consolas, "Courier New", courier, monospace; background-color: #ffffff; /*white-space: pre;*/ } .csharpcode pre { margin: 0em; } .csharpcode .rem { color: #008000; } .csharpcode...
Posted by rajbk | 5 comment(s)
Filed under: , ,

FormView Binding Gotcha

Version: ASP.NET 3.5 SP1 This post describes two gotchas with the FormView control when binding: 1) When performing two way databinding, Null values and Nullables get changed to string.Empty in the FormView. 2) Two way binding is not supported for nested...
Posted by rajbk | 3 comment(s)
Filed under: , ,
More Posts Next page »