P
Patrick Demets
I have a fairly simple form with databound text boxes, but changes (or new
records) are not recognized. The text boxes are successfully populated with
data (from the database) and I can cycle through all the records. Using a
datagrid works fine for updating.
I've based this on the first sample project from the book "C# Professional
Projects" (Premier Press). I've read many posts concerning this (and the MS
KB as well), and most seem to say that databound text boxes must use a
DataRow object (in addition to connection, data adapter, and dataset
objects), and therefore not as simple as a datagrid.
Based on what I've read, I'm inclined to believe that the book is wrong.
Here are the code fragments for loading and saving the data:
private void btnEdit_Click (object sender, System.EventArgs e)
{
customerDataSet.Clear();
sqlDataAdapter1.Fill(customerDataSet);
// . . .
}
private void btnSave_Click (object sender, System.EventArgs e)
{
// seems simple enough, but doesn't work (for databound text boxes),
works for datagrid
sqlDataAdapter1.Update (customerDataSet);
}
If the book is indeed wrong, I plan to still work through the projects (as
idea generators) but use "Programming C#" (Liberty) for support, which seems
like a better book.
Incidentally, I've had other problems with the "C# Professional Projects"
book (the underlying database for the above project is assumed to exist and
be accessible, but no details given). Then again, being new to .NET and C#,
I may be missing something obvious. Anyone else have issues with this book?
Any constructive help is much appreciated,
Patrick
records) are not recognized. The text boxes are successfully populated with
data (from the database) and I can cycle through all the records. Using a
datagrid works fine for updating.
I've based this on the first sample project from the book "C# Professional
Projects" (Premier Press). I've read many posts concerning this (and the MS
KB as well), and most seem to say that databound text boxes must use a
DataRow object (in addition to connection, data adapter, and dataset
objects), and therefore not as simple as a datagrid.
Based on what I've read, I'm inclined to believe that the book is wrong.
Here are the code fragments for loading and saving the data:
private void btnEdit_Click (object sender, System.EventArgs e)
{
customerDataSet.Clear();
sqlDataAdapter1.Fill(customerDataSet);
// . . .
}
private void btnSave_Click (object sender, System.EventArgs e)
{
// seems simple enough, but doesn't work (for databound text boxes),
works for datagrid
sqlDataAdapter1.Update (customerDataSet);
}
If the book is indeed wrong, I plan to still work through the projects (as
idea generators) but use "Programming C#" (Liberty) for support, which seems
like a better book.
Incidentally, I've had other problems with the "C# Professional Projects"
book (the underlying database for the above project is assumed to exist and
be accessible, but no details given). Then again, being new to .NET and C#,
I may be missing something obvious. Anyone else have issues with this book?
Any constructive help is much appreciated,
Patrick