how to save columns in a grid

Maneesh A N

how to save 'expencename','expence amount','income name','income amount' in a grid.these are in databse with seperate tables.i have to use select query but there is no common fields for both tables..how should i?but month and year must pass as parameter...(1)first i need to select from expense and income tables,already running with different fields(2)then i have to save all columns(means four)using dimensional array.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Wim Sturkenboom12y ago
I think your database design is wrong or you don't give all the tables that exist in your database.
If there is no relationship between the two tables, it's impossible to link the two together. It should also not be necessary to store information in the third table as it can be calculated.

If I look at your second table (what's the real table name?), it looks like an invoice (billing) table. It has a booking ID and I assume that it links to a table with bookings. Correct?
If not, why does it have a booking ID?
If it links to a table with bookings, what is in the booking table? Does that link by some means to the first table (last one in your above post)? What is the real table name of the 1st table?

The second table also contains a payment ID and so it might link to a payment table. If so, what does payment do in there? Isn't that already in the payment table? And what is in the payment table?
If it does not link to a table with payments, why is the payment ID in the second table?

I only have a faint idea about the first table (last one that you showed). What does exp stand for? Any other table that might use the exp ID?
Maneesh A N12y ago
3 rd table (1st and 2 nd should save here)
balid   int
expname varchar(50)
expamount decimal(18, 0)
incomeamount decimal(18, 0)
totexpamount decimal(18, 0)
totincomeamountdecimal(18, 0)
netincome decimal(18, 0)
month varchar(50)
year   varchar(50)

2nd table

ipaymentid intUnchecked
ibookingid intChecked
vpatientname varchar(50)
vtest varchar(50)
vpayment decimal(18, 0)
vbillnum varchar(50)
dbilldate datetime

1st table
expid int
expname   varchar(50)
expdescr   varchar(50)
expamountdecimal(18, 0)
expdate datetime

in win form,month and year and datagridview and total exptextbox,totalinctextbox and net income
Wim Sturkenboom12y ago
If there is no common field between tables, your exercise is basically useless as no system will ever know how they relate. Can you share structures of the tables? Note that the common field might actually be in a third table (in case of a many-to-many relationship); or maybe there is a users table and your two tables link to that table?

Next is that your question is not quite clear. Do you want to show the result of a query in a grid or do you want to save the information in a grid to a database or to a file?