1模拟网易邮箱实现全选,全不的功能(服务端和客户端) 2 使用DataList实现 加入购物车,编辑,删除,更新,取消功能。要求连一个产品表。

来源:互联网 发布:mt4自动交易kd指标编程 编辑:程序博客网 时间:2024/05/16 14:48

1模拟网易邮箱实现全选,全不的功能(服务端和客户端)

<%@ Page Xlanguage="C#" AutoEventWireup="true" CodeBehind="demoxf.aspx.cs" Inherits="cbk.demoxf" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<script type="text/javascript">
function chage(sender) {
var table = document.getElementById("GridView1");
for (var i = 1; i < table.rows.length; i++) {
table.rows[i].getElementsByTagName("input")[0].checked = sender.checked;

}
}
</script>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:studentConnectionString %>"
SelectCommand="SELECT * FROM [area]"></asp:SqlDataSource>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource1">
<Columns>
<asp:BoundField DataField="id" HeaderText="id" SortExpression="id" />
<asp:BoundField DataField="areaID" HeaderText="areaID"
SortExpression="areaID" />
<asp:BoundField DataField="area" HeaderText="area" SortExpression="area" />
<asp:BoundField DataField="father" HeaderText="father"
SortExpression="father" />
<asp:TemplateField>
<HeaderTemplate>
<asp:CheckBox ID="CheckBox2" runat="server" AutoPostBack="True"
Xoncheckedchanged="CheckBox2_CheckedChanged" />
<br />
<input id="Checkbox3" type="checkbox" Xonclick="chage(this)" />
</HeaderTemplate>
<ItemTemplate>
<asp:CheckBox ID="CheckBox1" runat="server" />
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
</div>
</form>
</body>
</html>
aspx.cs:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace cbk
{
public partial class demoxf : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}

protected void CheckBox2_CheckedChanged(object sender, EventArgs e)
{
CheckBox cbk = (CheckBox)sender;
foreach (GridViewRow row in GridView1.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
CheckBox c = (CheckBox)row.FindControl("CheckBox1");
c.Checked = cbk.Checked;
}
}
}
}
}

2 使用DataList实现 加入购物车,编辑,删除,更新,取消功能。要求连一个产品表。

前台:

<%@ Page Xlanguage="C#" AutoEventWireup="true" CodeBehind="Demo1.aspx.cs" Inherits="DataList.Demo1" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<style type="text/css">
.style1
{
width: 67px;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div>

<asp:DataList ID="DataList1" runat="server" Height="707px"
Xoncancelcommand="DataList1_CancelCommand"
Xondeletecommand="DataList1_DeleteCommand" Xoneditcommand="DataList1_EditCommand"
Xonitemcommand="DataList1_ItemCommand"
Xonselectedindexchanged="DataList1_SelectedIndexChanged"
Xonupdatecommand="DataList1_UpdateCommand">
<EditItemTemplate>
<table style="width:100%;">
<tr>
<td class="style1">
姓名:</td>
<td>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Eval("sname") %>'></asp:TextBox>
</td>
</tr>
<tr>
<td class="style1">
性别:</td>
<td>
<asp:TextBox ID="TextBox2" runat="server" Text='<%# Eval("sex") %>'></asp:TextBox>
</td>
</tr>
<tr>
<td class="style1">
年龄:</td>
<td>
<asp:TextBox ID="TextBox3" runat="server" Text='<%# Eval("age") %>'></asp:TextBox>
</td>
</tr>
<tr>
<td class="style1">
<asp:Button ID="btnUpdate" runat="server" CommandArgument='<%# Eval("sid") %>'
CommandName="update" Text="更新" />
</td>
<td>
<asp:Button ID="btnCancel" runat="server" CommandArgument='<%# Eval("sid") %>'
CommandName="cancel" Text="取消" />
</td>
</tr>
</table>
</EditItemTemplate>
<ItemTemplate>
<br/>
姓名:<asp:Label ID="Label1" runat="server" Text='<%# Eval("sname") %>'></asp:Label>
<br />
性别:<asp:Label ID="Label2" runat="server" Text='<%# Eval("sex") %>'></asp:Label>
<br />
年龄:<asp:Label ID="Label3" runat="server" Text='<%# Eval("age") %>'></asp:Label>
<br />
<asp:Button ID="btnEdit" runat="server" CommandName="edit" Text="编辑" />
&nbsp;<asp:Button ID="btnDelete" runat="server" CommandName="delete" Text="删除" />
<br />
<br />
<br />
<asp:Button ID="Button1" runat="server" Text="放入购物车"
CommandArgument='<%# Eval("sid") %>' CommandName="Buy" />
<br/>
</ItemTemplate>
</asp:DataList>

<br />
<asp:Button ID="Button2" runat="server" Text="Button" />
<asp:Button ID="Button3" runat="server" Text="Button" />
<asp:Button ID="Button4" runat="server" Text="Button" />
<asp:Button ID="Button5" runat="server" Text="Button" />

</div>
</form>
</body>
</html>
后台:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;

namespace DataList
{
public partial class Demo1 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if(!IsPostBack)
bindProduct();
}

private void bindProduct()
{
string sql = "select * from student";
DataTable dt = SqlHealpler2.SqlHealper.ExecuteDataTable(sql);
this.DataList1.DataSource = dt;
this.DataList1.DataBind();
}

protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)
{
if (e.CommandName == "buy")
{
Response.Write(e.CommandArgument.ToString());
}
}

protected void DataList1_EditCommand(object source, DataListCommandEventArgs e)
{
this.DataList1.EditItemIndex = e.Item.ItemIndex;
this.bindProduct();
}

protected void DataList1_UpdateCommand(object source, DataListCommandEventArgs e)
{
string name = (e.Item.FindControl("TextBox1") as TextBox).Text;
string sex = (e.Item.FindControl("TextBox2") as TextBox).Text;
string age = (e.Item.FindControl("TextBox3") as TextBox).Text;

string sql = "update student set sname=@name,sex=@sex,age=@age where sid=@sid";

SqlParameter[] pms = new SqlParameter[]{
new SqlParameter("@name",name),
new SqlParameter("@sex",sex),
new SqlParameter("@age",age),
new SqlParameter("@sid",e.CommandArgument)
};
SqlHealpler2.SqlHealper.ExectueNonQuery(sql, pms);
}

protected void DataList1_CancelCommand(object source, DataListCommandEventArgs e)
{
this.DataList1.EditItemIndex = -1;
this.bindProduct();
}

protected void DataList1_DeleteCommand(object source, DataListCommandEventArgs e)
{
string sql = "delete from student where sid=@sid";
SqlParameter p1 = new SqlParameter("@sid", e.CommandArgument);
SqlHealpler2.SqlHealper.ExectueNonQuery(sql, p1);
this.bindProduct();
}

protected void DataList1_SelectedIndexChanged(object sender, EventArgs e)
{

}
}
}

原创粉丝点击