itemlistform.cs

用C#+SQLCE开发的RSS读取工具

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlServerCe;

namespace MobileReader
{
    public partial class ItemListForm : Form
    {
        private MobileReaderResultSets.FeedResultSet feedRs;
        private SqlCeResultSet itemRs;

        public ItemListForm(MobileReaderResultSets.FeedResultSet feedRs)
        {
            InitializeComponent();
            this.feedRs = feedRs;
            this.Text = feedRs.Title;
        }

        private void ReturnMenuItem_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void ItemListForm_Load(object sender, EventArgs e)
        {
            SqlCeCommand command = feedRs.Connection.CreateCommand();
            command.CommandText = "SELECT * FROM Item WHERE FeedID = @feedID";
            command.CommandType = CommandType.Text;
            command.Parameters.Add("@feedID", feedRs.FeedID);
            itemRs = command.ExecuteResultSet(ResultSetOptions.Scrollable);

            ItemListBox.DataSource = itemRs;
            ItemListBox.DisplayMember = "Title";
        }

        private void ViewMenuItem_Click(object sender, EventArgs e)
        {
            itemRs.ReadAbsolute(ItemListBox.SelectedIndex);
            ItemReadForm itemReadForm = new ItemReadForm(itemRs);
            itemReadForm.Show();
        }
    }
}