Adding Rows in Datagridview from database in between 2 dates

[no[one]]

How to add rows in a datagridview by computing in between 2 dates

the computed number of months is the total number of inserted rows in my datagridview

This is what i want to do:

for example in my form1's DGV i have from mysql database

Id StartDate endDate Balance

1 01-26-2019 4-26-2019 20,000.00


and after running and clicking a button to form2


my form2's datagridview will gonna be like this

PaymentDate Status Balance

01-26-2019 Unpaid 5,000.00

02-26-2019 Unpaid 5,000.00

03-26-2019 Unpaid 5,000.00

04-26-2019 Unpaid 5,000.00

is this possible? sorry for my explanation im not good in english

Please help me i dont have any idea how to do it

Continue reading...