DataList绑定数据

        DataList 类是一个多功能的、模板化的数据绑定列表,使用时应该为其添加模板而不是仅仅添加数据源,datalist没有datagrid里的AutoGenerateColumns属性直接把数据源datasource给datagrid它就能自己呈现了,datalist不行.它需要使用模板,再在模板中绑定你需要的数据字段：

       SqlConnection con = new SqlConnection("Data Source=icuit.meibu.com;Initial Catalog=test;User ID=sa;Password=admin");

        string cmdstr = "select * from student_info stu,classes c ,specialty s,department d where stu.classes_id=c.classes_id and " +
                        "c.specialty_id=s.specialty_id and s.department_id=d.department_id and stu_no=100001";
        SqlDataAdapter adapter = new SqlDataAdapter(cmdstr, con);
        DataSet dsstu = new DataSet();
        con.Open();
        adapter.Fill(dsstu);
        con.Close();

        DL_stuinfo.DataSource = dsstu.Tables[0].DefaultView;
        DL_stuinfo.DataBind();

 

               <asp:DataList ID="DL_stuinfo" runat="server" Height="111px" Width="197px" RepeatColumns="1">      
                        <HeaderTemplate>
                            <span style="font-size: 16pt; text-decoration: underline">学生基本信息</span></HeaderTemplate>
                        <ItemTemplate>
                                相片：<br /><img src="images/3.jpg" /><br /><hr />
                                学号: <%# Eval("stu_no") %><br /><hr />
                                姓名: <%# Eval("stu_name") %><br /><hr />
                                性别: <%# Eval("sex") %> <br /><hr />
                            入学年份: <%# Eval("grade") %> <br /><hr /> 
                              所在系: <%# Eval("dept_name") %><br /><hr />
                                专业: <%# Eval("specialty") %> <br /><hr />    
                                班级: <%# Eval("squad") %>               
                        </ItemTemplate>
                            <ItemStyle BackColor="#A7B5CE" HorizontalAlign="Left" />
                            <HeaderStyle BackColor="#A7B5CE" />
                        </asp:DataList></td>