//here i hv to filter newsitems which i already hv in my database
// and save the rest. BUT i am getting some errors
// PLZ HELP
private void queryChannels()
{
int l=rssDataSet.Channel.Rows.Count;
foreach(rssDataSet.ChannelRow currentChannel in rssDataSet.Channel.Rows)
{
System.Collections.ArrayList result;
result = rssManager.processNewsFeed(currentChannel.URL);
foreach (RSSReader2.NewsItem currentNewsItem in result)
{
string title = currentNewsItem.Title;
if (title.Length >= 50)
title = title.Substring(0, 49);
title.Replace("'", "");
string filterExpression = "Title= '" + title + "'";
//i hv temporarily removed filtering
//System.Data.DataRow[] filterdNewsItems= rssDataSet.NewsItem.Select(filterExpression);
//PROBLEM IS HERE...!!!
//i am getting filterdNewsItems Dimensions=0
//if (filterdNewsItems.Length != 0)
//{
rssDataSet.NewsItemRow newRow = rssDataSet.NewsItem.NewNewsItemRow();
newRow.Title = currentNewsItem.Title;
newRow.Link = currentNewsItem.Link;
newRow.Description = currentNewsItem.Description;
newRow.ChannelID = currentChannel.ChannelID;
newRow.DateAcquired = DateTime.Now;
newRow.NewsItemID = ++l;
//if(newRow != null)
rssDataSet.NewsItem.AddNewsItemRow(newRow);
// }
}
}
//PROBLEM HERE ALSO....!!!!when i removed the filtering
//ERROR IS :Cannot insert explicit value for identity column
// in table 'NewsItem' when IDENTITY_INSERT is set to OFF.
int rowsAffected = newsItemTableAdapter.Update(rssDataSet);
// based on rowsaffected update status label
}