📄 index.aspx
字号:
<%@ Page Language="vb" Debug="true" %>
<%@ Import NameSpace="System.Data" %>
<%@ Import NameSpace="System.Data.SQLClient" %>
<%@ Import NameSpace="System.Configuration" %>
<html>
<head>
<title>li的测试页面 - LI Daojing' testpage</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<meta name="Creator" content="LI Daojing" />
<style type="text/css">
<!--
* {
margin:0px auto;
padding:0px;
}
html { overflow:-moz-scrollbars-vertical; }
body {
background-image:url(images/bg.jpg);
text-align:center;
background-attachment:fixed;
}
<!-- make round corner -->
b.trr1{display:block;height:1px;background-color:#15549B;overflow:hidden;margin:0 6px; border-color:#15549B;}
b.trr2{display:block;height:1px;background-color:#15549B;overflow:hidden;margin:0 4px;border-left:solid black 2px;border-right:solid black 2px; border-color:#15549B;}
b.trr3{display:block;height:1px;background-color:#15549B;overflow:hidden;margin:0 3px;border-left:solid black 1px;border-right:solid black 1px; border-color:#15549B;}
b.trr4{display:block;height:1px;background-color:#15549B;overflow:hidden;margin:0 2px;border-left:solid black 1px;border-right:solid black 1px; border-color:#15549B;}
b.trr5{display:block;height:2px;background-color:#15549B;overflow:hidden;margin:0 1px;border-left:solid black 1px;border-right:solid black 1px; border-color:#15549B;}
b.drr1{display:block;height:1px;background-color:#15549B;overflow:hidden;margin:0 6px; border-color:#15549B;}
b.drr2{display:block;height:1px;background-color:#15549B;overflow:hidden;margin:0 4px;border-left:solid black 2px;border-right:solid black 2px; border-color:#15549B;}
b.drr3{display:block;height:1px;background-color:#15549B;overflow:hidden;margin:0 3px;border-left:solid black 1px;border-right:solid black 1px; border-color:#15549B;}
b.drr4{display:block;height:1px;background-color:#15549B;overflow:hidden;margin:0 2px;border-left:solid black 1px;border-right:solid black 1px; border-color:#15549B;}
b.drr5{display:block;height:2px;background-color:#15549B;overflow:hidden;margin:0 1px;border-left:solid black 1px;border-right:solid black 1px; border-color:#15549B;}
#container {
margin:20px auto 0px;
width:800px;
font-family:"宋体";
font-size:10.5pt;
color:#222;
background-color:#FFF;
border:solid #FFF;
}
#header {
height:200px;
background-image:url(images/header.gif);
}
#mainbody {
background-color:#F0F0F0;
padding:10px;
}
#footer {
padding:16px 0px;
background-color:#15549B;
color:#FFF;
line-height:20px;
font-size:10pt;
font-family:arial;
}
p {
text-indent:2em;
line-height:20px;
color:#222;
text-align:justify;
}
field, img { border:none; }
img.frame {
background: #C0C0C0;
border:2px solid #C0C0C0;
padding: 4px;
width:60px;
height:60px;
}
table {
text-align:center;
border-collapse:collapse;
}
table tr td { padding:5px; }
h5 {
margin:10px auto;
margin:10px;
font-size:11pt;
}
hr {
margin:10px;
border:1px dashed #222;
clear:both;
}
#footer a {
color:#FFF;
text-decoration:none;
}
#footer a:active, #footer a:focus { outline:none; }
#footer a:hover {
color:#aa0033;
position:relative;
left:1px;
top:1px;
clip:rect();
}
-->
</style>
<script language="javascript">
function bookmark()
{
var title='李道敬的测试页面';
var url='http://localhost/index.aspx';
if(document.all)window.external.AddFavorite(url,title);
else if(window.sidebar)window.sidebar.addPanel(title,url,"");
else if(window.opera && window.print)return true;
}
</script>
<script runat="server">
Sub Page_Load(sender As Object, e As EventArgs)
If Not IsPostBack then
BindData
End If
End Sub
Sub BindData
Dim myDataSet As New DataSet
Dim myConnection As SQLConnection=New SqlConnection(ConfigurationSettings.appSettings("connectString"))
myConnection.Open()
Dim myDataAdapter As SqlDataAdapter=New SqlDataAdapter("SELECT * FROM productTest", myConnection)
myDataAdapter.Fill(myDataSet,"productTest")
myDataGrid.DataSource=myDataSet
myDataGrid.DataBind()
myConnection.close()
End Sub
Sub ChangePage(s As Object, e As DataGridPageChangedEventArgs)
myDataGrid.CurrentPageIndex=e.NewPageIndex
BindData
End Sub
Sub grid_edit(Sender As Object, e As DataGridCommandEventArgs)
myDataGrid.columns(3).visible="true"
mydatagrid.columns(2).visible="false"
myDataGrid.EditItemIndex=e.Item.ItemIndex
BindData
End Sub
Sub grid_canceledit(Sender As Object, e As DataGridCommandEventArgs)
mydatagrid.columns(3).visible="false"
mydatagrid.columns(2).visible="true"
myDataGrid.EditItemIndex=-1
BindData
End Sub
Sub grid_update(Sender As Object, e As DataGridCommandEventArgs)
Dim myConnection As SQLConnection=New SqlConnection(ConfigurationSettings.appSettings("connectString"))
Dim uName As TextBox=e.Item.FindControl("productName")
Dim uImage As TextBox=e.Item.FindControl("productImage")
Dim uPrice As TextBox=e.Item.FindControl("productPrice")
myConnection.Open()
Dim ids as integer=myDataGrid.DataKeys(e.Item.ItemIndex)
Dim mySqlCmd As New SqlCommand("UPDATE productTest SET productName=@uName, " & "productImage=@uImage, " & "productPrice=@uPrice WHERE id=" & ids,myConnection)
mySqlCmd.Parameters.Add(New SqlParameter("@uName", SqlDbType.NVARChar,255))
mySqlCmd.Parameters("@uName").Value=uName.text
mySqlCmd.executeNonQuery()
myConnection.close()
mydatagrid.columns(3).visible="false"
mydatagrid.columns(2).visible="true"
myDataGrid.EditItemIndex=-1
BindData
label1.text=myDataGrid.items(e.Item.ItemIndex).cells(1).Text
End Sub
Sub grid_delete(Sender As Object, e As DataGridCommandEventArgs)
Dim myConnection As SQLConnection=New SqlConnection(ConfigurationSettings.appSettings("connectString"))
myConnection.Open()
Dim ids as integer=myDataGrid.DataKeys(e.Item.ItemIndex)
Dim mySqlCmd As New SqlCommand("delete from productTest where id=" & ids,myConnection)
mySqlCmd.executeNonQuery()
myConnection.close()
myDataGrid.EditItemIndex=-1
BindData
End Sub
</script>
</head>
<body>
<div id="container">
<b class=trr1></b><b class=trr2></b><b class=trr3></b><b class=trr4></b><b class=trr5></b>
<div id="header"></div>
<div id="mainbody" style="height:550px;">
<h5>数据的列表显示</h5>
<form runat="server">
<asp:DataGrid id="myDataGrid" runat="server" AllowPaging="true" PageSize="5" PagerStyle-HorizontanAlign="Right" PagerStyle-Mode="NumericPages" PagerStyle-Backcolor="#C0C0C0" OnPageIndexChanged="Changepage" OnDeleteCommand="grid_delete" OnEditCommand="grid_edit" OnCancelCommand="grid_canceledit" OnUpdateCommand="grid_update" AutoGenerateColumns="False" datakeyfield="id" width="700" CellPadding="3" CellSpacing="0" BorderColor="black" BackColor="#ccccff" ShowFooter="false" font="7pt" HeaderStyle-BackColor="#C0C0C0" AlternatingItemStyle-BackColor="#ffffcd">
<columns>
<asp:BoundColumn visible="false" datafield="id" headertext="id" />
<asp:BoundColumn datafield="productName" headertext="产品名称" />
<asp:templatecolumn headertext="产品图片">
<itemtemplate><img class="frame" src=<%#databinder.eval(container.dataitem,"productImage")%>></itemtemplate>
</asp:templatecolumn>
<asp:BoundColumn visible="false" datafield="productImage" headertext="图片地址" />
<asp:BoundColumn datafield="productPrice" headertext="产品价格" />
<asp:editCommandColumn CancelText="取消" EditText="编辑" UpdateText="更新" HeaderText="编辑" />
<asp:buttonColumn CommandName="Delete" Text="删除" HeaderText="命令" />
</columns>
</asp:datagrid>
</form>
<asp:label id="label1" runat="server" />
</div>
<div id="footer">
<a href="javascript:bookmark();">收藏本站</a> | <a href="http://www.usst.edu.cn" target="_blank">上海理工大学</a> | <a href="http://ccad.usst.edu.cn/" target="_blank">出版印刷与艺术设计学院</a> | <a href="http://xy2.usst.edu.cn/art/diffuse/" target="_blank">现代传播科学实验中心</a><br>程序设计 ©2009 上海理工大学 <a href="mailto:1073704661@qq.com">李道敬</a><br>住址：上海市军工路516号；☎ 021-55277040
</div>
<b class=drr5></b><b class=drr4></b><b class=drr3></b><b class=drr2></b><b class=drr1></b>
</div>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -