locked
how to move 1 month data to another month in asp.net page RRS feed

  • 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 thread

    Sunday, 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