default.aspx.cs

将带您了解SQL Server Compact 3.5的发展历程和功能特性

using System;
using System.Collections;
using System.Collections.Generic;
using System.Collections.Specialized;
using System.Configuration;
using System.Data;
using System.Data.SqlServerCe;
using System.Diagnostics;
using System.Text;
using System.Text.RegularExpressions;
using System.Web;
using System.Web.Caching;
using System.Web.Profile;
using System.Web.Security;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;

namespace SQLceUnderASPnet
{
	public partial class _Default : System.Web.UI.Page
	{
		
		
		private string _connectionString = "Data Source=|DataDirectory|\\MyData.sdf";
		
		protected void Button1_Click(object sender, EventArgs e)
		{
			ErrorLabel.Text = "";
			try
			{
				using (SqlCeConnection conn = new SqlCeConnection())
				{
					conn.ConnectionString = _connectionString;
					if (System.IO.File.Exists(conn.Database))
					{
						ErrorLabel.Text = "Database Exists";
						ErrorLabel.ForeColor = System.Drawing.Color.Green;
					}
					else
					{
						using (SqlCeEngine engine = new SqlCeEngine(conn.ConnectionString))
						{
							engine.CreateDatabase();
							ErrorLabel.Text = "Database Created";
							ErrorLabel.ForeColor = System.Drawing.Color.Blue;
						}
						
					}
				}
				
			}
			catch (Exception ex)
			{
				ErrorLabel.Text = ex.ToString();
				ErrorLabel.ForeColor = System.Drawing.Color.Red;
			}
		}
		
		protected void DeleteButton_Click(object sender, EventArgs e)
		{
			using (SqlCeConnection conn = new SqlCeConnection())
			{
				conn.ConnectionString = _connectionString;
				if (System.IO.File.Exists(conn.Database))
				{
					System.IO.File.Delete(conn.Database);
					ErrorLabel.Text = "Database Deleted";
					ErrorLabel.ForeColor = System.Drawing.Color.Green;
				}
				else
				{
					ErrorLabel.Text = "Database Didn\'t Exist";
					ErrorLabel.ForeColor = System.Drawing.Color.Blue;
				}
			}
			
		}
		
		protected void Page_Load(object sender, EventArgs e)
		{
			if (EnableSQLceCheckBox.Checked)
			{
				AppDomain.CurrentDomain.SetData("SQLServerCompactEditionUnderWebHosting", true);
			}
			else
			{
				AppDomain.CurrentDomain.SetData("SQLServerCompactEditionUnderWebHosting", false);
			}
		}
	}
}