clear the gridview when the page load

Question

I develope simple application.. In this application output contains two gridview and two buttons.. When i click first button corresponding result show in first gridview.When i click second button result show in second gridview... That time First gridview also display.. I want to show second gridview only......... Anybody know answer reply me....
 
 
Thanks...
saravana

Answer 1

Please run bellow script .

you will get all tables information with number of rows

(you can modify this according to your requirement)

CREATE TABLE #counts
(
    table_name varchar(255),
    row_count int
)

EXEC sp_MSForEachTable @command1='INSERT #counts (table_name, row_count) SELECT ''?'', COUNT(*) FROM ?'
SELECT table_name, row_count FROM #counts ORDER BY table_name, row_count DESC
DROP TABLE #counts