// 窗体load事件查询
private void Form1_Load(object sender, EventArgs e)
{
string sql = "select * from student";
SqlHelp.conn.Open();
SqlDataAdapter sda = new SqlDataAdapter(sql, SqlHelp.conn);
DataSet ds = new DataSet();
sda.Fill(ds);
dataGridView1.AutoGenerateColumns = false;
dataGridView1.DataSource = ds.Tables[0];
SqlHelp.conn.Close();
}
// 单击添加按钮把选中行的数据添加到一个新建的表stu中
private void button1_Click(object sender, EventArgs e)
{
//取得选中行第一列的值
string name = dataGridView1.SelectedRows[0].Cells[0].Value.ToString();
//取得选中行第二列的值
string loginpwd = dataGridView1.SelectedRows[0].Cells[1].Value.ToString();
//写sql语句添加数据
string sql = string.Format("insert stu values('{0}','{1}')",name,loginpwd);
SqlHelp.conn.Open();
SqlCommand cmd = new SqlCommand(sql,SqlHelp.conn);
if (cmd.ExecuteNonQuery() > 0)
{
MessageBox.Show("添加成功!");
string sql1 = "select * from stu";
SqlDataAdapter sda = new SqlDataAdapter(sql1, SqlHelp.conn);
DataSet ds = new DataSet();
sda.Fill(ds);
dataGridView2.AutoGenerateColumns = false;
dataGridView2.DataSource = ds.Tables[0];
}
SqlHelp.conn.Close();
}