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

最新推荐文章于 2021-04-03 03:30:23 发布

PConlineSTU

最新推荐文章于 2021-04-03 03:30:23 发布

阅读量1.1k

点赞数

文章标签： dataset asp server string

本文链接：https://blog.csdn.net/PConlineSTU/article/details/1516622

版权

前台:

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