Eleven

        protected void Button5_Click(object sender, EventArgs e)
        {

            ////    linq to sql 新增

            TestTable tb = new TestTable();
            MainDataClassDataContext mainDataClassDataContext = new MainDataClassDataContext();

            tb.Name = TextBox1.Text;
            tb.Id =  TextBox2.Text;
            tb.Pw = TextBox3.Text;
            tb.Data = TextBox4.Text;
            tb.PKey = Guid.NewGuid();
            
            mainDataClassDataContext.TestTable.InsertOnSubmit(tb);
            mainDataClassDataContext.SubmitChanges();

        }

        protected void Button6_Click(object sender, EventArgs e)
        {
            
            /// linq to sql 刪除

           TestTable tb = new TestTable();
           MainDataClassDataContext main= new MainDataClassDataContext();

           var change = main.TestTable.First(c => c.Id == TextBox2.Text);
           //var change = (from c in main.TestTable where c.Id == TextBox2.Text select c).First();    
          //另一種寫法

           main.TestTable.DeleteOnSubmit(change);
           main.SubmitChanges();
        }

        protected void Button7_Click(object sender, EventArgs e)
        {
            //// linq to sql Updata
            TestTable tb = new TestTable();
            MainDataClassDataContext main = new MainDataClassDataContext();

            var change =main.TestTable.First(c => c.Id == TextBox2.Text);

            change.Name = TextBox1.Text;
            change.Pw = TextBox3.Text;
            change.Data = TextBox4.Text;

            main.SubmitChanges();
        }

        protected void Button8_Click(object sender, EventArgs e)
        {

            // linq to sql find
            TestTable tb = new TestTable();
            MainDataClassDataContext main = new MainDataClassDataContext();        
            var change = (from c in main.TestTable where c.Id == TextBox2.Text select c).Count();
            Response.Write(change.ToString());
        }