or
Protected Sub btnShowChart_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnShowChart.Click chTotal.DataSource = GetChartData() chTotal.DataBind() End Sub Private Function GetChartData() As DataTable Dim pCustomerID As New SqlClient.SqlParameter("@CustomerID", 8) Dim pFromPeriodID As New SqlClient.SqlParameter("@FromPeriodID", 8) Dim pToPeriodID As New SqlClient.SqlParameter("@ToPeriodID", 8) Dim pHasPPCTotals As New SqlClient.SqlParameter("@HasPPCTotals", SqlDbType.TinyInt) pCustomerID.Value = Session("CustomerID") If cbPPCTotal.Checked = True Then pHasPPCTotals.Value = 1 Else pHasPPCTotals.Value = 0 End If pFromPeriodID.Value = cbDateFromChart.SelectedValue pToPeriodID.Value = cbDateUntilChart.SelectedValue Dim tblResults As DataTable = ExecuteDataTable(ConnectionStrings.BilConnString, "GetCustomerSpendVessel", New Object() {pCustomerID, pFromPeriodID, pToPeriodID, pHasPPCTotals}) chTotal.Series(0).DataYColumn = "Total" chTotal.PlotArea.XAxis.DataLabelsColumn = "Vessel" chTotal.PlotArea.XAxis.Appearance.LabelAppearance.RotationAngle = 0 chTotal.PlotArea.XAxis.Appearance.TextAppearance.TextProperties.Color = System.Drawing.Color.DarkBlue chTotal.PlotArea.Appearance.Dimensions.Margins.Bottom = Telerik.Charting.Styles.Unit.Percentage(12) GetChartData = tblResults End Function
if (e.Item is GridEditableItem && e.Item.IsInEditMode) { GridDataItem gridDataItem = e.Item as GridDataItem; DataRowView dvRow = gridDataItem.DataItem as DataRowView; RadComboBox cmbPositionID = gridDataItem.FindControl("comboPositionID") as RadComboBox; cmbPositionID.SelectedValue = dvRow["PositionID"].ToString(); RadListBox listBox = gridDataItem.FindControl("comboLanguageID") as RadListBox; string value = dvRow["LanguageID"].ToString(); string[] values = value.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries); foreach (string val in values) { RadListBoxItem item = listBox.FindItemByText(val); if (item != null) item.Selected = true; } }<telerik:RadGrid ID="RadGrid1" runat="server" AllowFilteringByColumn="True" AllowPaging="True" AllowSorting="True" DataSourceID="ObjectDataSource1" GridLines="None" Skin="Black" AllowMultiRowSelection="True" onitemcommand="RadGrid1_ItemCommand" AutoGenerateEditColumn="True" ShowStatusBar="True" > <MasterTableView DataSourceID ="ObjectDataSource1" ><EditFormSettings UserControlName="picture.ascx" EditFormType="WebUserControl"> <EditColumn UniqueName="EditCommandColumn1"> </EditColumn> </EditFormSettings></MasterTableView> <ClientSettings AllowColumnsReorder="True" EnablePostBackOnRowClick="true"> </ClientSettings></telerik:RadGrid><EditFormSettings UserControlName="picture.ascx" EditFormType="WebUserControl"> <EditColumn UniqueName="EditCommandColumn1"> </EditColumn> </EditFormSettings>
both
protected void RadGrid1_ItemCommand(object source, Telerik.Web.UI.GridCommandEventArgs e) { e.Item.OwnerTableView.IsItemInserted = false; e.Item.OwnerTableView.EditFormSettings.UserControlName = "picture.ascx"; }