form1.cs

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

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

namespace StoreProcedureExample1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
  
        private void Form1_Load(object sender, EventArgs e)
        {
            dataGridView1.AllowUserToAddRows = false;
            dataGridView1.ReadOnly = true;
            selectNianJiTableAdapter1.Fill(myDatabaseDataSet1.SelectNianJi);
            comboBox1.DataSource = myDatabaseDataSet1.SelectNianJi;
            comboBox1.DisplayMember = myDatabaseDataSet1.SelectNianJi.nianjiColumn.ColumnName;

        }
        private void button1_Click(object sender, EventArgs e)
        {
            selectFilterStudentsTableAdapter1.Fill(
                myDatabaseDataSet1.SelectFilterStudents, comboBox1.Text, textBox1.Text);
            dataGridView1.DataSource = myDatabaseDataSet1.SelectFilterStudents;
            if (dataGridView1.RowCount == 0)
            {
                MessageBox.Show(
                    string.Format("{0}级中无姓{1}的学生", comboBox1.Text, textBox1.Text));
            }
        }
  
    }
}