wpf datagrid connecting with database

private void Add_Click(object sender, RoutedEventArgs e)
{

try
{

SqlCommand cmd = new SqlCommand();
String str = "insert into State(Code,Name)values ('" + this.txtstatecode.Text + "','" + this.txtstatename.Text + "')";
cmd.CommandText = str;
cmd.Connection = conn;
cmd.ExecuteNonQuery();
System.Windows.MessageBox.Show("Data Inserted Successfully");
DataTable dt = new DataTable();

String str1 = "select code,name from State";
//cmd.CommandText = str1;
cmd.Connection = conn;

cmd.CommandType = CommandType.Text;
cmd.CommandText = str1;
//DataSet ds = new DataSet();
SqlDataAdapter adp = new SqlDataAdapter(cmd);

SqlCommandBuilder cb = new SqlCommandBuilder(adp);
adp.Fill(ds,"State");
bs.DataSource = ds.Tables["State"];

statedg5.ItemsSource = bs;
}
catch (Exception e1)
{
System.Windows.MessageBox.Show(e1.Message);
}
finally
{
conn.Close();
}

}





I got answer when I assigned ItemSource instead of DataSource


Thank You

That you asked this three times is intolerably rude, esp when the issue was one of basic understanding of C#. Perhaps you should buy a book and read it.