using System.Data.SqlClient;
//数据绑定
private void BindData()
{SqlConnection con=new SqlConnection(s);
SqlDataAdapter sda = new SqlDataAdapter("select * from cpb",con);
DataSet ds = new DataSet();
sda.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
dataGridView1.Columns[0].HeaderText = "菜名";
dataGridView1.Columns[1].HeaderText = "菜品种类";
dataGridView1.Columns[2].HeaderText = "菜品容量";
dataGridView1.Columns[3].HeaderText = "菜品价格";
}
//修改按钮
private void buttonxg_Click(object sender, EventArgs e)
{
if (dataGridView1.SelectedRows.Count > 0)//有选中的行
{
string names = dataGridView1.SelectedCells[0].Value.ToString();
SqlConnection con = new SqlConnection(s);
con.Open();
string s3 = "update cpb set cpname='"+textBoxcpm.Text+"',cptype='"+textBoxcpzl.Text+"',cpstore="+textBoxcpyl.Text+",cpprice="+textBoxcpjg.Text+"where cpname='" + names.Trim() + "'";
Sq