Thanks Bonnie. U da woman! Just what I needed.

Einar
>Check out the MissingSchemaAction property of the DataAdapter.
>
>~~Bonnie
>
>
>
>>Again something works differently than how I expected it to work.
>>I have a table with 3 fields (field1, field2 and field3). I created a typed dataset from that table, but I removed field3 so the dataset only has 2 fields (field1 and field2).
>>I run the following code:
>>

>>DataSet1 ds = new DataSet1();
>>MessageBox.Show("Coulumns.Count: " + ds.Table2.Columns.Count.ToString(), "before");
>>
>>SqlDataAdapter adapter = new SqlDataAdapter();
>>adapter.SelectCommand = new SqlCommand("SELECT field1, field2, field3 FROM Table2", new SqlConnection("Data Source=localhost;Initial Catalog=Test;Integrated Security=SSPI;"));
>>adapter.Fill(ds, ds.Table2.TableName);
>>
>>MessageBox.Show("Coulumns.Count: " + ds.Table2.Columns.Count.ToString(), "after");
>>

>>
>>The first msgbox (with title before) displays a column count of 2 which is what I expect, but the 2nd msgbox (with title after) displays a column count of 3 which is not really what I expect.
>>
>>I understand why field3 is in my dataset after the fill (because it is included in the SELECT statement), but I am hoping that there is a way to prevent the structure of the dataset to be changed as a result of the Fill().
>>
>>Einar