Table Name : Table
EmpId EmpName EmpJob EmpSalary 101 Sampathv HR 24008.0000 102 John TL 22200.0000 103 Raju Accounts 23000.0000 104 Ramesh Accounts 22000.0000 105 Nash Medical 10000.0000 Total Employees:5 Total Salary:?????????? protected void btn1_Click(object sender, EventArgs e) { Strsqlcommand = "Select * from Emp;Select * from dept"; da = new SqlDataAdapter(Strsqlcommand, con); ds = new DataSet(); da.Fill(ds);
DataTable dt1 = ds.Tables[0]; if (Page.IsPostBack == ...

Go to the complete details ...