This is a migrated thread and some comments may be shown as answers.

Update selected rows only

4 Answers 76 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Thye
Top achievements
Rank 1
Thye asked on 06 Dec 2012, 08:04 PM
Hello,

I'm trying to upgrade my current WinForms application, to a webapplication, with a RadGrid.

I have the following problem: I want to have a checkbox in each row, and when I check it, it must change a row column. After that, a save action, must only update the selected rows. 

I have a table with a lot of receipts, and a table with invoices. In the receipts table, there is a comlumn, named InvoiceID, which binds the receipt to the invoice. Now, I want to have a RadGrid, with all unbinded receipts. Then, when I select a receipt, it must update the InvoiceID with a given number. Then I want to update the table, so the receipts are binded.

Maybe i'm not clear enough. Let me know.

I hope someone can help me.

4 Answers, 1 is accepted

Sort by
0
Kostadin
Telerik team
answered on 11 Dec 2012, 10:04 AM
Hi Thye,

I'm afraid I'm not completely sure that I understand what you are trying to achieve. Could you please provide us with additional information like images or your code declaration in order to get a better idea of your requirement?

Greetings,
Kostadin
the Telerik team
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
0
Thye
Top achievements
Rank 1
answered on 11 Dec 2012, 11:17 AM
Thanks for your answer. I've simplified my problem, so  I hope you understand it.

I have two tables: Receipt and Invoice. I have many receipts, and some will be paid by invoice. When I create a new invoice, I want to select the desired receipt in a grid. When I update, the new invoice must be added and or the selected receipts, the invoiceID must be updated, with the given one. 

Tables: https://dl.dropbox.com/u/2702645/invoicetable.gif

Desired UI: https://dl.dropbox.com/u/2702645/invoicegrid.gif

Hope this will help!
0
Kostadin
Telerik team
answered on 14 Dec 2012, 12:27 PM
Hello Thye,

As far as I understand a possible solution is to make a hierarchical grid where the Master Table will be populated with the date from the Receipt table, and the Detail Table will be populated with data from the Invoice table. In the last column you will have a button and when is clicked it will be added a row in the Detailed table. The structure of the grid could be as shown in schema below.
Receipts - MasterTableView
Invoices - DetailTableView
 
 
Receipt  |  Date      |    Time    |   InvoiceID    |  InvoiceButton
____________________________________________________________________
+ Receipt1   11/10/2000    13:25           1        |   Invoice 
     InvoiceID      InvoiceDate      InvoiceCustomer
     _______________________________________________________________
         1               date                      
  Receipt2   11/10/2000    13:25           null
  Receipt3   11/10/2000    13:25           null
  Receipt4   11/10/2000    13:25           null
  Receipt5   11/10/2000    13:25           null

I suggest you to check out the following example where is demonstrated how you could create a hierarchical grid declaratively.

All the best,
Kostadin
the Telerik team
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
0
Thye
Top achievements
Rank 1
answered on 17 Dec 2012, 07:35 PM
Kostadin,

Thanks for your reply. I've currently found a workaround, but in the future I will try your solution.

Greetings,
Thye
Tags
Grid
Asked by
Thye
Top achievements
Rank 1
Answers by
Kostadin
Telerik team
Thye
Top achievements
Rank 1
Share this question
or