silverlight datagird动态绑定

初步接触silverlight，遇到了一些问题，经过坎坷的探索最终解决了。这次把思路以及代码贴出来，抛砖引玉了。欢迎大家拍砖！

遇到的问题：silverlight 中的datagrid控件不能直接绑定datatable，导致不能实现动态绑定。

通用方法：自定义类，对自定义类序列化，使用自定义类中的属性作为列名称，使用List<自定义类>传递数据，并作为最终数据源绑定于datagrid上。存在的问题是：必须知道所含数据列个数以及数据列类型，这样导致不能动态的加载数据表。

解决办法：我的思路大概分三个关键部分。
1、 利用Dictionary来动态建立集合列。（参考http://www.cnblogs.com/Ivan-Yan/archive/2009/05/27/1490667.html博主文章）
2、 使WCF与Silverlight项目共享Dictionary建立的类。（参考http://jv9.itpub.net/post/41058/494434博主文章）
3、 实现 IValueConverter接口，定义转换器，解析集合数据。（参考http://www.cnblogs.com/Ivan-Yan/archive/2009/05/27/1490667.html博主文章）

client类库中TRow类：注意对类进行序列化标记。

using System; using System.Net; using System.Collections.Generic; using System.Runtime.Serialization; namespace SilverlightChina.CodeSharing { [DataContract] public class TRow { [DataMember] public Dictionary<string, object> dictionary = new Dictionary<string, object>(); public object this[string index] { get { return dictionary[index]; } set { dictionary[index] = value; } } } }

wcf程序
using System; using System.Linq; using System.Runtime.Serialization; using System.ServiceModel; using System.ServiceModel.Activation; using System.Data.SqlClient; using System.Data; using System.Collections.Generic; using System.Collections.ObjectModel; using SilverlightChina.CodeSharing; namespace ReportSilver.Web { [ServiceContract(Namespace = "")] [AspNetCompatibilityRequirements(RequirementsMode = AspNetCompatibilityRequirementsMode.Allowed)] public class TestService { string connstr = "Data Source=.;Initial Catalog=BGRIMMDataWarehouse;Integrated Security=True"; [OperationContract] public void DoWork() { // 在此处添加操作实现 return; } [OperationContract] public ObservableCollection<TRow> GetList(string tableName) { return this.retrow(tableName); } /// <summary> /// 获取数据源所有表名称 /// </summary> /// <returns></returns> [OperationContract] public List<string> GetDtList() { SqlConnection sqlcon = new SqlConnection(connstr); sqlcon.Open(); string sqlstr = "SELECT Name FROM BGRIMMDataWarehouse..SysObjects Where XType='U' ORDER BY Name"; SqlCommand sqlcom = new SqlCommand(sqlstr, sqlcon); List<string> mylist = new List<string>(); SqlDataReader sqlRead = sqlcom.ExecuteReader(); while (sqlRead.Read()) { mylist.Add(sqlRead[0].ToString()); } sqlcon.Close(); return mylist; } /// <summary> /// 获取这个表所有变量名称 /// </summary> /// <param name="Name"></param> /// <returns></returns> [OperationContract] public List<string> GetvarList(string Name) { SqlConnection sqlcon = new SqlConnection(connstr); sqlcon.Open(); string sqlstr = "select name from syscolumns where id=(select max(id) from sysobjects where xtype='u' and name='" + Name + "')"; SqlCommand sqlcom = new SqlCommand(sqlstr, sqlcon); List<string> mylist = new List<string>(); SqlDataReader sqlRead = sqlcom.ExecuteReader(); while (sqlRead.Read()) { mylist.Add(sqlRead[0].ToString()); } sqlcon.Close(); return mylist; } /// <summary> /// 获取绑定数据源 /// </summary> private ObservableCollection<TRow> retrow(string tableName) { ObservableCollection<TRow> result = new ObservableCollection<TRow>(); SqlConnection sqlcon = new SqlConnection(connstr); sqlcon.Open(); string sqlstr = "select * from " + tableName; SqlCommand sqlcom = new SqlCommand(sqlstr, sqlcon); SqlDataAdapter sqlda = new SqlDataAdapter(); DataTable dt = new DataTable(); sqlda.SelectCommand = sqlcom; sqlda.Fill(dt); if (!Convert.IsDBNull(dt)) { for (int j = 0; j < dt.Rows.Count; j++) { TRow row = new TRow(); for (int i = 0; i < dt.Columns.Count; i++) { string name = dt.Columns[i].ColumnName; row[name] = dt.Rows[j][i]; } result.Add(row); } sqlcon.Close(); return result; } return null; } // 在此处添加更多操作并使用 [OperationContract] 标记它们 } }

silverlight端

主界面程序
using System; using System.Collections.Generic; using System.Linq; using System.Net; using System.Windows; using System.Windows.Controls; using System.Windows.Documents; using System.Windows.Input; using System.Windows.Media; using System.Windows.Media.Animation; using System.Windows.Shapes; using System.Collections.ObjectModel; using SilverlightChina.CodeSharing; namespace ReportSilver { public partial class MainPage : UserControl { public MainPage() { InitializeComponent(); } /// <summary> /// 加载所有数据库表名称以供选择 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void UserControl_Loaded(object sender, RoutedEventArgs e) { ServiceReference1.TestServiceClient client = new ServiceReference1.TestServiceClient(); client.GetDtListCompleted += new EventHandler<ServiceReference1.GetDtListCompletedEventArgs>(client_GetDtListCompleted); client.GetDtListAsync(); } /// <summary> /// 加载数据库表名称 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> void client_GetDtListCompleted(object sender, ServiceReference1.GetDtListCompletedEventArgs e) { this.cbbTableName.ItemsSource = e.Result; } /// </summary> /// 测试获取数据 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button1_Click(object sender, RoutedEventArgs e) { this.dataGrid1.Columns.Clear(); this.dataGrid1.ItemsSource = null; ServiceReference1.TestServiceClient client = new ServiceReference1.TestServiceClient(); client.GetvarListCompleted += new EventHandler<ServiceReference1.GetvarListCompletedEventArgs>(client_GetvarListCompleted); client.GetvarListAsync(this.cbbTableName.SelectedItem.ToString()); } /// <summary> /// 加载某表下边所有变量名称 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> void client_GetvarListCompleted(object sender, ServiceReference1.GetvarListCompletedEventArgs e) { RowIndexConverter rowIn = new RowIndexConverter(); for (int i = 0; i < e.Result.Count; i++)//动态加载绑定列 { DataGridTextColumn dgtc = new DataGridTextColumn(); dgtc.Header = e.Result[i]; System.Windows.Data.Binding bind = new System.Windows.Data.Binding(); bind.Converter = rowIn; bind.ConverterParameter = e.Result[i]; dgtc.Binding = bind; dataGrid1.Columns.Add(dgtc); } ServiceReference1.TestServiceClient client1 = new ServiceReference1.TestServiceClient(); client1.GetListCompleted += new EventHandler<ServiceReference1.GetListCompletedEventArgs>(client_GetListCompleted); client1.GetListAsync(this.cbbTableName.SelectedItem.ToString()); } /// <summary> /// 绑定数据源，加载所有数据 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> void client_GetListCompleted(object sender, ServiceReference1.GetListCompletedEventArgs e) { dataGrid1.ItemsSource = e.Result; } } }

转换器代码：

using System; using System.Net; using System.Windows; using System.Windows.Controls; using System.Windows.Documents; using System.Windows.Ink; using System.Windows.Input; using System.Windows.Media; using System.Windows.Media.Animation; using System.Windows.Shapes; using System.Windows.Data; using System.Globalization; using SilverlightChina.CodeSharing; namespace ReportSilver { public class RowIndexConverter : IValueConverter { public object Convert(object value, Type targetType, object parameter, CultureInfo culture) { TRow row = value as TRow; string index = parameter as string; return row[index]; } public object ConvertBack( object value, Type targetType, object parameter, CultureInfo culture) { throw new NotImplementedException(); } } }

项目结构图：

 

如果有对silverlight感兴趣的加我qq，我的qq：854743589。