asked on

DataGridView data binding (ADO.NET 2.0)

I would like to use the results of a stored procedure to fill a datagridview. I am not using the Data Set IDE and created the Stored Procedure objects manually. I added a blank datagridview control to the form named dgPartInfo but don't know where to go from here:

Dim cmdGetPartInfo As New SqlCommand("SW_GET_PART_BASICS", dbConn) ' gets header info from part table
cmdGetPartInfo.CommandType = CommandType.StoredProcedure
cmdGetPartInfo.Parameters.AddWithValue("@PART_ID", strPartID)
Dim PartReader As SqlDataReader = cmdGetPartInfo.ExecuteReader
dgPartInfo.DataSource = PartReader

I am moving from mostly VB6 experience to .NET 2.0 so am not very familiar with the datagrid and datagrid view controls or the difference between them. All the documantation I can find only shows how to poulate a grid by dragging items from the Data Set IDE.

Thanks,

ASKER CERTIFIED SOLUTION

vadim63

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SEANWYATT

ASKER

OK but how does this data get into the datagridview control?

vadim63

DataGridView1.DataSource = categories.Tables("Categories")

Brian Crowe

the datasource for your datagridview needs to be a datatable/dataview not a datareader.

stealing from vadim's example:

dgpartinfo.datasource = categories.tables("categories")

SEANWYATT

ASKER

OK Thanks. I was trying to do it without the table defiined but now it makes sense.

I appreciate the quick response.