Blue Theme Orange Theme Green Theme Red Theme
 
6 Months Free & No Setup Fees ASP.NET Hosting!
Home | Forums | ASP.NET 2.0 Tutorials | Web Services | How Do I...? | Class Browser | WPF Quick Starts | Advertise with Us
 | Consulting  
Submit an Article Submit a Blog 
 Jump to
Skip Navigation Links
TechnologyExpand Technology
WebsiteExpand Website
Nevron Gauge for SharePoint
Search :       Advanced Search »
Home » .NET 3.0 » How to use a DataGrid or DataGridView in a WPF application

How to use a DataGrid or DataGridView in a WPF application

In WPF 1.0, there is no grid-like control. We can host windows forms datagrid inside our WPF. Here to use the behavior of DataGrid as in ASP.NET 2.0, we use a DataGridView in .NET 3.0.

Author Rank :
Page Views : 50304
Downloads : 564
Rating :
 Rate it
Level : Intermediate
   Print Read/Post comments Post a comment  Similar Articles  
   Email to a friend  Bookmark  Author's other articles  
Download Files:
DataGridinXAMl.zip
 
 
6 Months Free & No Setup Fees ASP.NET Hosting!
Become a Sponsor
Become a Sponsor
 Tag Cloud
 Latest Jobs
More ... 
 Latest Interview Questions
More ... 

There is no grid-like control in WPF 1.0. We can host windows forms datagrid inside our WPF. Here to use the behavior of DataGrid as in ASP.NET 2.0, we use a DataGridView. We can not use this DataGrid View directly. To use this we have to add two references named as:

  1. System.Windows.Forms (Refers to the controls we are building a wrapper for)
  2. WindowsFormsIntegration (which holds the WindowsFormsHost control we'll use)

With these two references, we can now use the special WPF control called WindowsFormsHost (found in the System.Windows.Forms.Integration namespace).

Here in this article I am showing this DataGridView which is connected with database.

The window.xaml code is:

<Window x:Class="DataGridinXAMl.Window1"

    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

    xmlns:wfi="clr-namespace:System.Windows.Forms.Integration;

                                    assembly=WindowsFormsIntegration"

    xmlns:wf="clr-namespace:System.Windows.Forms;

                                    assembly=System.Windows.Forms"

    Title="DataGridinXAMl" Height="510" Width="510"

    >

  <Grid>

    <wfi:WindowsFormsHost Width="650" Height="400">

      <wf:DataGridView x:Name="gridView" />

    </wfi:WindowsFormsHost>

  </Grid>

</Window>

The Window.xaml.cs code for the application is:

using System;

using System.Collections.Generic;

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.Shapes;

using System.Data;

using System.Data.SqlClient;

 

namespace DataGridinXAMl

{

    /// <summary>

    /// Interaction logic for Window1.xaml

    /// </summary>

 

    public partial class Window1 : System.Windows.Window

    {

 

        public Window1()

        {

            InitializeComponent();

            DataTable theTable = new DataTable();                     

 

            // Setting the connection String

            String connString = @"Data Source=MCN0100; Initial Catalog=DataBaseNew ;Integrated Security=True";

 

            //Set the query

            String query = @"SELECT ID, FirstName, LastName, Department,City,Country FROM Record";

 

            // Fill the Set with the data

            using (SqlConnection conn = new SqlConnection(connString))

            {

                //Passing the query and connection String

                SqlDataAdapter da = new SqlDataAdapter(query, conn);

                da.Fill(theTable);

 

                //Making the object of DataGridView

                System.Windows.Forms.DataGridView grid = this.FindName("gridView") as System.Windows.Forms.DataGridView;

 

                //Set the source of DataGridView from where the data will come

                grid.DataSource = theTable;

                grid.Refresh();

            }

 

            // Set the Data Context

            DataContext = theTable;      

        }

    }

}

When user will run the application then all record will come in DataGridView of that table from which this DataGridView is connected.



Figure 1.

Comment Request!
Thank you for reading this post. Please post your feedback, question, or comments about this post Here.
Login to add your contents and source code to this article
 [Top] Rate this article
 
 About the author
 
Rahul Kumar Saxena
Rahul shows great interests in working with Microsoft technologies. He specializes in the implementation of DataBase & Graphics. His area of expertise includes: C#, ASP.NET,ADO.NET,Windows Forms & Web Services. He hails from background , Master's in Computer Application. With programming he loves photography, traveling and reading books.
(Talabpur*)
Looking for C# Consulting?
C# Consulting is founded in 2002 by the founders of C# Corner. Unlike a traditional consulting company, our consultants are well-known experts in .NET and many of them are MVPs, authors, and trainers. We specialize in Microsoft .NET development and utilize Agile Development and Extreme Programming practices to provide fast pace quick turnaround results. Our software development model is a mix of Agile Development, traditional SDLC, and Waterfall models.
Click here to learn more about C# Consulting.
 
Introducing MaxV - one click. infinite control. Hyper-V Hosting from MaximumASP.
Finally – a virtual platform that delivers next-generation Windows Server 2008 Hyper-V virtualization technology from a managed hosting partner you can truly depend on. Visit www.maximumasp.com/max for a FREE 30 day trial. Hurry offer ends soon. Climb aboard the MaxV platform and take advantage of High Availability, Intelligent Monitoring, Recurrent Backups, and Scalability – with no hassle or hidden fees. As a managed hosting partner focused solely on Microsoft technologies since 2000, MaximumASP is uniquely qualified to provide the superior support that our business is built on. Unparalleled expertise with Microsoft technologies lead to working directly with Microsoft as first to offer IIS 7 and SQL 2008 betas in a hosted environment; partnering in the Go Live Program for Hyper-V; and product co-launches built on WS 2008 with Hyper-V technology.
Dynamic PDF
ceTE software specializes in components for dynamic PDF generation and manipulation. The DynamicPDF™ product line allows you to dynamically generate PDF documents, merge PDF documents and new content to existing PDF documents from within your applications.
Nevron Chart for .NET 2010.1 Now Available
The leading .NET charting control now features PDF, Flash and Silverlight export, visualization of large datasets and more. Deliver true charting functionality to your BI, Scorecard, Presentation or Scientific apps. Download evaluation now.
ASP.NET 4 Hosting
Get 2 Months Free of ASP.NET Hosting for Only $4.95/month! Receive FREE MS SQL and MySQL Databases Including ASP.NET 4/3.5, MVC 3.0, Silverlight 4, Windows 2008/IIS 7.0 Plus FREE IIS 7 Modules. Host UNLIMITED ASP.NET Web Sites – Click Here!
 
 Post a Feedback, Comment, or Question about this article
Subject:
Comment:
6 Months Free & No Setup Fees ASP.NET Hosting!
Become a Sponsor
 Comments
Use of InitializeComponent by Happyarimaan On December 12, 2008
Use of InitializeComponent gives an error :"Name "InitializeComponent" is not declared." Why is it so ? However when I remove the 'Namespace' declaration the error goes away.
Reply | Email | Modify 
Set SelectedIndex dynamically from datagrid by Manu On April 25, 2009
Is there a way to dynamically set the SelectedIndex="" from a datagrid tag? I want to set it based on the last modified record.
Reply | Email | Modify 
error in this sample by meysam On January 18, 2010
hello Rahul,
i encountered an error,

"""  Cannot create instance of 'Window1' defined in assembly 'DataGridinXAMl, Version=1.0.3670.23819, Culture=neutral, PublicKeyToken=null'. Exception has been thrown by the target of an invocation.  Error in markup file 'Window1.xaml' Line 1 Position 9. """"


what is your solution???

thx
Reply | Email | Modify 

 © 2012  contents copyright of their authors. Rest everything copyright Mindcracker. All rights reserved.