C连接数据库及增删查改操作

1、C#连接数据库及增删查改操作设计好的C#界面:gJDatagJDataGridViiI冋J0阖Farml.esForm2.CEJIForm3.esram匸共3个窗体。数据库:DataGndView-TDataGndView-T卍DataGridVS-ew与援乍斗仃丨回卜芨|编号姓名性别年龄班级1aa男20计算机-训dd.女30计算Ulll-23cc男21计算机-刑哙D妣目GricdUi亡训与接乍G回*|PFF|剧新删瞧添加修改查询姓名匸1查询编号姓名性别年龄班级133男20计算机11-廿43CG男21计算机11-对4nr,rnJDataGridView与昌乍回.剧新删瞧添加修改查询查询姓名上查

2、询代码：(Forml)publicpartialclassForml:FormpublicForml()InitializeComponent();privatevoidbuttonl_Click(objectsender,EventArgse)Forml_Load(sender,e);privatevoidForm1_Load(objectsender,EventArgse)trySqlConnectionconn=newSqlConnection();stringstr=DataSource=ZWEIQUAN-PC;InitialCatalog=Student;IntegratedSecu

3、rity=True;conn.ConnectionString=str;conn.Open();SqlCommandcmd=newSqlCommand();cmd.CommandText=select*from基本信息表;cmd.Connection=conn;SqlDataAdaptersda=newSqlDataAdapter(cmd);DataSetds=newDataSet();sda.Fill(ds,基本信息表);this.dataGridView1.DataSource=ds;this.dataGridView1.DataMember=基本信息表;this.dataGridView

4、1.AutoGenerateColumns=true;for(inti=1;ithis.dataGridView1.ColumnCount;i+)this.dataGridView1.Columnsi.DefaultCellStyle.SelectionBackColor=Color.White;this.dataGridView1.Columnsi.DefaultCellStyle.SelectionForeColor=Color.Black;this.dataGridView1.Columnsi.ReadOnly=true;conn.Close();catch(Exceptionee)Me

5、ssageBox.Show(错误:+ee.Message,错误);privatevoidbutton2_Click(objectsender,EventArgse)if(this.dataGridView1.SelectedCells=null)MessageBox.Show(请选择要删|除的项！，错误，MessageBoxButtons.OK,MessageBoxIcon.Error);elseif(this.dataGridView1.CurrentCell.ColumnIndex=0)stringst=this.dataGridView11，this.dataGridView1.Curr

6、entCell.RowIndex.Value.ToString();SqlConnectionconn=newSqlConnection();stringstr=DataSource=ZWEIQUAN-PC;InitialCatalog=Student;IntegratedSecurity=True;conn.ConnectionString=str;conn.Open();+stSqlCommandcmd=newSqlCommand();cmd.CommandText=deletefrom基本信息表where姓名=+stcmd.Connection=conn;cmd.ExecuteNonQu

7、ery();conn.Close();privatevoidbutton3_Click(objectsender,EventArgse)if(this.textBox1.Text.Trim()=)MessageBox.Show(请输入要查询的姓名!,提示)；elseSqlConnectionconn=newSqlConnection();stringstr=DataSource=ZWEIQUAN-PC;InitialCatalog=Student;IntegratedSecurity=True;conn.ConnectionString=str;conn.Open();SqlCommandcm

8、d=newSqlCommand();cmd.CommandText=select*from基本信息表where姓名=this.textBox1.Text.Trim()+;cmd.Connection=conn;SqlDataAdaptersda=newSqlDataAdapter(cmd);DataSetds=newDataSet();sda.Fill(ds);this.dataGridView1.DataSource=ds;this.dataGridView1.DataMember=ds.Tables0.ToString();this.dataGridView1.AutoGenerateCo

9、lumns=true;conn.Close();privatevoidbutton4_Click(objectsender,EventArgse)Form2f=newForm2();f.Show();privatevoidbutton5_Click(objectsender,EventArgse)Form3f=newForm3();f.id=Convert.ToInt32(this.dataGridView10,this.dataGridView1.CurrentCell.RowIndex.Value.ToString();f.Show();(Form2)publicpartialclassF

10、orm2:FormpublicForm2()InitializeComponent();privatevoidForm2_Load(objectsender,EventArgse)comboBoxl.Items.Add(男)；comboBoxl.Items.Add(女)；comboBox2.Items.Add(计算机11-1班)；comboBox2.Items.Add(计算机11-2班)；comboBox2.Items.Add(计算机11-3班)；comboBox1.DropDownStyle=ComboBoxStyle.DropDownList;comboBox2.DropDownStyle

11、=ComboBoxStyle.DropDownList;get_bh();privatevoidget_bh()SqlConnectionconn=newSqlConnection();stringstr=DataSource=ZWEIQUAN-PC;InitialCatalog=Student;IntegratedSecurity=True;conn.ConnectionString=str;conn.Open();SqlCommandcmd=newSqlCommand();cmd.CommandText=select*from基本信息表;/cmd.CommandText二selectisn

12、ull(max(编号)，0)+1from基本信息表；cmd.Connection=conn;SqlDataAdaptersda=newSqlDataAdapter(cmd);DataSetds=newDataSet();sda.Fill(ds);intt=ds.Tables0.Rows.Count;intbh=t-1;this.textBox1.Text二(Int32.Parse(ds.Tables0.Rowsbh编号.ToString()+1).ToString();/this.textBox1.Text=cmd.ExecuteScalar().ToString();conn.Close()

13、;privatevoidbutton1_Click(objectsender，EventArgse)if(textBox2.Text.Trim()=|textBox3.Text.Trim()=|comboBox1.Text.Trim()=|comboBox2.Text.Trim()=)MessageBox.Show(请输入完整信息！,错误，MessageBoxButtons.OK,MessageBoxIcon.Error);elsestringstr1=textBox3.Text.Trim();intl=str1.Length;for(inti=0;il;i+)if(!char.IsNumbe

14、r(str1i)MessageBox.Show(年龄输入有误！，错误，MessageBoxButtons.OK,MessageBoxIcon.Error);textBox3.SelectAll();textBox3.Focus();return;SqlConnectionconn=newSqlConnection();stringstr=DataSource=ZWEIQUAN-PC;InitialCatalog=Student;IntegratedSecurity=True;conn.ConnectionString=str;conn.Open();SqlCommandcmd=newSqlCo

15、mmand();cmd.CommandText=insertinto基本信息表(编号，姓名，性别，年龄，班级）values（编号,姓名，性别,年龄,班级）;cmd.Connection=conn;cmd.Parameters.Add(编号cmd.Connection=conn;cmd.Parameters.Add(编号，cmd.Parameters.Add(姓名，cmd.Parameters.Add(性别，cmd.Parameters.Add(年龄，cmd.Parameters.Add(班级，SqlDbType.Int);SqlDbType.NVarChar,SqlDbType.NVarCha

16、r,SqlDbType.Int);SqlDbType.NVarChar,50);50);50);textBox1.Text.Trim();textBox2.Text.Trim();comboBox1.Text.Trim();textBox3.Text.Trim();comboBox2.Text.Trim();cmd.Parameters编号.Valuecmd.Parameters姓名.Valuecmd.Parameters性别.Valuecmd.Parameters年龄.Valuecmd.Parameters班级.Valuecmd.ExecuteNonQuery();conn.Close();

17、this.Close();textBox1.Text.Trim();textBox2.Text.Trim();comboBox1.Text.Trim();textBox3.Text.Trim();comboBox2.Text.Trim();privatevoidbutton2_Click(objectsender，EventArgse)this.Close();(Form3)publicpartialclassForm3:FormpublicForm3()InitializeComponent();publicintid;privatevoidForm3_Load(objectsender，E

18、ventArgse)textBox1.Text=id.ToString();SqlConnectionconn=newSqlConnection(DataSource=ZWEIQUAN-PC;InitialCatalog=Student;IntegratedSecurity=True);SqlCommandcmd=newSqlCommand();cmd.Connection=conn;conn.Open();cmd.CommandText=select*from基本信息表where编号=+id.ToString();SqlDataAdaptersda=newSqlDataAdapter(cmd

19、);DataSetds=newDataSet();sda.Fill(ds);ififthis.textBox2.Textthis.textBox3.Textthis.textBox4.Textthis.textBox5.Textconn.Close();(ds.Tables0.Rows0姓名.ToString();(ds.Tables0.Rows0性别.ToString();(ds.Tables0.Rows0年龄.ToString();(ds.Tables0.Rows0班级.ToString();this.textBox2.Textthis.textBox3.Textthis.textBox4

20、.Textthis.textBox5.Textconn.Close();privatevoidbutton1_Click(objectsender,EventArgse)if(textBox2.Text.Trim()=|textBox3.Text.Trim()=|textBox4.Text.Trim()=|textBox5.Text.Trim()=)MessageBox.Show(请输入完整信息！,错误，MessageBoxButtons.OK,MessageBoxIcon.Error);elsestringstr1=textBox4.Text.Trim();intl=str1.Length;

21、for(inti=0;il;i+)if(!char.IsNumber(str1i)MessageBox.Show(年龄输入有误！，错误，MessageBoxButtons.OK,MessageBoxIcon.Error);textBox4.SelectAll();textBox4.Focus();return;SqlConnectionconn=newSqlConnection();stringstr=DataSource=ZWEIQUAN-PC;InitialCatalog=Student;IntegratedSecurity=True;conn.ConnectionString=str;conn.Open();SqlCommandcmd=newSqlCommand();cmd.CommandText=update基本信息表set编号=编号,姓名=姓名,性别=性别,年龄=年龄,班级=班级where编号=编号;cmd.Connection=conn;cmd.Parameters.Add(cmd.Connection=c