#眉標=Windows Azure、SQL Azure、ADO.NET
#副標=Windows Azure平台開發技術(3)
#大標=雲端上的關聯資料庫─SQL Azure
#作者=文／圖 黃忠成



===<反灰>=============
●SQL Server 2008 Management Studio R2 32 bit : http://go.microsoft.com/fwlink/?LinkID=168734&clcid=0x409。
●SQL Server 2008 Management Studio R2 64 bit : http://go.microsoft.com/fwlink/?LinkID=168735&clcid=0x409。
==<end>==============



===<反灰>=============

-- =========================================
-- Create table template SQL Azure Database 
-- =========================================
USE [Northwind]
SET QUOTED_IDENTIFIER ON
GO  

CREATE TABLE [dbo].[Customers](
  [CustomerID] [int] NOT NULL PRIMARY KEY,
  [Name] [nvarchar](100) NULL
) 
GO
==<end>==============




===<反灰>=============
Form1.cs
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace WindowsFormsApplication1
{
  public partial class Form1 : Form
  {
   public Form1()
   {
    InitializeComponent();
   }
   private void Form1_Load(object sender, EventArgs e)
   {
    this.customersTableAdapter.Fill(this.dataSet1.Customers);
   }
   private void button1_Click_1(object sender, EventArgs e)
   {
    customersTableAdapter.Update(
     this.dataSet1.Customers.GetChanges() as DataSet1.CustomersDataTable);
   }
  }
}
==<end>==============