//引用命名空间
<%@ Import Namespace="jmvt"%>
<%@ Import Namespace="System.Data" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<title>smslist</title>
<meta name="GENERATOR" Content="Microsoft Visual Studio .NET 7.1">
<meta name="CODE_LANGUAGE" Content="C#">
<meta name="vs_defaultClientScript" content="JavaScript">
<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
//使用C#
<script language="C#" runat="server">
private void Page_Load(object sender,System.EventArgs e)
{
BindGrid();
}
private void chgPage(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
dgList.CurrentPageIndex=e.NewPageIndex;
BindGrid();
}
private void BindGrid()
{
string strQuery=string.Empty;
string strConn="server=(local);database=axoav2;uid=sa;pwd=123456";
strQuery+=" select a.mobile,a.content,a.recetime,sender=isnull(convert(varchar,b.username),N'未知') from jsdl a ";
strQuery+=" left join man b ";
strQuery+=" on a.mobile=b.mobile ";
strQuery+=" order by a.id desc ";
try
{
dgList.DataSource=SqlHelper.ExecuteDataset(strConn,CommandType.Text,strQuery);
dgList.DataBind();
}
catch(Exception ex)
{
Response.Write(ex.ToString());
}
}
</script>
<LINK href="style1.css" rel="stylesheet">
</HEAD>
<body MS_POSITIONING="GridLayout">
<form id="Form1" method="post" runat="server">
<table cellpadding="1" cellspacing="1" width="100%" border="0" bgcolor="#e0dfe3">
<tr bgcolor="#ffffff">
<td>
<asp:DataGrid id="dgList" runat="server" AutoGenerateColumns="False" width="98%" ItemStyle-Height="25"
AllowPaging="True" PageSize="10" OnPageIndexChanged="chgPage">//只需要输入事件名称(不用参数)
<PagerStyle HorizontalAlign="Right" Position="TopAndBottom" Mode="NumericPages"></PagerStyle>
<ItemStyle Height="25px"></ItemStyle>
<Columns>
<asp:BoundColumn DataField="mobile" HeaderText="手机号码"></asp:BoundColumn>
<asp:BoundColumn DataField="content" HeaderText="信息内容"></asp:BoundColumn>
<asp:BoundColumn DataField="recetime" HeaderText="接收时间"></asp:BoundColumn>
<asp:BoundColumn DataField="sender" HeaderText="发送人"></asp:BoundColumn>
</Columns>
</asp:DataGrid>
</td>
</tr>
</table>
</form>
<%@ Import Namespace="jmvt"%>
<%@ Import Namespace="System.Data" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<title>smslist</title>
<meta name="GENERATOR" Content="Microsoft Visual Studio .NET 7.1">
<meta name="CODE_LANGUAGE" Content="C#">
<meta name="vs_defaultClientScript" content="JavaScript">
<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
//使用C#
<script language="C#" runat="server">
private void Page_Load(object sender,System.EventArgs e)
{
BindGrid();
}
private void chgPage(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
dgList.CurrentPageIndex=e.NewPageIndex;
BindGrid();
}
private void BindGrid()
{
string strQuery=string.Empty;
string strConn="server=(local);database=axoav2;uid=sa;pwd=123456";
strQuery+=" select a.mobile,a.content,a.recetime,sender=isnull(convert(varchar,b.username),N'未知') from jsdl a ";
strQuery+=" left join man b ";
strQuery+=" on a.mobile=b.mobile ";
strQuery+=" order by a.id desc ";
try
{
dgList.DataSource=SqlHelper.ExecuteDataset(strConn,CommandType.Text,strQuery);
dgList.DataBind();
}
catch(Exception ex)
{
Response.Write(ex.ToString());
}
}
</script>
<LINK href="style1.css" rel="stylesheet">
</HEAD>
<body MS_POSITIONING="GridLayout">
<form id="Form1" method="post" runat="server">
<table cellpadding="1" cellspacing="1" width="100%" border="0" bgcolor="#e0dfe3">
<tr bgcolor="#ffffff">
<td>
<asp:DataGrid id="dgList" runat="server" AutoGenerateColumns="False" width="98%" ItemStyle-Height="25"
AllowPaging="True" PageSize="10" OnPageIndexChanged="chgPage">//只需要输入事件名称(不用参数)
<PagerStyle HorizontalAlign="Right" Position="TopAndBottom" Mode="NumericPages"></PagerStyle>
<ItemStyle Height="25px"></ItemStyle>
<Columns>
<asp:BoundColumn DataField="mobile" HeaderText="手机号码"></asp:BoundColumn>
<asp:BoundColumn DataField="content" HeaderText="信息内容"></asp:BoundColumn>
<asp:BoundColumn DataField="recetime" HeaderText="接收时间"></asp:BoundColumn>
<asp:BoundColumn DataField="sender" HeaderText="发送人"></asp:BoundColumn>
</Columns>
</asp:DataGrid>
</td>
</tr>
</table>
</form>