1 Replies - 1128 Views - Last Post: 27 January 2013 - 12:21 PM Rate Topic: -----

#1 Blacksyntax181  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 9
  • Joined: 22-December 12

vb.net list view columns

Posted 27 January 2013 - 06:35 AM

is it possible that each column of listview in vb.net have each mysql query

column 1 = "select assets from tble where month='january';
column 2 = "select assets from tble where month='febuary';

i have a problem in monthly comparative;

i have to select the values in only one mysql column and show it in two listview column.

Is This A Good Question/Topic? 0
  • +

Replies To: vb.net list view columns

#2 Martyr2  Icon User is offline

  • Programming Theoretician
  • member icon

Reputation: 5201
  • View blog
  • Posts: 13,944
  • Joined: 18-April 07

Re: vb.net list view columns

Posted 27 January 2013 - 12:21 PM

Well you wouldn't usually have an sql query per column, you would pull all columns with one query, then read what you need into each column of the listview.

Example you would do select assets from tble and then you would put all of column 1 (january) into column 1 of the listview and then put february in column 2 etc. This is typically done by just looping over the result set you got from the database.

Perhaps if you can explain more on what you are trying to do, we can give more specific guidance. :)
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1