📄 19db.txt
字号:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script language="c#" runat="server">
void Page_Load(Object source, EventArgs e)
{
string str1 = "Persist Security Info=false;database=通讯录;user id=yzy;password=123456";
SqlConnection myconn = new SqlConnection(str1);
SqlDataAdapter myadapter1 = new SqlDataAdapter("select * from 韩师通讯录", myconn);
DataSet mydata1 = new DataSet();
myadapter1.Fill(mydata1, "韩师通讯录");
DataRow myrow1 = mydata1.Tables["韩师通讯录"].NewRow();
myrow1["学号"] = "03116100";
myrow1["姓名"] = "吴丽贤";
myrow1["手机号码"] = "13727973346";
myrow1["邮箱"] = null;
myrow1["家庭电话"] = null;
myrow1["家庭地址"] = "韩山师范学院";
myrow1["邮编"] = "521041";
mydata1.Tables["韩师通讯录"].Rows.Add(myrow1);
SqlCommandBuilder mybuilder1 = new SqlCommandBuilder(myadapter1);
myadapter1.InsertCommand = mybuilder1.GetInsertCommand();
myadapter1.Update(mydata1, "韩师通讯录");
mydata1.Clear();
myadapter1.Fill(mydata1, "韩师通讯录");
mylist1.DataSource = mydata1;
mylist1.DataBind();
}
</script>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html;charset=gb2312" />
<title>韩师通讯录</title>
</head>
<body>
<center>
<h3>
韩师通讯录</h3>
</center>
<form id="form1" runat="server">
<div>
<center>
<asp:DataList ID="mylist1" runat="server">
<HeaderStyle BackColor="#FF9900" />
<AlternatingItemStyle BackColor="#9999FF" />
<HeaderTemplate>
韩师通讯录的信息</HeaderTemplate>
<ItemTemplate>
<%#DataBinder.Eval(Container.DataItem,"学号 ") %>
<%#DataBinder.Eval(Container.DataItem,"姓名 ") %>
<%#DataBinder.Eval(Container.DataItem,"手机号码 ") %>
<%#DataBinder.Eval(Container.DataItem,"家庭电话 ") %>
<%#DataBinder.Eval(Container.DataItem,"家庭地址 ") %>
<%#DataBinder.Eval(Container.DataItem,"邮编 ") %>
</ItemTemplate>
<SeparatorTemplate><hr /></SeparatorTemplate>
<FooterTemplate>韩师通讯录</FooterTemplate>
</asp:DataList>
</center>
</div>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -