c#操作sql server2008 的界面实例代码

先是查询整张表，用到combobox选择查询哪张表，最后用DataGridView显示

using System; 
using System.Collections.Generic; 
using System.ComponentModel; 
using System.Data; 
using System.Drawing; 
using System.Linq; 
using System.Text; 
using System.Windows.Forms; 
namespace WindowsFormsApplication2 
{ 
  public partial class Form1 : Form 
  { 
    public Form1() 
    { 
      InitializeComponent(); 
    } 
    private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) 
    { 
    } 
    private void Form1_Load(object sender, EventArgs e) 
    { 
      this.dataGridView1.RowHeadersVisible = false; 
      this.dataGridView1.AllowUserToAddRows = false; 
      this.dataGridView1.ReadOnly = true; 
      this.dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; 
      // this.comboBox1.SelectedIndex =0; 
      string sql = "select * from student"; 
      DataTable table = SqlManage.TableSelect(sql); 
      this.dataGridView1.DataSource = table; 
      comboBox1.Items.Add("学生表"); 
      comboBox1.Items.Add("教师表"); 
    } 
    private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) 
    { 
      string sql = ""; 
      switch (this.comboBox1.SelectedIndex) 
      {  
        case 0: 
          sql = "select id as 学生号,name as 姓名,sage as 年龄 from student"; 
          break; 
        case 1: 
          sql = "select t_id as 教师号,t_name as 姓名,T_age as 年龄 from teacher"; 
          break; 
        default: 
          break; 
      } 
      DataTable table = SqlManage.TableSelect(sql); 
      this.dataGridView1.DataSource = table; 
    } 
  } 
} 

using System; 
using System.Collections.Generic; 
using System.ComponentModel; 
using System.Data; 
using System.Drawing; 
using System.Linq; 
using System.Text; 
using System.Windows.Forms; 
namespace WindowsFormsApplication2 
{ 
  public partial class Form2 : Form 
  { 
    public Form2() 
    { 
      InitializeComponent(); 
    } 
    private void button4_Click(object sender, EventArgs e) 
    { 
      this.Close(); 
    } 
    private void button1_Click(object sender, EventArgs e) 
    { 
      string sql = string.Format("insert into teacher values('{0}','{1}','{2}')", 
              this.textBox1.Text, this.textBox2.Text, this.textBox3.Text); 
      SqlManage.TableChange(sql); 
    } 
    private void button2_Click(object sender, EventArgs e) 
    { 
      string sql = string.Format("update teacher set ('{0}',''{1}'','{2}')", 
              this.textBox1.Text, this.textBox2.Text, this.textBox3.Text); 
      SqlManage.TableChange(sql); 
    } 
    private void button3_Click(object sender, EventArgs e) 
    { 
      string sql = string.Format("delete from teacher where t_id='{0}'", 
              this.textBox1.Text); 
      SqlManage.TableChange(sql); 
    } 
    private void Form2_Load(object sender, EventArgs e) 
    { 
    } 
  } 
} 								 
 1/3    1 2 3 下一页 尾页