<% @ Import Namespace = "System.Data" %>
<% @ Import Namespace = "System.Data.SqlClient" %>
<script language="c#" runat="server">
protected void Page_Load(Object sender , EventArgs e)
{
if (!Page.IsPostBack) {
String strconn="server=localhost;database=bestnews;uid=sa;pwd=''";
SqlConnection Conn = new SqlConnection(strconn);
String sql="select * from News Order by ID desc";
SqlDataAdapter Comm = new SqlDataAdapter(sql,Conn);
//捆绑数据
DataSet ds = new DataSet();
Comm.Fill(ds,"News");
NewsGridView.DataSource=ds.Tables["News"].DefaultView;
NewsGridView.DataBind();
}
}
void ChangePage(Object sender , GridViewPageEventArgs e)
{
NewsGridView.PageIndex = e.NewPageIndex;
String strconn="server=localhost;database=bestnews;uid=sa;pwd=''";
SqlConnection Conn = new SqlConnection(strconn);
String sql="select * from News Order by ID desc";
SqlDataAdapter Comm = new SqlDataAdapter(sql,Conn);
DataSet ds = new DataSet();
Comm.Fill(ds,"News");
NewsGridView.DataSource=ds.Tables["News"].DefaultView;
NewsGridView.DataBind();
}
</script>
<form id="form1" runat="server">
<asp:GridView AllowPaging="True" AutoGenerateColumns="False" PageSize="2" PagerStyle-Mode="NumericPages" OnPageIndexChanging="ChangePage" ID="NewsGridView" Headerstyle-BackColor = "#0C4EBC" runat="server">
<Columns>
<asp:HyperLinkField DataTextField="Title"
HeaderText="标题" DataNavigateUrlFormatString="News_Detail.aspx?ID={0}" NavigateUrl="News_Detail.aspx?ID={0}" DataNavigateUrlFields="ID" Target="_blank" />
<asp:BoundField HeaderText="来源" DataField="Title"/>
</Columns>
</asp:GridView>
</form>
<% @ Import Namespace = "System.Data.SqlClient" %>
<script language="c#" runat="server">
protected void Page_Load(Object sender , EventArgs e)
{
if (!Page.IsPostBack) {
String strconn="server=localhost;database=bestnews;uid=sa;pwd=''";
SqlConnection Conn = new SqlConnection(strconn);
String sql="select * from News Order by ID desc";
SqlDataAdapter Comm = new SqlDataAdapter(sql,Conn);
//捆绑数据
DataSet ds = new DataSet();
Comm.Fill(ds,"News");
NewsGridView.DataSource=ds.Tables["News"].DefaultView;
NewsGridView.DataBind();
}
}
void ChangePage(Object sender , GridViewPageEventArgs e)
{
NewsGridView.PageIndex = e.NewPageIndex;
String strconn="server=localhost;database=bestnews;uid=sa;pwd=''";
SqlConnection Conn = new SqlConnection(strconn);
String sql="select * from News Order by ID desc";
SqlDataAdapter Comm = new SqlDataAdapter(sql,Conn);
DataSet ds = new DataSet();
Comm.Fill(ds,"News");
NewsGridView.DataSource=ds.Tables["News"].DefaultView;
NewsGridView.DataBind();
}
</script>
<form id="form1" runat="server">
<asp:GridView AllowPaging="True" AutoGenerateColumns="False" PageSize="2" PagerStyle-Mode="NumericPages" OnPageIndexChanging="ChangePage" ID="NewsGridView" Headerstyle-BackColor = "#0C4EBC" runat="server">
<Columns>
<asp:HyperLinkField DataTextField="Title"
HeaderText="标题" DataNavigateUrlFormatString="News_Detail.aspx?ID={0}" NavigateUrl="News_Detail.aspx?ID={0}" DataNavigateUrlFields="ID" Target="_blank" />
<asp:BoundField HeaderText="来源" DataField="Title"/>
</Columns>
</asp:GridView>
</form>
解决方案 »
- 如果做论坛
- js调用ocx事件问题,菜鸟求助。。!
- 树节点太多,用treeview加载太慢!谁给一个带checkbox的,不是一次性加载完所有节点的tree,多谢了!
- 图片不能显示
- Asp.net 访问网络资源
- 新手vs2003提问
- datagrid中绑钉列内容显示的问题
- 新建项目出错-“VC软件包不可用或未注册”,咋回事?
- 微软专家及思归等高手请进:超级流氓问题。
- C#连接MySQL Connector/NET时打开数据库连接报给定关键字不在字典中
- ASP.net2.0页面,第一次访问时要几秒钟才能出来,比直接静太HTML慢很多,有什么办法?
- DropDownList 的 text 和value 初始错误
代码如下
<%@ Page language="c#" Codebehind="newslist.aspx.cs" AutoEventWireup="false" Inherits="myweb.newshow"%>
<form id="form1" runat="server">
<asp:GridView AllowPaging="True" AutoGenerateColumns="False" PageSize="2" PagerStyle-Mode="NumericPages" OnPageIndexChanging="ChangePage" ID="NewsGridView" Headerstyle-BackColor = "#0C4EBC" runat="server">
<Columns>
<asp:HyperLinkField DataTextField="Title"
HeaderText="标题" DataNavigateUrlFormatString="News_Detail.aspx?ID={0}" NavigateUrl="News_Detail.aspx?ID={0}" DataNavigateUrlFields="ID" Target="_blank" />
<asp:BoundField HeaderText="来源" DataField="Title"/>
</Columns>
</asp:GridView>
</form>newslist.aspx.cs
代码如下
namespace myweb
{
public class newshow:System.Web.UI.Page
{
protected void Page_Load(Object sender , EventArgs e)
{
if (!Page.IsPostBack) {
String strconn="server=localhost;database=bestnews;uid=sa;pwd=''";
SqlConnection Conn = new SqlConnection(strconn);
String sql="select * from News Order by ID desc";
SqlDataAdapter Comm = new SqlDataAdapter(sql,Conn);
//捆绑数据
DataSet ds = new DataSet();
Comm.Fill(ds,"News");
NewsGridView.DataSource=ds.Tables["News"].DefaultView;
NewsGridView.DataBind();
}
}
void ChangePage(Object sender , GridViewPageEventArgs e)
{
NewsGridView.PageIndex = e.NewPageIndex;
String strconn="server=localhost;database=bestnews;uid=sa;pwd=''";
SqlConnection Conn = new SqlConnection(strconn);
String sql="select * from News Order by ID desc";
SqlDataAdapter Comm = new SqlDataAdapter(sql,Conn);
DataSet ds = new DataSet();
Comm.Fill(ds,"News");
NewsGridView.DataSource=ds.Tables["News"].DefaultView;
NewsGridView.DataBind();
}
}
}
代码如下
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
namespace myweb
{
public class newshow:System.Web.UI.Page
{
protected void Page_Load(Object sender , EventArgs e)
{
if (!Page.IsPostBack) {
String strconn="server=localhost;database=bestnews;uid=sa;pwd=''";
SqlConnection Conn = new SqlConnection(strconn);
String sql="select * from News Order by ID desc";
SqlDataAdapter Comm = new SqlDataAdapter(sql,Conn);
//捆绑数据
DataSet ds = new DataSet();
Comm.Fill(ds,"News");
NewsGridView.DataSource=ds.Tables["News"].DefaultView;
NewsGridView.DataBind();
}
}
void ChangePage(Object sender , GridViewPageEventArgs e)
{
NewsGridView.PageIndex = e.NewPageIndex;
String strconn="server=localhost;database=bestnews;uid=sa;pwd=''";
SqlConnection Conn = new SqlConnection(strconn);
String sql="select * from News Order by ID desc";
SqlDataAdapter Comm = new SqlDataAdapter(sql,Conn);
DataSet ds = new DataSet();
Comm.Fill(ds,"News");
NewsGridView.DataSource=ds.Tables["News"].DefaultView;
NewsGridView.DataBind();
}
}
}
改名字
newshow.aspx.cs
newshow.aspx
<% @ Import Namespace = "System.Data" %>
<% @ Import Namespace = "System.Data.SqlClient" %>
<script language="c#" runat="server">
protected void Page_Load(Object sender , EventArgs e)
{
if (!Page.IsPostBack) {
String strconn="server=localhost;database=bestnews;uid=sa;pwd=''";
SqlConnection Conn = new SqlConnection(strconn);
String sql="select * from News Order by ID desc";
SqlDataAdapter Comm = new SqlDataAdapter(sql,Conn);
//捆绑数据
DataSet ds = new DataSet();
Comm.Fill(ds,"News");
NewsGridView.DataSource=ds.Tables["News"].DefaultView;
NewsGridView.DataBind();
}
}
void ChangePage(Object sender , GridViewPageEventArgs e)
{
NewsGridView.PageIndex = e.NewPageIndex;
String strconn="server=localhost;database=bestnews;uid=sa;pwd=''";
SqlConnection Conn = new SqlConnection(strconn);
String sql="select * from News Order by ID desc";
SqlDataAdapter Comm = new SqlDataAdapter(sql,Conn);
DataSet ds = new DataSet();
Comm.Fill(ds,"News");
NewsGridView.DataSource=ds.Tables["News"].DefaultView;
NewsGridView.DataBind();
}
</script>
<form id="form1" runat="server">
<asp:GridView AllowPaging="True" AutoGenerateColumns="False" PageSize="2" PagerStyle-Mode="NumericPages" OnPageIndexChanging="ChangePage" ID="NewsGridView" Headerstyle-BackColor = "#0C4EBC" runat="server">
<Columns>
<asp:HyperLinkField DataTextField="Title"
HeaderText="标题" DataNavigateUrlFormatString="News_Detail.aspx?ID={0}" NavigateUrl="News_Detail.aspx?ID={0}" DataNavigateUrlFields="ID" Target="_blank" />
<asp:BoundField HeaderText="来源" DataField="Title"/>
</Columns>
</asp:GridView>
</form>