form1.cs

WinCE系统的数据库操作示例

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;


namespace exp7SQL2
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            if (exp7SQL2DataSet1Util.DesignerUtil.IsRunTime())
            {
                // TODO: 删除此行代码以移除“exp7SQL2DataSet1.Employees”的默认 AutoFill。
                this.employeesTableAdapter.Fill(this.exp7SQL2DataSet1.Employees);
            }

        }

        private void buttonPrevious_Click(object sender, EventArgs e)
        {
            this.employeesBindingSource.Position--;
        }

        private void buttonNext_Click(object sender, EventArgs e)
        {
            this.employeesBindingSource.Position++;
        }

        private void buttonByAge_Click(object sender, EventArgs e)
        {
            this.employeesTableAdapter.FillByAge(this.exp7SQL2DataSet1.Employees, int.Parse(textBoxAge.Text));
            textBoxAge.Text = "";
        }

        private void buttonAdd_Click(object sender, EventArgs e)
        {
            //this.employeesBindingSource.AddNew();
            this.employeesTableAdapter.myInsert(textBoxAName.Text,
                    int.Parse(textBoxAAge.Text), textBoxAAddr.Text);
            this.employeesTableAdapter.Fill(this.exp7SQL2DataSet1.Employees);
            textBoxAAddr.Text = "";
            textBoxAAge.Text = "";
            textBoxAName.Text = "";
        }

/*        private void buttonSave_Click(object sender, EventArgs e)
        {
            this.employeesBindingSource.EndEdit();
            this.employeesTableAdapter.Update(this.exp7SQL2DataSet1.Employees);
        }

        private void buttonCancel_Click(object sender, EventArgs e)
        {
            this.employeesBindingSource.CancelEdit();
        }*/

        private void buttonUpdate_Click(object sender, EventArgs e)
        {
            try
            {
                this.employeesTableAdapter.Update_Edit(textBoxNName.Text,
                    int.Parse(textBoxNAge.Text), textBoxNAddr.Text, textBoxKName.Text);
                //this.employeesTableAdapter.FillByName(
                //    this.exp7SQL2DataSet1.Employees,textBoxKName.Text);
                this.employeesTableAdapter.Fill(this.exp7SQL2DataSet1.Employees); 
                textBoxKName.Text = "";
                textBoxNAddr.Text = "";
                textBoxNAge.Text = "";
                textBoxNName.Text = "";
            }
            catch (Exception e3)
            {
                MessageBox.Show("Error: " + e3.ToString());
            }
        }

        private void buttonByName_Click(object sender, EventArgs e)
        {
            try
            {
                this.employeesTableAdapter.FillByName(this.exp7SQL2DataSet1.Employees,
                    textBoxKName.Text);
                //textBoxKName.Text = "";
            }
            catch (Exception e2)
            {
                MessageBox.Show("Error: " + e2.ToString());
            }
        }

        private void buttonDelete_Click(object sender, EventArgs e)
        {
            try
            {
                this.employeesTableAdapter.myDelete(textBoxKName.Text);
                this.employeesTableAdapter.FillByName(
                    this.exp7SQL2DataSet1.Employees, textBoxKName.Text);
                textBoxKName.Text = "";
            }
            catch (Exception e1)
            {
                MessageBox.Show("Error: " + e1.ToString());
            }
        }

        private void buttonView_Click(object sender, EventArgs e)
        {
            this.employeesTableAdapter.Fill(this.exp7SQL2DataSet1.Employees);
        }
    }
}