显示新闻列表中的数据控件中加入新闻类别名称的列

前台:

<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();