关于DataGrid的增删改查，

[weiruan007]

我有4个按扭分别是增删改查的功能，功能都实现了，就是有点小问题，我的DataGrid和2个textBox1和textBox2绑定的，在没有增删改查前，我在DataGrid里选中哪行，textBox1和textBox2会分别显示我选中的行的值，可是我进行了增删改查后这个绑定功能没有了，不知道大家听不听懂我的意思

private void button1_Click(object sender, System.EventArgs e)
{
string strCon="server=CHINESE-E749083;database=fangzichuzu;user id=sa;password=";
SqlConnection con=new SqlConnection(strCon);
con.Open();
SqlCommand cmd=new SqlCommand("insert into Login(UserName,PassWord) values(@UserName,@PassWord)",con);
cmd.Parameters.Add("@UserName",this.textBox1.Text);
cmd.Parameters.Add("@PassWord",this.textBox2.Text);
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("添加成功");

SqlDataAdapter da=new SqlDataAdapter("select * from Login",strCon);
DataSet ds=new DataSet();
da.Fill(ds,"Login");
this.dataGrid1.SetDataBinding(ds,"Login");
}



private void button2_Click(object sender, System.EventArgs e)
{
string strCon="server=CHINESE-E749083;database=fangzichuzu;user id=sa;password=";
SqlConnection con=new SqlConnection(strCon);
con.Open();
SqlCommand cmd=new SqlCommand("delete from Login where UserName=@UserName",con);
cmd.Parameters.Add("@UserName",this.textBox1.Text);
cmd.Parameters.Add("@PassWord",this.textBox2.Text);
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("删除成功");
SqlDataAdapter da=new SqlDataAdapter("select * from Login",strCon);
DataSet ds=new DataSet();
da.Fill(ds,"Login");
this.dataGrid1.SetDataBinding(ds,"Login");
}


private void button3_Click(object sender, System.EventArgs e)
{
string strCon="server=CHINESE-E749083;database=fangzichuzu;user id=sa;password=";
SqlConnection con=new SqlConnection(strCon);
con.Open();
SqlCommand cmd=new SqlCommand("update Login set PassWord=@PassWord where UserName='"+textBox1.Text+"'",con);
cmd.Parameters.Add("@UserName",this.textBox1.Text);
cmd.Parameters.Add("@PassWord",this.textBox2.Text);
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("修改成功");
SqlDataAdapter da=new SqlDataAdapter("select * from Login",strCon);
DataSet ds=new DataSet();
da.Fill(ds,"Login");
this.dataGrid1.SetDataBinding(ds,"Login");
}


private void Form1_Load(object sender, System.EventArgs e)
{
string strCon="server=CHINESE-E749083;database=fangzichuzu;user id=sa;password=";
SqlDataAdapter da=new SqlDataAdapter("select * from Login",strCon);
DataSet ds=new DataSet();
da.Fill(ds,"Login");
textBox1.DataBindings.Add("Text",ds,"Login.UserName");
textBox2.DataBindings.Add("Text",ds,"Login.PassWord");
this.dataGrid1.SetDataBinding(ds,"Login");
}

private void button4_Click(object sender, System.EventArgs e)
{
string strCon="server=CHINESE-E749083;database=fangzichuzu;user id=sa;password=";
SqlDataAdapter da=new SqlDataAdapter("select * from Login",strCon);
DataSet ds=new DataSet();
da.Fill(ds,"Login");
this.dataGrid1.SetDataBinding(ds,"Login");
}