wince操作远程sqlserver数据库

wince下引用sqlclient.dll

增加dbnetlib.dll

便可以随意操作远程数据库

 

dbnetlib.dll下载地址：http://download.csdn.net/detail/tiz198183/4344983

1、将 dbnetlib.dll 复制粘贴到vs项目里面

2、设置dbnetlib.dll的属性-----》复制到输出目录：如果较新则复制

 

using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using System.Data.SqlTypes;using System.Data.SqlClient;namespace Wince远程连接数据库{    public partial class Form1 : Form    {        public Form1()        {            InitializeComponent();        }        private void Form1_Load(object sender, EventArgs e)        {            string Sqlstr = "Data Source=192.168.1.225;Database=MyOffice;User ID=sa;Password=123";            System.Data.SqlClient.SqlConnection  conn= new SqlConnection(Sqlstr);            System.Data.SqlClient.SqlCommand cmd = new SqlCommand("select * from UserInfo",conn);            conn.Open();            DataTable dt = new DataTable();            SqlDataAdapter da = new SqlDataAdapter(cmd);            da.Fill(dt);            dataGrid1.DataSource = dt;        }    }}

代码下载

内含sqlclient，dbnetlib