62,046
社区成员
发帖
与我相关
我的任务
分享
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Motorola.aspx.cs" Inherits="Motorola" %>
<!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>MOTOROLA</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="Data Source=MICROSOF-E0D392;Initial Catalog=ProductExhibitionSystem;Integrated Security=True"
ProviderName="System.Data.SqlClient" SelectCommand="SELECT [型号], [样式], [网络], [系统], [摄像头], [蓝牙], [WiFi], [价格] FROM [Motorola]">
</asp:SqlDataSource>
<asp:Menu ID="Menu1" runat="server" Style="z-index: 102; left: 8px; position: absolute;
top: 6px" BackColor="#E3EAEB" DynamicHorizontalOffset="2" Font-Names="Verdana" Font-Size="0.8em" ForeColor="#666666" StaticSubMenuIndent="10px">
<Items>
<asp:MenuItem NavigateUrl="~/HomePage.aspx" Text="首页" Value="首页">
<asp:MenuItem Text="欧美品牌" Value="欧美品牌">
<asp:MenuItem NavigateUrl="~/Nokia.aspx" Text="NOKIA" Value="NOKIA"></asp:MenuItem>
<asp:MenuItem NavigateUrl="~/Motorola.aspx" Text="MOTOROLA" Value="MOTOROLA"></asp:MenuItem>
<asp:MenuItem NavigateUrl="~/Apple.aspx" Text="Apple" Value="Apple"></asp:MenuItem>
<asp:MenuItem NavigateUrl="~/BlackBerry.aspx" Text="BlackBerry" Value="BlackBerry"></asp:MenuItem>
<asp:MenuItem NavigateUrl="~/Palm.aspx" Text="Palm" Value="Palm"></asp:MenuItem>
<asp:MenuItem NavigateUrl="~/SonyEricsson.aspx" Text="SonyEricsson" Value="SonyEricsson">
</asp:MenuItem>
</asp:MenuItem>
<asp:MenuItem Text="日韩品牌" Value="日韩品牌">
<asp:MenuItem NavigateUrl="~/Samsung.aspx" Text="SAMSUNG" Value="SAMSUNG"></asp:MenuItem>
<asp:MenuItem NavigateUrl="~/Lg.aspx" Text="LG" Value="LG"></asp:MenuItem>
<asp:MenuItem NavigateUrl="~/Sharp.aspx" Text="SHARP" Value="SHARP"></asp:MenuItem>
</asp:MenuItem>
<asp:MenuItem Text="国产品牌" Value="国产品牌">
<asp:MenuItem NavigateUrl="~/Dopod.aspx" Text="DOPOD" Value="DOPOD"></asp:MenuItem>
<asp:MenuItem NavigateUrl="~/Htc.aspx" Text="HTC" Value="HTC"></asp:MenuItem>
<asp:MenuItem NavigateUrl="~/Meizu.aspx" Text="Meizu" Value="Meizu"></asp:MenuItem>
</asp:MenuItem>
</asp:MenuItem>
</Items>
<StaticMenuItemStyle HorizontalPadding="5px" VerticalPadding="2px" />
<DynamicHoverStyle BackColor="#666666" ForeColor="White" />
<DynamicMenuStyle BackColor="#E3EAEB" />
<StaticSelectedStyle BackColor="#1C5E55" />
<DynamicSelectedStyle BackColor="#1C5E55" />
<DynamicMenuItemStyle HorizontalPadding="5px" VerticalPadding="2px" />
<StaticHoverStyle BackColor="#666666" ForeColor="White" />
</asp:Menu>
<br />
<br />
<br />
<br />
<br />
<br />
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
AutoGenerateColumns="False" BackColor="White" BorderColor="#999999" BorderStyle="None"
BorderWidth="1px" CellPadding="3" DataSourceID="SqlDataSource2" GridLines="Vertical"
OnRowDataBound="GridView1_RowDataBound1" PageSize="5">
<FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
<Columns>
<asp:BoundField DataField="型号" HeaderText="型号" SortExpression="型号" />
<asp:BoundField DataField="样式" HeaderText="样式" SortExpression="样式" />
<asp:BoundField DataField="网络" HeaderText="网络" SortExpression="网络" />
<asp:BoundField DataField="系统" HeaderText="系统" SortExpression="系统" />
<asp:BoundField DataField="摄像头" HeaderText="摄像头" SortExpression="摄像头" />
<asp:BoundField DataField="蓝牙" HeaderText="蓝牙" SortExpression="蓝牙" />
<asp:BoundField DataField="WiFi" HeaderText="WiFi" SortExpression="WiFi" />
<asp:BoundField DataField="价格" HeaderText="价格" SortExpression="价格" />
<asp:CommandField ShowEditButton="True" />
<asp:CommandField ShowDeleteButton="True" />
</Columns>
<RowStyle BackColor="#EEEEEE" ForeColor="Black" />
<SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
<HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="#DCDCDC" />
</asp:GridView>
</div>
</form>
</body>
</html>
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class Motorola : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
e.Row.Attributes.Add("onmouseover", "currentcolor=this.style.backgroundColor;this.style.backgroundColor='#6699ff'");
e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=currentcolor;");
}
}
protected void GridView1_RowDataBound1(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
e.Row.Attributes.Add("onmouseover", "currentcolor=this.style.backgroundColor;this.style.backgroundColor='#6699ff'");
e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=currentcolor;");
}
}
}
<asp:SqlDataSource
id="SqlDataSource1"
ConnectionString="server=;uid=sa;password=;database="
SelectCommand="Select ID,Name from table"
UpdateCommand="Update table set Name=@Name where ID=@ID"
runat="server" ></asp:SqlDataSource>