Display counted data in gridview

baijuep

SOLVED CLOSED ACTIVE ANSWERED
User: baijuep
Posted: on Jul 17, 2013 01:49 AM
Forum: Data Controls
Answer: 1
Views: 3128

In my asp.net+vb+access web there is a gridview which shows the name of company and the authorised man power state i am willing to count the held manpower from a table and display in the same gridview.

my gridview with sampel data is as under

Company Auth Held

Tata 12

Dell 11

HP 21

Opera 11

Bangour 10

my database name is WING and the table in which the data is held is PERS

i want to count number of persons in (eg Tata) company and show in front of tata company auth coloumn in my existing gridview. and same as others

the data in gridview is binded through datasource dynamically the held field is blank now. i want to display held also

ashusing...

0 9

Reply
ANSWER
User: ashusingh
Replied: on Jul 19, 2013 11:15 PM
Report

Hi,

I have modified query as per your need.

 SELECT COUNT(companyDetails.CompanyName) AS Held
	,CompanyName
	,Auth
	INTO #Results
FROM PersonDetails personDetails
INNER JOIN Table_CompanyDetails companyDetails
    ON personDetails.Company = companyDetails.CompanyName
GROUP BY companyDetails.CompanyName,CompanyName,Auth

UPDATE Authpers 
SET Held = (SELECT Held
			FROM #Results result 
			WHERE result.CompanyName = Authpers.Company)

SELECT CompanyName
	,Auth
	,Held
FROM #Results

DROP TABLE #Results

Here #Results is a temporary table to store values. After performing the task it must be deleted from schema. So use above query your problem will be solved.

Display counted data in gridview

Company

Explore

Follow us

Contact Us