form1.cs

window mobile 访问 SQL SERVER数据库

using System;
using System.Linq;
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 DeviceSQLDemo2
{
    public partial class Form1 : Form
    {
        DBResultSets.OrdersResultSet orderSet;
        string connString = @"Data Source=.\DB.sdf";

        public Form1()
        {
            InitializeComponent();
        }

        private void menuItem7_Click(object sender, EventArgs e)
        {
            Application.Exit();
        }

        private void menuItem1_Click(object sender, EventArgs e)
        {
            BindingSource bs = new BindingSource();
            orderSet.Bind(bs);
            this.dataGrid1.DataSource = bs;
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            orderSet = new DeviceSQLDemo2.DBResultSets.OrdersResultSet(connString, ResultSetOptions.Scrollable | ResultSetOptions.Sensitive | ResultSetOptions.Updatable);
        }

        private void menuItem3_Click(object sender, EventArgs e)
        {
            Random random = new Random();
            int qty = random.Next(10);
            orderSet.AddOrdersRecord(System.DateTime.Now, "123", 1, qty, 100 * qty);
        }

        private void menuItem4_Click(object sender, EventArgs e)
        {
            Random random = new Random();
            int qty = random.Next(10);

            orderSet.ReadAbsolute(this.dataGrid1.CurrentRowIndex);
            orderSet.Qty = qty;
            orderSet.Price = 100 * qty;
            orderSet.Update();
        }

        private void menuItem5_Click(object sender, EventArgs e)
        {
            orderSet.ReadAbsolute(this.dataGrid1.CurrentRowIndex);
            orderSet.Delete();
        }
    }
}