AVADHESH PATEL

 02-May-2012
 3
 13767
 India

Difference between char, varchar and nvarchar in sql server

char, varchar and nvarchar are SQL Server data type that used for allocated memory in storage device.

Table Relationships in Access

In this blog I have described use of relationships between tables in Access Database.

Remove Primary Key from Access Table

In this blog I have described how to remove primary key from table in Access.

Calculate Age in ASP.Net C#

Some time we face problem related to calculating exact age in year. In this blog I have explained how to calculate exact age in year in ASP.Net with C#.

Database connectivity in C#

In this blog, I’m going to describe how to establish connection with database in C#.

C#
C# 

How to Create Log File in C#

In this blog I have described how to create log file in C#. Log file can be simple text file, XML document or we can also use tables in database to create log. Here I have used .txt file.

C#
C# 

Compress or Remove WhiteSpace before deploying in Asp.NET MVC

In a normal webpage there is a lot of whitespace. Compressed requests and responses always increase the performance of sites.

Custom Checkbox using CSS

In this blog, I have described how to create custom checkbox using css only or pure css.

Simple popup panel in HTML

In this blog, I have described how to create a simple popup window or display page as popup window. There are simple CSS file and JavaScript that used for open model popup. Steps are given below.

Trim method in SQL Server

SQL server does not have Trim method, but for trimming blank spaces (leading and trailing) from string we have used LTRIM and RTRIM method in SQL Server.

Count table size in SQL Server

This blog have to described, how to retrieve table size.

File download in zip Folder in ASP.NET MVC 4

In this blog have described how to download multiple files within a zip folder in ASP.NET MVC 4. This is also help full in C# and ASP.NET C#. Steps are given below.

Optimizing URL Generation in ASP.NET MVC

URL generation is particularly important for ASP.NET MVC because it uses a routing engine to map URLs to code. If we hard code a URL than we lose the ability to later vary our routing scheme.

New features in SQL Server 2012

Microsoft recently lunched SQL Server 2012. We are known, SQL Server 2012 is enhancing of SQL Server 2008, but we not aware, what are new features Microsoft include in SQL Server 2012.

Why Generics in C#

In this blog I not tell you “What is generic class in C#?” you can read about generic from below link.

C#
C# 

Use of Using Keyword in C#

We use “Using” keyword as directive in c#. “Using” keyword can be used for importing namespace to your classes.

C#
C# 

ExecuteNonQuery, ExecuteReader and ExecuteScalar Methods in C#

This method is commonly used for update, insert and delete statements, where the only returned value is the number of record affected.

C#
C# 

Changed Data Type of column in SQL Server

In this blog I have described how to changed data type of existing column of table. For demonstration I have used a table that given below.

Use custom font in website

Some time we faced problem related to font family on the user’s system. Which font family we used for webpage during development time, not works another system.

Import multiple .css file into single file

Importing allows you to import one style sheet into another. This is slightly different than the link scenario, because you can import style sheets inside a linked style sheet.

@charset in CSS

It is a good idea to always declare the encoding of external CSS style sheets if you have any non-ASCII text in your CSS file.

Drop Column in SQL Server

In this blog I have described how to drop column from existing table. For demonstration I have used a table that given below.

Add New Column in Table in SQL Server

In this blog I have described how to add new column in existing table. For demonstration I have used a table that given below.

Custom Checkbox in ASP.Net MVC 4 Razor

Here I have described how to create custom checkbox in ASP.Net MVC 4. This custom checkbox support all browsers (Internet Explorer, Mozilla, Chrome, Opera and Safari) with latest updates.

JavaScript Errors & Exception Handling

In this article I am going to explain the types of errors and what feature JavaScript had provided us to handle errors.

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!