.NET Compact Framework在windows ce 5.0上直接访问桌面版的SQL Server 2005

来源：互联网发布：复杂网络引论编辑：程序博客网时间：2024/05/10 16:07

.NET Compact Framework在windows ce5.0上直接访问桌面版的SQL Server 2005

参照http://blog.csdn.net/upto/archive/2007/09/23/1797126.aspx的提示和外国朋友的劳动成果。本人英文不好不能翻译只能将自己理解总结如下：

环境：

SQL Server 2005 + SQL Server Compcat 3.5SP1 XP SP3 Virsual Studio 2008

1、配置SQL Server2005远程连接

开始->所有程序->Microsoft SQL Server 2005->配置工具->SQL Server外围应用配置器或者

Click On Start | All Programs | MicrosoftSQL Server2005 | Configuration Tools | SQL Server Surface Area configuration

设置图片

点击“服务和连接的外围应用配置器” 或 Surface Area Configuration for Services and Connections”

配置图片

按照上面的选项：选择远程连接->选择本地连接和远程连接->选中同时使用TCP/IP和named pipes(B)

点击“应用”或者确定即可。重新启动服务。

2、配置防火墙

开始->控制面板->安全中心->Windows 防火墙

防火墙

点击“添加程序”，选择C:/Program Files/Microsoft SQL Server/MSSQL.1/MSSQL/Binn/sqlservr.exe选择确定

3、编写程序

myConn = newSqlConnection(@"Server=192.168.1.189;Database=C_Gather;User Id=csqlce; Password=CAOchangHONG12345^&*()");

myConn.Open();

SqlDataReadermyDataReader;

SqlCommandmyCmd = myConn.CreateCommand();

myCmd.CommandText = @"SELECT TABLE_SCHEMA, TABLE_NAME FROMINFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE'";

treeView1.BeginUpdate();

treeView1.Nodes.Clear();

treeView1.Nodes.Add(new TreeNode("Tables"));

TreeNodechildNode = treeView1.Nodes[0];

intchildCount = 0;

myDataReader =myCmd.ExecuteReader();

while(myDataReader.Read())

{

stringTableName = (myDataReader[0].ToString()) + "."+ (myDataReader[1].ToString());

childNode.Nodes.Insert(childCount, new TreeNode(TableName));

childCount += 1;

}

myDataReader.Close();

treeView1.Nodes.Add(new TreeNode("Views"));

SqlCommandmyCmdView = myConn.CreateCommand();

myCmdView.CommandText = @"SELECT TABLE_SCHEMA, TABLE_NAME FROMINFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'VIEW'";

TreeNodechildNodeView = treeView1.Nodes[1];

intchildCountView = 0;

myDataReader =myCmdView.ExecuteReader();

while(myDataReader.Read())

{

stringViewName = (myDataReader[0].ToString()) + "."+ (myDataReader[1].ToString());

childNodeView.Nodes.Insert(childCount,new TreeNode(ViewName));

childCountView += 1;

}

myDataReader.Close();

treeView1.ExpandAll();

treeView1.EndUpdate();

myConn.Close();

} // try

catch(SqlException myexception)

{

foreach(SqlError err inmyexception.Errors)

{

MessageBox.Show(err.Message);

}

类似上面的代码，你可以到http://www.opennetcf.com/downloads/download.aspx?s=SSMS_Device下载他的完整代码

运行以后在myConn.Open();可能出现错误与他dbnetlib.dll有关的错误。你将 C:/ProgramFiles/Microsoft SQL Server Compact Edition/v3.5/Devices/Client/wce500/x86文件夹下两个文件