Adding Column to populated DataSet
<p>I'm trying to add a column to a dataset that has my sql table data.  I basically wanted to add a column after the data is loaded to keep track of which values are already in the database and which values are new in the datagrid.  Then I can just know which rows to add into the database. I would appreciate any help.</p>

<p>Here is my code, I'm just trying to get the column to show up at this point, I will worry about updating the rows with this new column later.</p>

<pre><code>        sqlcom.CommandText = @"INSERT INTO members (firstname, lastname) VALUES ('" + textBox1.Text +"', '"+ textBox2.Text +"')";
        sqlcom.ExecuteNonQuery();

        SqlDataAdapter sqladapt = new SqlDataAdapter("SELECT * FROM members", thisConnect);
        DataSet ds = new DataSet();
        sqladapt.Fill(ds, "members");

        //add column to dataset?
        ds.Tables["members"].Columns.Add("inDb");

        dataGridView1.DataSource = ds;
        dataGridView1.DataMember = "members";

        thisConnect.Close();
</code></pre>
