vb.NET Datagrid vith MySql

[160473]

I have populated a datagrid with data from a MySql table in normal maners (MySqlDataAdapter, DataTable etc).
Now, when I change data (rows or cells) the data in MySql must change at the same time. All information I can find is about asp.NET with a [EDIT] button. I like the datagrid to function just like Access tables.
Any ideas?

 

[ThatRickGuy]

If you are looking for an interface solution for updating data from a datagrid in ASP.Net, I would recommend looking on the Microsoft: ASP.NET forum.

-Rick

----------------------
If you're about to post an ASP.Net question,
please don't do it in the VB.Net forum

http://www.ringdev.com

I believe in killer coding ninja monkeys.

 

[160473]

No I'm NOT looking for a solution for ASP.NET.
VB.NET my dear friend.

 

[SqueakinSweep]

The Datagrid is simply a container for displaying the underlying data. Changes made in the grid are made in the underlying datatable also. Each row of a grid represents a datarow in the datatable.

Note that the datarow has beginedit and endedit methods.

To fire back the updates, use the .Update method of the DataAdaptor

Dont forget you are working with disconnected data here, and its not like Access, where you are bound to the data. I guess if you reall wanted you could fire back an update after moving between each cell change, but personally I would only do this on row change.



Sweep
...if it works dont mess with it