dataSet用法

MSDN:DataList Web 服务器控件以某种格式显示数据，这种格式可以使用模板和样式进行定义。DataList 控件可用于任何重复结构中的数据，如表。DataList 控件可以以不同的布局显示行，如按列或行对数据进行排序。

也就是说一般情况我们用的GIRDVIEW控件只显示一行一条的话，那么DataList 可以在一行上显示多条数据。

一 绑定数据源 并显示数据

1.WEB.CONFIG配置数据源

[c-sharp] view plain copy print ?

1. <connectionStrings>  
2. <add name="NorthwindConnectionString1" connectionString="Data Source=127.0.0.1;Initial Catalog=Northwind;Persist Security Info=True;User ID=sa;Password=xxxxxxxxxx"  
3.     providerName="System.Data.SqlClient" /> 
4. </connectionStrings> 

<connectionStrings> <add name="NorthwindConnectionString1" connectionString="Data Source=127.0.0.1;Initial Catalog=Northwind;Persist Security Info=True;User ID=sa;Password=xxxxxxxxxx" providerName="System.Data.SqlClient" /> </connectionStrings>

2.在页面上添加DATALIST控件

3 后台代码绑定数据

[c-sharp] view plain copy print ?

1. protectedvoid Page_Load(object sender, EventArgs e)  
2. {  
3.     bind();  
4. }  
5. ///  
6. /// 获得数据库的链接  
7. ///  
8. ///  
9. public SqlConnection GetConnection()  
10. {  
11.     ConnectionStringSettings setting = System.Configuration.ConfigurationManager.ConnectionStrings["NorthwindConnectionString1"];  
12.     string myStr = setting.ConnectionString;  
13.     SqlConnection myConn = new SqlConnection(myStr);  
14.     return myConn;  
15. }  
16. ///  
17. ///  绑定数据 
18. ///  
19. protectedvoid bind()  
20. {  
21.     SqlConnection myConn = GetConnection();  
22.     myConn.Open();  
23.     string sqlStr ="select employeeid,lastname,firstname,address from employees";  
24.     SqlDataAdapter myDa = new SqlDataAdapter(sqlStr, myConn);  
25.     DataSet myDs = new DataSet();  
26.     myDa.Fill(myDs);  
27.     DataList1.DataSource = myDs;  
28.     DataList1.DataBind();  
29. } 

protected void Page_Load(object sender, EventArgs e) { bind(); } /// /// 获得数据库的链接 /// /// public SqlConnection GetConnection() { ConnectionStringSettings setting = System.Configuration.ConfigurationManager.ConnectionStrings["NorthwindConnectionString1"]; string myStr = setting.ConnectionString; SqlConnection myConn = new SqlConnection(myStr); return myConn; } /// /// 绑定数据 /// protected void bind() { SqlConnection myConn = GetConnection(); myConn.Open(); string sqlStr = "select employeeid,lastname,firstname,address from employees"; SqlDataAdapter myDa = new SqlDataAdapter(sqlStr, myConn); DataSet myDs = new DataSet(); myDa.Fill(myDs); DataList1.DataSource = myDs; DataList1.DataBind(); }

4.前台设置显示模板

编辑模板的-》项模板

• 在项模板的ItemTemplate中加入Lable控件