Solved

Problem populating DataGridView in VB.NET Forms App

Posted on 2009-07-14
2
514 Views
Last Modified: 2013-11-07
Hi,

I'm having trouble getting a DataGridView to populate in this simple VB.NET forms application.

I'm going through, creating the dataset, adding columns and then rows, but when I run the program, no exceptions are thrown, but my datagrid view is completely empty.

Can anyone suggest what might be wrong here?

Cheers
Imports ToDoListLibrary

Imports System.IO

Imports System.Data.SqlClient

 

 

Public Class ToDoListUI

 

    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

 

        Dim toDoItem = New ToDoItem()

 

        toDoItem.ToDoItemDoneProperty() = False

        toDoItem.ToDoItemDoneDateTimeProperty() = DateTime.Now

        toDoItem.ToDoItemDoByDateTimeProperty() = DateTime.Now

        toDoItem.ToDoItemTextProperty() = ""

        toDoItem.ToDoItemPriorityProperty() = toDoItem.ToDoItemPriorityProperty().High

 

        Dim toDoList = New ToDoList()

 

        toDoList.ToDoItemListProperty().Add(toDoItem)

 

 

        Dim ds As DataSet = New DataSet()

 

        Dim tb As DataTable = ds.Tables.Add()

 

        tb.Columns.Add("ToDoItemDone", GetType(Boolean))

        tb.Columns.Add("ToDoItemDoneDateTime", GetType(DateTime))

        tb.Columns.Add("ToDoItemDoByDateTime", GetType(DateTime))

        tb.Columns.Add("ToDoItemText", GetType(String))

        tb.Columns.Add("ToDoItemPriority", GetType(ToDoItem.ToDoItemPriority))

 

 

        For Each toDo As ToDoItem In toDoList.ToDoItemListProperty()

 

            tb.Rows.Add(toDo.ToDoItemDoneProperty, toDo.ToDoItemDoneDateTimeProperty, _

                         toDo.ToDoItemDoByDateTimeProperty, toDo.ToDoItemTextProperty, _

                         toDo.ToDoItemPriorityProperty)

        Next

 

        m_toDoListUIDataGridView.DataSource = ds.DefaultViewManager

 

    End Sub

 

 

End Class

Open in new window

form.JPG
0
Comment
Question by:Cognize
2 Comments
 
LVL 1

Accepted Solution

by:
RSBuTCHeR earned 500 total points
ID: 24847770
Hi Cognize,

Try to use this line:

m_toDoListUIDataGridView.DataSource = ds.Tables(0)

or

m_toDoListUIDataGridView.DataSource = dt

Regards,

Falcko
0
 
LVL 2

Author Closing Comment

by:Cognize
ID: 31603175
Thanks mate, thats what I needed.
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Suggested Solutions

This document covers how to connect to SQL Server and browse its contents.  It is meant for those new to Visual Studio and/or working with Microsoft SQL Server.  It is not a guide to building SQL Server database connections in your code.  This is mo…
Creating an analog clock UserControl seems fairly straight forward.  It is, after all, essentially just a circle with several lines in it!  Two common approaches for rendering an analog clock typically involve either manually calculating points with…
This video discusses moving either the default database or any database to a new volume.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now