Silverlight访问数据库

Silverlight访问数据库需要通过Webservice来实现。

在服务器端Add New Item-->Webservice，然后添加代码

[WebMethod] public <a href="http://code.js-code.com/tag/sma/" target="_blank" class="keywords">sma</a>rtProgramData OnOpen(<a href="http://code.js-code.com/tag/Stri/" target="_blank" class="keywords">Stri</a>ng i_DB<a href="http://code.js-code.com/tag/Name/" target="_blank" class="keywords">Name)</a> <a href="http://code.js-code.com/tag/" target="_blank" class="keywords">{</a> AccessDBUtility.Initialize(_strData<a href="http://code.js-code.com/tag/sourc/" target="_blank" class="keywords">sourc</a>e + @"E:/Pro<a href="http://code.js-code.com/tag/je/" target="_blank" class="keywords">je</a>ct/<a href="http://code.js-code.com/tag/sma/" target="_blank" class="keywords">sma</a>rtTesterNet/<a href="http://code.js-code.com/tag/sma/" target="_blank" class="keywords">sma</a>rtTesterNet.Web/App_Data/" + i_DB<a href="http://code.js-code.com/tag/Name/" target="_blank" class="keywords">Name)</a>; return ServerDataBaseMode<a href="http://code.js-code.com/tag/l/" target="_blank" class="keywords">l.</a>Read(@"E:/Pro<a href="http://code.js-code.com/tag/je/" target="_blank" class="keywords">je</a>ct/<a href="http://code.js-code.com/tag/sma/" target="_blank" class="keywords">sma</a>rtTesterNet/<a href="http://code.js-code.com/tag/sma/" target="_blank" class="keywords">sma</a>rtTesterNet.Web/App_Data/" + i_DB<a href="http://code.js-code.com/tag/Name/" target="_blank" class="keywords">Name)</a>; }

OnOpen函数带有参数数据库名，具体的实现的函数在ServerDataBaseModel类中

然后在客户端添加service References引用，discover会自动找到，然后选择并添加

使用：

public static <a href="http://code.js-code.com/tag/sma/" target="_blank" class="keywords">sma</a>rtTester<a href="http://code.js-code.com/tag/servi/" target="_blank" class="keywords">servi</a>ceSoapClient client = new <a href="http://code.js-code.com/tag/sma/" target="_blank" class="keywords">sma</a>rtTester<a href="http://code.js-code.com/tag/servi/" target="_blank" class="keywords">servi</a>ceSoapClient(<a href="http://code.js-code.com/tag/" target="_blank" class="keywords">);</a>

定义一个client

然后调用client的方法和注册事件

client<a href="http://code.js-code.com/tag/o/" target="_blank" class="keywords">.o</a>nOpenCompleted += new EventHandler<OnOpenCompletedEventArgs>(client_OnOpenCompleted<a href="http://code.js-code.com/tag/" target="_blank" class="keywords">);</a> private button1_click(ob<a href="http://code.js-code.com/tag/je/" target="_blank" class="keywords">je</a>ct sender,RouteEventArgs <a href="http://code.js-code.com/tag/E/" target="_blank" class="keywords">E)</a> <a href="http://code.js-code.com/tag/" target="_blank" class="keywords">{</a> client<a href="http://code.js-code.com/tag/o/" target="_blank" class="keywords">.o</a>n<a href="http://code.js-code.com/tag/open/" target="_blank" class="keywords">open()</a>; } // void client_OnOpenCompleted(ob<a href="http://code.js-code.com/tag/je/" target="_blank" class="keywords">je</a>ct sender,OnOpenCompletedEventArgs <a href="http://code.js-code.com/tag/E/" target="_blank" class="keywords">E)</a> <a href="http://code.js-code.com/tag/" target="_blank" class="keywords">{</a> }

这样，Open操作完成之后，会自动进入到OnOpenCompleted中，OnOpenCompletedEventArgs e的result就是返回的数据

然后就可以根据需要，将返回的数据绑定到treeview上了