using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
namespace test2
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
public static int loading = 0;
public event Action<int> Transfer;
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
string sql = "";
listView1.Items.Clear();
listView1.Columns.Clear();
SqlDataReader dr;
switch (this.comboBox1.SelectedIndex)
{
case 0:
sql ="select * from TEACHERS";
listView1.Columns.Add("编号");
listView1.Columns.Add("姓名");
listView1.Columns.Add("性别");
dr = SqlHelper.ExecuteReader(sql);
while (dr.Read())
{
ListViewItem it = new ListViewItem();
it.Text = dr["tid"].ToString();
it.SubItems.Add(dr["tname"].ToString());
it.SubItems.Add(dr["tgender"].ToString());
listView1.Items.Add(it);
}
break;
case 1:
sql ="select * from WORKS";
listView1.Columns.Add("教师号");
listView1.Columns.Add("课程号");
listView1.Columns.Add("年份");
listView1.Columns.Add("学期");
dr = SqlHelper.ExecuteReader(sql);
while (dr.Read())
{
ListViewItem it = new ListViewItem();
it.Text = dr["tid"].ToString();
it.SubItems.Add(dr["cid"].ToString());
it.SubItems.Add(dr["cyear"].ToString());
it.SubItems.Add(dr["cterm"].ToString());
listView1.Items.Add(it);
}
break;
case 2:
sql = "select * from COURSES";
listView1.Columns.Add("编号");
listView1.Columns.Add("课程名称");
listView1.Columns.Add("学时");
dr = SqlHelper.ExecuteReader(sql);
while (dr.Read())
{
ListViewItem it = new ListViewItem();
it.Text = dr["cid"].ToString();
it.SubItems.Add(dr["cname"].ToString());
it.SubItems.Add(dr["ctime"].ToString());
listView1.Items.Add(it);
}
break;
}
}
private void tabPage1_Click(object sender, EventArgs e)
{
MessageBox.Show("点击了page1");
}
private void tabPage2_Click(object sender, EventArgs e)
{
MessageBox.Show("点击了page2");
}
private void Form1_Load(object sender, EventArgs e)
{
Tab1Load();
Tab2Load();
Tab3Load();
comboBox1.SelectedIndex = 0;
}
private void Tab1Load()
{
string sql ="select * from TEACHERS";
SqlDataReader dr = SqlHelper.ExecuteReader(sql);
listView1.Items.Clear();//注意。不是listView1.clear,是listView1.Items.Clear
listView1.Columns.Add("编号");
listView1.Columns.Add("姓名");
listView1.Columns.Add("性别");
while (dr.Read())
{
ListViewItem it = new ListViewItem();
it.Text = dr["tid"].ToString();
it.SubItems.Add(dr["tname"].ToString());
it.SubItems.Add(dr["tgender"].ToString());
listView1.Items.Add(it);
}
}
private void Tab2Load()
{
string sql = "select tid as 编号,tname as 姓名,tgender as 性别 from TEACHERS";
DataTable dt = SqlHelper.ExecuteTable(sql);
dataGridView1.DataSource = dt;
}
private void Tab3Load()
{
string sql = "select * from TEACHERS";
DataTable dt = SqlHelper.ExecuteTable(sql);
loading = 1;
comboBox2.DisplayMember = "tid";
comboBox2.ValueMember = "tid";
//comboBox2.DataSource=(dt);
foreach (DataRow row in dt.Rows)
{
this.comboBox2.Items.Add(row["tid"].ToString());
}
//DataTable dt2 = SqlHelper.ExecuteTable(sql);
comboBox3.DisplayMember = "tname";
comboBox3.ValueMember = "tname";
//comboBox3.DataSource=(dt);
foreach (DataRow row in dt.Rows)
{
this.comboBox3.Items.Add(row["tname"].ToString());
}
sql = "select distinct cyear from WORKS";
dt = SqlHelper.ExecuteTable(sql);
comboBox4.DisplayMember = "cyear";
comboBox4.ValueMember = "cyear";
// comboBox4.DataSource = (dt);
foreach (DataRow row in dt.Rows)
{
this.comboBox4.Items.Add(row["cyear"].ToString());
}
loading = 0;
}
private void listView1_SelectedIndexChanged(object sender, EventArgs e)
{
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
}
private void tabControl1_TabIndexChanged(object sender, EventArgs e)
{
}
private void button1_Click(object sender, EventArgs e)
{
add addform = new add();
addform.Show();
}
private void button2_Click(object sender, EventArgs e)//修改按钮
{
int id = Convert.ToInt32(dataGridView1.SelectedRows[0].Cells[0].Value);
edit addform = new edit();
Transfer += addform.ShowInfo;
addform.Show();
Transfer(id);
}
private void button4_Click(object sender, EventArgs e)
{
Tab2Load();
}
private void button3_Click(object sender, EventArgs e)
{
int id = Convert.ToInt32(dataGridView1.SelectedRows[0].Cells[0].Value);
string sql = "delete from TEACHERS where tid ="+id;
int re = SqlHelper.ExecuteNonQuery(sql);
if (re > 0)
{
MessageBox.Show("删除成功");
}
else
{
MessageBox.Show("删除失败!");
}
Tab2Load();
}
private void comboBox2_SelectedValueChanged(object sender, EventArgs e)
{
if (loading != 1)
{
string sql = "select TEACHERS.tid as 编号,tname as 姓名,tgender as 性别 ,cname as 课程,ctime as 课时,cyear as 年份 from TEACHERS,COURSES,WORKS where TEACHERS.tid=WORKS.tid and WORKS.cid=COURSES.cid and TEACHERS.tid=" + comboBox2.Text;
DataTable dt = SqlHelper.ExecuteTable(sql);
dataGridView2.DataSource=(dt);
comboBox3.Text = "";
}
}
private void comboBox3_SelectedValueChanged(object sender, EventArgs e)
{
if (loading != 1)
{
string sql = string.Format("select TEACHERS.tid as 编号,tname as 姓名,tgender as 性别 ,cname as 课程,ctime as 课时,cyear as 年份 from TEACHERS,COURSES,WORKS where TEACHERS.tid=WORKS.tid and WORKS.cid=COURSES.cid and TEACHERS.tname='{0}'", comboBox3.Text);
DataTable dt = SqlHelper.ExecuteTable(sql);
dataGridView2.DataSource = (dt);
comboBox2.Text = "";
}
}
private void comboBox5_SelectionChangeCommitted(object sender, EventArgs e)
{
//string sql =
}
}
}
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
namespace test2
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
public static int loading = 0;
public event Action<int> Transfer;
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
string sql = "";
listView1.Items.Clear();
listView1.Columns.Clear();
SqlDataReader dr;
switch (this.comboBox1.SelectedIndex)
{
case 0:
sql ="select * from TEACHERS";
listView1.Columns.Add("编号");
listView1.Columns.Add("姓名");
listView1.Columns.Add("性别");
dr = SqlHelper.ExecuteReader(sql);
while (dr.Read())
{
ListViewItem it = new ListViewItem();
it.Text = dr["tid"].ToString();
it.SubItems.Add(dr["tname"].ToString());
it.SubItems.Add(dr["tgender"].ToString());
listView1.Items.Add(it);
}
break;
case 1:
sql ="select * from WORKS";
listView1.Columns.Add("教师号");
listView1.Columns.Add("课程号");
listView1.Columns.Add("年份");
listView1.Columns.Add("学期");
dr = SqlHelper.ExecuteReader(sql);
while (dr.Read())
{
ListViewItem it = new ListViewItem();
it.Text = dr["tid"].ToString();
it.SubItems.Add(dr["cid"].ToString());
it.SubItems.Add(dr["cyear"].ToString());
it.SubItems.Add(dr["cterm"].ToString());
listView1.Items.Add(it);
}
break;
case 2:
sql = "select * from COURSES";
listView1.Columns.Add("编号");
listView1.Columns.Add("课程名称");
listView1.Columns.Add("学时");
dr = SqlHelper.ExecuteReader(sql);
while (dr.Read())
{
ListViewItem it = new ListViewItem();
it.Text = dr["cid"].ToString();
it.SubItems.Add(dr["cname"].ToString());
it.SubItems.Add(dr["ctime"].ToString());
listView1.Items.Add(it);
}
break;
}
}
private void tabPage1_Click(object sender, EventArgs e)
{
MessageBox.Show("点击了page1");
}
private void tabPage2_Click(object sender, EventArgs e)
{
MessageBox.Show("点击了page2");
}
private void Form1_Load(object sender, EventArgs e)
{
Tab1Load();
Tab2Load();
Tab3Load();
comboBox1.SelectedIndex = 0;
}
private void Tab1Load()
{
string sql ="select * from TEACHERS";
SqlDataReader dr = SqlHelper.ExecuteReader(sql);
listView1.Items.Clear();//注意。不是listView1.clear,是listView1.Items.Clear
listView1.Columns.Add("编号");
listView1.Columns.Add("姓名");
listView1.Columns.Add("性别");
while (dr.Read())
{
ListViewItem it = new ListViewItem();
it.Text = dr["tid"].ToString();
it.SubItems.Add(dr["tname"].ToString());
it.SubItems.Add(dr["tgender"].ToString());
listView1.Items.Add(it);
}
}
private void Tab2Load()
{
string sql = "select tid as 编号,tname as 姓名,tgender as 性别 from TEACHERS";
DataTable dt = SqlHelper.ExecuteTable(sql);
dataGridView1.DataSource = dt;
}
private void Tab3Load()
{
string sql = "select * from TEACHERS";
DataTable dt = SqlHelper.ExecuteTable(sql);
loading = 1;
comboBox2.DisplayMember = "tid";
comboBox2.ValueMember = "tid";
//comboBox2.DataSource=(dt);
foreach (DataRow row in dt.Rows)
{
this.comboBox2.Items.Add(row["tid"].ToString());
}
//DataTable dt2 = SqlHelper.ExecuteTable(sql);
comboBox3.DisplayMember = "tname";
comboBox3.ValueMember = "tname";
//comboBox3.DataSource=(dt);
foreach (DataRow row in dt.Rows)
{
this.comboBox3.Items.Add(row["tname"].ToString());
}
sql = "select distinct cyear from WORKS";
dt = SqlHelper.ExecuteTable(sql);
comboBox4.DisplayMember = "cyear";
comboBox4.ValueMember = "cyear";
// comboBox4.DataSource = (dt);
foreach (DataRow row in dt.Rows)
{
this.comboBox4.Items.Add(row["cyear"].ToString());
}
loading = 0;
}
private void listView1_SelectedIndexChanged(object sender, EventArgs e)
{
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
}
private void tabControl1_TabIndexChanged(object sender, EventArgs e)
{
}
private void button1_Click(object sender, EventArgs e)
{
add addform = new add();
addform.Show();
}
private void button2_Click(object sender, EventArgs e)//修改按钮
{
int id = Convert.ToInt32(dataGridView1.SelectedRows[0].Cells[0].Value);
edit addform = new edit();
Transfer += addform.ShowInfo;
addform.Show();
Transfer(id);
}
private void button4_Click(object sender, EventArgs e)
{
Tab2Load();
}
private void button3_Click(object sender, EventArgs e)
{
int id = Convert.ToInt32(dataGridView1.SelectedRows[0].Cells[0].Value);
string sql = "delete from TEACHERS where tid ="+id;
int re = SqlHelper.ExecuteNonQuery(sql);
if (re > 0)
{
MessageBox.Show("删除成功");
}
else
{
MessageBox.Show("删除失败!");
}
Tab2Load();
}
private void comboBox2_SelectedValueChanged(object sender, EventArgs e)
{
if (loading != 1)
{
string sql = "select TEACHERS.tid as 编号,tname as 姓名,tgender as 性别 ,cname as 课程,ctime as 课时,cyear as 年份 from TEACHERS,COURSES,WORKS where TEACHERS.tid=WORKS.tid and WORKS.cid=COURSES.cid and TEACHERS.tid=" + comboBox2.Text;
DataTable dt = SqlHelper.ExecuteTable(sql);
dataGridView2.DataSource=(dt);
comboBox3.Text = "";
}
}
private void comboBox3_SelectedValueChanged(object sender, EventArgs e)
{
if (loading != 1)
{
string sql = string.Format("select TEACHERS.tid as 编号,tname as 姓名,tgender as 性别 ,cname as 课程,ctime as 课时,cyear as 年份 from TEACHERS,COURSES,WORKS where TEACHERS.tid=WORKS.tid and WORKS.cid=COURSES.cid and TEACHERS.tname='{0}'", comboBox3.Text);
DataTable dt = SqlHelper.ExecuteTable(sql);
dataGridView2.DataSource = (dt);
comboBox2.Text = "";
}
}
private void comboBox5_SelectionChangeCommitted(object sender, EventArgs e)
{
//string sql =
}
}
}