Click here to Skip to main content
15,868,306 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
how can i Retrieve date value of last record from a database table and assign it to a variable in vb?? My table has columns like "fact1/fact2/fact3/total/date/timestamp" i'm using sql server as my database..
Posted

dim ds as new dataset
dim qry as string = "select * from tabletemp"
dim command as sqlcommand = new sqlcommand(qry,connection)
dim da as sqldataadapter = new sqldataadapter)command)
da.fill(ds,"tabletemp")

dim datevariable as string

datevariable = ds.tables(0).rows(ds.tables(0).rows.count - 1).item("date").tostring



'''' this is how u will get the value of date from last record u saved
 
Share this answer
 
see, below code
VB
dim datevar = dbScalarvalue("select date from tbl where timstampcol=max(timestampcol)")
'dbScalarvalue function take query and give result from sql, database connection and all that will manage internally by function.

Happy Coding!
:)
 
Share this answer
 
You can also convert date by query
sql="select *,Convert(char(10),date),103)As date from tabletemp"
this will give u date in 'dmy' format
 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900