How to fetch data from sql server 2008 to visual studio 2010

Question

0.00/5 (No votes)

See more:

VS2010

I am having a database called procurement and 5 tables named as e1, e2, material_master, material_group and project.

In the e1 table there is a column name called sl_no which is the primary key and i want it to have unique and different values.

the problem is when i put auto increment from the sql server it automatically changes the value but when i change to a different project also it is continuing to increase the serial number. Please help me "if i change the project it must call the last value in the respective database and have to add 1 to the last called serial number".

Posted 30-Oct-12 19:56pm

armarzook

Add a Solution

1 solution

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)

Anandkumar D · Answer 1 · 2012-10-30T20:02:00

Solution 1

You can reset the identity column value to 1 by using

SQL

DBCC CHECKIDENT (Table_1, RESEED, 1)

Posted 30-Oct-12 20:02pm

Anandkumar D

Comments

armarzook 31-Oct-12 2:28am

Thanks for your reply Anand. But where i have to insert this statement and can u explain how it exactly works? i can even give you the full vb code also. Actually the value is a text box from the datatable.

Anandkumar D 7-Nov-12 1:12am

Go with this http://social.msdn.microsoft.com/Forums/en/Vsexpressvb/thread/39046718-a653-49d3-9c22-85e5896ab889, it will solve your problem