App.xaml

#region 创建数据库using (MyDataContext dc = new MyDataContext()) {  if (dc.DatabaseExists() == false)  {    dc.CreateDatabase();  }}#endregion

 

MainPage.xaml

using System;using System.Collections.Generic;using System.Linq;using System.Net;using System.Windows;using System.Windows.Controls;using System.Windows.Documents;using System.Windows.Input;using System.Windows.Media;using System.Windows.Media.Animation;using System.Windows.Shapes;using Microsoft.Phone.Controls;namespace LocalDataBase{    public partial class MainPage : PhoneApplicationPage    {        // 构造函数           public MainPage()        {            InitializeComponent();        }        // 编辑           private void OnDataEdit(object sender, RoutedEventArgs e)        {            Button btn = e.OriginalSource as Button;            if (btn != null)            {                string no = btn.Tag as string;                NavigationService.Navigate(new Uri("/EditPage.xaml?sno=" + no, UriKind.Relative));            }        }        // 删除数据           private void OnDataDelete(object sender, RoutedEventArgs e)        {            Button btn = e.OriginalSource as Button;            if (btn != null)            {                string sNo = btn.Tag.ToString();                using (MyDataContext dc = new MyDataContext())                {                    Students stu = dc.Students.FirstOrDefault(s => s.StuNo == sNo);                    if (stu != null)                    {                        dc.Students.DeleteOnSubmit(stu);                        dc.SubmitChanges();                        BindList();                    }                }            }        }        private void onRefresh(object sender, EventArgs e)        {            BindList();        }        // 新增           private void onNew(object sender, EventArgs e)        {            NavigationService.Navigate(new Uri("/AddPage.xaml", UriKind.Relative));        }        /// 
           /// 把数据绑定到ListBox           /// 
           private void BindList()        {            using (MyDataContext dc = new MyDataContext())            {                var res =                    from s in dc.Students                    select s;                this.stuList.ItemsSource = res.ToList();            }        }        protected override void OnNavigatedTo(System.Windows.Navigation.NavigationEventArgs e)        {            base.OnNavigatedTo(e);            BindList();        }    }}

AddPage.xaml

using System;using System.Collections.Generic;using System.Linq;using System.Net;using System.Windows;using System.Windows.Controls;using System.Windows.Documents;using System.Windows.Input;using System.Windows.Media;using System.Windows.Media.Animation;using System.Windows.Shapes;using Microsoft.Phone.Controls;namespace LocalDataBase{    public partial class AddPage : PhoneApplicationPage    {        public AddPage()        {            InitializeComponent();        }        private void onCancel(object sender, EventArgs e)        {            //NavigationService.Navigate(new Uri("/MainPage.xaml", UriKind.Relative));               if (NavigationService.CanGoBack)            {                NavigationService.GoBack();            }        }        private void onSave(object sender, EventArgs e)        {            if (txtNo.Text == "")            {                MessageBox.Show("学号不能为空。"); return;            }            if (txtName.Text == "")            {                MessageBox.Show("姓名不能为空。"); return;            }            using (MyDataContext dc = new MyDataContext())            {                if (dc.Students.Where(c => c.StuNo == txtNo.Text).Count() > 0)                {                    MessageBox.Show("输入的学号已经存在。"); return;                }                Students stu = new Students()                {                    StuNo = txtNo.Text,                    Name = txtName.Text,                    Email = txtEmail.Text                };                dc.Students.InsertOnSubmit(stu);                dc.SubmitChanges();            }            //NavigationService.Navigate(new Uri("/MainPage.xaml", UriKind.Relative));               if (NavigationService.CanGoBack)            {                NavigationService.GoBack();            }        }    }}

EditPage.xaml

using System;using System.Collections.Generic;using System.Linq;using System.Net;using System.Windows;using System.Windows.Controls;using System.Windows.Documents;using System.Windows.Input;using System.Windows.Media;using System.Windows.Media.Animation;using System.Windows.Shapes;using Microsoft.Phone.Controls;namespace LocalDataBase{    public partial class EditPage : PhoneApplicationPage    {        public EditPage()        {            InitializeComponent();        }        private void onSave(object sender, EventArgs e)        {            if (txtName.Text == "")            {                MessageBox.Show("姓名不能为空。"); return;            }            using (MyDataContext dc = new MyDataContext())            {                Students stu = dc.Students.FirstOrDefault(s => s.StuNo == txtNo.Text);                if (stu != null)                {                    stu.Name = txtName.Text;                    stu.Email = txtEmail.Text;                    dc.SubmitChanges();                }            }            //NavigationService.Navigate(new Uri("/MainPage.xaml", UriKind.Relative));               if (NavigationService.CanGoBack)            {                NavigationService.GoBack();            }        }        private void onCancel(object sender, EventArgs e)        {            //NavigationService.Navigate(new Uri("/MainPage.xaml", UriKind.Relative));               if (NavigationService.CanGoBack)            {                NavigationService.GoBack();            }        }        protected override void OnNavigatedTo(System.Windows.Navigation.NavigationEventArgs e)        {            base.OnNavigatedTo(e);            if (NavigationContext.QueryString.ContainsKey("sno"))            {                txtNo.Text = NavigationContext.QueryString["sno"];                using (MyDataContext dc = new MyDataContext())                {                    Students stu = dc.Students.FirstOrDefault(s => s.StuNo == txtNo.Text);                    if (stu != null)                    {                        txtName.Text = stu.Name;                        txtEmail.Text = stu.Email;                    }                }            }        }    }}

MyDataContext.cs

using System;using System.Net;using System.Windows;using System.Windows.Controls;using System.Windows.Documents;using System.Windows.Ink;using System.Windows.Input;using System.Windows.Media;using System.Windows.Media.Animation;using System.Windows.Shapes;using Microsoft.Phone.Data.Linq;using System.Data.Linq;using System.Data.Linq.Mapping;using System.ComponentModel;namespace LocalDataBase{    public class MyDataContext : DataContext    {        /// 
           /// 连接字符串           /// 
           public const string ConnectionString = "Data Source='isostore:/MyDb.sdf';Password='123456'";        /// 
           /// 构造函数           /// 
           public MyDataContext() : base(ConnectionString) { }        public Table
     
       Students;    }    [Table]    public class Students : INotifyPropertyChanged, INotifyPropertyChanging    {        string _stuNo;        /// 
      
           /// 学号           /// 
           [Column(CanBeNull = false, IsPrimaryKey = true)]        public string StuNo        {            get            {                return this._stuNo;            }            set            {                if (_stuNo != value)                {                    OnPropertyChanging(new PropertyChangingEventArgs("StuNo"));                    this._stuNo = value;                    OnPropertyChanged(new PropertyChangedEventArgs("StuNo"));                }            }        }        string _name;        /// 
      
           /// 姓名           /// 
           [Column]        public string Name        {            get            {                return this._name;            }            set            {                if (_name != value)                {                    OnPropertyChanging(new PropertyChangingEventArgs("Name"));                    _name = value;                    OnPropertyChanged(new PropertyChangedEventArgs("Name"));                }            }        }        string _email;        /// 
      
           /// 电邮           /// 
           [Column]        public string Email        {            get            {                return this._email;            }            set            {                if (_email != value)                {                    OnPropertyChanging(new PropertyChangingEventArgs("Email"));                    _email = value;                    OnPropertyChanged(new PropertyChangedEventArgs("Email"));                }            }        }        public event PropertyChangingEventHandler PropertyChanging;        public event PropertyChangedEventHandler PropertyChanged;        protected void OnPropertyChanging(PropertyChangingEventArgs e)        {            if (PropertyChanging != null)            {                PropertyChanging(this, e);            }        }        protected void OnPropertyChanged(PropertyChangedEventArgs e)        {            if (PropertyChanged != null)            {                PropertyChanged(this, e);            }        }    }}