Suljettu

Getting an auto incremented SQL column onto a VB [url removed, login to view] text box

Hi All:

I'm creating this [url removed, login to view] form to database project

for a manufacturing company. There is a web form, a [url removed, login to view] coded .apsx page. They want their employees to click on the web form and have a brand new reference number autopopulate a field. Its kinda like some of the help desk ticket systems I've worked with in my tech support days... a new reference number autopopulates upon page load.

Quick facts:

> SQL Server 2000 database has about 30 columns, DocID column is set as Primary Key, Indentity seed yes and autoincrements by 1, it works great.

> Front end is VB (using Visual Web Developer 2005 express edition).

Form works great... as DBA I can see DocID column goes up by one after each form submission.

Problem: I don't know how to get the Reference Number/Doc ID to autopopulate from the SQL Server database.

Please help with this autopopulate portion of this [url removed, login to view] forms to database project I'm on. More work is possible, as this particular project I'm working on is ongoing. I'm a novice developer... need help with the finer details.

Thanks,

Paul

Taidot: .NET, ASP, Visual Basic

Näytä lisää: small projects net, web developer sql, web developer express, visual web developer express, visual basic net developer, visual basic developer, vb work, vb this, tech support company, novice to, net systems, need sql help, need quick web developer, need sql developer, need help asp net, key web developer 2005, id tech, get tech support, get help desk, front desk, employees new, apsx table auto increment, fake autoincrement sql view, vbscript auto increment seed, sql column auto populate

About the Employer:
( 1 review ) Waterbury, United States

Projektin tunnus: #445930

42 freelanceria on tarjonnut keskimäärin 44 $ tähän työhön

rajtuhin1

This is an easy task for any freelancer, But PLEASE, PLEASE, PLEASE let me do this, because, i am saying you 3 consecutive 'PLEASE'. Thanks and Regards : TUHIN

30 $ USD 0 päivässä
(160 arvostelua)
7.2
guoxinliu917

Hello, please check my PMB. Thanks.

30 $ USD 1 päivässä
(92 arvostelua)
7.1
Nirmal2006

Hi, I can do it easily. Let's start...

30 $ USD 0 päivässä
(119 arvostelua)
7.0
shmai

have a glance at PM. Regards,

36 $ USD 0 päivässä
(179 arvostelua)
7.0
Ajz

can do it for you.

40 $ USD 2 päivässä
(58 arvostelua)
6.7
AlosDeveloper

Hi, please see PMB.

30 $ USD 0 päivässä
(45 arvostelua)
6.7
HeoQue

that's easy !

30 $ USD 0 päivässä
(53 arvostelua)
6.7
sandeep25101982

Hi ! [url removed, login to view],[url removed, login to view] expert here ! Your issue is not so complex. let me help you ! thanks

30 $ USD 1 päivässä
(42 arvostelua)
6.6
kipo

Please check PM I sent you.

30 $ USD 0 päivässä
(33 arvostelua)
5.4
crajeshbe

Hi Good day, Expert in [url removed, login to view] and Sql. Ready to start the project. I'll fix it in an hour. Waiting for selection. Regards [url removed, login to view] B.E

30 $ USD 0 päivässä
(29 arvostelua)
5.1
ranacseruet

hi, check PM.

30 $ USD 0 päivässä
(7 arvostelua)
5.0
visu14

Hi.. Expert in [url removed, login to view] ans [url removed, login to view] with SQL2000 and SQL2005.. Please check PM...

30 $ USD 0 päivässä
(19 arvostelua)
4.2
sriv151

Please Check pmb

60 $ USD 1 päivässä
(5 arvostelua)
3.4
rptoshniwal

I am interested in doing your project. I have more than 3.5 Yrs. of Experience in [url removed, login to view] using C# & SQL SERVER 2005. All projects what I have done are in 3-tier architecture following all coding standards. Please view Lisää

30 $ USD 1 päivässä
(4 arvostelua)
3.2
hfreelancer

Hello, I have 3+yrs. of experience in .net [url removed, login to view] PM for more details and understanding of project. Thank you.

30 $ USD 1 päivässä
(4 arvostelua)
3.1
GavaskarAnand

hi see my PMB regards gavaskar

30 $ USD 0 päivässä
(3 arvostelua)
2.9
GsoftTechnology

Hi, Kindly see PM for details, Thanks,

30 $ USD 1 päivässä
(1 arvostelu)
2.5
angan

please check PM

30 $ USD 0 päivässä
(4 arvostelua)
2.1
YankoNik

Hi Pauly! Somewhat difficult to do with Identity column. In SQL 2000 has a function which may derive a number for the last Identity column, but this means that we must add an entry in the table. The best approach in yo Lisää

40 $ USD 2 päivässä
(2 arvostelua)
1.0
idimensions

Infinite Dimensions is a team of Professional Software Developers, CMS Experts and Multimedia Designers. We prefer long term customer relationships rather heavy charges. We'll be glad to help you in any other scenario Lisää

30 $ USD 1 päivässä
(2 arvostelua)
1.0