Click here to Skip to main content
12,402,211 members (35,408 online)
Rate this:
 
Please Sign up or sign in to vote.
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 30-Aug-12 21:32pm
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 2

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
  Permalink  
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

see, below code
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!
Smile | :)
  Permalink  
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 3

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
  Permalink  

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

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.160721.1 | Last Updated 31 Aug 2012
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100