将SqlCeResultSet作为Itemsource绑定到DataGrid。 [英] Binding SqlCeResultSet as Itemsource to DataGrid.
问题描述
你好,
我正在使用sqlceresultset来填充数据网格。 检索并设置ResultSetView属性后。
DataGrid显示正确的列标题,并扩展了正确的行数。但数据行都是空白。
为什么会这样?
Why is it so ?
Code Snippet
MyModel>>>>>>>>>>>> ;>>>>>>>>>>>>
MyModel>>>>>>>>>>>>>>>>>>>>>>
公共类型号
{
SqlCeConnection conn = null;
SqlCeCommand cmd = null;
SqlCeResultSet rs = null;
ResultSetView rsview = null;
public SqlCeResultSet GetData()
{
this.conn = new SqlCeConnection(" Data Source = ../../Data/AdventureWorksExt4.0.sdf");
this。 conn.Open();
this.cmd = conn.CreateCommand();
this.cmd.CommandText =" Pers on_Address" ;;
          this.cmd.CommandType = CommandType.TableDirect;
          if(null!= rs)
              rs.Close();
          rs = cmd.ExecuteResultSet(ResultSetOptions.Sensitive | ResultSetOptions.Updatable | ResultSetOptions.Scrollable);
          return rs.ResultSetView;
      }
public class Model
{
SqlCeConnection conn = null;
SqlCeCommand cmd = null;
SqlCeResultSet rs = null;
ResultSetView rsview = null;
public SqlCeResultSet GetData()
{
this.conn = new SqlCeConnection("Data Source = ../../Data/AdventureWorksExt4.0.sdf");
this.conn.Open();
this.cmd = conn.CreateCommand();
this.cmd.CommandText = "Person_Address";
this.cmd.CommandType = CommandType.TableDirect;
if (null != rs)
rs.Close();
rs = cmd.ExecuteResultSet(ResultSetOptions.Sensitive | ResultSetOptions.Updatable | ResultSetOptions.Scrollable);
return rs.ResultSetView;
}
}
>>>>>>>>>>>>>>
>>>>>>>>>>>>>
代码背后>>>>>>>>>
Code behind>>>>>>>>>
this.datagrid.ItemsSource = new Model()。GetData();
this.datagrid.ItemsSource = new Model().GetData();
>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>
提前致谢....
sankar
推荐答案
当数据库路径无效时,这会在设备上爆炸。如果您在桌面上执行此操作,请尝试更多相应的论坛。
That would blow up on devices as your database path is invalid. If you're doing that on the desktop please try more appropriate forum.
这篇关于将SqlCeResultSet作为Itemsource绑定到DataGrid。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!