 |  |  |  |  |  |  |  |
Auto increment proble...
Please support our VB.NET advertiser: Intel Parallel Studio Home
 |
dear friends,
I am using MS access as back end and vb.net as front end.
in one of my table i have a auto increment field.(for ex:orderid).
Please tell me how can i insert new row to the table with auto increment field.
Thanking you,
I am using MS access as back end and vb.net as front end.
in one of my table i have a auto increment field.(for ex:orderid).
Please tell me how can i insert new row to the table with auto increment field.
Thanking you,
select the last OrderId value then + 1.
ex : 1,2,3
Select last value = 3, then 3 + 1 = 4...
ex : 1,2,3
Select last value = 3, then 3 + 1 = 4...
Never tried = Never Know
So, Please do something before post your thread.
* PM Asking will be ignored *
So, Please do something before post your thread.
* PM Asking will be ignored *
Or u can set data types as AutoNumber
Never tried = Never Know
So, Please do something before post your thread.
* PM Asking will be ignored *
So, Please do something before post your thread.
* PM Asking will be ignored *
•
•
Join Date: May 2008
Posts: 7
Reputation: 
Solved Threads: 0
Newbie Poster
•
•
•
•
Originally Posted by deepukng 
dear friends,
I am using MS access as back end and vb.net as front end.
in one of my table i have a auto increment field.(for ex:orderid).
Please tell me how can i insert new row to the table with auto increment field.
Thanking you,
just imagin ur table orderid is ur column name ok so just write follwoing code.
public sub Form_Load()
Dim cmd as new OledbCommand("Select * from TableName",cn) 'cn is Connection Object
cn.open()
Dim dr as oledbdatareader=cmd.executereader
while dr.read()
TextBox1.Text=dr(0)
End While
TextBox1.Text=Val(TextBox1.Text) + 1
dr.close()
cn.close()
End Sub
|
Other Threads in the VB.NET Forum
- Previous Thread: login verification form
- Next Thread: Webcam Image Capture
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest VB.NET Posts
- Today's Posts
- Unanswered Threads
.net .net2008 2008 access account advanced application array basic beginner browser button buttons center click code combo cuesent data database datagrid datagridview date datetimepicker designer dissertation dissertations dissertationtopic excel exists fade filter forms generatetags gridview html images input insert intel internet listview map mobile module monitor msaccess net number objects open panel passingparameters pdf picturebox picturebox2 port position print printing problem regex remove right-to-left save search searchvb.net select serial settings shutdown socket sqldatbase sqlserver survey temperature textbox timer timespan transparency txttoxmlconverter update user usercontol vb vb.net vb.netformclosing()eventpictureboxmessagebox vba vbnet visual visualbasic visualbasic.net visualstudio.net visualstudio2008 web winforms wpf wrapingcode xml year
