How to display particular columns in datagrid view ?

Question

How to display particular columns in datagrid in silverlight?

I am connecting my SL application to WCF and EntityFramework . I adding two tables in EF. After that i inserting details into tables by using entity framework.

Employee ==> EID(PK), FirstName, LastName, Gender, Designation, DOJ

Salary ==> EID(FK), Basic, HRA, DA, NetSalary

Now i want to display selected columns only like EID, FullName, Designation, DOJ, NetSalary in DataGrid View

please reply

Kiran Kumar Talikoti · Answer

Hi VijayCheck This Query It may Help You Var Query=from t in DB.Employee Join s in DB.Salary On t.EID=s.EID select new { EmployeeId=t.EID FullName=t.FirstName+ +t.LastName Disignation=t.Disignation DOj=t.DOJ Salary=s.NetSalary } datagrid.ItemSource=Query.ToList() Mark as Accepted If It Helps You

Vijay · Answer

please give example for explicitly add columns

Sam Hobbs · Answer

For the FullName column I think you need a Complex User Control but I do not know how to do that. Other than that probably all you need to do is to turn off automatic generation of columns for the DataGridView and then add columns explicitly.

Vijay · Answer

It should not be vary...static only... want to display selected columns only like EID FullName Designation DOJ Basic NetSalary in DataGrid View from two tables. In FullName colums want to concatenate firstname and lastname.

Sam Hobbs · Answer

Will the selected columns vary or will they always be the same columns? If they vary then what determines the columns to be shown or not shown?

Kiran Kumar Talikoti · Answer

DB nothing but your Instance of Your Context Class; Class Context { public DbSet Employees {get;set;} public Dbset Salaries{get;set;} } Context DB=new Context(); Try This it may help you

Vijay · Answer

Hi Kiran Kumar Talikoti  it 's not working for me that DB.Employee please reply alternative result for that