调试易

1.创建一个 db.dbml 文件 然后在VS中 连接数据库  把你需要操作的那张表托入db.dbml文件里
2.创建一个类(MessageManager) 头部用 [SerializableAttribute] 序列化 
3.创建一个方法 例如(以下用表User作为对象):[SerializableAttribute]
    public class MessageManager : SystemException
    {
      
       public static  dbDataContext get() 
       {
            dbDataContext data = new dbDataContext();
            return data;
       }
    }4.然后在页面调用方法就可以 （增删改查都可以）//绑定表user数据到 GridView控件上去 
 this.GridView1.DataSource = MessageManager.get().User;
 this.GridView1.DataBind();
//添加表User数据
dbDataContext dc = MessageManager.get();
        User user = new User();
        user.Name = this.txtname.Text;
        if (this.RadioButton1.Checked == true)
        {
            user.Sex = this.RadioButton1.Text;
        }
        else if (this.RadioButton2.Checked == true)
        {
            user.Sex = this.RadioButton2.Text;
        }
        user.QQ = this.txtqq.Text;
        user.Email = this.txtmail.Text;
        user.Phone = this.txtphone.Text;
        user.Content = this.txtcontent.Text;
        user.Time = DateTime.Now.ToString();
        dc.User.InsertOnSubmit(user);
        dc.SubmitChanges();
        get();
        Response.Write("<script>alert('添加成功');location.href='index.aspx'</script>");
//删除表User数据
            dbDataContext dc = MessageManager.get();
            int i = int.Parse(e.CommandArgument.ToString());
            var result = from p in dc.User where p.Id == i select p;            foreach (var item in result)
            {
                dc.User.DeleteOnSubmit(item);
            }            dc.SubmitChanges();            get();
            Response.Write("<script>alert('删除成功');location.href='index.aspx'</script>");
//修改数据
    dbDataContext dc = MessageManager.get();
            int i = int.Parse(Session["ID"].ToString());
            var result = from p in dc.User where p.Id == i select p;
            foreach (var item in result)
            {
                item.Hcontent = this.txtHcontent.Text;
                item.Hid = 1;
            }
            dc.SubmitChanges();
            get();
            Session["ID"] = null;
            Response.Write("<script>alert('回复成功');location.href='index.aspx'</script>");
你滴明白？ 还不懂 就[email protected] 留言给我