SQL Server 2005 Reporting Service.

There are lots tool available to develop reports. It has it's own advantage and disadvantage. One of most popular reporting tool is crystal report also has some limitation.

Microsoft has introduced a new way to develop the reports directly from sql server....SQL Reporting Service. It was there in sql server 2000 days but we have to add it as external service. Now with SQL Serve r2005 it is there with the sql server 2005 itself.

It supports all the features such as cross tab,sub reports etc...

Continue Reading

SQL Server 2005 Express Edition User Instances.

Sql Server Express edition is a small version of a sql server 2005 and that provides data storage capability up to 4 gb. It is easily ships with the each application so many users are using this version of sql server instead Microsoft access as a database for windows base application.
One of the problem using sql server instances is whenever you compile it will overwrite the existing database.

For Example, if you perform a insert operations from application and add new row to the database then again after compile the application. It will over right that database with older
database.

I have found a simple solutions to get rid of this problem. In solution browse to the database and select the database (.mdf files) then go to the property window. There is a property called 'Copy to output' select property and select 'Do not copy'.

Now when you compile the application it will not copy your older database to the bin directory.

Continue Reading

Display group header in every page of Crystal Report.NET

We have often used the crystal report as a reporting tool to create various reports.
We some time need our group header to display in each and every page. In crystal
reports right click crystal report-> select group expert and then select the group
you want to display in each page. and goto the options and check the the
checkbox >Repeat group header in each page.

That's it.. Your group header will display on the top of each page.

Continue Reading

Display multiple columns in the Crystal Report.NET

While generating reports we are offten need to display data in multiple columns in cyrstal reports or any other report generation tool.

Crystal Report provides very easy way to do it. Please follow the following steps to complete things.

1) Open crystal report
2) Go to the section exprert and then select details section
3) Select 'Format with multiple columns' checkbox.
4) A layout tab appears in the section expert. From where you can design layout that how the multiple columns display in the crystal report.

That's it... You have created reports with multiple columns. You can also format crystal report groups with it.

Happy Programming.

Continue Reading

Developing n-tier application with Microsoft.NET

There are lots of debates and information about developing n-tier application using Microsoft .net framework. Every one has its own mechanism. I found a interesting article at Microsoft site. It is very good and with the source code.

Here are the link for that article:

http://www.microsoft.com/belux/msdn/nl/community/columns/hyatt/ntier1.mspx

It explains every aspects of developing n-tier application with Microsoft .net framework.

Happy Programming

Continue Reading

Microsoft Application Block for .NET

It's dream of every developer to create a robust,efficient and fast solution for his client and Microsoft application blocks help greatly to develop a efficient,robust and n-tier applications.
Like every developer we want our solutions robust,efficient,cost effective and elegant. But as we all know sometimes it is not easy to achieve this goals. Microsoft application block help you achieve this goals in the great way.

Microsoft Pattern and Practices:

Since the late 90s there has been an increased awareness within Microsoft that its customers require guidance in using the quickly growing array of technology emanating from Redmond. Among the first efforts were a series of Prescriptive Architecture Guides (PAGs) that detailed how to use Microsoft technology to create an Internet data center (IDC) and enterprise data center (EDC). From that things micro soft has started a new group called Microsoft patterns and practices. This group help to achieve goals in best ways.

This group has build some libraries for Microsoft.net plate form called Microsoft application blocks to deliver highly efficient,robust solutions.

Typically, each application block includes the complete source code for the subsystem in both C# and VB, and sample applications called Quick Starts to get you started.

Following application blocks are created.

1) Data Access Application Blocks.
2) Exception Management Application Blocks.
3) Cryptography application blocks
4) Caching application blocks
5) Logging application blocks
6) Security application blocks.

All that application blocks are freely available for download. User can download and install it.

Following are the links for both versions 1.1 and 2.0 of Microsoft .NET Framework

Link for 1.1 Version:

http://www.microsoft.com/downloads/details.aspx?familyid=a7d2a109-660e-444e-945a-6b32af1581b3&displaylang=en

Link for 2.0 Version:

http://www.microsoft.com/downloads/details.aspx?familyid=5A14E870-406B-4F2A-B723-97BA84AE80B5&displaylang=en

Happy Programming

Continue Reading

Ajax Realted Keyworkd for Search Engine Optimization

Following are the some Ajax related keywords for search engine optimization.

AJAX Development India,
Ajax Programming,
Ajax Programming India,
Ajax ASP.NET Development,
Ajax ASP.NET Atlas Developement,
Ajax,
Ajax development,
Ajax application development,
Ajax javascript,
Ajax programming,
Ajax XML,
Ajax java script,
Ajax java script and XML,
Ajax java,
Ajax network,
Ajax net,
Ajax php,
java Ajax,
Ajax asp,
Ajax asp net,
net Ajax,
Ajax site,
Ajax asynchronous,
Ajax cold fusion,
ajax asp.net,
ajax site,
ajax enable sites,
ajax enabled sites in india

Continue Reading