form1.cs

Microsoft Mobile Development Handbook的代码,有C#,VB,C++的

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

namespace MobileDevelopersHandbook 
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            if (ProductsDataSetUtil.DesignerUtil.IsRunTime())
            {
                // TODO: Delete this line of code to remove the default AutoFill for 'productsDataSet.Product'.
                this.productTableAdapter.Fill(this.productsDataSet.Product);
                FillProductCategories();
            }

        }

        private void newMenuItemMenuItem_Click(object sender, EventArgs e)
        {
            // Don't allow new Product creation if there are no Product Categories
            if (GetProductCategoriesCount() == 0)
            {
                MessageBox.Show("You must create some Product Categories first");
            }
            else
            {
                // Set some default column values
                this.productsDataSet.Product.ProductCategoryIDColumn.DefaultValue = 1;
                this.productsDataSet.Product.SizeColumn.DefaultValue = "M";

                productBindingSource.AddNew();

                MobileDevelopersHandbook.ProductEditViewDialog productEditViewDialog = MobileDevelopersHandbook.ProductEditViewDialog.Instance(this.productBindingSource);
                productEditViewDialog.ShowDialog();
            }
        }

        private void productDataGrid_Click(object sender, EventArgs e)
        {
            MobileDevelopersHandbook.ProductSummaryViewDialog productSummaryViewDialog = MobileDevelopersHandbook.ProductSummaryViewDialog.Instance(this.productBindingSource);
            productSummaryViewDialog.ShowDialog();
        }

        private void productBindingSource_AddingNew(object sender, AddingNewEventArgs e)
        {
            MessageBox.Show("AddingNew event fired");
            // Create a DataRowView
            DataRowView datarowview = ((DataView)productBindingSource.List).AddNew();

            // You can set fields in the new row like this:
            datarowview["ProductCategoryID"] = 1;
            // Or by getting the underlying DataRow in the data source
            ProductsDataSet.ProductRow productRow = (ProductsDataSet.ProductRow)datarowview.Row;
            productRow.ProductCategoryID = 1;
            productRow.ListPrice = 0.00M;

            // Tell it that this is the new row
            e.NewObject = datarowview;

            // Set the position of the BindingSource
            productBindingSource.Position = productBindingSource.Count - 1;
        }

        private int GetProductCategoriesCount()
        {
            int count = -1;
            using (SqlCeCommand cmd =
                new SqlCeCommand("SELECT COUNT(*) FROM ProductCategory",
                this.productTableAdapter.Connection))
            {
                try
                {
                    this.productTableAdapter.Connection.Open();
                    count = (int)cmd.ExecuteScalar();
                }
                finally
                {
                    this.productTableAdapter.Connection.Close();
                }
            }
            return count;
        }

        private void menuItem1_Click(object sender, EventArgs e)
        {
            ProductCategoriesForm frm = new ProductCategoriesForm();
            frm.ShowDialog();

            // When we are finished maintaining Product Categories, fill the ProductCategory table in the DataSet
            FillProductCategories();
        }

        private void FillProductCategories()
        {
            MobileDevelopersHandbook.ProductsDataSetTableAdapters.ProductCategoryTableAdapter
               prodCatTA = new MobileDevelopersHandbook.ProductsDataSetTableAdapters.ProductCategoryTableAdapter();
            prodCatTA.Fill(this.productsDataSet.ProductCategory);
        }
    }
}