首页 > 代码库 > Silverlight以列表显示数据库数据_DataGrid
Silverlight以列表显示数据库数据_DataGrid
效果图：
前台代码：
里面有一部分是我测试统计图的代码，不想改，感觉应该不影响理解....
<UserControl x:Class="Task_One.MainPage" xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" xmlns:d="http://schemas.microsoft.com/expression/blend/2008" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:my="clr-namespace:System.Windows.Controls;assembly=System.Windows.Controls.Data" xmlns:vc="clr-namespace:Visifire.Charts;assembly=SLVisifire.Charts" mc:Ignorable="d" d:DesignHeight="700" d:DesignWidth="1400" > <Grid x:Name="LayoutRoot1" Background="AliceBlue"> <Grid.RowDefinitions> <RowDefinition Height="50"/> <RowDefinition Height="*"/> <RowDefinition Height="auto"/> <RowDefinition Height="40"/> </Grid.RowDefinitions> <!--<Grid Grid.Row="0"> <Button Content="Button" HorizontalAlignment="Left" Margin="188,17,0,0" VerticalAlignment="Top" Width="75" Click="Button_Click_1"/> <TextBox x:Name="myText" HorizontalAlignment="Left" Height="23" Margin="10,17,0,0" TextWrapping="Wrap" VerticalAlignment="Top" Width="143"/> <TextBox x:Name="text18" HorizontalAlignment="Left" Height="23" Margin="430,16,0,0" TextWrapping="Wrap" VerticalAlignment="Top" Width="120"/> <TextBox x:Name="text30" HorizontalAlignment="Left" Height="23" Margin="643,16,0,0" TextWrapping="Wrap" VerticalAlignment="Top" Width="120"/> <TextBox x:Name="text40" HorizontalAlignment="Left" Height="23" Margin="858,16,0,0" TextWrapping="Wrap" VerticalAlignment="Top" Width="120"/> <TextBlock HorizontalAlignment="Left" Margin="358,20,0,0" TextWrapping="Wrap" Text="18岁占比：" VerticalAlignment="Top"/> <TextBlock HorizontalAlignment="Left" Margin="569,20,0,0" TextWrapping="Wrap" Text="30岁占比：" VerticalAlignment="Top"/> <TextBlock HorizontalAlignment="Left" Margin="795,20,0,0" TextWrapping="Wrap" Text="40岁占比：" VerticalAlignment="Top"/> <Button Content="修改" HorizontalAlignment="Left" Margin="1014,17,0,0" VerticalAlignment="Top" Width="75" Click="Button_Click_2"/> </Grid>--> <Grid x:Name="LayoutRoot" Grid.Row="1" Background="AntiqueWhite"> <my:DataGrid AutoGenerateColumns="False" HorizontalAlignment="Left" Name="dgList" Width="250" Margin="10,10,0,60"> <my:DataGrid.Columns> <my:DataGridTextColumn Header="ID" Binding="{Binding ID,Mode=OneWay}" Width="80"></my:DataGridTextColumn> <my:DataGridTextColumn Header="手机号" Binding="{Binding WORKSTATION,Mode=OneWay}" Width="150"></my:DataGridTextColumn> </my:DataGrid.Columns> </my:DataGrid> <vc:Chart Grid.Row="0" Name="chtChartOne" Height="300" Width="500"> <vc:Chart.AxesY> <!--Y间隔--> <vc:Axis Interval="20" Suffix="%"/> </vc:Chart.AxesY> </vc:Chart> </Grid> </Grid></UserControl>
后台代码：
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 Task_One.ServiceReference1;using System.Reflection;using Visifire.Charts; //因为要用到Assembly，所以引入此空间namespace Task_One{ public partial class MainPage : UserControl { public MainPage() { _YV18 = new Random().Next(45); _YV30 = new Random().Next(30); _YV40 = new Random().Next(20); InitializeComponent(); InitPage(); } private void client_GetDatabyNameCompleted(object sender, GetDatabyNameCompletedEventArgs e) { System.Collections.ObjectModel.ObservableCollection<ServiceReference1.Class1> temp = new ObservableCollection<ServiceReference1.Class1>(); temp = e.Result; dgList.ItemsSource = temp; //for (int i = 0; i < temp.Count; i++) //{ // MessageBox.Show(temp[i].ID.ToString() + " and " + temp[i].WORKSTATION.ToString()); //} } private void Button_Click_1(object sender, RoutedEventArgs e) { Task_One.ServiceReference1.ServiceClient client = new Task_One.ServiceReference1.ServiceClient(); client.GetDatabyNameAsync(Convert.ToInt32(myText.Text.ToString())); client.GetDatabyNameCompleted += new EventHandler<GetDatabyNameCompletedEventArgs>(client_GetDatabyNameCompleted); client.CloseAsync(); } #region 柱状图示例 /// <summary> /// 画柱状图 /// </summary> public void InitPage() { chtChartOne.Series.Clear(); chtChartOne.View3D = true; //Title title = new Title(); //title.Text = "柱状图的标题内容"; //chtChartOne.Titles.Add(title); //统计资料列 DataSeries ds = new DataSeries(); //柱状类型 ds.RenderAs = RenderAs.StackedColumn; //显示Lable ds.LabelStyle = LabelStyles.OutSide; ds.LabelEnabled = true; //栏 ds.DataPoints.Add(new DataPoint() { AxisXLabel = "18-29岁", YValue =http://www.mamicode.com/ YV18 }); ds.DataPoints.Add(new DataPoint() { AxisXLabel = "30-39岁", YValue =http://www.mamicode.com/ YV30 }); ds.DataPoints.Add(new DataPoint() { AxisXLabel = "40-49岁", YValue =http://www.mamicode.com/ YV40 }); ds.DataPoints.Add(new DataPoint() { AxisXLabel = "50-64岁", YValue = http://www.mamicode.com/18.9 }); ds.DataPoints.Add(new DataPoint() { AxisXLabel = "65岁以上", YValue = http://www.mamicode.com/17.2 }); chtChartOne.Series.Add(ds); } #endregion /// <summary> /// 修改比例值 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Button_Click_2(object sender, RoutedEventArgs e) { YV18 = Convert.ToInt32(text18.Text.ToString()); if (Convert.ToInt32(text30.Text.ToString()) >= 0) { YV30 = Convert.ToInt32(text30.Text.ToString()); } else { YV30 = 0; } if (Convert.ToInt32(text40.Text.ToString())>=0) { YV40 = Convert.ToInt32(text40.Text.ToString()); } else { YV40 = 0; } InitPage(); } private Int32 _YV18; private Int32 _YV30; private Int32 _YV40; public Int32 YV18 { get { return _YV18; } set { _YV18 = value; } } public Int32 YV30 { get { return _YV30; } set { _YV30 = value; } } public Int32 YV40 { get { return _YV40; } set { _YV40 = value; } } }}
源码：http://pan.baidu.com/s/1o6p2F9o
参考资料：http://www.cnblogs.com/Kinglee/archive/2009/08/25/1553938.html
http://www.nbcoder.net
Silverlight以列表显示数据库数据_DataGrid
声明：以上内容来自用户投稿及互联网公开渠道收集整理发布，本网站不拥有所有权，未作人工编辑处理，也不承担相关法律责任，若内容有误或涉及侵权可进行投诉： 投诉/举报 工作人员会在5个工作日内联系你，一经查实，本站将立刻删除涉嫌侵权内容。