form1.cs

来自「csharp课本的源代码」· CS 代码 · 共 106 行

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

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

        private void Form1_Load(object sender, EventArgs e)
        {
            //填充数据集中的表
            myTable1TableAdapter.Fill(myDatabaseDataSet.MyTable1);
            myTable2TableAdapter.Fill(myDatabaseDataSet.MyTable2);
            //设置dateTimePickerStudentBirthday显示格式
            dateTimePickerStudentBirthday.Format = DateTimePickerFormat.Custom;
            dateTimePickerStudentBirthday.CustomFormat = " ";

        }
        private void buttonBinding_Click(object sender, EventArgs e)
        {
            //设置数据源
            myTable1BindingSource.DataSource = myDatabaseDataSet;
            myTable1BindingSource.DataMember = "MyTable1";
            myTable2BindingSource.DataSource = myDatabaseDataSet;
            myTable2BindingSource.DataMember = "MyTable2";
            //绑定导航条
            myTable2BindingNavigator.BindingSource = myTable2BindingSource;
            //绑定maskedTextBoxStudentID到学号
            maskedTextBoxStudentID.DataBindings.Add("Text", myTable2BindingSource, "学号");
            maskedTextBoxStudentID.Mask = "99999999";
            //绑定textBoxStudentName到姓名
            textBoxStudentName.DataBindings.Add("Text", myTable2BindingSource, "姓名");
            //绑定checkedListBoxStudentSex到性别
            checkedListBoxStudentSex.Items.AddRange(new object[] { "男", "女" });
            checkedListBoxStudentSex.DataBindings.Add("SelectedItem", myTable2BindingSource, "性别");
            checkedListBoxStudentSex.DataBindings.Add(
                "SelectedValue", myTable2BindingSource, "性别");
            checkedListBoxStudentSex.CheckOnClick = true;
            checkedListBoxStudentSex.MultiColumn = true;
            checkedListBoxStudentSex.ColumnWidth = 45;
            //绑定dateTimePickerStudentBirthday到出生日期
            dateTimePickerStudentBirthday.DataBindings.Add(
                "Value", myTable2BindingSource, "出生日期");
            dateTimePickerStudentBirthday.Format = DateTimePickerFormat.Short;
            //绑定comboBoxStudentCollege到学院编码
            comboBoxStudentCollege.DataBindings.Add(
                "SelectedValue", myTable2BindingSource, "学院编码");
            comboBoxStudentCollege.DataSource = this.myTable1BindingSource;
            comboBoxStudentCollege.DisplayMember = "名称";
            comboBoxStudentCollege.FormattingEnabled = true;
            comboBoxStudentCollege.ValueMember = "编码";
            //绑定dataGridViewMyTable2到MyTable2
            dataGridViewMyTable2.DataSource = myTable2BindingSource;

        }
        private void buttonCancelBinding_Click(object sender, EventArgs e)
        {
            //清除数据源，注意应该先清除与BindingSource的绑定
            //然后才能清除BindingSource的数据源
            maskedTextBoxStudentID.DataBindings.Clear();
            maskedTextBoxStudentID.Text = "";
            textBoxStudentName.DataBindings.Clear();
            textBoxStudentName.Text = "";
            checkedListBoxStudentSex.DataBindings.Clear();
            checkedListBoxStudentSex.Items.Clear();
            dateTimePickerStudentBirthday.DataBindings.Clear();
            dateTimePickerStudentBirthday.Format = DateTimePickerFormat.Custom;
            dateTimePickerStudentBirthday.CustomFormat = " ";
            comboBoxStudentCollege.DataBindings.Clear();
            dataGridViewMyTable2.DataSource = null;
            myTable2BindingNavigator.BindingSource = null;
            myTable1BindingSource.DataMember = null;
            myTable1BindingSource.DataSource = null;
            myTable2BindingSource.DataMember = null;
            myTable2BindingSource.DataSource = null;
        }
        private void checkedListBoxStudentSex_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (checkedListBoxStudentSex.SelectedIndex == 0)
            {
                checkedListBoxStudentSex.SetItemChecked(0, true);
                checkedListBoxStudentSex.SetItemChecked(1, false);
            }
            else if (checkedListBoxStudentSex.SelectedIndex == 1)
            {
                checkedListBoxStudentSex.SetItemChecked(0, false);
                checkedListBoxStudentSex.SetItemChecked(1, true);
            }
            else
            {
                checkedListBoxStudentSex.SetItemChecked(0, false);
                checkedListBoxStudentSex.SetItemChecked(1, false);
            }
        }
              
    }
}