using system;
using system.collections;
using system.configuration;
using system.data;
using system.linq;
using system.web;
using system.web.security;
using system.web.ui;
using system.web.ui.htmlcontrols;
using system.web.ui.webcontrols;
using system.web.ui.webcontrols.webparts;
using system.xml.linq;
using system.data.sqlclient;
public partial class _default : system.web.ui.page
{
    protected void page_load(object sender, eventargs e)
    {
      // sqlconnection con = new sqlconnection("server=dbtalbe;uid=sa;pwd=sa;database=addb;");
        //con.open();
        sqlconnection con = new sqlconnection(configurationmanager.appsettings["strconn"]);
        con.open();
        /*寫入數據庫
        sqlcommand cmd = new sqlcommand("insert into [ad_sort] ([sortname])  values  ('首頁廣告')",con);
        cmd.executenonquery();
        response.write("寫入成功！");
        con.close();
        */
        string strsql = "select * from ad_sort order by id desc";
        //讀取數據
        sqldataadapter sda = new sqldataadapter(strsql, con);
        dataset ds = new dataset();
        sda.fill(ds, "ad_sort");
        this.hotcommentlist.datasource = ds;
        this.hotcommentlist.databind();

        //讀取單個數據
        sqldataadapter set = new sqldataadapter(strsql, con);
        dataset rs = new dataset();
        set.fill(rs,"ad_sort");
        //datarowview mydrview = rs.tables["ad_sort"].defaultview[0];
        this.sortname.innerhtml = convert.tostring(rs.tables["ad_sort"].defaultview[0].row[1]);
        /*
        sqldataadapter set = new sqldataadapter(strsql,con);
        dataset rs = new dataset();
        set.fill(rs,"ad_sort");
        this.sortname.innerhtml = convert.tostring(rs.tables["ad_sort"].defaultview[0].row[1]);
        this.sortname.innerhtml = convert.tostring(rs.tables["ad_sort"].defaultview[0].row[1]);
        */

        sqlcommand cmd = new sqlcommand(strsql, con);
        sqldatareader res1 = cmd.executereader();
        string listbody="";
        listbody += ("<table border=0 ");
        listbody+=("<tr><td>executereader讀取數據</td></tr>");
        listbody += ("<tr><th>編號</th><th>名稱</th></tr>");
        while (res1.read())
        {
            listbody += ("<tr>");
            listbody += ("<td align='center'>" + res1["id"].tostring() + "</td>");
            listbody += ("<td align='left'>" + res1["sortname"].tostring() + "</td>");
            listbody += ("</tr>");
        }
        listbody += ("</table>");
        list2.innerhtml = listbody;
        res1.close();

        con.close();
    }
}