default.aspx.cs

来自「这是我老师做给我们Asp.net数据库的连接里面有有网站的稍微的 设计的感觉挺吧」· CS 代码 · 共 26 行

using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class _Default : System.Web.UI.Page 
{
    protected void Page_Load(object sender, EventArgs e)
    {
        SqlConnection dbconn = new SqlConnection();
        dbconn.ConnectionString = "user id=sa;data source=localhost;Integrated security = False;initial catalog=web";
        dbconn.Open();
        SqlDataAdapter dbda = new SqlDataAdapter("select * from news",dbconn);
        DataSet rs = new DataSet();
        dbda.Fill(rs);
        Repeater1.DataSource = rs;
        Repeater1.DataBind();
    }
}