WPF DataGrid

最新推荐文章于 2024-04-04 15:06:09 发布

zlcntt

最新推荐文章于 2024-04-04 15:06:09 发布

阅读量756

点赞数 1

分类专栏： UI编程（C#）文章标签： WPF DataGrid

本文链接：https://blog.csdn.net/zhlechn/article/details/18938187

版权

UI编程（C#）专栏收录该内容

8 篇文章 0 订阅

订阅专栏

1、自带的DataGrid的使用（将Access数据放入DataGrid）

<DataGrid x:Name="dataGrid"
				  DockPanel.Dock="Top"
				  AutoGenerateColumns="False"
				  GridLinesVisibility="All"
				  FontFamily="仿宋"
				  FontSize="14"
				  Foreground="Blue"
				  CanUserReorderColumns="False"
				  HeadersVisibility="All"
				  ColumnHeaderHeight="25">

			<DataGrid.Columns>
				<DataGridTextColumn Header="ID"
									Binding="{Binding Path=ID}"/>
				<DataGridTextColumn Header="仪器编号"
									Binding="{Binding Path=仪器编号}"
									Foreground="Black"/>
				<DataGridTextColumn Header="管道类型"
									Binding="{Binding Path=管道类型}"
									Foreground="Black" />
				<DataGridTextColumn Header="管道编号"
									Binding="{Binding Path=管道编号}"
									Foreground="Black" />
				<DataGridTextColumn Header="流量(m3/min)"
									Binding="{Binding Path=流量}"
									Foreground="Black" />
				<DataGridTextColumn Header="CH4(%)"
									Binding="{Binding Path=CH4}"
									Foreground="Black" />
				<DataGridTextColumn Header="纯量(m3/min)"
									Binding="{Binding Path=纯量}"
									Foreground="Black" />
				<DataGridTextColumn Header="压力(kPa)"
									Binding="{Binding Path=压力}"
									Foreground="Black" />
				<DataGridTextColumn Header="温度(℃)"
									Binding="{Binding Path=温度}"
									Foreground="Black" />
				<DataGridTextColumn Header="测量日期"
									Binding="{Binding Path=测量日期}"
									Foreground="Black" />
				<DataGridTextColumn Header="测量时间"
									Binding="{Binding Path=测量时间}"
									Foreground="Black" />
			</DataGrid.Columns>
		</DataGrid>

public void Read()
		{
			OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + dataBaseName);// 连接数据库
			conn.Open();// 打开数据库
			string sql = "select * from GasDataTable";

			OleDbDataAdapter ad = new OleDbDataAdapter(sql, conn);

			DataSet ds = new DataSet();

			ad.Fill(ds);

			MainWindow.Class.dataGrid.ItemsSource = ds.Tables[0].DefaultView;
			MainWindow.Class.dataGrid1.ItemsSource = ds.Tables[0].DefaultView;    
			conn.Close();
		}