Andy

Andy

  • NA
  • 12
  • 0

tableadapter update problem

Nov 15 2007 10:26 AM

I can't seem to update the datasource when I call the tableadapter's update method.  Here is my code snippet:

DealsTableAdapter ta = new DealsTableAdapter();
dsDeals.DealsDataTable dt = new dsDeals.DealsDataTable();
dsDeals.DealsRow dr = dt.NewDealsRow();
dr.NominalRate =varNewRate;
ta.Update(dr);

The update command on the table adapter looks like this:

UPDATE    Deals
SET  NominalRate = @NominalRate

If I use the query builder, and supply a parameter value for NominalRate, it works.  But otherwise, no.

I am not sure what I am missing here.  Can anyone help?

Andy