例子如下:
初始代码如下:
有关删除的代码如下:
在这里要是没有添加:
Response.Redirect(
"
WebForm1.aspx
"
);
//
能不能不要是直接加载本页面?
这一句,没有办法看出没有删除(看了数据库才知道!)
有没有办法说不用跳转加本页,一样可以直接看到是否有删除?
初始代码如下:
1
protected
System.Web.UI.WebControls.DataGrid DataGrid1;
2
private
DataSet ds
=
new
DataSet();
3
4
private
void
Page_Load(
object
sender, System.EventArgs e)
5![ExpandedBlockStart.gif](/Images/OutliningIndicators/ExpandedBlockStart.gif)
{
6
// 在此处放置用户代码以初始化页面
7
if(!this.IsPostBack)
8![ExpandedSubBlockStart.gif](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
9
string strConnection = ConfigurationSettings.AppSettings["ConnectionString"].ToString();
10
SqlConnection myConnection = new SqlConnection(strConnection);
11
SqlDataAdapter myAdapter = new SqlDataAdapter("SELECT CategoryID,CategoryName, Description FROM Categories",myConnection);
12
myAdapter.Fill(ds);
13
this.DataGrid1.DataSource = ds.Tables[0].DefaultView;
14
this.DataGrid1.DataKeyField = "CategoryID";
15
this.DataGrid1.DataBind();
16
}
17
![None.gif](/Images/OutliningIndicators/None.gif)
2
![None.gif](/Images/OutliningIndicators/None.gif)
3
![None.gif](/Images/OutliningIndicators/None.gif)
4
![None.gif](/Images/OutliningIndicators/None.gif)
5
![ExpandedBlockStart.gif](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![ContractedBlock.gif](/Images/OutliningIndicators/ContractedBlock.gif)
![dot.gif](/Images/dot.gif)
6
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
7
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
8
![ExpandedSubBlockStart.gif](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](/Images/OutliningIndicators/ContractedSubBlock.gif)
![dot.gif](/Images/dot.gif)
9
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
10
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
11
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
12
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
13
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
14
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
15
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
16
![ExpandedSubBlockEnd.gif](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
17
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
有关删除的代码如下:
1
private
void
DataGrid1_ItemDataBound(
object
sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
2![ExpandedBlockStart.gif](/Images/OutliningIndicators/ExpandedBlockStart.gif)
{
3
if(e.Item.ItemIndex!=-1)
4![ExpandedSubBlockStart.gif](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
5
e.Item.Cells[1].Text=Convert.ToString((e.Item.ItemIndex+1));
6
}
7![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
8
switch(e.Item.ItemType)
9![ExpandedSubBlockStart.gif](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
10
case ListItemType.Item:
11
case ListItemType.AlternatingItem:
12
case ListItemType.EditItem:
13![ExpandedSubBlockStart.gif](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
14
Button btn = (Button)e.Item.FindControl("btnDelete");
15
btn.Attributes.Add("onclick", "return confirm('你是否确定删除这条记录');");
16
break;
17
}
18
}
19
}
20![None.gif](/Images/OutliningIndicators/None.gif)
21
private
void
DataGrid1_ItemCommand(
object
source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
22![ExpandedBlockStart.gif](/Images/OutliningIndicators/ExpandedBlockStart.gif)
{
23
if(e.CommandName == "Delete")
24![ExpandedSubBlockStart.gif](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
25
this.DeleteRow(this.DataGrid1.DataKeys[e.Item.ItemIndex].ToString());
26
}
27
Response.Redirect("WebForm1.aspx");//能不能不要是直接加载本页面?
28
}
29![None.gif](/Images/OutliningIndicators/None.gif)
30
private
void
DeleteRow(
string
i)
31![ExpandedBlockStart.gif](/Images/OutliningIndicators/ExpandedBlockStart.gif)
{
32
string strConnection = ConfigurationSettings.AppSettings["ConnectionString"].ToString();
33
SqlConnection myConnection = new SqlConnection(strConnection);
34
SqlCommand cmd = new SqlCommand("DELETE FROM Categories WHERE (CategoryID = "+i+")",myConnection);
35
myConnection.Open();
36
cmd.ExecuteNonQuery();
37
myConnection.Close();
38
}
39
![None.gif](/Images/OutliningIndicators/None.gif)
2
![ExpandedBlockStart.gif](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![ContractedBlock.gif](/Images/OutliningIndicators/ContractedBlock.gif)
![dot.gif](/Images/dot.gif)
3
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
4
![ExpandedSubBlockStart.gif](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](/Images/OutliningIndicators/ContractedSubBlock.gif)
![dot.gif](/Images/dot.gif)
5
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
6
![ExpandedSubBlockEnd.gif](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
7
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
8
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
9
![ExpandedSubBlockStart.gif](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](/Images/OutliningIndicators/ContractedSubBlock.gif)
![dot.gif](/Images/dot.gif)
10
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
11
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
12
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
13
![ExpandedSubBlockStart.gif](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](/Images/OutliningIndicators/ContractedSubBlock.gif)
![dot.gif](/Images/dot.gif)
14
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
15
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
16
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
17
![ExpandedSubBlockEnd.gif](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
18
![ExpandedSubBlockEnd.gif](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
19
![ExpandedBlockEnd.gif](/Images/OutliningIndicators/ExpandedBlockEnd.gif)
20
![None.gif](/Images/OutliningIndicators/None.gif)
21
![None.gif](/Images/OutliningIndicators/None.gif)
22
![ExpandedBlockStart.gif](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![ContractedBlock.gif](/Images/OutliningIndicators/ContractedBlock.gif)
![dot.gif](/Images/dot.gif)
23
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
24
![ExpandedSubBlockStart.gif](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](/Images/OutliningIndicators/ContractedSubBlock.gif)
![dot.gif](/Images/dot.gif)
25
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
26
![ExpandedSubBlockEnd.gif](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
27
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
28
![ExpandedBlockEnd.gif](/Images/OutliningIndicators/ExpandedBlockEnd.gif)
29
![None.gif](/Images/OutliningIndicators/None.gif)
30
![None.gif](/Images/OutliningIndicators/None.gif)
31
![ExpandedBlockStart.gif](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![ContractedBlock.gif](/Images/OutliningIndicators/ContractedBlock.gif)
![dot.gif](/Images/dot.gif)
32
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
33
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
34
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
35
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
36
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
37
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
38
![ExpandedBlockEnd.gif](/Images/OutliningIndicators/ExpandedBlockEnd.gif)
39
![None.gif](/Images/OutliningIndicators/None.gif)
前台代码如下:
1
<
body
MS_POSITIONING
="GridLayout"
>
2
<
form
id
="Form1"
method
="post"
runat
="server"
>
3
<
FONT
face
="宋体"
>
4
<
asp:DataGrid
id
="DataGrid1"
style
="Z-INDEX: 101; LEFT: 48px; POSITION: absolute; TOP: 88px"
runat
="server"
5
Width
="632px"
>
6
<
Columns
>
7
<
asp:TemplateColumn
HeaderText
="删除"
>
8
<
HeaderTemplate
>
9
删除
10
</
HeaderTemplate
>
11
<
ItemTemplate
>
12
<
asp:Button
id
="btnDelete"
runat
="server"
CommandName
="Delete"
Text
="Delete"
></
asp:Button
>
13
</
ItemTemplate
>
14
</
asp:TemplateColumn
>
15
<
asp:TemplateColumn
HeaderText
="序号"
></
asp:TemplateColumn
>
16
</
Columns
>
17
</
asp:DataGrid
></
FONT
>
18
</
form
>
19
</
body
>
![None.gif](/Images/OutliningIndicators/None.gif)
2
![None.gif](/Images/OutliningIndicators/None.gif)
3
![None.gif](/Images/OutliningIndicators/None.gif)
4
![None.gif](/Images/OutliningIndicators/None.gif)
5
![None.gif](/Images/OutliningIndicators/None.gif)
6
![None.gif](/Images/OutliningIndicators/None.gif)
7
![None.gif](/Images/OutliningIndicators/None.gif)
8
![None.gif](/Images/OutliningIndicators/None.gif)
9
![None.gif](/Images/OutliningIndicators/None.gif)
10
![None.gif](/Images/OutliningIndicators/None.gif)
11
![None.gif](/Images/OutliningIndicators/None.gif)
12
![None.gif](/Images/OutliningIndicators/None.gif)
13
![None.gif](/Images/OutliningIndicators/None.gif)
14
![None.gif](/Images/OutliningIndicators/None.gif)
15
![None.gif](/Images/OutliningIndicators/None.gif)
16
![None.gif](/Images/OutliningIndicators/None.gif)
17
![None.gif](/Images/OutliningIndicators/None.gif)
18
![None.gif](/Images/OutliningIndicators/None.gif)
19
![None.gif](/Images/OutliningIndicators/None.gif)
在这里要是没有添加:
![None.gif](/Images/OutliningIndicators/None.gif)
有没有办法说不用跳转加本页,一样可以直接看到是否有删除?