default.aspx.cs

数据库连接查询

using System;
using System.Data;
using System.Configuration;
using System.Linq;
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;
using System.Xml.Linq;
using System.Data.Linq;
using System.IO;


public partial class _Default : System.Web.UI.Page 
{
    GuestBookDataContext ctx = new GuestBookDataContext("server=srv-devdbhost;database=GuestBook;uid=sa;pwd=Abcd1234");
       
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            SetBind();
        }
    }
    protected void btn_SendMessage_Click(object sender, EventArgs e)
    {
        StreamWriter sw = new StreamWriter(Server.MapPath("log.txt"), false);
        ctx.Log = sw;
        tbGuestBook gb = new tbGuestBook();
        gb.UserName = tb_UserName.Text;
        gb.Message = tb_Message.Text;
        ctx.tbGuestBooks.Add(gb);
        ctx.SubmitChanges();
        SetBind();
        sw.Close();
    }
    private void SetBind()
    {
        rpt_Message.DataSource = from gb in ctx.tbGuestBooks orderby gb.PostTime descending select gb;
        rpt_Message.DataBind();
    }
}