<br><b>Code</b>: rsb:print<br><b>Error</b>: Formatter [ rootadoname ] failed in the evaluation of <p>?????? CData ADO.NET Provider for [service] ?????Infragistics WPF XamDataGrid ? [service] [datatype] ???????????????????</p> <h2>??????</h2> <p>?????? Infragistics WPF XamDataGrid ?[datasource]?????????????????????????????</p> <p><img src="https://cdatajbuilds.s3-ap-northeast-1.amazonaws.com/sugimototest/xamDataGrid.gif" title="XamDataGrid" width="600" /></p> <h2>1. WPF?????????</h2> <p>???VisualStudio???????WPF?????????????????</p> <p><img src="../articles/ado-XamDataGrid01.png" title="XamDataGrid" width="600" /></p> <p>???????????????????CData ADO.NET Provider?SQL??????TextBox????????????????</p> <p><img src="../articles/ado-XamDataGrid01.png" title="XamDataGrid" width="600" /></p> <p>??????XAML??????????????</p> <code> <Window x:Class="CData.XamDataGrid.GropingListApp.MainWindow" 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:local="clr-namespace:CData.XamDataGrid.GropingListApp" mc:Ignorable="d" Title="MainWindow" Height="450" Width="800"> <Grid> <TextBox x:Name="sqlTextBox" HorizontalAlignment="Left" Height="45" Margin="10,10,0,0" TextWrapping="Wrap" Text="TextBox" VerticalAlignment="Top" Width="668"/> <Button x:Name="executeButton" Content="Execute" HorizontalAlignment="Left" Margin="683,10,0,0" VerticalAlignment="Top" Width="99" Height="45" /> </Grid> </Window> </code> <h2>2. XamDataGrid ???·??</h2> <p>???XamDataGrid???????? Infragistics WPF UI??????????????????????????????????????????</p> <p><img src="../articles/ado-XamDataGrid01.png" title="XamDataGrid" width="600" /></p> <p>????????????????????????</p> <p><img src="../articles/ado-XamDataGrid01.png" title="XamDataGrid" width="600" /></p> <p>?????????(xamDataGrid?????)?DataSource?{Binding}????????????????????Custom:FieldSettings???AllowRecordFiltering="true"??AllowSummaries="True" ?????????</p> <p>???????????????????????Theme="Metro"????????????????????????</p> <code> <Window 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:local="clr-namespace:CData.XamDataGrid.GropingListApp" xmlns:Custom="http://infragistics.com/DataPresenter" x:Class="CData.XamDataGrid.GropingListApp.MainWindow" mc:Ignorable="d" Title="MainWindow" Height="450" Width="800"> <Grid> <TextBox x:Name="sqlTextBox" HorizontalAlignment="Left" Height="45" Margin="10,10,0,0" TextWrapping="Wrap" Text="TextBox" VerticalAlignment="Top" Width="668"/> <Button x:Name="executeButton" Content="Execute" HorizontalAlignment="Left" Margin="683,10,0,0" VerticalAlignment="Top" Width="99" Height="45"/> <Custom:XamDataGrid Name="xamDataGrid" DataSource="{Binding}" HorizontalAlignment="Left" Margin="10,60,0,0" VerticalAlignment="Top" Height="349" Width="772" Theme="Metro"> <Custom:XamDataGrid.FieldSettings> <Custom:FieldSettings AllowSummaries="True" AllowRecordFiltering="true"/> </Custom:XamDataGrid.FieldSettings> </Custom:XamDataGrid> </Grid> </Window> </code> <h2>3. CData [service] ADO.NET Provider ???????</h2> <p>??? CData [service] ADO.NET Provider ?????????????</p> <p>?????????CData [service] ADO.NET Provider ??????????System.Data.CData.[rootadoname].dll????????</p> <p>??????????System.Data.CData.[rootadoname]?????</p> <code> using System.Data.CData.[rootadoname]; </code> <p>????????????TextBox??SQL??????[service] ????????????????????????????????????????????????????</p> <code> using System.Data; using System.Data.CData.[rootadoname]; using System.Windows; namespace CData.XamDataGrid.GropingListApp { /// <summary> /// MainWindow.xaml ????????? /// </summary> public partial class MainWindow : Window { public MainWindow() { InitializeComponent(); sqlTextBox.Text = "SELECT * FROM Samples"; } private void ExecuteButton_Click(object sender, RoutedEventArgs e) { string connectionString = "[extraconnectionprops]. The error was: The value of the attribute could not be accessed: The attribute does not exist.<br><b>URL</b>: /jp/kb/tech/ponparemall-ado-xamdatagrid.rst