吴小强的博客

using System;
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Data.Linq;
using System.IO;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
 
namespace LinqTest
{
    public partial class _Default : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            DataClasses1DataContext ctx = new DataClasses1DataContext();
            StreamWriter sw = new StreamWriter(Server.MapPath("log.txt"), true);
            ctx.Log = sw;
 
            // add
            //Employees emp = new Employees();
            //emp.EmployeeID = 10;
            //emp.Address = "luo hu word finance center.";
            //emp.FirstName = "james";
            //emp.LastName = "wu";
            //emp.Country = "china";
            //ctx.Employees.InsertOnSubmit(emp);
 
            //update
            Employees emp = ctx.Employees.Single(eemp => eemp.EmployeeID == 10);
            emp.Address = "luo hu word finance center.";
            emp.FirstName = "sun";
            emp.LastName = "su";
            ctx.SubmitChanges();
 
            //list
            Table<Employees> Employees = ctx.GetTable<Employees>();
            GridView1.DataSource = from ee in Employees where ee.EmployeeID > 0 select new { 員工姓名 = ee.FirstName + ee.LastName, 員工ID = ee.EmployeeID, 地址 = ee.Address };
            GridView1.DataBind();
 
            sw.Close();
        }
    }
}

<?php
//
// +------------------------------------------------------------------------+
// | PHP Version 5                                                          |
// +------------------------------------------------------------------------+
// | Copyright (c) All rights reserved.                                     |
// +------------------------------------------------------------------------+
// | This source file is subject to version 3.00 of the PHP License,        |
// | that is available at http://www.php.net/license/3_0.txt.               |
// | If you did not receive a copy of the PHP license and are unable to     |
// | obtain it through the world-wide-web, please send a note to            |
// | license@php.net so we can mail you a copy immediately.                 |
// +------------------------------------------------------------------------+
// | Author:                                                                |
// +------------------------------------------------------------------------+
//
// $Id$
//
 
 
/**
* @author       Administrator
*/
class SurveyBus
{
 
    /**
    * @var      long
    */
    public $busId;
 
    /**
    * @var      String
    */
    public $routeNo;
 
    /**
    * @var      int
    */
    public $typeId;
 
    /**
    * @var      String
    */
    public $engName;
 
    /**
    * @var      String
    */
    public $chiName;
 
    /**
    * @var      String
    */
    public $bounds;
 
    /**
    * @var      int
    */
    public $distId;
 
    /**
    * @var      String
    */
    public $distCode;
 
    /**
    * @var      String
    */
    public $busDay;
 
    /**
    * @var      int
    */
    public $allSchNo;
 
    /**
    * @var      int
    */
    public $amSchNo;
 
    /**
    * @var      int
    */
    public $pmSchNo;
 
    /**
    * @var      Date
    */
    public $inputTime;
 
    /**
    * @var      Date
    */
    public $modifyTime;
 
    /**
    * @var      enum('yes','no')
    */
    public $delFlag;
}
 
?>