C#数据库操作（1）

private void button1_add_Click(object sender, EventArgs e)

        {

            SqlCommand com = null;

            SqlConnection con = null;

            String uri = @"server=localhost;database=Warehouse;uid=sa;pwd=123456";

            try

            {

                con = new SqlConnection(uri);

                con.Open();

                com = new SqlCommand();

                com.Connection = con;

                String Id = textBox1_id.Text.Trim();

                String Name = textBox1_name.Text.Trim();

                Double Price = Double.Parse(textBox1_price.Text.Trim());

                int num = Convert.ToInt16(textBox1_count.Text.Trim());

                DateTime dt = new DateTime();

                String sql = "insert into good1(goodId,goodName,goodPrice,Count) values('" + Id + "','" + Name + "'," + Price + "," + num + ")";

                com.CommandType = CommandType.Text;

                com.CommandText = sql;

                com.ExecuteNonQuery();

                MessageBox.Show("添加成功！");

            }

            catch (SqlException oe)

            {

                MessageBox.Show("操作失败！" + oe);

            }

            finally {

            if(con!=null){

                con.Close();

            }

            }

            textBox1_id.Text = "";

            textBox1_name.Text = "";

            textBox1_price.Text = "";

            textBox1_count.Text = "";

  private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)

        {

            if (e.RowIndex >= 0) {

                textBox1_id.Text = dataGridView1.Rows[e.RowIndex].Cells["goodId"].Value.ToString();

                textBox1_name.Text = dataGridView1.Rows[e.RowIndex].Cells["goodName"].Value.ToString();

                textBox1_price.Text = dataGridView1.Rows[e.RowIndex].Cells["goodPrice"].Value.ToString();

                textBox1_count.Text = dataGridView1.Rows[e.RowIndex].Cells["Count"].Value.ToString();

            }

        }