示例#1
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!IsPostBack)
     {
         使用LINQ語法新增資料DataContext db = new 使用LINQ語法新增資料DataContext();
         var data = db.GetTable <Products>().Where(table => table.ProductID <= 10);
         GridView1.DataSource = data;
         GridView1.DataBind();
     }
 }
示例#2
0
        protected void Button2_Click(object sender, EventArgs e)
        {
            使用LINQ語法新增資料DataContext db = new 使用LINQ語法新增資料DataContext();
            Products data = db.GetTable <Products>().Where(table => table.ProductID == 1).First();

            data.ProductName = "Chai";
            data.UnitPrice   = (decimal)18.55;
            //data.Discontinued = true;
            db.SubmitChanges();//寫回DB
            GridView1.DataSource = db.GetTable <Products>();
            GridView1.DataBind();
        }
        protected void Button4_Click(object sender, EventArgs e)
        {
            string id = Request.Form["TextBox4"];
            使用LINQ語法新增資料DataContext db = new 使用LINQ語法新增資料DataContext();
            Products         data      = db.GetTable <Products>().Where(table => table.ProductID.Equals(id)).First();
            Table <Products> tb        = db.GetTable <Products>();

            tb.DeleteOnSubmit(data);
            db.SubmitChanges();//寫回DB
            GridView1.DataSource = db.GetTable <Products>();
            GridView1.DataBind();
        }
示例#4
0
        protected void Button1_Click(object sender, EventArgs e)
        {
            使用LINQ語法新增資料DataContext db = new 使用LINQ語法新增資料DataContext();
            Products p = new Products();

            p.ProductName  = "My New Product";
            p.UnitPrice    = (decimal)99.953;
            p.Discontinued = true;
            Table <Products> table = db.GetTable <Products>();

            table.InsertOnSubmit(p); //新資料加入資料表
            db.SubmitChanges();      //寫回DB
            GridView1.DataSource = table;
            GridView1.DataBind();
        }
示例#5
0
        protected void Button3_Click(object sender, EventArgs e)
        {
            string  id    = Request.Form["TextBox1"];
            string  name  = Request.Form["TextBox2"];
            decimal price = Convert.ToDecimal(Request.Form["TextBox3"]);
            bool    disco = Convert.ToBoolean(Request.Form["RadioButtonList1"]);
            //Response.Write(string.Format("{0} {1} {2} {3}", id, name, price, disco));


            使用LINQ語法新增資料DataContext db = new 使用LINQ語法新增資料DataContext();
            Products data = db.GetTable <Products>().Where(table => table.ProductID.Equals(id)).First();

            data.ProductName  = name;
            data.UnitPrice    = price;
            data.Discontinued = disco;
            db.SubmitChanges();//寫回DB
            GridView1.DataSource = db.GetTable <Products>();
            GridView1.DataBind();
        }