showing updated rows on form

[johnc83]

Hi all,

could someone point me in the direction of a solution for this please..

I am planning an invoicing module for charging out the records in my Jobs table.

I would like to issue an update command, something like this:

update tblJobs
set Job_Status = 'Invoiced'
where Account_Number = @param1

that is straight forward enough but I would like a form which has a nice box which prints which job is being updated.

Like this:

JobNo, Date , Status
12345, 20/05/2008, Invoiced
12346, 19/05/2008, Invoiced

and it keeps adding a new row each time a record has been updated.

Im sure this is possible (and hope I've made sense) but really have little idea where to start..

Hope someone can help

Thanks

John

.NET 2.0, Visual Studio 2005, SQL Server 2005 Express

 

[Sorwen]

Maybe I'm slow today, because I just can't seem to get what people are asking. If you mean how would you go about printing that then I don't do much printing, but the one time I did I used the PrintForm Component (VS2k5) you can download. I think I heard there is a simialr option for 2k8, but I haven't played around much yet. The component will print the form so you can then set it up however you want (i.e. simple TextBox, ListView, DataGrid, etc.).

-I hate Microsoft!
-Forever and always forward.
-My kingdom for a edit button!

 

[johnc83]

Hi Sorwen, thanks for the reply.

Yes I think I mean printing on the form. Now that I know what it is called, I'll take a look round the net for tutorials.

Thanks

John

.NET 2.0, Visual Studio 2005, SQL Server 2005 Express