C#如何向SQLCE写入数据

Question

问题1：
SqlCeEngine engine = new SqlCeEngine(@"Data Source=\abc.sdf");
engine.CreateDatabase();
string a="12345";
如何在abc.sdf中建表并写入a的值？

问题2：
如何从ppc2003程序中访问电脑上的SQL？如下语句，调试时总是在30秒后在tc.Open处报错（未处理SqlException），请教如何解决。（下面语句是在ppc2003中运行的）
SqlConnection tc = new SqlConnection(@"Server=JUJUMAO\sqlexpress;Integrated Security=True;Database=abc");
tc.Open();

Answer 1

2.C#连接SQL Server
程序代码:
--------------------------------------------------------------------------------

using System.Data;
using System.Data.SqlClient;
string strConnection="";

if (Password != "" )

{ strConnection= "server = " & ipAddress & ";database =" & databaseName & " DataAnalyseSystem;UID =" & user & " ;Pwd =" & password & ";max pool size = 500" //SQL连接方法
}else{
strConnection= "server =" & ipAddress & ";integrated security = SSPI ;database =" & databaseName //SQL连接方法}

SqlConnection objConnection=new SqlConnection(strConnection);

...

objConnection.Open();
objConnection.Close();

...

参考资料：http://hi.baidu.com/jonesvale/blog/item/33885c3c4fa4d2e63d6d97cb.html