Click here to Skip to main content
15,881,757 members
Articles / Desktop Programming / WPF

Data binding in WPF DataGrid control using SQL Server database

Rate me:
Please Sign up or sign in to vote.
4.84/5 (29 votes)
10 Apr 2012CPOL1 min read 351.2K   36  
In this article I will explain how to display data from a SQL Server database table in a WPF DataGrid control
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Navigation;
using System.Windows.Shapes;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;

namespace WpfApplication1
{
    /// <summary>
    /// Interaction logic for MainWindow.xaml
    /// </summary>
    public partial class MainWindow : Window
    {
        public MainWindow()
        {
            InitializeComponent();
            FillDataGrid();
        }

        private void FillDataGrid()
        {
            SqlConnection con;

            SqlDataAdapter sda;

            SqlCommand cmd;

            String CmdString = "SELECT TOP 100 * FROM Employees";
            string ConString = ConfigurationManager.ConnectionStrings["ConString"].ConnectionString;
            using (con = new SqlConnection(ConString))
            { 
                cmd=new SqlCommand(CmdString, con);
                sda=new SqlDataAdapter(cmd);
                DataSet ds=new DataSet();
                sda.Fill(ds, "Employees");
                grdEmployee.ItemsSource = ds.Tables[0].DefaultView;
            }          
        }

        private void dataGrid1_SelectedCellsChanged(object sender, SelectedCellsChangedEventArgs e)
        {
            
        }
    }
}

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Software Developer (Senior)
India India
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Comments and Discussions