INSERT Problem

[Tom]

This is driving me crazy ...

I have a typed dataset that I created using VS2008. I created an Insert
statement:

"INSERT INTO x (v1, v2, v3, ..., vN) VALUES (?, ?, ?, ... N?)"

Then I add parameters to the Insert command (OleDbCommand BTW, going into an
Access database):

myOldDbCommandI nsert.Parameter s.Add(new OleDbParameter( "columnName ",
OleDbType.DBTim eStamp));
myOldDbCommandI nsert.Parameter s.Add(new OleDbParameter( "columnName 2",
OleDbType.Char) );
....
myOldDbCommandI nsert.Parameter s.Add(new OleDbParameter( "columnName N",
OleDbType.Unsig nedInt));

Now I set my default values:
myOldDbCommandI nsert.Parameter s["c1"].Value = defaultValue1;
myOldDbCommandI nsert.Parameter s["c2"].Value = defaultValue2;
....
myOldDbCommandI nsert.Parameter s["cN"].Value = defaultValueN;

Then I create my data adapter:
OleDbDataAdapte r a = new OleDbDataAdapte r("SELECT * FROM x", myConn);

Then the dataset:
MyCustomDataSet ds = new MyCustomDataSet ();
a.Fill(ds.MyCus tomTable);

So far, everything has worked fine up until this point. So now, I simply
want to add rows to MyCustomTable:
SomeLoopWith5Va luesOrWhatever
{
MyCustomDataSet .MyCustomRowA r = (cast)
MyCustomDataSet .MyCustomTable. NewRow();
r.v1 = x;
r.v2 = y;
r.v3 = z;
r.nN = N;
myDataSet.myDat aTable.Rows.Add (r);
}

Stepping through the debugger, that appears to do exactly what I expect. I
can see that the table gets the new rows, and they have the correct values.

However, when I do the following:
myDataAdapter.U pdate(myDataSet , "NameOfCorrectT able");

The correct number of rows are added to the correct table, but they do not
have the new values?!! They are keeping the default values that I set
earlier in my code. Why is my INSERT statement using these default values?

It's been a while since I messed with database stuff.
Thanks.

[Bob Barrows [MVP]]

Tom wrote:

This is driving me crazy ...

I have a typed dataset that I created using VS2008. I created an
Insert statement:

There was no way for you to know it (except maybe by browsing through some
of the previous questions in this newsgroup before posting yours - always a
recommended practice) , but this is a classic (COM-based) ADO newsgroup.
ADO.Net bears very little resemblance to classic ADO so, while you may be
lucky enough to find a dotnet-knowledgeable person here who can answer your
question, you can eliminate the luck factor by posting your question to a
group where those dotnet-knowledgeable people hang out. I suggest
microsoft.publi c.dotnet.framew ork.adonet.

Oops, I've just noticed you crossposted to several groups. I'm replying from
the data.ado group.The only relevant group you chose was the dotnet group.
They might be able to help you there. if not, try the adonet group.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[Tom]

Thanks Bob. I've since posted to the adonet newsgroup.
"Bob Barrows [MVP]" <re******@NOyah oo.SPAMcomwrote in message
news:ug******** ******@TK2MSFTN GP03.phx.gbl...

Tom wrote:

>This is driving me crazy ...

I have a typed dataset that I created using VS2008. I created an
Insert statement:

There was no way for you to know it (except maybe by browsing through some
of the previous questions in this newsgroup before posting yours - always
a
recommended practice) , but this is a classic (COM-based) ADO newsgroup.
ADO.Net bears very little resemblance to classic ADO so, while you may be
lucky enough to find a dotnet-knowledgeable person here who can answer
your
question, you can eliminate the luck factor by posting your question to a
group where those dotnet-knowledgeable people hang out. I suggest
microsoft.publi c.dotnet.framew ork.adonet.

Oops, I've just noticed you crossposted to several groups. I'm replying
from the data.ado group.The only relevant group you chose was the dotnet
group. They might be able to help you there. if not, try the adonet group.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"