<telerik:RadGrid ID="uxPaymentsGrid" runat="server" AutoGenerateColumns="false" AllowMultiRowSelection="false" OnNeedDataSource="uxPaymentsGrid_NeedDataSource" OnCustomAggregate="uxPaymentsGrid_CustomAggregate" OnItemDataBound="uxPaymentsGrid_ItemDataBound" OnSelectedIndexChanged="uxPaymentsGrid_SelectedIndexChanged" OnDeleteCommand="uxPaymentsGrid_DeleteCommand" OnUpdateCommand="uxPaymentsGrid_UpdateCommand"> <MasterTableView ShowFooter="true" DataKeyNames="PaymentId" EditMode="PopUp"> <Columns> <telerik:GridBoundColumn DataField="PaymentId" DataType="System.Guid" HeaderText="PaymentId" Display="false"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Amount" DataType="System.Decimal" HeaderText="Amount" DataFormatString="{0:C}" Aggregate="Custom" Display="true"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="PaymentType" DataType="System.String" HeaderText="Type" Display="true"></telerik:GridBoundColumn> <telerik:GridCheckBoxColumn DataField="Deductible" DataType="System.Boolean" HeaderText="Ded" ItemStyle-HorizontalAlign="Center" HeaderStyle-HorizontalAlign="Center" Display="true"></telerik:GridCheckBoxColumn> <telerik:GridBoundColumn DataField="License" DataType="System.String" HeaderText="License" Display="true"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="DOB" DataType="System.DateTime" HeaderText="DOB" DataFormatString="{0:d}" Display="true"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="PartialAccount" DataType="System.String" HeaderText="Account" Display="true"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="DExpires" DataType="System.Int32" HeaderText="Expires" DataFormatString="{0:M/yyyy}" Display="true"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="ApprovalCode" DataType="System.String" HeaderText="App. Code" Display="true"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="DTransactionId" DataType="System.String" HeaderText="Trans ID" Display="true"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="PaymentDate" DataType="System.DateTime" HeaderText="Paid" DataFormatString="{0:MM/dd/yyyy}" Display="true"></telerik:GridBoundColumn> </Columns> <EditFormSettings EditFormType="WebUserControl" UserControlName="PaymentControl.ascx"> <PopUpSettings Modal="true" Width="640px" /> </EditFormSettings> ...Hello there,
Our requirement is for a RadGrid to provide inserts and edits to the rows. At any given time if the user does not like what they have added, they can hit a "reload" button and the original dataset is reloaded to the grid. This piece works fine.
However
Upon completion of inserted rows and edits to existing rows, the user will click a Submit button on a form and all of the new and edited data will be committed to the database.
I am struggling with reading the radgrid to update to the database.
How do I loop through the rows...I have tried a couple methods to capture each row and so I may execute a SP to insert the row.
However I cannot seem to be able to read the rows, while they are int's strings etc. my latest attempt was to just capture the text from each GridDataItem, based on a forum post I found.
For Each row As GridDataItem In rgMyGrid.Items
Dim ID As String = row.Item("ID").Text
Dim Rate As String = row.Item("Rate").Text
Dim Description As String = row.Item("Description").Text
Next
What are my options? It does not appear I can pull the radgrid into a datatable. And my attempts along those lines failed.
So I am attempting to go row by row, which will work provided i can
1. identify each row
2. extract the data value from each column
3. convert to appropriate datatype
Thank you for suggestions
ps - i forgot to mention this is intended for VB codebehind. thanks.
Is it possible to install multiple versions of the ASP.NET Ajax Telerik Controls on the same machine?
I have installed 2013 Q3 Net 40 but want to install a version from 2011. Our projects are using 2011 and the team does not want to update to 2013.