Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

select colname, count(*) from datatable ..... help

Status
Not open for further replies.

SidTheSquid

Programmer
Sep 25, 2002
34
CA
Hi, I have a myDataSet that has a dataTable tableSource. Its data from a web traffic log broken up in their repective columns.

I would like to create a vb.net function that takes in paramenters [columnName as string, tableSource as dataTable]
and returns a dataTable (or view). Its functionality would be equivalent to

"select columnName, count(*) from tableSource group by columnName"

In the end, I would like something like

ColumnName Count
IE6 345
IE5 35
Netscape 765
etc

I have no clue how to do this using dataview's filter, so any help you can give is super appreciated.
Thanks
Sid.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top