how to update dataset to sql server?

string excelConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\export.xls;Extended Properties=""Excel 8.0;HDR=YES;""";

DataSet ds = new DataSet();
OleDbDataAdapter mydata = new OleDbDataAdapter("Select * FROM [exportZAAH$]", excelConnectionString);
mydata.Fill(ds);

i am having my excelsheet datas in my dataset(ds)

how to update this dataset to my sql server table?

Thanks in advance
Manivannan.s

Hi Mani,

Create a select command against your table, and then use a DataAdapter
with a CommandBuilder to automatically flush your DataTable.

EG.

SqlCommand cmd = new SqlCommand("select * from myTable",con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
SqlCommandBuilder cb = new SqlCommandBuilder(da);
DataTable dt = . . . ;
da.Update(dt);


Use this...

__________________
S.VinothkumaR
Behind me is infinite power,
Before me is Endless Possibility,
Around me is Boundless Opportunity,
Why should I fear!