Solved

Compare values in datatable using asp.net

Posted on 2006-07-21
2
240 Views
Last Modified: 2008-01-09
I want to test to see if the time in date changes.  If it does i want to write out a blank line.   I can write out a blank line just fine but I need to know how to compare the timein values to see if they change each time.

Thank you


dim query
query="select eh.recordid, firstname + ' ' +  lastname as name, timein, timeout, description from employeehours as eh inner join employeelist as el on eh.employeeid = el.employeeid inner join masterjobcodelist as mjc on eh.jobcode = mjc.jobcode where firstname = 'Justine' and lastname = 'Cleary' and timein  > CONVERT(datetime, '" & strCurrentdate & "', 102) order by timein "
                 
 Dim da As SqlDataAdapter = New SqlDataAdapter(query, objconn)
dim Tbl = new DataTable()
da.Fill(Tbl)
Tbl.columns.add("columnNames")
dim i
dim cou as integer = Tbl.Rows.count()
dim objRow as datarow
'Get the time in date
                                       
while i <> cou
   ' Adding rows
   objRow = Tbl.newrow()
   'objRow("columnNames") = ...
   Tbl.rows.add(objRow)
   i = i + 1
end while

dgAddressBook.DataSource = Tbl        
dgAddressBook.DataBind()
0
Comment
Question by:running32
2 Comments
 
LVL 96

Accepted Solution

by:
Bob Learned earned 500 total points
ID: 17160863
And, what is happening with this code?

Bob
0
 

Author Comment

by:running32
ID: 17171323
I took your advice prior and when with a dataset.

Thanks
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Calling web service and its methods dynamically 2 35
How do I get the id from URL? 19 53
Duplicate a row 2 46
Data is not showing from images 15 36
In .NET 2.0, Microsoft introduced the Web Site.  This was the default way to create a web Project in Visual Studio 2005.  In Visual Studio 2008, the Web Application has been restored as the default web Project in Visual Studio/.NET 3.x The Web Si…
ASP.Net to Oracle Connectivity Recently I had to develop an ASP.NET application connecting to an Oracle database.As I am doing it first time ,I had to solve several problems. This article will help to such developers  to develop an ASP.NET client…
This is a video that shows how the OnPage alerts system integrates into ConnectWise, how a trigger is set, how a page is sent via the trigger, and how the SENT, DELIVERED, READ & REPLIED receipts get entered into the internal tab of the ConnectWise …
Delivering innovative fully-managed cloud services for mission-critical applications requires expertise in multiple areas plus vision and commitment. Meet a few of the people behind the quality services of Concerto.

929 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now