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.

Answer 1

User1992938117 posted
If it's move then why can't you just change date of the rows to next month.

Answer 2

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 

Answer 3

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

Answer 4

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 thread

Answer 5

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.

Answer 6

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?

Answer 7

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