实现windows程序的数据绑定第五章

来源：互联网发布：微信解封软件免费版编辑：程序博客网时间：2024/04/30 21:15
using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Windows.Forms;using System.Data.SqlClient;namespace WindowsFormsApplication1{    public partial class Form1 : Form    {            DataSet ds = new DataSet();            DBHelper db = new DBHelper();            SqlDataAdapter adapter = null;        public Form1()        {            InitializeComponent();        }        public void getStu() {            try            {                string sql = "select * from student";                if (!this.comboBox1.SelectedValue.Equals("-1")) {                    sql += " where gradeid= " + this.comboBox1.SelectedValue;                 }                if(ds.Tables["Student"]!=null){                    ds.Tables["Student"].Clear();                }                adapter = new SqlDataAdapter(sql, db.Connection);                adapter.Fill(ds, "student");                this.dataGridView1.DataSource = ds.Tables["student"];            }            catch (Exception ex)            {                MessageBox.Show(ex.Message);            }            //this.dataGridView1.AutoGenerateColumns = false;            //this.dataGridView1.DataSource = ds.Tables["student"];        }        private void Form1_Load(object sender, EventArgs e)        {            getGrade();            getStu();        }        public void getGrade()        {            try            {                string sql = "select * from grade";                adapter = new SqlDataAdapter(sql, db.Connection);                adapter.Fill(ds, "grade");                DataRow row = ds.Tables["Grade"].NewRow();                row[0] = -1;                row[1] = "全部";                ds.Tables["Grade"].Rows.InsertAt(row, 0);                this.comboBox1.DataSource = ds.Tables["Grade"];                this.comboBox1.DisplayMember = "gradename";                this.comboBox1.ValueMember="gradeid";            }            catch (Exception ex)            {                MessageBox.Show(ex.Message);            }        }        private void button1_Click(object sender, EventArgs e)        {            getStu();            //string shiji = this.comboBox1.SelectedValue.ToString();            //string neirong = this.comboBox1.Text;            //MessageBox.Show("选中内容" + neirong + "实际值" + shiji);        }        private void 获取IdToolStripMenuItem_Click(object sender, EventArgs e)        {            MessageBox.Show(this.dataGridView1.SelectedCells[0].Value.ToString());        }        private void button2_Click(object sender, EventArgs e)        {            MessageBox.Show("确定保存?", "提示", MessageBoxButtons.OKCancel);            SqlCommandBuilder builder = new SqlCommandBuilder(adapter);            adapter.Update(ds, "student");        }    }}
0 0