Bind Multiple Table LINQ to GridView Dynamically

Question

4.00/5 (1 vote)

See more:

I have two tables in my LINQ: first one is CertificateType (CID,Name,EID) and second one is Equipment(EID,EName), tables have a relation via "EID" column.
When i create a CertificateType object I can simply retrieve the related Equipment Name :

CertificateType Cert = new CertificateType();
string EName = Cert.Equipment.EName;

I made a gridview dynamically and bind it to CertificateType table , the problem is how I can bind Equipment.EName column to my grid view?

here is my GridView code which throw an exception when trying to bind Equipment.Ename :

IQueryable<CertificateType> CTList = CertificateTypeSearch();
GridView1.DataSource = CTList;
//Setting DataKeyNames
GridView1.DataKeyNames = new string[] { "CID", "Name"};
//Binding Data by creating BoundField
BoundField Name = new BoundField();
Name.DataField = "Name";
Name.HeaderText = "Name";

BoundField EquipmentName = new BoundField();
EquipmentName.DataField = "Equipment.EName";
EquipmentName.HeaderText = "Equipment Name";
GridView1.Columns.Add(Name);
GridView1.Columns.Add(EquipmentName);
GridView1.DataBind();

public static IQueryable<CertificateType> CertificateTypeSearch()
{
DataClassesDataContext context = new DataClassesDataContext();
var CertType = (from certificateType in context.CertificateTypes
select certificateType);
return CertType;
}

Posted 4-Mar-11 18:45pm

Behrang_a

Updated 4-Mar-11 19:04pm

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

dongavipul · Accepted Answer · 2011-03-04T19:38:00

Solution 1

hi,
you can do this way

XML

public static IQueryable<CertificateType> CertificateTypeSearch()
{
DataClassesDataContext context = new DataClassesDataContext();
var CertType = (from certificateType in context.CertificateTypes
select new 
{
  CID = certificateType.CID,
  Name = certificateType.Name,
  EName = certificateType.Equipment
});
return CertType;
}

Posted 4-Mar-11 19:38pm

dongavipul

Comments

Behrang_a 5-Mar-11 1:57am

the problem is CertType would not be CertficateType any more.
the error is as follow :
Error 11 Cannot implicitly convert type 'System.Linq.IQueryable<AnonymousType#4>' to 'System.Linq.IQueryable<datamanager.certificatetype>

dongavipul 5-Mar-11 2:57am

Hi,
for that you have to create one model class in that you have to take this three property say CID,Name and Ename and use this class instead of "CertificateType"

Behrang_a 12-Mar-11 23:32pm

There is no other solution, Thanks for you response