How do I separate rows from one data table a put them into multiple different datagridviews? Vb.net

Question

0.00/5 (No votes)

See more:

I am trying to display a row of data from one excel form in separate boxes in a form. The way I see the solution is to place multiple datagridviews on one form and separate the rows to have 1 row of data per dgv.

Where the second dgv (dg2) displays row 4 from the datatable.

Any help would be appreciated.

What I have tried:

<pre lang="vb">Imports System.Data.OleDb

Public Class Form1
    Dim exceldata As New DataTable
    Public Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load

        Dim conn As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\Ash\Dropbox\Sac U2\s1.xlsx;Extended Properties = ""Excel 12.0 Xml;HDR=YES"""
        Dim inserts As String = "SELECT [Name], [Date], [Description (basic)], [Location], [Size] FROM [sheet1$]"
        Dim adapter As New OleDbDataAdapter(inserts, conn)

        dg1.DataSource = exceldata
        adapter.Fill(exceldata)

        Dim row4 As DataRow = exceldata.Rows(4)
        dg2.DataSource = row1

        
    End Sub

Posted 11-Oct-20 17:50pm

Member 14961724

Updated 13-Oct-20 2:51am

Add a Solution

Comments

Richard MacCutchan 12-Oct-20 4:46am

Why would you want each row in a separate DataGridView? The whole reason for using such a control is to display all rows/columns in a way that makes it easy for the user.

[no name] 12-Oct-20 13:40pm

If you go through life picking the "easiest" control for yourself (vs the user), you will get nowhere. If someone needs a "form", a grid doesn't cut it.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

CHill60 · Answer 1 · 2020-10-13T02:52:00

You haven't actually told us what the problem is, which is in the following

VB

dg2.DataSource = row1

If you go to the documentation on DataGridView.DataSource[^] you will see

Quote:
The DataGridView class supports the standard Windows Forms data-binding model. This means the data source can be of any type that implements one of the following interfaces:

- The IList interface, including one-dimensional arrays.
- The IListSource interface, such as the DataTable and DataSet classes.
- The IBindingList interface, such as the BindingList<t> class.
- The IBindingListView interface, such as the BindingSource class.

If you go to the documentation for the DataRow Class[^] you will note that it does not implement any of those interfaces which means it cannot be used as a DataSource for your DataGridView. You probably want a DataTable [^] for that.

Something like this might work (untested!)

VB

Dim tempData As New DataTable
tempData.Rows.Add(row1)
dg2.DataSource = tempData

This doesn't get away from the fact that this is bad UI design - see the comments from @Richard-MacCutchan and @Gerry-Schmitz.
It is not difficult to design a pleasing and easy-to-use form consisting of the appropriate controls and to assign the individual values in the datarow columns to those controls. Your approach smacks of laziness