Writing update back to MSAccess table?
- From: "planetthoughtful" <planetthoughtful@xxxxxxxxx>
- Date: 21 Sep 2006 19:52:47 -0700
Hi All,
I'm building a Windows Form application that will use a Microsoft
Access mdb file as a data store.
I have a section of code that is executed when the main form is closed
that _should_ update a setting value in a table in my mdb file. The
code executes without any error, but the value in the table appears
unchanged when I open up the table in the mdb file. I call this
function in the FormClosed event of the app's main form.
Code for the function is below:
private void fnSetRewardRemain()
{
using (OleDbConnection conn = new
OleDbConnection(ConnString)){
string thisval = "20";
string CommandString = "UPDATE tblSettings SET
settingval = '" + thisval + "' WHERE setting = 'remainreward'";
OleDbCommand remcom = new OleDbCommand(CommandString,
conn);
remcom.Connection.Open();
remcom.ExecuteNonQuery();
remcom.Dispose();
conn.Close();
}
}
In the example I'm attempting to write the 'hard coded' value of '20'
back to the table. If I write the value of CommandString out to the
console, and manually run it as a query in the mdb file itself, it
works fine. I'm assuming that I'm supposed to do something to 'flush'
the update back to the database, but I'm not sure what. If it helps,
the mdb was created in Acc2003 and is the 2002-2003 compatible file
structure.
Can anyone help me figure out how to get the update to write back to
the actual database?
Many thanks in advance,
pt
.
- Follow-Ups:
- Re: Writing update back to MSAccess table?
- From: Nicholas Paldino [.NET/C# MVP]
- Re: Writing update back to MSAccess table?
- Prev by Date: Re: dynamically getting similar indentifiers while program running
- Next by Date: Re: Writing update back to MSAccess table?
- Previous by thread: Re: Reporting and C#
- Next by thread: Re: Writing update back to MSAccess table?
- Index(es):
Relevant Pages
|
