change field in sql server

[bahram]

i have a table in sqlserver 2000 by 10 feild and i build a sqldataadapter anda dataset.xsd in my vs.net 2005 project
now i add a file in sqlserver table and my filed is 11
now i should delete my dataset and chang my dataadapter that my program work currectly
but i chang my dataadapter and dont want delete my dataset and rebuild it i need chang my dataset.xsd handly
for example if i chang my dataadapter my dataset chang automaticly and dont want i delete it and rebuild it plaese help me?

 

[cjard]

if you have altered the database schema and the new column is essential to your program then you must add it to the datatable in the dataset too.

If you have no need for this column (perhaps it is an internal auditing column written to by the database triggers) then you do not need to change your program