Skip to main content

Posts

Showing posts from March, 2007

ASP.NET Caching

Caching is process of saving html and data in browser cache. Some data are difficult to obatin it assumes lot of resouceof the server. The best way to store it in cache. So we can retrive from cache instead doing round trip to the server.There are also some portion of the site does not change frequently so caching is a good idea to store this portion ofwebsite in cahce rather then loadind it from server.

ASP.NET also provide caching features.ASP.NET Caching API provides great features for caching.ASP.NET provide three types of caching.

1) Page Output Caching
2) Page Fragment Caching
3) Data Caching


1) Page Output Caching:

In ASP.NET you can do page output caching with output directive....
Here is the code for output caching

<%@ OutputCache Duration="120" VaryByParam="none"%>

This means that page will cache for 120 second and during that time page will not change with get or post parameters.After 120 second page cache will be flush and then page content can be change b…

Search Engine Optimization tools

Search Engine Optmization is one of the hottest things in this days. I have found great tool that will help you to opmize your sites.

First one is market leap which contains three tools
1) Link popularity tool

Link popularity check is one of the best ways to quantifiably and independently measure your website's online awareness and overall visibility. Simply put, link popularity refers to the total number of links or "votes" that a search engine has found for your website.

here is link for this tool...
http://www.marketleap.com/publinkpop/

2) Search Engine saturation

Search Engine Saturation simply refers to the number of pages a given search engine has in its index for your website domain. Not all search engines report this information but enough of them do to create some meaningful benchmarks for your search engine marketing campaigns.

here is the link for this tool..
http://www.marketleap.com/siteindex/default.htm

3) Keyword Verification.

Key word verification tool checks to se…

Tool, Menu, and Status Strips

Windows Forms 2.0 have great control in their stack. ToolStrip and MenuStrip are great example of it. It is a great new control which you can use with application to developer better user interface.

I have found an article on both controls. It describes all the things that realted with toolstrip and menustrip. It also teaches how to another control in toolstrip. It also specifies how to customize the tool strip and menustrip control as per our need.

Here is the link for atricle...

http://en.csharp-online.net/Tool%2C_Menu%2C_and_Status_Strips

Creating Collections for Data Binding and Serialization

Collection are faster then the any datasource like dataset, data reader. So it must be used to bind control in application rather then other datasources. I have found very ineresting article series written by Thiru Thangarathinam which discusss how to create collection and how to bind it with controls.

here is the link:
http://www.15seconds.com/issue/040210.htm

Increase your windows forms application performance

With microsoft.net technology and windows forms 2.0 you can build great application. It provides great user interface component so you can develope very reach applications.

There are two aspects of application design and another one is performance. If any of this two is not perfect then your application may lead to a failure.

I have found one interesting link that discuss about this issues. It discuss all aspects realted to design and performance. It discuss about common performance-critical scenarios such as startup, control population, and control painting to boost your application performance and make it user responsive.

here is the link:

http://msdn.microsoft.com/msdnmag/issues/06/03/windowsformsperformance/default.aspx

Search Engine Optimization tool

Search Engine marketing is one of the most important aspect of site popularity. We must have have to consider when we are developing a website. Today most of thing are find by the search engine so if you want to increase your popularity and visitor you must to search engine optimization.

Keyword is the most import in search engine optimization. You must put right keyword to increase your site popularity among search engine. I have found a link that help us in great way to create search engine keywords.

It contains many links to search engine tools and also help us to understand what is search engine optimization all about?

here is the link:

http://www.hubspot.com/MarketingTips//tabid/8625/Default.aspx

Brainbench ASP.NET Certification

Yester I have received brainbench certification People can find my live transcript from following
http://www.brainbench.com/transcript.jsp?pid=6684815

TRY-CATCH Block-SQL Server

In SQL server 2000, to handle sql server exception we have to use goto statement while in the sql server 2005 support the try-catch type of exception handling just like vb.net or c#.

here is exmple of it.


set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go


CREATE PROCEDURE [dbo].[sp_InsertState]
@StateId int,
@Name varchar(30)
AS
BEGIN
declare @Error Int
declare @TableName sysname
declare @ErrorMessage nvarchar(2000)
BEGIN TRY
BEGIN TRANSACTION
SET NOCOUNT ON;
INSERT INTO tbl_State_Master
(stateid, name, isactive)
VALUES (@StateId,@Name,1)
SET NOCOUNT OFF;
COMMIT TRANSACTION;
END TRY
BEGIN CATCH
ROLLBACK TRANSACTION
set @ErrorMessage=ERROR_MESSAGE()
RAISERROR('State can not be inserted',16,1)
END CATCH
END

Spalsh Screen -C#

It is a good idea to create splash screen when you loading data on the main form. So splash screen resides till the data loaded on the screen.

Fist design a form then set formborderstyle property to "SizableToolWindow"
set ControlBox Property to "False"
set StartPosition Property to "CenterScreen"
set WindowState Property to "Normal"

Import following name space with using directive


using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

then write following code on the your main forms load event


FrmSplash frm = new FrmSplash();
frm.Show();
Application.DoEvents();
Application.DoEvents();
Application.DoEvents();
Application.DoEvents();
Application.DoEvents();
Application.DoEvents();
////do your work here you can put your code to load data
Application.DoEvents();
Application.DoEvents();
Application.DoEvents();
Application.DoEvents();
Application.DoEvents();
frm.Close()…

Stored Procedure-Importing CSV Files into Table -SQL Server

Here is the Stored Procedure code for importing comma seperated CSV files to table.


CREATE PROCEDURE [dbo].[sp_ImportScript]
@filepath varchar(2000)
AS
BEGIN TRY
declare @tmpsql varchar(3000)
set @tmpsql='BULK INSERT table'
set @tmpsql=@tmpsql + ' FROM ''' + @filepath + ''''
set @tmpsql=@tmpsql + ' WITH (FIRSTROW=2,FIELDTERMINATOR ='
set @tmpsql=@tmpsql + ''','''
set @tmpsql=@tmpsql + ',ROWTERMINATOR ='
set @tmpsql=@tmpsql + ''','''
set @tmpsql=@tmpsql + ')'
EXEC(@tmpsql)
select @@rowcount
END TRY
BEGIN CATCH
DECLARE @ErrMsg nvarchar(4000), @ErrSeverity int
SELECT @ErrMsg = ERROR_MESSAGE(),
@ErrSeverity = ERROR_SEVERITY()
RAISERROR(@ErrMsg, @ErrSeverity, 1)
END CATCH

How to set default value of a property in Class-C# 2.0

If you wanna set properties default value at the time of Class Instance creationg here is code that.

Import following name space to your class with using directives.

using System.Collections.Generic; using System.Text; using System.ComponentModel;
Then create a private variable field for property

private string _message;
Finally here is code that generate default value with property.

[DefaultValue("This is default value of message")] //this code generates default value public string Message { get { return _message; } set { _message = value; } }


Note: You can create a DefaultValueAttribute with any value. A member's default value is typically its initial value. A visual designer can use the default value to reset the member's value. Code generators can use the default values also to determine whether code should be generated for the member.

For more reference see following link - http://msdn.microsoft.com/en-us/library/system.compo…

Filling typed dataset with enterprise libary 2006-C#

Here is the code filling data with enterprise library.

First Create a Type dataset in the visual studio dataset called 'crystal'.
Then create a data table via right click add datatable called script.create
columns you require.

and then first import following name space using directives.

using Microsoft.Practices.EnterpriseLibrary.Data;
using Microsoft.Practices.EnterpriseLibrary;
using System.Data;
using System.Data.Common;

Database db = DatabaseFactory.CreateDatabase("StockConnectionString");
private string _CommandName;
_CommandName = "sp_LoadScript";
DbCommand dbCommand = db.GetStoredProcCommand(_CommandName);
db.AddInParameter(dbCommand, "Name", DbType.String, "abc");
db.LoadDataSet(dbCommand, Crystal, "script");

here sp_Loadscript is a sql server 2005 stored procedure which load
script.