how to bind a web grid to a data source

Question

Hello everyone m facing difficulty in binding my we grid in view to datasource through my controller action here is my code :

Model:

public DataContext()

: base("conn")

{

}

public DbSet<GeshaftPartner> geschaftPartner { get; set;}

View:

@{

var grid = new WebGrid(Model);

grid.GetHtml(columns:grid.Columns(grid.Column("PartnerName1","Name",canSort :true),

grid.Column("AnSchriftOrt","Ort")));

}

CONTROLLER:

public ActionResult ShowSelectedPartnerGrid_EF(string partnerID)

{

DataContext db = new DataContext();

var strQuery = "select PartnerName1,AnSchriftOrt from db.geschaftPartner =" + partnerID;

return View(strQuery.AsEnumerable());

}

The "partnerID" I am getting from another view ..based on this partnerID I want to fetch the row from my DataBase and show it in the grid

any suggestions are really appreciated.. thanx in advance

Vincent Maverick Durano · Answer

You should create a class that will house some properties that you would need in your View. public class Partner{ public int PartnerID{ get ; set ;} public string PartnerName{ get ; set ;} public string AnSchriftOrt{ get ; set ;} } then you can do something like this: public ActionResultShowSelectedPartnerGrid_EF( string partnerID) { using (DataContextdb= new DataContext()){ varresult=fromq in db.geschaftPartner whereq.PartnerID==partnerID select new Partner{ PartnerID=q.PartnerID PartnerName=q.PartnerName AnSchriftOrt=q.AnSchriftOrt } return View(result.ToList()); } } And of course there a bunch of articles that demonstrate how to bind webgrid in MVC. Just google the term bind webgrid mvc ef :)