or
hi
I can not delete rows in RadGrid
any body can help me?
my database code is:
CREATE TABLE [test]( [c1] [int] IDENTITY(1,1) NOT NULL CONSTRAINT [PK_test] PRIMARY KEY, [c2] [nvarchar](50) NULL, ) insert [test] ([c2]) values ('aaa'), ('bbb'), ('ccc'), ('ddd'), ('eee')my aspx code is:
<%@ Page Language="C#" %> <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title>test</title> </head> <body> <form id="form1" runat="server"> <div> <tlk:RadScriptManager ID="RadScriptManager1" runat="server" /> <tlk:RadGrid ID="RadGrid1" runat="server" AutoGenerateDeleteColumn="True" DataSourceID="data"> <MasterTableView DataSourceID="data" DataKeyNames="c1"> </MasterTableView> </tlk:RadGrid> <asp:SqlDataSource ID="data" runat="server" ConnectionString="<%$ ConnectionStrings:database %>" ProviderName="System.Data.SqlClient" SelectCommand="SELECT * FROM [test]" DeleteCommand="DELETE FROM [test] WHERE [c1] = @c1"> <DeleteParameters> <asp:Parameter Name="c1" Type="Int32" /> </DeleteParameters> </asp:SqlDataSource> </div> </form> </body> </html> <telerik:RadChart ID="RadChart1" runat="server" Height="500px" Width="1200px" SkinsOverrideStyles="false" ChartTitle-Visible="false"></telerik:RadChart>RadChart1.Chart.Appearance.Border.Visible = false;RadChart1.Appearance.TextQuality = Telerik.Charting.Styles.TextQuality.ClearTypeGridFit;RadChart1.PlotArea.Appearance.FillStyle.FillType = Telerik.Charting.Styles.FillType.Solid;RadChart1.PlotArea.Appearance.FillStyle.MainColor = Color.White;RadChart1.PlotArea.Appearance.Border.Color = Color.LightGray;RadChart1.PlotArea.Appearance.Dimensions.Margins.Top = new Telerik.Charting.Styles.Unit(5);RadChart1.PlotArea.Appearance.Dimensions.Margins.Right = new Telerik.Charting.Styles.Unit(200);RadChart1.PlotArea.Appearance.Dimensions.Margins.Left = new Telerik.Charting.Styles.Unit(90);RadChart1.PlotArea.Appearance.Dimensions.Margins.Bottom = new Telerik.Charting.Styles.Unit(60);RadChart1.Legend.Appearance.Position.AlignedPosition = Telerik.Charting.Styles.AlignedPositions.TopRight;RadChart1.Legend.Appearance.ItemTextAppearance.AutoTextWrap = Telerik.Charting.Styles.AutoTextWrap.True;RadChart1.PlotArea.XAxis.Appearance.ValueFormat = Telerik.Charting.Styles.ChartValueFormat.ShortDate;RadChart1.PlotArea.XAxis.Appearance.CustomFormat = "d MMM";RadChart1.PlotArea.XAxis.DataLabelsColumn = "SHIFT_DATE";RadChart1.PlotArea.XAxis.Appearance.TextAppearance.TextProperties.Color = Color.Black;RadChart1.PlotArea.XAxis.LayoutMode = Telerik.Charting.Styles.ChartAxisLayoutMode.Normal;RadChart1.PlotArea.XAxis.Appearance.LabelAppearance.Dimensions.Margins.Top = new Telerik.Charting.Styles.Unit(5);RadChart1.PlotArea.XAxis.IsZeroBased = false;RadChart1.PlotArea.XAxis.AddRange(startdate.ToOADate(), enddate.ToOADate(), 1);RadChart1.PlotArea.XAxis.LabelStep = Convert.ToInt32(Math.Floor(Convert.ToDecimal((enddate - startdate).Days / 8)));RadChart1.PlotArea.YAxis.Appearance.MajorGridLines.Visible = true;RadChart1.PlotArea.YAxis.Appearance.MajorGridLines.Color = Color.Gray;RadChart1.PlotArea.YAxis.IsZeroBased = true;RadChart1.PlotArea.YAxis.AxisLabel.TextBlock.Text = "Metres (RC)";RadChart1.PlotArea.YAxis.AxisLabel.TextBlock.Appearance.TextProperties.Color = Color.Black;RadChart1.PlotArea.YAxis.AxisLabel.Visible = true;RadChart1.PlotArea.YAxis.Appearance.CustomFormat = "N0";RadChart1.PlotArea.YAxis.Appearance.TextAppearance.TextProperties.Color = Color.Black;RadChart1.PlotArea.YAxis2.IsZeroBased = true;RadChart1.PlotArea.YAxis2.AxisLabel.TextBlock.Text = "m / day";RadChart1.PlotArea.YAxis2.AxisLabel.TextBlock.Appearance.TextProperties.Color = Color.Black;RadChart1.PlotArea.YAxis2.AxisLabel.Visible = true;RadChart1.PlotArea.YAxis2.Appearance.CustomFormat = "N0";RadChart1.PlotArea.YAxis2.Appearance.TextAppearance.TextProperties.Color = Color.Black;RadChart1.PlotArea.YAxis2.AxisLabel.Appearance.Position.AlignedPosition = Telerik.Charting.Styles.AlignedPositions.Left;function updateChanges() { ItemsService.AddNewItem(updateGrid); } function updateGrid(result) { var tableView = $find("<%= grdInvoiceItems.ClientID %>").get_masterTableView(); tableView.set_dataSource(result); tableView.rebind(); }[WebMethod(EnableSession = true)] public List<InvoiceItemsDetails> AddNewItem() { Invoice.InsertInvoiceItems(string.Empty, string.Empty, 0, 0, 0, 0, 0, 0, 1001); return Invoice.GetInvoiceItems(1001); }<asp:Panel ID="pnlMain" runat="server"> <uc1:ProcessGridViewEmb ID="embGrid" runat="server" /> <uc1t:ProcessTreeViewEmb ID="embTree" runat="server" /> </asp:Panel>