List view control. Need assistance

Question

1.00/5 (1 vote)

See more:

I have type the code and it showing such kind of error:

Rs.Fields(DS, "Register") "This is the area where the error shows"

Property access must assign to the property or use its value.

Please respected seniors do something in such regards.

What I have tried:

Private Sub Button2_Click(sender As System.Object, e As System.EventArgs) Handles Button2.Click

       Dim DDR As ADODB.Recordset
       Dim DS As DataSet
       ListView1.View = View.Details
       ListView1.GridLines = True
       ConnectDatabase()
       DDR.Open("select * from Register", CON)

       Rs.Fields(DS, "Register")

       For i As Integer = 0 To DS.Tables(0).Columns.ToString.Count - 1
           ListView1.Columns.Add(DS.Tables(0).Columns(i).ColumnName.ToString())
       Next

       ListView1.Columns(0).Text = "Serial No."
       ListView1.Columns(1).Text = "Employee Name"
       ListView1.Columns(2).Text = "Father Name"
       ListView1.Columns(3).Text = "NIC No."
       ListView1.Columns(4).Text = "Tel. Phone No."
       ListView1.Columns(5).Text = "Address"
       ListView1.Columns(6).Text = "Designation"
       ListView1.Columns(7).Text = "Department"
       ListView1.Columns(8).Text = "Status"
       ListView1.Columns(9).Text = "Medical"
       ListView1.Columns(10).Text = "Graduity"
       ListView1.Columns(11).Text = "PFund"
       ListView1.Columns(12).Text = "Transport"
       ListView1.Columns(13).Text = "Employement Date"


       Dim ItemCol(100) As String

       For i As Integer = 0 To DS.Tables(0).Rows.Count - 1
           For j As Integer = 0 To DS.Tables(0).Columns.Count - 1
               ItemCol(j) = DS.Tables(0).Rows(i)(j).ToString()
           Next

           Dim livi As New ListViewItem(ItemCol)
           ListView1.Items.Add(livi)
       Next

   End Sub

Posted 3-Jan-17 0:13am

Saadbinata

Updated 3-Jan-17 1:13am

v3

Add a Solution

Comments

Andy Lanng 3-Jan-17 6:23am

What is 'Rs'?

Saadbinata 3-Jan-17 6:25am

DIM Rs As New ADODB.Recordset "Public Varialble"

Saadbinata 3-Jan-17 6:28am

Publically defined, because i use it on other places also

Richard MacCutchan 3-Jan-17 6:37am

The message is quite clear, your statement (Rs.Fields(DS, "Register")) is incomplete.

Andy Lanng 3-Jan-17 6:37am

Well the first thing I notice is that documentation for the Fields collection is piss poor :S

From what I can tell, the Fields object is a base collection of Field objects. I don't see any sort of override documented that could take in two arguments, so I'm stuck.

Then again, I am a C# senior, not VB so I may be missing something.

I could take a guess that Rs.Fields(DataSet, String) is a property selector, not just a method. If so then you'll have to find documentation specific to it's use :S

Sorry I cannot be of any further help

Saadbinata 3-Jan-17 6:43am

Actually i want to use Rs.fill(DS, "Register")
but when i typed Rs. "there is not showing any fill control in the list" so i just choose the field from the given list.

Andy Lanng 3-Jan-17 7:10am

ah - gotcha. I think I have a solution. I'll post in now...

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)

Andy Lanng · Answer 1 · 2017-01-03T01:13:00

So via the comments we found that the requirement is to populate the recordset from a given dataset. The method giving the error should never be used for this purpose, so the exact error message is not relevant to the issue.

Given this new information I was able to find this page:
convert Dataset to VB recordset[^]

Which led right back here to this article:
Simplest code to convert an ADO.NET DataTable to an ADODB.Recordset[^]

I took a quick look and it appears to be exactly what you're looking for.

NB: OP: Try to describe your intended outcome in the question next time.
Try thinking along these lines:

What I am trying to do
What I expect the outcome to be
What is the actual (unexpected?) outcome
What I have tried
Why i am stuck

Just a suggestion ^_^