Hello,

I am writing a small (ie needs to be small and portable) application, so
decided to use an Access database. Having spent several frustrating
hours trying to do data access, I have failed completely. I would be
very grateful if anyone could help me accomplish this supposedly trivial
task.

I first tried doing it manually, and generating an SQL command, but that
gave a syntax error when I (who has a lot of years of professional
database work, and does know how to write SQL!) couldn't see one.

So, I tried using parameters, like this...

string sql = "update Profiles set FirstName=?, Surname=? where
WebSiteID=?";
using (OleDbConnection conn = new OleDbConnection(connStr)) {
using (OleDbCommand cmd = new OleDbCommand(sql, conn)) {
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("FirstName", txtFirstName.Text);
cmd.Parameters.AddWithValue("Surname", txtSurname.Text);
cmd.Parameters.AddWithValue("ProfileID", m_ProfileId);
try {
conn.Open();
cmd.ExecuteNonQuery();
this.Close();
}
catch (Exception ex) {
MessageBox.Show(ex.Message);
}
}
}

However, this just didn't do anything. No error was thrown, but the
database wasn't updated.

I then discovered the VS2005 data access features, such as the ones
shown in the walkthroughs here...

http://msdn.microsoft.com/en-us/libr...=VS.71%29.aspx

....but they didn't work. I created and configured a dataset from the
Access database, and then dragged the table onto the form. So far so
good, I had controls for the fields, and navigation controls to move
from one record to the next.

Trouble was, all it did was display the data. Any changes made were not
saved to the database, and any new records added weren't inserted.

I tried this on two different machines, with two different databases,
but the results (or lack thereof) were the same. No errors, but no
database updates.

Anyone any idea how I sort this out? I have been using SQL Server
heavily for years and never had this sort of problem. Last time I did
Access stuff was with VB6, and it all worked fine then. Am I missing
something here?

TIA

On 5/6/2010 11:06 AM, Alan Silver wrote:
[..]
> but the results (or lack thereof) were the same. No errors, but no
> database updates.
>
> Anyone any idea how I sort this out? I have been using SQL Server
> heavily for years and never had this sort of problem. Last time I did
> Access stuff was with VB6, and it all worked fine then. Am I missing
> something here?
>
> TIA
>

I've always done this following the style shown here:
http://msdn.microsoft.com/en-us/library/bbw6zyha.aspx