Asked by:
how to move 1 month data to another month in asp.net page

Question
-
User364480375 posted
hi masters
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] ,[r_date] ,[r_month] ,[DistrictId] ,[CircleId] ,[cell_02] ,[cell_03] ,[cell_04] ,[cell_05] ,[cell_06] ,[cell_07] ,[cell_08] ,[cell_09] ,[cell_10] ,[cell_11] ,[cell_12] ,[cell_13] ,[cell_14] ,[createddate] ,[status] FROM [landrecord].[dbo].[praptra21]
kindly suggest how to get the requirement.
Saturday, September 1, 2018 3:36 PM
All replies
-
User1992938117 posted
If it's move then why can't you just change date of the rows to next month.Saturday, September 1, 2018 4:06 PM -
User364480375 posted
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
Sunday, September 2, 2018 3:45 AM -
User-1716253493 posted
Im not really clear with your requirement, what do you mean move to another month?
- show july data in august
- change july data to august
- copy july data to august
- additional moveto value
Sunday, September 2, 2018 6:40 AM -
User364480375 posted
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 threadSunday, September 2, 2018 8:30 AM -
User1992938117 posted
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.
Sunday, September 2, 2018 3:59 PM -
User1120430333 posted
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?
Monday, September 3, 2018 6:50 AM -
User-1716253493 posted
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
Monday, September 3, 2018 7:42 AM