Getting number of rows in a sql table

Question

0.00/5 (No votes)

See more:

my table columns(studentID,studentName,studentRegNumber)
when I enter studentID & studentName studentRegNumber should be added automatically by considering current number of records in the table.
Examples records
StdID StdName StdRegNo
1 Nishan A1
2 Brian A2
3 Thomas A3

StdRegNumber should be added automatically like this..
Give me a help with an example...
Because I am a beginner for c#

Posted 22-Nov-12 0:30am

NISHAN SANDEEPA

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mohd. Mukhtar · Accepted Answer · 2012-11-22T00:33:00

Solution 1

Hi Nishan,

You need to create table with autoincrement of id.

Refer below link to create or alter table.

http://www.sitepoint.com/forums/showthread.php?41676-Auto-Increment-primary-key-in-MS-SQL-server[^]

http://howtoideas.net/how-to-create-auto-increment-column-in-a-sql-server-table[^]

Posted 22-Nov-12 0:33am

Mohd. Mukhtar

Updated 22-Nov-12 0:34am

v2

__TR__ · Accepted Answer · 2012-11-22T00:39:00

Looking at the sample data you have provided you need not use the studentRegNumber column in your table. You can just concatenate an A to your student ID in your query itself and get the result.

SQL

SELECT StdID,  StdName, 'A' + CAST(StdID AS VARCHAR) AS StdRegNo FROM [YourTableName]

You can use IDENTITY (Property)[^] to auto generate the student ID.