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

来源：互联网发布：工作日志记录软件编辑：程序博客网时间：2024/04/30 14:29

前台:

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