commiting changes made to a typed dataset



hello,
i am writing an app in c# which reads data from Excel files and submits
them to an sqlserver database. the db is not going to be modified by
others during the excecution of the program. also the db has many
tables with complex relations.

1. i created a typed dataset of the datasource
2. the data read from an excel file are being inserted as new rows in
corresponding tables of the dataset
3. finally all the added rows have to be submitted to the datasource

the problem is i can't figure out how to do step 3: submit the changes
to the datasource. i thought there should be a way of synchronising the
dataset with the datasource in one move and in one place (i.e. main()
). is that possible??

please help, i am running out of time....
dimitrisx

.



Relevant Pages

  • Creating a mail merge document using C#.
    ... I'm trying to develop a C# app that creates Word 2003 mail merge ... documents with an Oracle 9i database as the datasource. ...
    (microsoft.public.dotnet.general)
  • Re: DataGrid Methods
    ... No, its a win app ... Robin S. ... I also created a DataGrid and bound it by changing the DataSource ...
    (microsoft.public.dotnet.framework.adonet)
  • working with Access in VB.Net
    ... I have created a small DB in Access, I then created the datasource and ... So far I have created a variable for each of the textboxes when I click ... line and if I give the app any six numbers then I need it to search ... through the DB and give me back all the strings that had 3 or more ...
    (microsoft.public.dotnet.languages.vb)
  • Persisting a Dataset
    ... I have a Windows Forms app deployed on Terminal Server. ... it loads up several datatables that then serve as the datasource for ... One of these datatables has about 5000 ROWS, ... app load such a large datatable into memory. ...
    (microsoft.public.dotnet.framework.adonet)