Convert datatables into the entities

Question

1.00/5 (1 vote)

See more:

Hi I am new to .net and I got an internship in a company.
To complete my task I need to convert the datatable into the entity.

Can any one please give me code so that I can convert the datatable into the entity?

Posted 12-May-11 20:49pm

MURARI00

Updated 12-May-11 22:08pm

Dalek Dave

v2

Add a Solution

Comments

Dalek Dave 13-May-11 4:08am

Edited for Grammar and Readability.

2 solutions

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)

OriginalGriff · Answer 1 · 2011-05-12T20:56:00

Solution 1

If by "entity" you mean instances of the relevant class, then sorry - without knowing a lot more about the class you need to create, and the format of your datatable it is really not possible to be so specific as to give you code!

Posted 12-May-11 20:56pm

OriginalGriff

Comments

MURARI00 13-May-11 3:05am

thanks for response as u told u give me the full code as sample for converting the datatable into the particlular class object please

OriginalGriff 13-May-11 3:28am

Read my reply.
Do I know your classes? No.
Do I know your data structure? No.
So how can you expect me to know how to create one from the other?

It's like trying to forge your drivers licence, given only all the letters of the alphabet!

Dalek Dave 13-May-11 4:08am

Good point Griff.

Pratik Bhesaniya · Answer 2 · 2011-05-12T21:26:00

Try this,

You can Declare your own class with your own properties and load it's values from your Datatable like this,

C#

public class MyEnt
    {
     public string Name {get; set;}
     public string Type {get; set;}
     public LoadMyEnt(object [] array)
      {
         this.Name = array[0].ToString();
         this.Type = array[1].ToString();
      }
    }

For datatable, you could do

XML

List<MyEnt> list = new List<MyEnt>();
foreach(DataRow dr in table.Rows)
{
  MyEnt obj = new MyEnt();
obj.Load(dr.ItemArray);
list.Add(obj);
}

I hope this will help you.