我的DataGrid代码是
DataGrid1.HeaderStyle.BackColor = Color.FromArgb(192,229,248);
DataGrid1.HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
DataGrid1.HeaderStyle.Height=22; // 设置翻页导航栏设置
DataGrid1.PagerStyle.Mode = PagerMode.NumericPages;
DataGrid1.PagerStyle.BackColor = Color.FromArgb(238,247,254);
DataGrid1.PagerStyle.PageButtonCount = 10;
DataGrid1.PagerStyle.HorizontalAlign = HorizontalAlign.Right;
DataGrid1.PagerStyle.Height=22; // 分页设置
DataGrid1.AllowPaging = true;
DataGrid1.PageSize = 10;
// 默认显示设定
DataGrid1.CellSpacing = 0;
DataGrid1.CellPadding = 2;
DataGrid1.BorderColor =Color.Black;
DataGrid1.BackColor=Color.FromArgb(243,243,245);
DataGrid1.HorizontalAlign=HorizontalAlign.Center;
DataGrid1.BorderWidth = (Unit)1;
DataGrid1.AutoGenerateColumns=true; // 绑定项高度
DataGrid1.ItemStyle.Height=20; // 交替项样式设定
DataGrid1.AlternatingItemStyle.BackColor = Color.FromArgb(243,243,245);
DataGrid1.AlternatingItemStyle.Height=20;谢谢
DataGrid1.HeaderStyle.BackColor = Color.FromArgb(192,229,248);
DataGrid1.HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
DataGrid1.HeaderStyle.Height=22; // 设置翻页导航栏设置
DataGrid1.PagerStyle.Mode = PagerMode.NumericPages;
DataGrid1.PagerStyle.BackColor = Color.FromArgb(238,247,254);
DataGrid1.PagerStyle.PageButtonCount = 10;
DataGrid1.PagerStyle.HorizontalAlign = HorizontalAlign.Right;
DataGrid1.PagerStyle.Height=22; // 分页设置
DataGrid1.AllowPaging = true;
DataGrid1.PageSize = 10;
// 默认显示设定
DataGrid1.CellSpacing = 0;
DataGrid1.CellPadding = 2;
DataGrid1.BorderColor =Color.Black;
DataGrid1.BackColor=Color.FromArgb(243,243,245);
DataGrid1.HorizontalAlign=HorizontalAlign.Center;
DataGrid1.BorderWidth = (Unit)1;
DataGrid1.AutoGenerateColumns=true; // 绑定项高度
DataGrid1.ItemStyle.Height=20; // 交替项样式设定
DataGrid1.AlternatingItemStyle.BackColor = Color.FromArgb(243,243,245);
DataGrid1.AlternatingItemStyle.Height=20;谢谢
private void dgGrid_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
dgGrid.CurrentPageIndex = e.NewPageIndex;
BindDate();
}private void BindDate()
{
DataView dv=null; if (this.txtDateB.Text .Trim ()!="")
{
if (!ECI.Valid.Valider.IsValidDate(this.txtDateB .Text .Trim ()))
{
this.dgGrid .Visible =false;
Page.RegisterStartupScript ("","<script>alert('录入日期从格式不正确!');FrmCheckMeasureGateJobHead.txtDateB.focus();</script>");
return ;
}
} if (this.txtDateE.Text .Trim ()!="")
{
if (!ECI.Valid.Valider.IsValidDate(this.txtDateE .Text .Trim ()))
{
this.dgGrid .Visible =false;
Page.RegisterStartupScript ("","<script>alert('录入日期到格式不正确!');FrmCheckMeasureGateJobHead.txtDateE.focus();</script>");
return ;
}
}
CltScrapJobList objCltScrapJobList = new CltScrapJobList();
dv = objCltScrapJobList.GetGateHeadQuertList(txtGPNO.Text.Trim(),txtJobNO.Text.Trim(),txtDateB.Text.Trim(),txtDateE.Text.Trim(),"L","");
dgGrid.DataSource = dv;
dgGrid.DataBind(); }
Roping.Zong
<%@ Page Language="VB" AutoEventWireup="True" Debug="true"%>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %><html>
<script runat="server">
dim MyConnection as OleDbConnection Sub Page_Load(sender As Object, e As EventArgs)
MyConnection = New OleDbConnection( "Provider=Microsoft.Jet.OLEDB.4.0; Data Source =" + Server.MapPath(".")+"/db/data.mdb") If Not IsPostBack Then
BindGrid()
End If
End Sub Sub MyDataGrid_Page(sender as Object, e As DataGridPageChangedEventArgs)
MyDataGrid.CurrentPageIndex = e.NewPageIndex
BindGrid()
End Sub Sub BindGrid()
Dim MyCommand As OleDbDataAdapter = new OleDbDataAdapter("select * from [min]", MyConnection)
Dim DS As DataSet = new DataSet()
MyCommand.Fill(DS,"min")
MyDataGrid.DataSource = DS.Tables("min").DefaultView
MyDataGrid.DataBind()
End Sub
</script>
<form runat="server">
<asp:DataGrid id="MyDataGrid"
AllowPaging="True"
PageSize="5"
OnPageIndexChanged="MyDataGrid_Page"
runat="server"
AutoGenerateColumns="False"
Width="200">
<HeaderStyle BackColor="Navy"
ForeColor="White"
Font-Bold="True"
HorizontalAlign="Center"/>
<PagerStyle Mode="NextPrev"
HorizontalAlign="Right"
NextPageText="ÏÂÒ»Ò³"
PrevPageText="ÉÏÒ»Ò³"/>
<Columns>
<asp:BoundColumn DataField="id" HeaderText="ID"/>
<asp:TemplateColumn HeaderText="zhuti">
<ItemTemplate>
<asp:Label ID="lblTotalPrice" Text='<%#(Container.DataItem("zhuti"))%>' Runat=server />
</ItemTemplate>
</asp:TemplateColumn>
</Columns>
</asp:DataGrid>
</form>