Hi to all,
I don't know whether it is possible or not, to display table name in list view control from database.
It goes like this.
I have a tables(several) in Sql Server 2008. sometime i was asked to represent the current status of database in respect to client id (unique attribute), in order to provide this information i have to do query.
To avoid this, i designed a form wherein a user enters client id and results appear in list view with the current status from the database.
Now i m in a fix. I dont know to display the table name in list view. For ex: select [client id], min([invoice month]) as startdate, max([invoice month]) as enddate From tbl_catalogue_Tax_spend_analysis group by [client id].
so my table name is : catalogue_Tax_spend_analysis.
How do i display this name in my listview control.
Please
Thanks in advance.