个人网页/Default.aspx.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;


namespace 个人网页
{
    public partial class _Default : System.Web.UI.Page
    {
        public SqlConnection sqlcon = new SqlConnection(ConfigurationSettings.AppSettings["ConnStr"]);
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                //绑定新进日志
                string sqlstr1 = "select top 10 * from ST_news order by ST_n_id desc";
                //调用自定义方法GetDataSet从数据库中获取会员日志信息
                DataSet myds1 = GetDataSet(sqlstr1, "ST_news");
                //设置ArtDetailList的数据源
                ArtDetailList.DataSource = myds1;
                ArtDetailList.DataBind();
            }
            Lbble3.Text = "您是该网站的第[" + Application["count"] + "]访问者!";
        }


        public DataSet GetDataSet(string SqlCom, string tablename)
        {
            try
            {
                //打开链接
                sqlcon.Open();
                //创建数据库命令对象
                SqlCommand sqlcom = new SqlCommand(SqlCom, sqlcon);
                //创建填充数据的适配器
                SqlDataAdapter sqldata = new SqlDataAdapter();
                sqldata.SelectCommand = sqlcom;
                //创建一个DataSet数据集
                DataSet ds = new DataSet();
                //填充数据集
                sqldata.Fill(ds, tablename);
                //返回结果集
                return ds;
            }
            finally
            {
                //关闭数据库连接
                sqlcon.Close();
            }
        }
    }
}