查询

/// 
        /// 查询        /// 
        ///         ///         private void button1_Click(object sender, EventArgs e)        {            string YiGuo = "server=.;database=YiGuo;uid=sa;pwd=sasa";            SqlConnection MyConnerction = new SqlConnection(YiGuo);//定义一个数据库连接            SqlCommand MyCommand = new SqlCommand("select * from Users", MyConnerction);//定义一个数据库戏迷指令            SqlDataAdapter SelectAdapter = new SqlDataAdapter();//定义一个数据适配器；            SelectAdapter.SelectCommand = MyCommand;//定义数据适配器的操作指令            DataSet MyDataset = new DataSet();//定义一个数据集            MyConnerction.Open();//打开数据库连接;            SelectAdapter.SelectCommand.ExecuteNonQuery();//执行数据库查询指令            MyConnerction.Close();//关闭数据库            SelectAdapter.Fill(MyDataset);//填充数据集            DataGrid1.DataSource = MyDataset.Tables[0];            ////DataGrid1.DataBind();//将数据表格用数据集中的数据填充        }

添加

/// 
        /// 添加        /// 
        ///         ///         private void DataGrid1_CellContentClick(object sender, DataGridViewCellEventArgs e)        {        }        private void button2_Click(object sender, EventArgs e)        {            string YiGuo = "server=.;database=YiGuo;uid=sa;pwd=sasa";            SqlConnection MyConnerction = new SqlConnection(YiGuo);            string MyInsert = ("insert into Users (6583,15565628888,www.j&q@com,女,9420)values('" + Convert.ToString(textBox1.Text) + "','" + Convert.ToString(textBox2.Text) + "','" + Convert.ToString(textBox3.Text) + "','" + Convert.ToString(textBox4.Text) + "','" + Convert.ToString(textBox5.Text) + "')");            SqlCommand MyCommand = new SqlCommand(MyInsert, MyConnerction);            try//处理异常            {                MyConnerction.Open();                MyCommand.ExecuteNonQuery();                MyConnerction.Close();            }            catch(Exception ex)            {                MessageBox.Show(ex.Message);            }        }

修改更新

/// 
        /// 修改更新        /// 
        ///         ///         private void button3_Click(object sender, EventArgs e)        {            string YiGuo = "server = .;database=YiGuo;uid=sa;pwd=sasa";            SqlConnection MyConnerction = new SqlConnection(YiGuo);            string MyUpdata = "Update Users set 操作员 ='" + textBox2.Text + "'" + "where userName = " + "'" + textBox6.Text + "'";            SqlCommand MyCommand = new SqlCommand(MyUpdata, MyConnerction);            try            {                MyConnerction.Open();                MyCommand.ExecuteNonQuery();                MyConnerction.Close();                textBox6.Text = "";            }            catch(Exception ex)            {                MessageBox.Show(ex.Message);            }        }

删除

/// 
        /// 删除        /// 
        ///         ///         private void button4_Click(object sender, EventArgs e)        {            string YiGuo = "server = .;database = YiGuo;uid = sa; pwd=sasa";            SqlConnection MyConnection = new SqlConnection(YiGuo);            string MyData ="Delete from Users where UserID = "+ textBox5.Text;            SqlCommand MyCommand = new SqlCommand(MyData,MyConnection);            try            {                MyConnection.Open();                MyCommand.ExecuteNonQuery();                MyConnection.Close();                textBox6.Text = "";            }            catch(Exception ex)            {                MessageBox.Show(ex.Message);            }        }