将Wpf的datagrid绑定到数据库(binding datagrid for Wpf to a DB)

 我试图将WPF的DataGrid绑定到MS SQL数据库中的表。 
 
 1）首先，我创建了一个App.config文件，如下所示 
 
    <connectionStrings> 
      <add name="ConString" connectionString="Data Source=MYDataSB\SQLExpress; 
       User Id=sa;Password=gm03C3; Initial Catalog=MYDB;">
    <connectionStrings/>
 
 2）其次，我添加了一个名为grdEventLog的我的表单的数据网格 
 
      <Grid>
        <DataGrid Name="grdEventLog"/>
      </Grid>
 
 3）然后我将这段代码添加到MainWindow.xaml.cs文件中，如下所示： 
 
     using System.Data;
     using System.Data.SqlClient;
     using System.Web;

public partial class MainWindow : Window
{
    public MainWindow()
    {
        InitializeComponent();
        FillDataGrid();
    }

    private void FillDataGrid()
    {
        string ConString = ConfigurationManager.ConnectionStrings["ConString"].ConnectionString;
        string CmdString = string.Empty;
        using (SqlConnection con = new SqlConnection(ConString))
        {
            CmdString = "SELECT Server,Date,Typ,Msg FROM EventLog";
            SqlCommand cmd = new SqlCommand(CmdString, con);
            SqlDataAdapter sda = new SqlDataAdapter(cmd);
            DataTable dt = new DataTable("EventLog");
            sda.Fill(dt);
            grdEventLog.ItemsSource = dt.DefaultView;
        }
    }
 
 输入所有这些条目后，我在ConfigurationManager中出现错误，指出“名称在当前上下文中不存在” 
 
 我正在尝试添加参考cfgmgr32.dll来克服此错误。 但它没有被接受。 任何人都可以建议过来这个错误？！ 
 
 也欢迎替代WPF中的数据绑定的替代建议。 

I am trying bind a DataGrid for WPF to a table in MS SQL Database.
 
1) First I created a App.config file as followsrrr
 
    <connectionStrings> 
      <add name="ConString" connectionString="Data Source=MYDataSB\SQLExpress; 
       User Id=sa;Password=gm03C3; Initial Catalog=MYDB;">
    <connectionStrings/>
 
2) Secondly, I added a datagrid to my Form with a name grdEventLog
 
      <Grid>
        <DataGrid Name="grdEventLog"/>
      </Grid>
 
3) then I added this code to MainWindow.xaml.cs file as follows:
 
     using System.Data;
     using System.Data.SqlClient;
     using System.Web;

public partial class MainWindow : Window
{
    public MainWindow()
    {
        InitializeComponent();
        FillDataGrid();
    }

    private void FillDataGrid()
    {
        string ConString = ConfigurationManager.ConnectionStrings["ConString"].ConnectionString;
        string CmdString = string.Empty;
        using (SqlConnection con = new SqlConnection(ConString))
        {
            CmdString = "SELECT Server,Date,Typ,Msg FROM EventLog";
            SqlCommand cmd = new SqlCommand(CmdString, con);
            SqlDataAdapter sda = new SqlDataAdapter(cmd);
            DataTable dt = new DataTable("EventLog");
            sda.Fill(dt);
            grdEventLog.ItemsSource = dt.DefaultView;
        }
    }
 
After typing all these entries, I have the error at ConfigurationManager stating "The name does not exist in the current context"
 
I am trying to add reference cfgmgr32.dll to overcome this error. But it is not being accepted. Can anyone suggest to over come this error ?!
 
Alternative suggestion for approaching databinding in WPF is also welcome.

原文：https://stackoverflow.com/questions/13685026