Public Sub DataBing() dbconn.ConnectionString = "User ID=sa;Initial Catalog=zhm_db;User ID=sa;PassWord=;" Dim SqlStr As String = "Select UserID, UserName,UserPassword,UserEmail,UserClass from Dv_User"
dbadapter = New SqlClient.SqlDataAdapter(SqlStr, dbconn) dbset.Clear() dbadapter.Fill(dbset, "dv_user") Me.DataGrid1.DataSource = dbset.Tables("dv_user").DefaultView Me.DataBind() End Sub
Private Sub DataGrid1_PageIndexChanged(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridPageChangedEventArgs) Handles DataGrid1.PageIndexChanged Me.DataGrid1.CurrentPageIndex = e.NewPageIndex Me.DataBind() Call Me.DataBing() End Sub
先在页面的<head>与</head>之间加入CSS代码
-----------------------------------------
<style type="text/css">
<!--
.bg {
background-image: url(../images/2.gif);
}
-->
</style>
-----------------------------------------
DataGrid控件添加如下属性HeaderStyle-CssClass="bg"
dbconn.ConnectionString = "User ID=sa;Initial Catalog=zhm_db;User ID=sa;PassWord=;"
Dim SqlStr As String = "Select UserID, UserName,UserPassword,UserEmail,UserClass from Dv_User"
dbadapter = New SqlClient.SqlDataAdapter(SqlStr, dbconn)
dbset.Clear()
dbadapter.Fill(dbset, "dv_user")
Me.DataGrid1.DataSource = dbset.Tables("dv_user").DefaultView
Me.DataBind()
End Sub
Private Sub DataGrid1_PageIndexChanged(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridPageChangedEventArgs) Handles DataGrid1.PageIndexChanged
Me.DataGrid1.CurrentPageIndex = e.NewPageIndex
Me.DataBind()
Call Me.DataBing()
End Sub
<!--
.dgHeader {
background-image: url(../images/2.gif);
}
-->
</style><HeaderStyle CssClass="dgHeader"></HeaderStyle>
<!--
.bg {
background-image: url(../images/2.gif);
}
-->
</style>
-----------------------------------------
DataGrid控件添加如下属性<HeaderStyle CssClass="bg"></HeaderStyle>
困扰我很久的问题无意中在别人的贴解决。真爽