DataGrid1.DataSource = DS.Tables("dbo.orders").DefaultView
DataGrid1.DataBind()
DataGrid1.DataBind()
解决方案 »
- ajax在ff下失效
- ~~~~~~~~脚本创建html,请各位朋友帮忙!非常感谢!
- aspnetpagerforvs2k5只有一个dll怎么用?添加dll就可以用了吗?
- 求解一个关于DataGrid的问题
- 我的系统是windows 2003 server,该怎样安装asp.net?请多多指教!
- .net连接oracle的问题
- 框架
- .net Framework2.0是不是不能用以前的IEwebcontrols了?
- 又是DataGrid的问题,请各位帮忙,谢谢!!
- asp.net中怎样使用crystalreport水晶报表?
- 各位高手,如何在ASP中制作有树形目录的网页?
- 请问:在一个页面中如何用两个datggrid实现主-明细表?
<% @ Page Language="C#" Debug="true"%>
<% @ Import Namespace="System.Data" %>
<% @ Import Namespace="System.Data.OleDb" %><Script Language= "C#" Runat= "Server">
public void Page_Load(Object src,EventArgs e)
{
BindGrid();
}ICollection CreateDataSource()
{
/*
读取数据库的信息,获得DataView
*/
string strProvider="Provider=SQLOLEDB;server=localhost;uid=sa;pwd=;database=AspNetDataBase";
OleDbConnection cnnAspNet=new OleDbConnection(strProvider);
OleDbCommand cmdAspNet=new OleDbCommand("Select * From WorkerSalary", cnnAspNet);
OleDbDataAdapter adaAspNet =new OleDbDataAdapter();
adaAspNet.SelectCommand =cmdAspNet;
DataSet dsAspNet = new DataSet();
adaAspNet.Fill(dsAspNet,"WorkerSalary");
return dsAspNet.Tables["WorkerSalary"].DefaultView;
}void DataGrid_Page(Object sender, DataGridPageChangedEventArgs e)
{
//处理按下数字的方法
MyDataGrid.CurrentPageIndex = e.NewPageIndex;
BindGrid();
}void BindGrid()
{
//将DataView绑定到DataGrid上去
MyDataGrid.DataSource = CreateDataSource();
MyDataGrid.DataBind();
}</script>
<html>
<head>
<title>数据库应用例程</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head><body bgcolor="#FFFFFF" text="#000000"><form RunAt="Server">
<ASP:DataGrid id="MyDataGrid" runat="server"
AllowPaging="True"
PageSize="5"
PagerStyle-Mode="NumericPages"
PagerStyle-HorizontalAlign="Right"
BorderColor="black"
BorderWidth="1"
GridLines="Both"
CellPadding="3"
CellSpacing="0"
Font-Name="Verdana"
OnPageIndexChanged="DataGrid_Page"
Font-Size="10pt"
HeaderStyle-BackColor="#aaaadd"
AlternatingItemStyle-BackColor="#eeeeee"/>
</form><asp:Label id="labDebug" font-size="11pt" font-underline="true" runat="server" /></body>
</html>