Last post Sep 03, 2018 07:42 AM by oned_gk
Sep 01, 2018 03:36 PM|mike4u|LINK
I am storing month-wise data in table. I want that i should have
one webpage in which user can move 1 month data to another month i.e suppose july month data to august month.
database design is like this:
/****** Script for SelectTopNRows command from SSMS ******/
SELECT TOP 1000 [pid]
kindly suggest how to get the requirement.
Sep 01, 2018 04:06 PM|Rajneesh Verma|LINK
Sep 02, 2018 03:45 AM|mike4u|LINK
Rajneesh I be to create webpage so that user can move data within month to month within my same database table as I be described in my thread.kindly suggest how to achieve it
Sep 02, 2018 06:40 AM|oned_gk|LINK
Im not really clear with your requirement, what do you mean move to another month?
Sep 02, 2018 08:30 AM|mike4u|LINK
Oned_gk I am storing month wise data in my table.I have multiple data in my table.so user has to enter multiple data on monthly basis.I want to create 1 webpage in which user will select month and year .l.e
From month: year. To. Month: year:
By selecting month and year user will move data I.e july month data to aug month.so this will save user time to enterr multiple data .table is mentioned in my thread
Sep 02, 2018 03:59 PM|Rajneesh Verma|LINK
By selecting a month and year user will move data I.e July month data to aug month.
As you said move, then why can't you change the month (current month + 1).
In case you have a date then it will be the issue because some months are having different days 28, 30 or even 31.
Please think about your requirement and let us know, what really you are looking for.
Sep 03, 2018 06:50 AM|DA924|LINK
Your problem would be primary-key duplication assuming the record has a primary-key. So each month of data are you trying to tie the data back to some original source, like ID 1 has month 01, 02, 03, 04, etc. and etc by year linkws to ID1?
Sep 03, 2018 07:42 AM|oned_gk|LINK
In new data form, select july data based dropdown selection, show it in gridview as textboxes in itemtemplates
When saving data, insert row by row textboxes value with target month value
For single record only simply get july data to fill your form