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
>