Hi folks,
I've connected to the SQL backend using OdbcConnection. After fetching
data I present it in DataGrid control.
When I want insert a row, I create DataRow and pass it into
DataSet.Tables[tabIndex].Rows.Add() method directly. Database is updated
(previously established InsertCommand is called) and everything looks
good. But in what way should I update a row?
I can change its fields in DataGrid but when i call
DataAdapter.Fill(DataSet, "tabName") method, nothing happens. Of course
I defined proper UpdateCommand.
Is there a need to create some special connection between DataGrid and
DataSet?
Currently the only connection I have is set up in class constructor
manually:
DataGrid.DataSource = DataSource.Tables["tabName"];
I use above class names instead of names of my objects, of course.
When I used VS 2003 .NET, I can set up everything automatically and I
saw there appeared some mappings. But I even don't know between which
objects they were. Currently I work in Visual C# 2005 beta 1 and many
parts of my work I have to accomplish in code editor.
In what way should I update my database while working with DataGrid object?
Many thanks in advance,
Rafal