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 ...