To show the data in the tabular format

Question

1.00/5 (1 vote)

See more:

to show the data in the tabular format that are stored in the oracle database in vb.net .I don't want to use data grid view. if it possible use list method otherwise

What I have tried:

Dim oh As New Helper.Oracle.OracleHelper
Dim str As New System.Text.StringBuilder
 Dim dt As DataTable
  Dim dr As DataRow
  Dim sql As String
dt = oh.ExecuteDataSet(sql).Tables(0)
  If dt.Rows.Count > 0 Then
      For Each dr In dt.Rows
          Str.Append(dr(0))
          Str.Append("®")
          Str.Append(dr(1))
          Str.Append("®")
          Str.Append(dr(2))
          Str.Append("®")
          Str.Append(dr(3))
          Str.Append("®")
          Str.Append(dr(4))
          Str.Append("®")
          Str.Append(dr(5))
          Str.Append("®")
          Str.Append(dr(6))
          Str.Append("®")
      Next
  end if

Posted 21-Jul-22 18:32pm

Sreedevi p krishnan

Updated 21-Jul-22 19:22pm

Add a Solution

Comments

Maciej Los 22-Jul-22 1:46am

Why to force doors wide open?

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)

OriginalGriff · Answer 1 · 2022-07-21T19:22:00

You could, but ... it'll give you a load more trouble than a DataGridView would.
You could use a multiline TextBox: put each row in an array of strings, with each column separated by TAB characters. Then set the TextBox.Lines property to teh array and it's display in a table. Sort of.
It'll work, but ... if any column contains data which is longer than the other rows data it'll "push" columns to the right sideways.
If any column data exceeds the "table" right hand edge it'll wrap to the next line.
It's a mess, and it'll be a right PITA to sort out.

Use a table-based control, and it'll all be sorted out for you: use a DataAdapter to load a DataTable direct from your DB and set the DataSource of the DataGridView to the DataTable - not only will it do all the hard work for you, it'll allow your uses to select rows, columns, or cells, sort by specific columns, justify as needed, format specific data differently, and so forth.

Why reinvent the wheel if you end up with a worse experience fro your users and a load more trouble for you?