Ajax is one of most hot and upcoming technologies for web developement plateform. Microsoft has launched its ajax development kit . With it you can easily create ajax enabled application with asp.net . With help it takes few mintues to convert existing asp.net application to ajax enabled asp.net application.Microsoft also lauched some tutorial and video with it's How do I ajax video series. It is...
Wednesday, February 28, 2007
C#-VB.NET name spaces
I have found one interesting things name spaces. Name space help us to organize our code in better way.You should create name space as following.company.product.layer.sect...
Performance Tuning on SQL Server
Performance is one of most important factor at the time of the application developement. If your application or website is not responding fast to user queries then it's accepted by the users.Here are the some tips to make fast retrival of data from sql server.1) Create Index- Indexes are great way to improve your performance. It uniquely indetifys the each row in table.2) Avoid Cursor- Cursors are...
Saturday, February 24, 2007
SQL Server Index
Some Times we want to retrive data fastly without wasting time to retrive it. SQL Server Indexes can greatly help to make data retrival fast and provide quick access to tables. Therer are four type of indexes in SQL Server 2000/2005. 1) Unique Key Index2) Clustered Index3) Non Clustered Index4) Compsite Key Index Unique Key Index:As the name suggest this index does not allow duplicate values in rows....
Creating ASP.NET 2.0 Website with Web 2.0 Standards
Web 2.0 is used mostly today because it provides great compatibility with most of the browsers.So that a website can reach maximum audience. That's why the web 2.0 used the div tags rather then the other html standards.An ASP.NET site also can be build by this standards. Stephen Walther has written great article at msdn with all the knowledge required to build ASP.NET Sites with web 2.0. Here is the...
Tuesday, February 20, 2007
Directly Binding Dataset with Datagrid View
With windows forms 2.0 you can directly bound the datagrid with dataset.For example,your dataset name is 'dt'First fill your dataset with data.Then select datagridview and create the columns and in the datamember property of each give the name of column you want to bind.just write the following code.For example you datagrid code is dgdg.DataSource=dt;dg.Refresh();That's it you have bound the datagrid...
Thursday, February 15, 2007
Capabilities Microsoft SQL Server,Microsoft ACCESS, MSDE
I have found a very good site with provide the comparison of Microsoft sql server, Microsoft and mdse capabilities on the basis of following.Number of instances per serverNumber of databases per instance / serverNumber of objects per databaseNumber of users per databaseNumber of roles per databaseOverall size of database (excluding logs)Number of columns per tableNumber of rows per tableNumber of...
Tuesday, February 13, 2007
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...
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,...
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 crystalreports right click crystal report-> select group expert and then select the groupyou want to display in each page. and goto the options and check the thecheckbox >Repeat group header in each page.That's it.. Your group header will...
Saturday, February 10, 2007
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 report2) Go to the section exprert and then select details section3) Select 'Format with multiple columns' checkbox.4) A layout tab appears in the section...
Thursday, February 1, 2007
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.mspxIt explains every aspects of developing n-tier application...
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...
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...
ASP.NET Case Studies
Today, ASP.NET is one of the most popular plate form for developing web application and Ajax enabled web sites and web application. ASP.NET Case Studies by Microsoft is mirror of the relevant world. You can find what the world are doing with asp.net and you can learn from their experiences.Here is the link ASP.NET Case Studies.http://msdn2.microsoft.com/en-us/asp.net/aa336563.a...
Previous week startdate and enddate in SQL Server 2005,SQL Server 2000
s have found the way to get start date and end date of previous week with the help of the date part function of SQL Server 2005. It also work on sql server 2000 also.Following are the code for finding start date and end date of previous week.Set @STimeStamp=GETDATE()set @PStartDate=@STimeStamp-DATEPART(dw,@STimeStamp)-6set @PEndDate=@STimeStamp-DATEPART(dw,@STimeStamp)Happy Programm...
Crystal Report Field Color
In the crystal report You can also set the color of database field the dynamically. For that youhave to right click the field and select the format object then go to the font and color tab. Click the formula icon opposite to color and a formula editor opens. Put your formula whatever you want to implement and you set your color based on this formula.Happy Programmin...
ASP.NET Starter Kit For Visual Web Developer
The asp.net visual web developer starts kits are best way to start professional asp.net web programming. I have gone through several starter kits it's amazing. The ASP.NET 2.0 Starter Kits for Visual Web Developer are fully functional sample applications to help you learn ASP.NET 2.0 and accomplish common Web development scenarios. Each sample is complete an dwell-documented so that you can use the...
