国产探花免费观看_亚洲丰满少妇自慰呻吟_97日韩有码在线_资源在线日韩欧美_一区二区精品毛片,辰东完美世界有声小说,欢乐颂第一季,yy玄幻小说排行榜完本

首頁(yè) > 學(xué)院 > 開發(fā)設(shè)計(jì) > 正文

數(shù)據(jù)綁定

2019-11-17 01:29:58
字體:
來(lái)源:轉(zhuǎn)載
供稿:網(wǎng)友

數(shù)據(jù)綁定

WEB.config:  <connectionStrings>    <add name="conn" connectionString="Data Source=orcl;User ID=qxw;PassWord=123456" OracleClient"/>  </connectionStrings>數(shù)據(jù)庫(kù)類:DBTool.cs:    public class DBTool    {        public OracleConnection GetConnection()        {            string str = ConfigurationManager.ConnectionStrings["conn"].ConnectionString;            OracleConnection conn = new OracleConnection(str);            return conn;        }        public DataTable Get_FFLOWList()        {            string sql = "select * from rr";            OracleConnection conn = GetConnection();            OracleDataAdapter oda = new OracleDataAdapter(sql, conn);            DataTable dt = new DataTable();            oda.Fill(dt);            return dt;        }    }載入頁(yè)面:        protected void Page_Load(object sender, EventArgs e)        {            DBTool tool = new DBTool();            DataTable dt = tool.Get_FFLOWList();            GridView1.DataSource = dt;            GridView1.DataBind();            DataList1.DataSource = dt;            DataList1.DataBind();            Repeater1.DataSource = dt;            Repeater1.DataBind();        }aspX:GridView:        <asp:GridView ID="GridView1" runat="server" BackColor="LightGoldenrodYellow"             BorderColor="Tan" BorderWidth="1px" CellPadding="2"             EnableModelValidation="True" ForeColor="Black" GridLines="None">            <AlternatingRowStyle BackColor="PaleGoldenrod" />            <FooterStyle BackColor="Tan" />            <HeaderStyle BackColor="Tan" Font-Bold="True" />            <PagerStyle BackColor="PaleGoldenrod" ForeColor="DarkSlateBlue"                 HorizontalAlign="Center" />            <SelectedRowStyle BackColor="DarkSlateBlue" ForeColor="GhostWhite" />        </asp:GridView>DataList:        <asp:DataList ID="DataList1" runat="server" CellPadding="4" ForeColor="#333333">            <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />        <HeaderTemplate>        <table border="1">        <tr><td>序號(hào)</td><td>名字</td></tr>        </HeaderTemplate>            <ItemStyle BackColor="#FFFBD6" ForeColor="#333333" />        <ItemTemplate>        <tr><td><%# DataBinder.Eval(Container.DataItem, "ID")%></td><td><%# DataBinder.Eval(Container.DataItem, "NAME")%></td></tr>        </ItemTemplate>            <AlternatingItemStyle BackColor="White" />            <FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />        <FooterTemplate>        </table>        </FooterTemplate>            <SelectedItemStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" />        </asp:DataList>Repeater:        <asp:Repeater ID="Repeater1" runat="server"             onitemcommand="Repeater1_ItemCommand">        <HeaderTemplate>        <table border="1"><tr><td>IDD</td><td>NameE</td></tr>        </HeaderTemplate>        <ItemTemplate><tr><td><%# DataBinder.Eval(Container.DataItem, "ID")%></td><td><%# DataBinder.Eval(Container.DataItem, "NAME")%></td></tr></ItemTemplate>        <AlternatingItemTemplate><tr style="background-color:gray;"><td><%# DataBinder.Eval(Container.DataItem, "ID")%></td><td><%# DataBinder.Eval(Container.DataItem, "NAME")%></td></tr></AlternatingItemTemplate>        <FooterTemplate></table></FooterTemplate>        </asp:Repeater>

發(fā)表評(píng)論 共有條評(píng)論
用戶名: 密碼:
驗(yàn)證碼: 匿名發(fā)表
主站蜘蛛池模板: 长丰县| 明光市| 鄂托克前旗| 右玉县| 香港 | 临沂市| 平安县| 阜新市| 新安县| 怀宁县| 白银市| 梁河县| 蕲春县| 拜城县| 漳浦县| 新安县| 明水县| 庆阳市| 安国市| 金秀| 陇西县| 北碚区| 广饶县| 资兴市| 习水县| 华容县| 广宗县| 竹山县| 霍林郭勒市| 洞口县| 富蕴县| 陇南市| 乌什县| 剑河县| 藁城市| 阿荣旗| 三河市| 墨竹工卡县| 太仆寺旗| 贞丰县| 民勤县|