前台:

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False">
            <Columns>
                <asp:BoundField DataField="Title" HeaderText="新闻标题" />
                <asp:BoundField DataField="UpdateTime" DataFormatString="{0:yyyy-MM-DD}" HeaderText="发表时间" />
                <asp:BoundField DataField="ClassName" HeaderText="新闻类型" />
            </Columns>
        </asp:GridView>

后台:

string strSelect;
        SqlConnection myConnection;
        SqlDataAdapter dad;
        DataSet ds;
        strSelect = "SELECT Title,UpdateTime,ClassName from News,NewsType where News.ClassID=NewsType.ClassID";

        myConnection = new SqlConnection(@"server=localhost;uid=sa;pwd=system;database=test");
        dad = new SqlDataAdapter(strSelect, myConnection);
        ds = new DataSet();
        dad.Fill(ds, "News");
        GridView1.DataSource = ds;
        GridView1.DataBind(); 

发表于 @ 2007年02月28日　11:42:00 | 评论( loading... ) | 编辑| 举报| 收藏

旧一篇:.net开发的三层结构 | 新一篇:通过下拉DropDownList来筛选新闻显示表(有新闻类别名称)