最簡單的ASP.NET資料庫操作樣本原始碼

來源:互聯網
上載者:User

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

 



相關文章

Beyond APAC's No.1 Cloud

19.6% IaaS Market Share in Asia Pacific - Gartner IT Service report, 2018

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

聯繫我們

該頁面正文內容均來源於網絡整理,並不代表阿里雲官方的觀點,該頁面所提到的產品和服務也與阿里云無關,如果該頁面內容對您造成了困擾,歡迎寫郵件給我們,收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: info-contact@alibabacloud.com 進行舉報並提供相關證據,工作人員會在 5 個工作天內聯絡您,一經查實,本站將立刻刪除涉嫌侵權內容。