C#連接數(shù)據(jù)庫及增刪查改操作

1、C#連接數(shù)據(jù)庫及增刪查改操作 設(shè)計好的C#界面：共3個窗體。數(shù)據(jù)庫：運行后的界面：代碼：（Form1）public partial class Form1 : Form public Form1() InitializeComponent(); private void button1_Click(object sender, EventArgs e) Form1_Load(sender, e); private void Form1_Load(object sender, EventArgs e) try SqlConnection conn = new SqlConnection(); s

2、tring str = "Data Source=ZWEIQUAN-PC;Initial Catalog=Student;Integrated Security=True" conn.ConnectionString = str; conn.Open(); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "select * from 基本信息表" cmd.Connection = conn; SqlDataAdapter sda = new SqlDataAdapter(cmd); DataSet

3、 ds = new DataSet(); sda.Fill(ds, "基本信息表"); this.dataGridView1.DataSource = ds; this.dataGridView1.DataMember = "基本信息表" this.dataGridView1.AutoGenerateColumns = true; for (int i = 1; i < this.dataGridView1.ColumnCount; i+) this.dataGridView1.Columnsi.DefaultCellStyle.Selection

4、BackColor = Color.White; this.dataGridView1.Columnsi.DefaultCellStyle.SelectionForeColor = Color.Black; this.dataGridView1.Columnsi.ReadOnly = true; conn.Close(); catch(Exception ee) MessageBox.Show("錯誤："+ee.Message,"錯誤"); private void button2_Click(object sender, EventArgs e) if

5、 (this.dataGridView1.SelectedCells=null) MessageBox.Show("請選擇要刪¦除的項！", "錯誤", MessageBoxButtons.OK, MessageBoxIcon.Error); else if (this.dataGridView1.CurrentCell.ColumnIndex = 0) string st = this.dataGridView11, this.dataGridView1.CurrentCell.RowIndex.Value.ToString(); SqlCo

6、nnection conn = new SqlConnection(); string str = "Data Source=ZWEIQUAN-PC;Initial Catalog=Student;Integrated Security=True" conn.ConnectionString = str; conn.Open(); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "delete from 基本信息表 where 姓名='" + st + "'"

7、cmd.Connection = conn; cmd.ExecuteNonQuery(); conn.Close(); private void button3_Click(object sender, EventArgs e) if (this.textBox1.Text.Trim() = "") MessageBox.Show("請輸入要查詢的姓名!", "提示"); else SqlConnection conn = new SqlConnection(); string str = "Data Source=ZWEI

8、QUAN-PC;Initial Catalog=Student;Integrated Security=True" conn.ConnectionString = str; conn.Open(); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "select * from 基本信息表 where 姓名='" + this.textBox1.Text.Trim() + "'" cmd.Connection = conn; SqlDataAdapter sda = new

9、 SqlDataAdapter(cmd); DataSet ds = new DataSet(); sda.Fill(ds); this.dataGridView1.DataSource = ds; this.dataGridView1.DataMember = ds.Tables0.ToString(); this.dataGridView1.AutoGenerateColumns = true; conn.Close(); private void button4_Click(object sender, EventArgs e) Form2 f = new Form2(); f.Show

10、(); private void button5_Click(object sender, EventArgs e) Form3 f = new Form3(); f.id = Convert.ToInt32(this.dataGridView10, this.dataGridView1.CurrentCell.RowIndex.Value.ToString(); f.Show(); (Form2)public partial class Form2 : Form public Form2() InitializeComponent(); private void Form2_Load(obj

11、ect sender, EventArgs e) comboBox1.Items.Add("男"); comboBox1.Items.Add("女"); comboBox2.Items.Add("計算機11-1班"); comboBox2.Items.Add("計算機11-2班"); comboBox2.Items.Add("計算機11-3班"); comboBox1.DropDownStyle = ComboBoxStyle.DropDownList; comboBox2.DropDownSt

12、yle = ComboBoxStyle.DropDownList; get_bh(); private void get_bh() SqlConnection conn = new SqlConnection(); string str = "Data Source=ZWEIQUAN-PC;Initial Catalog=Student;Integrated Security=True" conn.ConnectionString = str; conn.Open(); SqlCommand cmd = new SqlCommand(); cmd.CommandText =

13、 "select * from 基本信息表" /cmd.CommandText = "select isnull(max(編號),0)+1 from 基本信息表" cmd.Connection = conn; SqlDataAdapter sda = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); sda.Fill(ds); int t = ds.Tables0.Rows.Count; int bh = t - 1; this.textBox1.Text = (Int32.Parse(ds.Tab

14、les0.Rowsbh"編號".ToString() + 1).ToString(); /this.textBox1.Text = cmd.ExecuteScalar().ToString(); conn.Close(); private void button1_Click(object sender, EventArgs e) if (textBox2.Text.Trim() = "" | textBox3.Text.Trim() = "" | comboBox1.Text.Trim() = "" | comb

15、oBox2.Text.Trim() = "") MessageBox.Show("請輸入完整信息！", "錯誤", MessageBoxButtons.OK, MessageBoxIcon.Error); else string str1 = textBox3.Text.Trim(); int l = str1.Length; for (int i = 0; i < l; i+) if (!char.IsNumber(str1i) MessageBox.Show("年齡輸入有誤！", "錯誤&quo

16、t;, MessageBoxButtons.OK, MessageBoxIcon.Error); textBox3.SelectAll(); textBox3.Focus(); return; SqlConnection conn = new SqlConnection(); string str = "Data Source=ZWEIQUAN-PC;Initial Catalog=Student;Integrated Security=True" conn.ConnectionString = str; conn.Open(); SqlCommand cmd = new

17、SqlCommand(); cmd.CommandText = "insert into 基本信息表(編號,姓名,性別,年齡,班級)values(編號,姓名,性別,年齡,班級)" cmd.Connection = conn; cmd.Parameters.Add("編號", SqlDbType.Int); cmd.Parameters.Add("姓名", SqlDbType.NVarChar, 50); cmd.Parameters.Add("性別", SqlDbType.NVarChar, 50); cmd.Pa

18、rameters.Add("年齡", SqlDbType.Int); cmd.Parameters.Add("班級", SqlDbType.NVarChar, 50); cmd.Parameters"編號".Value = textBox1.Text.Trim(); cmd.Parameters"姓名".Value = textBox2.Text.Trim(); cmd.Parameters"性別".Value = comboBox1.Text.Trim(); cmd.Parameters&qu

19、ot;年齡".Value = textBox3.Text.Trim(); cmd.Parameters"班級".Value = comboBox2.Text.Trim(); cmd.ExecuteNonQuery(); conn.Close(); this.Close(); private void button2_Click(object sender, EventArgs e) this.Close(); (Form3)public partial class Form3 : Form public Form3() InitializeComponent();

20、 public int id; private void Form3_Load(object sender, EventArgs e) textBox1.Text = id.ToString(); SqlConnection conn = new SqlConnection("Data Source=ZWEIQUAN-PC;Initial Catalog=Student;Integrated Security=True"); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; conn.Open(); cmd.

21、CommandText = "select * from 基本信息表 where 編號=" + id.ToString(); SqlDataAdapter sda = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); sda.Fill(ds); if (ds.Tables0.Rows.Count = 1) this.textBox2.Text = (ds.Tables0.Rows0"姓名".ToString(); this.textBox3.Text = (ds.Tables0.Rows0"

22、;性別".ToString(); this.textBox4.Text = (ds.Tables0.Rows0"年齡".ToString(); this.textBox5.Text = (ds.Tables0.Rows0"班級".ToString(); conn.Close(); private void button1_Click(object sender, EventArgs e) if (textBox2.Text.Trim() = "" | textBox3.Text.Trim() = "" |

23、 textBox4.Text.Trim() = "" | textBox5.Text.Trim() = "") MessageBox.Show("請輸入完整信息！", "錯誤", MessageBoxButtons.OK, MessageBoxIcon.Error); else string str1 = textBox4.Text.Trim(); int l = str1.Length; for (int i = 0; i < l; i+) if (!char.IsNumber(str1i) Message

24、Box.Show("年齡輸入有誤！", "錯誤", MessageBoxButtons.OK, MessageBoxIcon.Error); textBox4.SelectAll(); textBox4.Focus(); return; SqlConnection conn = new SqlConnection(); string str = "Data Source=ZWEIQUAN-PC;Initial Catalog=Student;Integrated Security=True" conn.ConnectionString = str; conn.Open(); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "update 基本信息表 set 編號=編號,姓名=姓名,性別=性別,年齡=年齡,班級=班級 where 編號=編號" cmd.Connection = con