I'm new to C# and am having a problem with databases, specifically updating a table with dataset contents. No exceptions are being thrown, the update method tells me one row is affected but there is nothing in the table! Code below, your help is appreciated.
RSSDataSet.NewsItemRow newRow = rSSDataSet.NewsItem.NewNewsItemRow();
newRow.title = "a";
newRow.description = "a";
newRow.link = "a";
newRow.dateAcquired = DateTime.Now;
newRow.channelID = 1;
this.rSSDataSet.NewsItem.Rows.Add(newRow);
int result = this.newsItemTableAdapter.Update(this.rSSDataSet.NewsItem);
// Alternatively
newsItemTableAdapter.Insert("aa", "a", "a", DateTime.Now, 1);