if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[fei]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[fei]
GO
CREATE TABLE [dbo].[fei] (
[xm] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[kk] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[age] [int] NULL
) ON [PRIMARY]
GO
insert into fei values('张三','111',11);
insert into fei values('李四','222',22);
insert into fei values('张三1','111',11);
insert into fei values('李四1','222',22);
insert into fei values('张三2','111',11);
insert into fei values('李四2','222',22);
insert into fei values('张三3','111',11);
insert into fei values('李四3','222',22);
就搞定了阿,
如果你自己写的绑定的话,那也蛮好的:
实例化DataSet,DataAdapter,SqlConnection
con = new SqlConnection("连接字符串");
DataAdapter da = new DataAdapter("select语句",con);
DataSet ds = new DataSet();
adapter.Fill(ds, "数据库表名");
DataGrid名.DataSource = ds.Tables["数据库表名"].DefaultView;
DataGrid名.DataBind();