📄 18db.txt
字号:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Data"%>
<!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=project;user id=aspnetname;password=123456";
SqlConnection myconn = new SqlConnection(str1);
string str2 = "select * from 项目";
SqlDataAdapter myadapter1 = new SqlDataAdapter(str2,myconn);
DataSet mydata1 = new DataSet();
myadapter1.Fill(mydata1,"项目");
mygrid1.DataSource = mydata1;
mygrid1.DataBind();
}
</script>
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<meta http-equiv="Content-Type" content="text/html;charset=gb2312" />
<title>U表格显示数据库中的数据</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<center>
<h3>表格表示数据库中的数据</h3>
<asp:DataGrid ID="mygrid1" runat="server" BackColor="#33CCCC" Font-Bold="True"
Font-Size="Medium"></asp:DataGrid>
</center>
</div>
</form>
</body>
</html>
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Data"%>
<!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);
string str2 = "select * from 华师通讯录";
SqlDataAdapter myadapter1 = new SqlDataAdapter(str2,myconn);
DataSet mydata1 = new DataSet();
myadapter1.Fill(mydata1, "华师通讯录");
mygrid1.DataSource = mydata1;
mygrid1.DataBind();
}
void changedpage(Object source, DataGridPageChangedEventArgs e)
{
mygrid1.CurrentPageIndex = e.NewPageIndex;
mygrid1.DataBind();
}
</script>
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<meta http-equiv="Content-Type" content="text/html;charset=gb2312" />
<title>华师通讯录</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<center>
<h3>华师通讯录</h3>
<asp:DataGrid ID="mygrid1" runat="server" BackColor="#33CCCC" Font-Bold="True" AllowPaging="true" OnPageIndexChanged="changedpage" PageSize="10"
Font-Size="Medium">
<PagerStyle HorizontalAlign="Right" Mode="NumericPages" />
</asp:DataGrid>
</center>
</div>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -