例子如下：
初始代码如下：
有关删除的代码如下：
在这里要是没有添加：
Response.Redirect("WebForm1.aspx");//能不能不要是直接加载本页面？
这一句，没有办法看出没有删除（看了数据库才知道！）
有没有办法说不用跳转加本页，一样可以直接看到是否有删除？
初始代码如下：
1protected System.Web.UI.WebControls.DataGrid DataGrid1;
2 private DataSet ds = new DataSet();
3
4 private void Page_Load(object sender, System.EventArgs e)
5
{
6
// 在此处放置用户代码以初始化页面
7 if(!this.IsPostBack)
8
{
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
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
{
6
// 在此处放置用户代码以初始化页面7
if(!this.IsPostBack)8
{
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
有关删除的代码如下：
1private void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
2 {
3 if(e.Item.ItemIndex!=-1)
4 {
5 e.Item.Cells[1].Text=Convert.ToString((e.Item.ItemIndex+1));
6 }
7
8 switch(e.Item.ItemType)
9 {
10 case ListItemType.Item:
11 case ListItemType.AlternatingItem:
12 case ListItemType.EditItem:
13 {
14 Button btn = (Button)e.Item.FindControl("btnDelete");
15 btn.Attributes.Add("onclick", "return confirm('你是否确定删除这条记录');");
16 break;
17 }
18 }
19
}
20
21 private void DataGrid1_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
22 {
23 if(e.CommandName == "Delete")
24 {
25 this.DeleteRow(this.DataGrid1.DataKeys[e.Item.ItemIndex].ToString());
26 }
27 Response.Redirect("WebForm1.aspx");//能不能不要是直接加载本页面？
28 }
29
30 private void DeleteRow(string i)
31 {
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
private void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)2
{3
if(e.Item.ItemIndex!=-1)4
{5
e.Item.Cells[1].Text=Convert.ToString((e.Item.ItemIndex+1));6
}7
8
switch(e.Item.ItemType)9
{10
case ListItemType.Item:11
case ListItemType.AlternatingItem:12
case ListItemType.EditItem:13
{14
Button btn = (Button)e.Item.FindControl("btnDelete");15
btn.Attributes.Add("onclick", "return confirm('你是否确定删除这条记录');");16
break;17
}18
}19
}20
21
private void DataGrid1_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)22
{23
if(e.CommandName == "Delete")24
{25
this.DeleteRow(this.DataGrid1.DataKeys[e.Item.ItemIndex].ToString());26
}27
Response.Redirect("WebForm1.aspx");//能不能不要是直接加载本页面？28
}29
30
private void DeleteRow(string i)31
{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
前台代码如下：
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>
<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>在这里要是没有添加：
Response.Redirect("WebForm1.aspx");//能不能不要是直接加载本页面？有没有办法说不用跳转加本页，一样可以直接看到是否有删除？
浙公网安备 33010602011771号