How to bind a datagrid with datatable in wpf ?

Question

Hi all,

Here is my code , but its not working .

DataTable aTable = new DataTable();
            aTable.Columns.Add(new DataColumn("ProductID", typeof(int)));
            aTable.Columns.Add(new DataColumn("ProductName", typeof(string)));

            aTable.Rows.Add(12, "Lap top");
            aTable.Rows.Add(13, "bbb");
            aTable.Rows.Add(14, "ccc");

            this.DataContext = aTable;

           

---

MSDN Forum

Answer 1

Hi,

Check this links

http://www.i-programmer.info/programming/wpf-workings/620-using-the-wpf-net-40-datagrid-.html

http://stackoverflow.com/questions/2511177/how-to-bind-a-table-in-a-dataset-to-a-wpf-datagrid-in-c-sharp-and-xaml

---

PS.Shakeer Hussain

Answer 2

If this is your wpf datatable, than it goes for me.

Maybe first try it with the name of the DataGrid instead of this.

---

Success
Cor

Answer 3

Hi Amal,

you are calling this which represents current window/page, can you change it to the name of your datagrid and try again....

---

Sai Kumar K (MCP)
Blog: Sai's Stuff.
WebSite: SantoshTechnologies.
MCP ID:Microsoft Transcript.

Answer 4

Hi Amal,

you are calling this which represents current window/page, can you change it to the name of your datagrid and try again....

---

Sai,

Depends, if it is in a user control it can be an inherited datagrid, that was why I replied it so kind of cryptic, the OP is not very clear in this and also not in his code.

:-)

---

Success
Cor

Answer 5

Hi,

create a datatable Property which get your data table,

then bind the datagrid to the new property

---

{Pishkari}

Answer 6

 http://msdn.microsoft.com/en-us/library/ms750612.aspx

http://msdn.microsoft.com/en-us/library/ms743643.aspx

 

You should be using objects a collection of objects not a datatable. You

can use Linq-To-Sql or ADO.NET Entity Framework, but come away from

using datatables.

 

Although datatables are mentioned in the link above, WPF is more geared

towards using Linq-2-SQL or Entity Framework

 

http://dotnetslackers.com/articles/wpf/WPFDataBindingWithLINQ.aspx

http://msdn.microsoft.com/en-us/data/ff806174.aspx

 

Answer 7

Hi Amal E S,

DataGrid.ItemsSource = DataTableName.DefaultView();

Best regards,

---

Sheldon _Xiao[MSFT]
MSDN Community Support | Feedback to us
Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 8

If DataGrid is in a Panel (for example)

then you could use Panel.DataContext = <dataTable> and the grid would automatically use the Context of its parent control. Not sure but i think you should define the columns in this case manually.

-- greets blub

Answer 9

Hi Amal E S,
 
I am marking your issue as "Answered", if you have new findings about your issue, please let me know.

Best regards,

---

Sheldon _Xiao[MSFT]
MSDN Community Support | Feedback to us
Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.