protected void ShowData(string strFindPolicy = "") { List <Policy> Policys = _db.Policies.Include(p => p.Client).Include(p => p.TypeOfInsurance).Where(s => s.Client.FullName.Contains(strFindPolicy)).ToList(); GridViewPolicy.DataSource = Policys; GridViewPolicy.DataBind(); }
protected void JoinStatement() { sc.Open(); SqlCommand sqlQuery = new SqlCommand() { Connection = sc }; sqlQuery.CommandText = "SELECT i.FirstName, i.LastName, a.HouseNumber, a.Street, a.CityCounty, a.StateAbb, a.CountryAbb, a.Zip, h.ExteriorType, h.Alarm, " + "h.DistanceToFireStation FROM Insured i, Address a, Policy p LEFT JOIN Home h ON p.PolicyID = h.PolicyID " + "WHERE i.AddressID = a.AddressID AND i.InsuredID = p.InsuredID; "; SqlDataReader reader = sqlQuery.ExecuteReader(); GridViewPolicy.DataSource = reader; GridViewPolicy.DataBind(); reader.Close(); sc.Close(); }