c#与数据库的连接（二）数据库信息管理

项目效果

加载

效果：与数据库连接，将指定表载入dataGridView1中。

代码：

            conn.Open();
            string str = " select *from 属性表 ";
            DataTable b = new DataTable();
            SqlDataAdapter c = new SqlDataAdapter(str, conn);
            c.Fill(b);
            dataGridView1.DataSource = b;
            conn.Close();

添加

代码：

调用添加窗体

           adddata i = new adddata();
            i.Owner = this;
            i.Show();

button 确定：

            conn.Open();
            
            string s2 =Convert.ToString( textBox2.Text);
            string s3 = Convert.ToString(textBox3.Text);
            string s4 = Convert.ToString(textBox4.Text);

            string sqladd = "insert into 属性表  (id,name ,sex ,Occupation) values  ( "+ textBox1.Text + " , ' "+ s2  + " ' , '" + s3 +" ' ,'" + s4 +" ' " +  " ) ";
              SqlCommand n = new SqlCommand(sqladd, conn);
            try
            {
                
                n.ExecuteNonQuery();
                MessageBox.Show("添加成功！", "恭喜你");

            }
            catch
            {
                MessageBox.Show("失败");
            }
            finally
            {
                conn.Close();
            }

删除

代码：

            conn.Open();
            DialogResult r1 = MessageBox.Show("你确定要删除指定的列，删除后数据库中将不再存在哦", "返回值 是6 否7 取消2", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Exclamation);
            if (r1 == DialogResult.Yes)
            {
               
            for (int i = this.dataGridView1.SelectedRows.Count; i > 0; i--)
            {
                int ID = Convert.ToInt32(dataGridView1.SelectedRows[i - 1].Cells[0].Value);
                dataGridView1.Rows.RemoveAt(dataGridView1.SelectedRows[i - 1].Index);
                

                string sqldelete = "delete from 属性表 where id = " + ID ;
                SqlCommand r = new SqlCommand(sqldelete, conn);
                try
                {

                    r.ExecuteNonQuery();
                    MessageBox.Show("删除成功！", "恭喜你");

                }
                catch
                {
                    MessageBox.Show("失败");
                }
                finally
                {
                    conn.Close();
                }

            }


            }
            else
            {
                conn.Close();
            }
        }

清空：

dataGridView1.DataSource = null;