Modify Data in WPF DataGrid

See more: (untagged)

In my project when I modify data in database and then displaying in WPF datagrid, the data displaying in datagrid in separate row
It is not modifying in the same row


For eg:
When I modified Karnataka as Karnataka1, it is displaying in separate row
How can I solve this problem
As follows it is showing


Code Name

KA Karnataka
KA Karnataka1



The code I wrote is as follows


public State()
{
InitializeComponent();



conn.ConnectionString = "Data Source=.\\SQLEXPRESS;AttachDbFilename=D:\\HR Suite\\HR Suite(4-1)\\WpfApplication1\\WpfApplication1\\database.mdf;Integrated Security=True;User Instance=True";
conn.Open();
cmd.Connection = conn;
DataTable dt = new DataTable();
String str1 = "select code,name from State";
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = str1;
SqlDataAdapter adp = new SqlDataAdapter(cmd);
SqlCommandBuilder cb = new SqlCommandBuilder(adp);
adp.Fill(ds, "State");
bs.DataSource = ds.Tables["State"];
statedg5.ItemsSource = bs;
string a = cmdadd.Content.ToString();

switch (a)
{
case "Add":
{
//txtstatecode.IsEnabled = false;
//txtstatename.IsEnabled = false;
break;
}
}


}



case "Update":
{

cmdadd.Content = "Add";
cmdmodify.Content = "Modify";
try
{

SqlCommand cmd = new SqlCommand();
String str = "update State set name='" + this.txtstatename.Text + "'where code='" + this.txtstatecode.Text + "'";
cmd.CommandText = str;
cmd.Connection = conn;
cmd.ExecuteNonQuery();
//System.Windows.MessageBox.Show("Data Inserted Successfully");
cmd.Connection = conn;
DataTable dt = new DataTable();

/////////I think problem is here
String str1 = "select code,name from State where code='" + this.txtstatecode.Text + "'";

cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = str1;
SqlDataAdapter adp = new SqlDataAdapter(cmd);
SqlCommandBuilder cb = new SqlCommandBuilder(adp);
adp.Fill(ds, "State");
//adp.Update(ds, "State");
bs.DataSource = ds.Tables["State"];
statedg5.ItemsSource = bs;

}