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
>
<
form
id
=
"form1"
runat
=
"server"
>
<
asp:PlaceHolder
ID
=
"phValid"
runat
=
"server"
>
<
telerik:RadScriptManager
ID
=
"rsm"
runat
=
"server"
>
<
Scripts
>
<
asp:ScriptReference
Assembly
=
"Telerik.Web.UI"
Name
=
"Telerik.Web.UI.Common.Core.js"
/>
<
asp:ScriptReference
Assembly
=
"Telerik.Web.UI"
Name
=
"Telerik.Web.UI.Common.jQuery.js"
/>
<
asp:ScriptReference
Assembly
=
"Telerik.Web.UI"
Name
=
"Telerik.Web.UI.Common.jQueryInclude.js"
/>
</
Scripts
>
</
telerik:RadScriptManager
>
<
telerik:RadAjaxManager
ID
=
"RadAjaxManager1"
runat
=
"server"
>
</
telerik:RadAjaxManager
>
<
div
class
=
"pnlCourseMainContentDialog"
>
<
asp:ContentPlaceHolder
id
=
"cphMain"
runat
=
"server"
>
</
asp:ContentPlaceHolder
>
</
div
>
</
asp:PlaceHolder
>
<
telerik:RadAjaxManagerProxy
ID
=
"RadAjaxManagerProxy1"
runat
=
"server"
>
</
telerik:RadAjaxManagerProxy
>
<
telerik:RadCodeBlock
ID
=
"RadCodeBlock1"
runat
=
"server"
>
<
script
type
=
"text/javascript"
>
window.$ = $telerik.$;
function get_RadWindow() { var oWindow = null; if (window.radWindow) { oWindow = window.radWindow; } else if ((window.frameElement) && (window.frameElement.radWindow)) { oWindow = window.frameElement.radWindow; } return oWindow; }
function JustClose() { get_RadWindow().Close(); }
function fileUploaded(sender, eventArgs) {
$find("<%= RadAjaxManager.GetCurrent(Page).ClientID %>").ajaxRequest();
}
function requestStart(sender, eventArgs) {
}
function responseEnd(sender, eventArgs) {
var oWnd = get_RadWindow();
var oArg = new Object();
oArg.id = $("#<%= hfId.ClientID %>").val();
alert('Id is: ' + oArg.id + " ");
/*
//Close the RadWindow and send the argument to the parent page
if (oWnd)
oWnd.close(oArg);
*/
}
function test() {
$find("<%= RadAjaxManager.GetCurrent(Page).ClientID %>").ajaxRequest();
}
</
script
>
</
telerik:RadCodeBlock
>
<
asp:HiddenField
ID
=
"hfId"
runat
=
"server"
/>
<
asp:TextBox
ID
=
"tbId"
runat
=
"server"
></
asp:TextBox
>
<
input
type
=
"button"
onclick
=
"test()"
/>
}
protected
void
manager_AjaxRequest(
object
sender, Telerik.Web.UI.AjaxRequestEventArgs e)
{
//handle the manager AjaxRequest event here
hfId.Value =
"100"
;
}
protected
void
Page_Load(
object
sender, EventArgs e)
{
RadAjaxManager manager = RadAjaxManager.GetCurrent(Page);
manager.ClientEvents.OnRequestStart =
"requestStart"
;
manager.ClientEvents.OnResponseEnd =
"responseEnd"
;
manager.AjaxRequest +=
new
RadAjaxControl.AjaxRequestDelegate(manager_AjaxRequest);
manager.AjaxSettings.AddAjaxSetting(manager,
this
.hfId);
}