3 Answers, 1 is accepted
0
Princy
Top achievements
Rank 2
answered on 18 Jun 2013, 09:19 AM
Hi Raka,
Please try the following code snippet.
ASPX:
Thanks,
Princy
Please try the following code snippet.
ASPX:
<
telerik:RadGrid
ID
=
"RadGrid1"
DataSourceID
=
"SqlDataSource1"
runat
=
"server"
AutoGenerateColumns
=
"False"
PageSize
=
"10"
AllowSorting
=
"True"
AllowPaging
=
"True"
GridLines
=
"None"
AllowAutomaticDeletes
=
"true"
>
<
ClientSettings
>
<
Selecting
AllowRowSelect
=
"true"
/>
</
ClientSettings
>
<
MasterTableView
DataKeyNames
=
"CustomerID"
CommandItemDisplay
=
"Top"
Name
=
"Customers"
>
<
DetailTables
>
<
telerik:GridTableView
DataKeyNames
=
"OrderID"
DataSourceID
=
"SqlDataSource2"
Width
=
"100%"
runat
=
"server"
CommandItemDisplay
=
"Top"
Name
=
"Orders"
>
<
ParentTableRelation
>
<
telerik:GridRelationFields
DetailKeyField
=
"CustomerID"
MasterKeyField
=
"CustomerID"
>
</
telerik:GridRelationFields
>
</
ParentTableRelation
>
<
DetailTables
>
<
telerik:GridTableView
DataKeyNames
=
"OrderID,ProductID"
DataSourceID
=
"SqlDataSource3"
Width
=
"100%"
runat
=
"server"
CommandItemDisplay
=
"Top"
Name
=
"Details"
>
<
ParentTableRelation
>
<
telerik:GridRelationFields
DetailKeyField
=
"OrderID"
MasterKeyField
=
"OrderID"
></
telerik:GridRelationFields
>
</
ParentTableRelation
>
<
Columns
>
... ... ...
</
Columns
>
</
telerik:GridTableView
>
</
DetailTables
>
<
Columns
>
... ... ...
</
Columns
>
</
telerik:GridTableView
>
</
DetailTables
>
<
Columns
>
... ... ...
</
Columns
>
<
CommandItemTemplate
>
<
asp:LinkButton
ID
=
"LinkButton1"
Height
=
"50px"
OnClientClick
=
"javascript:return confirm('Delete all selected customers?')"
runat
=
"server"
CommandName
=
"DeleteSelected"
>Delete selected customers</
asp:LinkButton
>
</
CommandItemTemplate
>
</
MasterTableView
>
</
telerik:RadGrid
>
<
asp:SqlDataSource
ID
=
"SqlDataSource1"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:Northwind_newConnectionString3 %>"
DeleteCommand="DELETE FROM [Customers] WHERE [CustomerID] = @CustomerID" SelectCommand="SELECT * FROM [Customers]">
<
DeleteParameters
>
<
asp:Parameter
Name
=
"CustomerID"
Type
=
"String"
></
asp:Parameter
>
</
DeleteParameters
>
</
asp:SqlDataSource
>
<
asp:SqlDataSource
ID
=
"SqlDataSource2"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:Northwind_newConnectionString3 %>"
DeleteCommand="DELETE FROM [Orders] WHERE [OrderID] = @OrderID" SelectCommand="SELECT * FROM [Orders]">
<
SelectParameters
>
<
asp:Parameter
Name
=
"CustomerID"
Type
=
"String"
></
asp:Parameter
>
</
SelectParameters
>
<
DeleteParameters
>
<
asp:Parameter
Name
=
"OrderID"
Type
=
"Int32"
></
asp:Parameter
>
</
DeleteParameters
>
</
asp:SqlDataSource
>
<
asp:SqlDataSource
ID
=
"SqlDataSource3"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:Northwind_newConnectionString3 %>"
DeleteCommand="DELETE FROM [Order Details] WHERE [OrderID] = @OrderID AND [ProductID] = @ProductID"
SelectCommand="SELECT * FROM [Order Details] ">
<
SelectParameters
>
<
asp:Parameter
Name
=
"OrderID"
Type
=
"Int32"
></
asp:Parameter
>
</
SelectParameters
>
<
DeleteParameters
>
<
asp:Parameter
Name
=
"OrderID"
Type
=
"Int32"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"ProductID"
Type
=
"Int32"
></
asp:Parameter
>
</
DeleteParameters
>
</
asp:SqlDataSource
>
Thanks,
Princy
0
Raka
Top achievements
Rank 1
answered on 18 Jun 2013, 11:13 AM
Hello Princy
Thanks for your reply. However mine is a self referencing grid and so I do not have separate tables.
It looks like --
<MasterTableView DataKeyNames="EmployeeId, EmployerId" ...>
<SelfHierarchySettings ParentKeyName="EmployerId" KeyName="EmployeeId" />
<Columns>
...
So it needs some sort of cascading or recursive delete. I am not quite sure how to do it.
Thanks
Raka
Thanks for your reply. However mine is a self referencing grid and so I do not have separate tables.
It looks like --
<MasterTableView DataKeyNames="EmployeeId, EmployerId" ...>
<SelfHierarchySettings ParentKeyName="EmployerId" KeyName="EmployeeId" />
<Columns>
...
So it needs some sort of cascading or recursive delete. I am not quite sure how to do it.
Thanks
Raka
0
Princy
Top achievements
Rank 2
answered on 21 Jun 2013, 10:44 AM
Hi Raka,
Please try the following code snippet,its using self referencing hierarchy.
ASPX:
C#:
Thanks,
Princy
Please try the following code snippet,its using self referencing hierarchy.
ASPX:
<
telerik:RadGrid
ID
=
"RadGrid1"
runat
=
"server"
DataSourceID
=
"SqlDataSource1"
onitemcommand
=
"RadGrid1_ItemCommand"
>
<
ClientSettings
Selecting-AllowRowSelect
=
"true"
>
</
ClientSettings
>
<
MasterTableView
HierarchyDefaultExpanded
=
"false"
HierarchyLoadMode
=
"Client"
AllowSorting
=
"true"
CommandItemDisplay
=
"Top"
DataKeyNames
=
"EmployeeID, ReportsTo"
Width
=
"100%"
>
<
SelfHierarchySettings
ParentKeyName
=
"ReportsTo"
KeyName
=
"EmployeeID"
/>
<
CommandItemTemplate
>
<
asp:LinkButton
ID
=
"LinkButton1"
Height
=
"50px"
runat
=
"server"
CommandName
=
"DeleteSelected"
>Delete selected customers</
asp:LinkButton
>
</
CommandItemTemplate
>
</
MasterTableView
>
<
ClientSettings
AllowExpandCollapse
=
"true"
/>
</
telerik:RadGrid
>
C#:
protected
void
RadGrid1_ItemCommand(
object
sender, Telerik.Web.UI.GridCommandEventArgs e)
{
if
(e.CommandName ==
"DeleteSelected"
)
{
//your code to delete
}
}
Thanks,
Princy