C#

public ViewResult Index()
        {
            var carCostLinq = from e in db.Cars
                        join q in db.Costs  on e.CarId equals q.CarId
                        select new {Car = e, Cost = q};


           return View(carCostLinq.ToList());
                   }

namespace LounasAuto.Models
{
    using System;
    using System.Collections.Generic;
    
    public partial class Car
    {
        public Car()
        {
            this.Locations = new HashSet<Location>();
        }
    
        public int CarId { get; set; }
        public string Plate { get; set; }
        public string ModelDesc { get; set; }
        public string Description { get; set; }
        public int Year { get; set; }
        public string Color { get; set; }
        public string Photo { get; set; }
    
        public virtual ICollection<Location> Locations { get; set; }
        public virtual Cost Cost { get; set; }
    }
}

namespace LounasAuto.Models
{
    using System;
    using System.Collections.Generic;
    
    public partial class Cost
    {
        public int CarId { get; set; }
        public decimal DailyCost { get; set; }
    
        public virtual Car Car { get; set; }
    }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace LounasAuto.Models
{
    public class  CarCost
    {
         
     
        public Car car { get; set; }
        public Cost cost { get; set; }

       
    }
}

@{
    ViewBag.Title = "Index";
}

<h2>Index -- partial _CarList </h2>
 
@Html.Partial("_CarList")

@model IEnumerable<LounasAuto.Models.CarCost>
@using System.Linq

<table>
    <tr>
        <th>
            Plate
        </th>
        <th>
            ModelDesc
        </th>
        <th>
            Description
        </th>
        <th>
            Year
        </th>
        <th>
            Color
        </th>
        <th>
            Photo
        </th>
        <th></th>
    </tr>



@foreach (var item in Model)
{
    <tr>
        <td>
            @Html.DisplayFor(modelItem => item.car.Plate)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.car.ModelDesc)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.car.Description)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.car.Year)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.car.Color)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.car.Photo)
        </td>

        <td>
            @Html.ActionLink("Edit", "Edit", new { id = item.car.CarId }) |
            @Html.ActionLink("Details", "Details", new { id = item.car.CarId }) |
            @Html.ActionLink("Delete", "Delete", new { id = item.car.CarId }) ||

           
              @Html.ActionLink("Cost", "Cost", new { id = item.cost.CarId,
                                                     plate = item.car.Plate,
                                                     modelDesc = item.car.ModelDesc,
                                                     description = item.car.Description,
                                                     year = item.car.Year,
                                                     color = item.car.Color,
                                                     all = item.car.Plate + "\n" + item.car.ModelDesc + "\n" + item.car.Description + "\n" + item.car.Year + "\n" + item.car.Color
         })
                     
        </td>
    </tr>
}




</table>
<p>
    @Html.ActionLink("Create New", "Create")
</p>

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.Sql;
using System.Data.SqlClient;
using System.Configuration;
using System.Data;

namespace StaffingWebParts.KeyPerTest
{
    public partial class KeyPerTestUserControl : UserControl
    {
        SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["SQLStaffingConn"].ConnectionString);
        SqlCommand cmd = new SqlCommand();
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            {
                DataTable dt = new DataTable();
                

                dt.Columns.Add("Name");
                dt.Columns.Add("VDCIDIQ");
                dt.Columns.Add("VDCFFS");
                dt.Columns.Add("VDCHIM");
                dt.Columns.Add("VDCWEBHOSTING");
                dt.Columns.Add("VDCCWF");
                SqlDataReader myReader = null;
                SqlCommand cmd = new SqlCommand("SELECT distinct  Name, VDCIDIQ , VDCFFS, VDCHIM, VDCWEBHOSTING, VDCCWF  from CMS_Key_Personnel where Name <> '   ' order by  Name");
                cmd.Connection = conn;
                conn.Open();
                myReader = cmd.ExecuteReader();
                while (myReader.Read())
                {
                    DataRow dr = dt.NewRow();
                    dr[0] = myReader["Name"].ToString();
                    dr[1] = myReader["VDCIDIQ"].ToString();
                    dr[2] = myReader["VDCFFS"].ToString();
                    dr[3] = myReader["VDCHIM"].ToString();
                    dr[4] = myReader["VDCWEBHOSTING"].ToString();
                    dr[5] = myReader["VDCCWF"].ToString();
                    dt.Rows.Add(dr);
                }
                
                gvKeyPersonnel.DataSource = dt;
                gvKeyPersonnel.DataBind();
                conn.Close();
            }
        }

       protected void Button_Update(object sender, EventArgs e)
        
       {
         using(SqlCommand cmd = new SqlCommand())
        {
                     
          cmd.Connection = conn;
          conn.Open();
          cmd.CommandText = "UPDATE SP2010_EDCStaffing_AppDB.dbo.CMS_Key_Personnel  SET  Name = @Name  WHERE ID = @id";
          cmd.Parameters.Add("@Name", SqlDbType.NVarChar, 75);



          cmd.Parameters.Add("@id", SqlDbType.Int).Value = id;
          
          
          cmd.ExecuteNonQuery();
          conn.Close();
        }
        }
        }
        }