ASP.NET C#: Helper function to get a new valid row ID

As we know lots of basic things about the database and tables. Each row in the table is identified by an ID. This is the primary key for the table, so it must be unique for each row. You must obtain a new row with unique ID from the database. Here is the following helper function to the ASP.NET class to get this unique ID before adding the row.

Read full article..

How to: Create SEO Friendly URL in ASP Classic

Nowadays Search Engine Optimization (SEO) is very common, everyone talks about SEO. The basic and important part of the SEO is to create Friendly URL. It means remove all unnecessary words and symbols in url. Few months ago I was looking after this script for ASP Classic and that time I didn't get anything positively. When I migrated my website from ASP Classic to ASPNET 2.0 then I got a script for SEO Friendly URL/Title for ASPNET, and by ASPNET I got an idea to create SEO Friendly URL method for ASP Classic and I have done this job perfectly.

Read Full Article

Creating a Data Access Layer (DAL) for ASP.NET and C# Part-3

In the last post I had created a method for INSERT, UPDATE and DELETE with affected rows count. This time I will write same method but a bit difference to previous one. A new method will be created for getting INSERT_ID which creates by Primary Key (Auto Increment).

Here you will find a bit change, even you have to make changes in the SQL Store Procedure too. Lets take a look of Store Procedure.

Read Full Article

Creating a Data Access Layer (DAL) for ASP.NET and C# Part-2

Hi. Welcome to another article of Data Access Layer (DAL) for ASP.NET and C#. Here I will tell you about how to create method for INSERT, UPDATE and DELETE. This method will return affected rows count by ExecuteNonQuery Method.

Read Full Article

Creating a Data Access Layer (DAL) for ASP.NET and C# Part-1

Introduction:

In ASP.NET you should use ADO.NET Data Access Model for designing a
Data Access Layer. I'm going to show you a DAL Framework which you can
use in any project for SELECT purpose.

See Full Post