DataGrid Methods

[John]

I created a connection, adapter, and a dataset using a .mdb, then filling in
at runtime;



OleDbDataAdapter1.Fill(DataSet11)



I also created a DataGrid and bound it by changing the DataSource property
to 'DataSet11.MainTable'.



My Goal is to modify the data in the rows and also add new rows with new
data in MainTable at runtime and keep the changes permanent. What methods
would I use to do this?

 

[RobinS]

Since you say DataGrid, you're doing a web app?

Robin S.

 

[John]

No, its a win app

Since you say DataGrid, you're doing a web app?

Robin S.

 

[Cor Ligthert [MVP]]

John,

In a multiuser environment you have only one choose.

Updating the database.
Clear the dataset
Fill the dataset again.

It was probably not what you whished, but it is hard to get the changes by
other users (althought that is possible in version 2005, is it probably more
work and takes a lot from your computer).

http://www.vb-tips.com/dbpages.aspx?ID=97f5073b-4c42-4215-b71c-3503c15fd46e

Cor

 

[RobinS]

If he has a multi-user environment, you're right. (Of course.)

If he doesn't, as long as the grid is bound, he could use a table
adapter to save the changes. Or a data adapter, but he has to write
his own logic. No matter what he does, he should *not* use that pesky
CommandBuilder. ;-) We all agree on that!

I didn't answer this at first, because it seems like an enormous
question
to me. There are whole chapters of books written about this very topic.

So John -- is it a multi-user environment?

Robin S.