Well I resolve this issue by using a table with just one field ID and made it IDENTITY and set its max value to 999 and then used the following procedure to get the next number for 3 digit number...

Hi All SQL Gurus,

I am working on a project for a college. I have to generate a unique student Id for each student. I know I can use IDENTITY column to achieve this but I have rather...

Thankx for your suggestion.

It resolve the issue with both IIS and SQL Server 2005 on same machine.

Hi,

I have hosted a website that has MSSQL Server 2005 database on different machine. I am using the following connection string

<add name="ConnectionString"...

use ASP.NET AJAX Extension or simply the AJAX toolkit .

http://www.asp.net/AJAX/AjaxControlToolkit/Samples/CascadingDropDown/CascadingDropDown.aspx

It is definitely a DLL problem. Your server and local machine may not be using the same version of Oledb.

Array get instantiated when you create it with new keyword:

integers = new int[10]; // size array

declaration can just create a reference.

int[] integers; // declare array

use RegularExpression validators or simply set textbox's maxlenght property to 12 and 8 respectively.

Put
Console.ReadLine() when your app is exiting while loop. By that way you can keep your app running till user enter something.

New in ASP.NET is GridView and DataList.
AJAX Extension

There is minimul documentation from 3rd party and that just suggest use adVarchar as input parameters of fields with width of 50. and takes in RecordSet as referenced input parameter.

Is there a...

Hi there,

I am using third party ActiveX control in my application. It requires RecordSet as a input parameter to its method. I am programming my application in C#. When I call the method after...