jfkennedy5

I have a project to make a Settlement Statement in this format.

Column1 Column2 Column3 Colume4

Adv Deposits Guest City Monthtoday forColumn 3

Previous Balance 0.00 0.00 300.0 -

Settlements ---The Settlements Section will be Manual Entry

Net cash 0.00 0.00 0.00 450

Checks 0.00 0.00 0.00 600

Paid Out 200.00 0.00 0.00 500

F&B Paid Out 0.00 0.00 0.00 0.00

Lockbox 0.00 150.00 0.00 150

American Express 0.00 0.00 150.00 150

Discover 0.00 0.00 0.00 0.00

Visa-Pos 0.00 0.00 0.00 0.00

--- Calculated

Sum of Settlement 200.00 150.00 450.00 1850.00

Previous + Settlement(EB) 200.00 150.00 750.00 3000.00

I want to use SQL to Store the data for each days date. And when a new day starts automatically Bring the Ending Balance(EB) to the Previous Balance from the previous day.

I would like to use Visual Studio, but would I use a DataGridView or Excel¡ªWith

Visual Studio Tools for Office as a Form

In this type of format what would be the best way to store the information in a sql database

Thanks for your time.




Re: Visual Studio Tools for Office Which way to go?

Douglas H. Troy

I would like to use Visual Studio, but would I use a DataGridView or Excel¡ªWith

Visual Studio Tools for Office as a Form

That's up to you, depends on you and/or your users plan on doing with your data ... this isn't something that anyone can really answer for you, but will be dictated more by your requirements.

In this type of format what would be the best way to store the information in a sql database

This is not a VSTO specific question and directly relates to database technology; you'll need to ask this question in the SQL forum.

I have to be perfectly honest with you, if you have to ask "what the best way to store this information in a database" is, you're getting yourself in over your head, attempting an entire VSTO or .NET project like this ...

Sounds like you need to first start off with figuring out how Databases work ...

Just my two cents.