会员
周边
众包
新闻
博问
闪存
赞助商
所有博客
当前博客
我的博客
我的园子
账号设置
简洁模式
...
退出登录
注册
登录
ASP.NET IS LIFE
博客园
首页
新随笔
联系
管理
订阅
GridView之学习一
Default.aspx
<%
@ Page Language
=
"
C#
"
AutoEventWireup
=
"
true
"
CodeFile
=
"
Default.aspx.cs
"
Inherits
=
"
_Default
"
%>
<!
DOCTYPE html PUBLIC
"
-//W3C//DTD XHTML 1.0 Transitional//EN
"
"
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd
"
>
<
html xmlns
=
"
http://www.w3.org/1999/xhtml
"
>
<
head runat
=
"
server
"
>
<
title
>
无标题页
</
title
>
</
head
>
<
body
>
<
form id
=
"
form1
"
runat
=
"
server
"
>
<
div
>
<
asp:GridView ID
=
"
GridView1
"
runat
=
"
server
"
AllowPaging
=
"
True
"
AutoGenerateColumns
=
"
False
"
BackColor
=
"
White
"
BorderColor
=
"
#CCCCCC
"
BorderStyle
=
"
None
"
BorderWidth
=
"
1px
"
CellPadding
=
"
3
"
OnPageIndexChanging
=
"
GridView1_PageIndexChanging
"
PageSize
=
"
5
"
>
<
PagerSettings FirstPageImageUrl
=
"
~/Images/First.gif
"
FirstPageText
=
"
|&lt;
"
LastPageImageUrl
=
"
~/Images/Last.gif
"
LastPageText
=
"
&gt;|
"
Mode
=
"
NumericFirstLast
"
NextPageImageUrl
=
"
~/Images/Next.gif
"
PageButtonCount
=
"
5
"
PreviousPageImageUrl
=
"
~/Images/Previous.gif
"
/>
<
FooterStyle BackColor
=
"
White
"
ForeColor
=
"
#000066
"
/>
<
Columns
>
<
asp:BoundField DataField
=
"
ClientName
"
HeaderText
=
"
姓名
"
SortExpression
=
"
Name
"
/>
<
asp:BoundField DataField
=
"
AddressStr
"
HeaderText
=
"
地址
"
SortExpression
=
"
Address
"
/>
<
asp:BoundField DataField
=
"
PostCode
"
HeaderText
=
"
邮编
"
SortExpression
=
"
PostCode
"
/>
</
Columns
>
<
RowStyle ForeColor
=
"
#000066
"
/>
<
SelectedRowStyle BackColor
=
"
#669999
"
Font
-
Bold
=
"
True
"
ForeColor
=
"
White
"
/>
<
PagerStyle BackColor
=
"
#FFC080
"
BorderColor
=
"
Blue
"
Font
-
Bold
=
"
True
"
ForeColor
=
"
#000066
"
HorizontalAlign
=
"
Left
"
/>
<
HeaderStyle BackColor
=
"
#006699
"
Font
-
Bold
=
"
True
"
ForeColor
=
"
White
"
/>
</
asp:GridView
>
</
div
>
</
form
>
</
body
>
</
html
>
ClientInfo.cs
using
System;
using
System.Data;
using
System.Configuration;
using
System.Web;
using
System.Web.Security;
using
System.Web.UI;
using
System.Web.UI.WebControls;
using
System.Web.UI.WebControls.WebParts;
using
System.Web.UI.HtmlControls;
/**/
///
<summary>
///
ClientInfo 的摘要说明
///
</summary>
public
class
ClientInfo
{
private
int
clientID;
//
客户编号
public
int
ClientID
{
get
{
return
clientID; }
set
{ clientID
=
value; }
}
private
string
clientName;
//
客户姓名
public
string
ClientName
{
get
{
return
clientName; }
set
{ clientName
=
value; }
}
private
string
addressStr;
//
客户地址
public
string
AddressStr
{
get
{
return
addressStr; }
set
{ addressStr
=
value; }
}
private
string
postCode;
//
客户邮编
public
string
PostCode
{
get
{
return
postCode; }
set
{ postCode
=
value; }
}
private
string
telephone;
//
客户电话
public
string
Telephone
{
get
{
return
telephone; }
set
{ telephone
=
value; }
}
private
string
email;
//
客户邮件
public
string
Email
{
get
{
return
email; }
set
{ email
=
value; }
}
}
ClientInfoAccessObj.cs
using
System;
using
System.Data;
using
System.Configuration;
using
System.Web;
using
System.Web.Security;
using
System.Web.UI;
using
System.Web.UI.WebControls;
using
System.Web.UI.WebControls.WebParts;
using
System.Web.UI.HtmlControls;
using
System.Collections.Generic;
using
System.Data.SqlClient;
/**/
///
<summary>
///
ClientInfoAccessObj 的摘要说明
///
</summary>
public
class
ClientInfoAccessObj
{
//
连接字符串
private
readonly
string
connString
=
"
server=.\\sqlexpress;database=Clients;uid=sa;pwd=123456;
"
;
//
获得所有的客户信息
public
List
<
ClientInfo
>
GetAllClients()
{
List
<
ClientInfo
>
clients
=
new
List
<
ClientInfo
>
();
using
(SqlConnection conn
=
new
SqlConnection(connString))
{
string
sql
=
"
select * from orderClient
"
;
using
(SqlCommand comm
=
new
SqlCommand(sql,conn))
{
conn.Open();
using
(SqlDataReader sdr
=
comm.ExecuteReader())
{
while
(sdr.Read())
{
ClientInfo ci
=
new
ClientInfo();
ci.ClientID
=
int
.Parse(sdr[
"
ClientID
"
].ToString());
ci.ClientName
=
sdr[
"
ClientName
"
].ToString();
ci.AddressStr
=
sdr[
"
AddressStr
"
].ToString();
ci.PostCode
=
sdr[
"
PostCode
"
].ToString();
ci.Telephone
=
sdr[
"
Telephone
"
].ToString();
ci.Email
=
sdr[
"
Email
"
].ToString();
clients.Add(ci);
}
return
clients;
}
}
}
}
}
Default.aspx.cs
using
System;
using
System.Data;
using
System.Configuration;
using
System.Web;
using
System.Web.Security;
using
System.Web.UI;
using
System.Web.UI.WebControls;
using
System.Web.UI.WebControls.WebParts;
using
System.Web.UI.HtmlControls;
public
partial
class
_Default : System.Web.UI.Page
{
protected
void
Page_Load(
object
sender, EventArgs e)
{
if
(
!
IsPostBack)
{
ClientInfoAccessObj obj
=
new
ClientInfoAccessObj();
GridView1.DataSource
=
obj.GetAllClients();
GridView1.DataBind();
}
}
protected
void
GridView1_PageIndexChanging(
object
sender, GridViewPageEventArgs e)
{
ClientInfoAccessObj obj
=
new
ClientInfoAccessObj();
GridView1.DataSource
=
obj.GetAllClients();
GridView1.PageIndex
=
e.NewPageIndex;
//
将点击的新页下标赋给GridView
GridView1.DataBind();
}
}
posted on
2008-12-09 22:49
麻衣之光
阅读(
246
) 评论(
0
)
编辑
收藏
举报
会员力量,点亮园子希望
刷新页面
返回顶部
公告