wince操作遠程sqlserver資料庫

wince下引用sqlclient.dll

增加dbnetlib.dll

便可以隨意操作遠端資料庫

 

dbnetlib.dll：http://download.csdn.net/detail/tiz198183/4344983

1、將 dbnetlib.dll 複製粘貼到vs項目裡面

2、設定dbnetlib.dll的屬性-----》複製到輸出目錄：如果較新則複製

 

View Code

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