private void getall() { DataTable dt = dlbooking.Profitability(blbooking); if (dt != null && dt.Rows.Count > 0) { lblRevenue.Text = dt.Rows[0]["totalincome"].ToString(); lblCommissionamount.Text = dt.Rows[0]["AgentCommision"].ToString(); lblProfitability.Text = dt.Rows[0]["Profiability"].ToString(); } }