How to write two select query in one button click event

Hi Anil

Yes.. you can use procedure as suggested by Mr. Vishal.. it will be faster than you execute a query.. or if you dont want to use procedure.. you can use multiple query as shown below.

String query = "select * from table1 ; select * from table2";

var adp= new SqlDataAdapter (query, connectionstring);

DataSet ds= mew DataSet ();

adp.Fill (ds);

// when the above query got executed... it fetch your data in 2 different tables.. i.e

var first= ds.Tables [0];

var second = ds.Tables [1];


Rest... as per your requirement.