SQL - Raj Kaimal

Browse by Tags

All Tags » SQL (RSS)
Saturday, May 15, 2010 4:57 AM

Pre-filtering and shaping OData feeds using WCF Data Services and the Entity Framework - Part 2

In the previous post , you saw how to create an OData feed and pre-filter the data. In this post, we will see how to shape the data. A sample project is attached at the bottom of this post. Pre-filtering and shaping OData feeds using WCF Data Services...
Posted by rajbk | 7 comment(s)
Filed under: , , , ,
Saturday, May 15, 2010 4:49 AM

Pre-filtering and shaping OData feeds using WCF Data Services and the Entity Framework - Part 1

The Open Data Protocol , referred to as OData , is a new data-sharing standard that breaks down silos and fosters an interoperative ecosystem for data consumers (clients) and producers (services) that is far more powerful than currently possible. It enables...
Posted by rajbk | 5 comment(s)
Filed under: , , , ,
Wednesday, May 12, 2010 10:34 PM

Adding a hyperlink in a client report definition file (RDLC)

This post shows you how to add a hyperlink to your RDLC report. In a previous post , I showed you how to create an RDLC report. We have been given the requirement to the report we created earlier , the Northwind Product report, to add a column that will...
Posted by rajbk | 5 comment(s)
Filed under: , , ,
Sunday, May 09, 2010 11:14 PM

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...
Posted by rajbk | 12 comment(s)
Filed under: , , , , , , , ,
Sunday, May 09, 2010 11:14 PM

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: , , , ,
Sunday, May 09, 2010 11:13 PM

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

This tutorial walks you through creating an ASP.NET report based on the Northwind sample database. It shows how to add a client report definition file (RDLC), create a dataset for the RDLC, define queries using LINQ to Entities, design the report and...
Posted by rajbk | 21 comment(s)
Filed under: , , , , ,
Friday, March 12, 2010 10:28 PM

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: , , ,
Saturday, February 20, 2010 11:31 PM

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: , , , , ,
Wednesday, November 25, 2009 1:21 AM

Rendering an RDLC directly to the Response stream in ASP.NET MVC

The following post shows you how to render an RDLC (Client Report Definition File) in a MVC project. For this tutorial, I am using VS 2008 with MVC 2 Beta . I will also be using the priceless Northwind database and the report will contain a list of customers...
Posted by rajbk | 12 comment(s)
Filed under: , , , , , ,
Thursday, July 16, 2009 11:25 AM

Altering Indexed Views - Gotcha

According to BOL , “ALTER VIEW can be applied to indexed views; however, ALTER VIEW unconditionally drops all indexes on the view .” We can see this behavior by creating an indexed view using the Northwind database. The script is shown below: CREATE VIEW...
Posted by rajbk | with no comments
Filed under: ,
More Posts Next page »