Still no response after 18hrs. At this rate you'll be on your Hols before we know if the problem was resolved. Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.”

Hi, if you are using CrystalDecisions.CrystalReports.Engine.ReportDocument you can set user name and password with the property DataSourceConnections[0] with method SetConnection. For explample: rpt.DataSourceConnections[0].SetConnection(server, connection.CatalogName, connection.UserId, connection.Password); kind regards [edit]you should do this before you send the ReportDocument to CrystalReportViewer. ;-)[/edit]

Ya if it is a Windows forms app in VS.NET there is a tool in the tool box (DataGridView). You should be able to put data into it, and it should display it in a table. I have not tried it before but it looks strait forward. hope this helps! :-D static void main() { while (Robotics == cool) { Me.Build.Robots } }

Your query looks like: select count(occupants) from tablename group by [datecol],roomtype having datecol between '2008-05-01' and '2008-05-31' If this doesn't helps you then post data as they are saved in table and post output result which u want to have, we will see what we can do. I Love T-SQL "Don't torture yourself,let the life to do it for you."

Hi, some remarks: 1. You can force a redraw by calling Invalidate() on the Control that does the drawing, in your case a Form. 2. Please, please publish code snippets inside PRE tags; it reads much better. 3. You must call Dispose() on those objects that you create and havre such a class, as in SolidBrush and Pen. 4. For predefined colors there also exist predefined objects (Pen, Brush), see Pens class and Brushes class. You should not try to dispose these, since you did not create them! :) Luc Pattyn [Forum Guidelines] [My Articles] this months tips: - use PRE tags to preserve formatting when showing multi-line code snippets - before you ask a question here, search CodeProject, then Google

twsted f8 wrote: Dim mytablelogoninfo As TableLogOnInfos = myCrystalReportViewer.LogOnInfo twsted f8 wrote: For Each myTableLogOnInfo As TableLogOnInfo In [myTableLogOnInfos] Is that the difference, maybe?

You could also consider SQL Server Reporting Services[^]. It's free, although you need to install SQL Server to use it. Reports are relatively easy to develop and there are plenty of resources on the web that demonstrate how to use it. Paul Marfleet

i think we have a property called Cancel in the event of form_close so you have to do this to prevent closing window e.cancel=true A.E.K

Christian Graus wrote: In fact, just deleting the bin and obj folders should do it. Just what i was going to say -- the Obj folder is making its own choices... it sees a "newer" version and tries to use that but it cant because the dates dont match. Thats what I call a "clean all" :) ---- Morgan Gangwere Lead programmer, Unknown Software "Pinky, are you thinking what im thinking?" "I Dunno brain, how many licks DOES it take to get to the tootsie roll center of a tootsie pop?" "You want me to calculate that? or should we take over the world?" "ooh! OooooOOOooH! lets find out!"

Concurrency isn't just a multiuser issue. There are more than a couple of ways your own code can think it's updating records that it's not. The most common of which happens when your code goes to update a single record (such as when using the DataAdapter or TableAdapter), the number of affected records comes back 0 or greater than 1, because your table's primary key isn't setup properly, or if it doesn't even have one. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007

You would need to write a query that returns: i) the total rent incurred thus far by each guest. This would presumably be the the number of days elapsed since the guest began their stay, multiplied by their daily rate ii) the total amount paid by the guest thus far Subtracting ii) from i) should give you the total amount currently owed by each guest. Regards Paul

With SQL express you are going to have to allow access via TCP/IP from the SQL Server Configuration Manager. Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture) http://www.frankkerrigan.com/[^]

select * from rooms where roomNumber not in ( select roomNumber from sessions where '01092007' between startdate and enddate) and roomstatus <> 'blocked' order by roomNumber If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message".

Hi Thanks for helping. I do have a group box on the form. I still got a bit of a qn? What do u mean by iterate over the controls of the form, How could I go about this? Thanks again. twsted f8

You cannot compare the type of control with TextBox Class. The control has to be compared with the type of TextBox. Possibly the the code snippet will resolve your issue For Each ctrl As Control In Me.Controls If ctrl.GetType() Is GetType(TextBox) Then If ctrl.Text="" Then MessageBox.Show("Message",MessageBoxButtons.OK,MessageBoxIcon.Exclamation) ctrl.Focus() End IF End If Next Santosh Metal