How to Create a Generic Class which can get the values from datatable or dataset into get set properties

Question

0.00/5 (No votes)

See more:

How to Create a generic class which can store the values in get set properties from the dataset or the data table where get set values can be accessible from any form in windows c#

string from
{
get;set;
}
string val1
{
get;set;
}
string val2
{
get;set;
}

data table is in the form of

formval val1 val2 val3 val4
form 1 0 0 0
form1 2 0 1 1
form2 1 2 0 1
form3 5 0 1 0

how do i get the data table values in the get set properties form the generic class

So that i can use this property to enable disable buttons...

Posted 8-Oct-13 3:39am

safiuddin nawaz

Updated 8-Oct-13 4:00am

v2

Add a Solution

Comments

Mart Rijkers 8-Oct-13 16:31pm

I see you edited the question. If you do so, noone that tried to answer sees the edit. You can better add a comment to get more help.

BillWoodruff 8-Oct-13 18:16pm

I can't understand your question. What do the numbers after your database entries, like "form3 5 0 1 0" refer to ?

You can create Classes at run-time in C#, and then create instances of them to use, but doing that is a very advanced use of Reflection.

MuhammadUSman1 9-Oct-13 0:57am

What you want to get from datatable?
DataRows, DataColumns, or specific field data?

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)

Mart Rijkers · Answer 1 · 2013-10-08T03:47:00

Solution 1

C#

private DataTable dataTable;

public DataTable myTable
{
  get {return dataTable;}
  set {datTable=value;}
}

Posted 8-Oct-13 3:47am

Mart Rijkers

Mart Rijkers · Answer 2 · 2013-10-08T10:43:00

Ofcourse you can fill different strings but
if you want specific values, you can create methods to do this in your class. You can set the datatable with the public object as in solution 1. After you have loaded the DataTable in the private DataTable object "dataTable" you can use this in your methods in the class.

For example:

C#

public string Value1(int FormNumber)
{
  return dataTable.Rows[FormNumber]["val1"].ToString();
}

I did NOT test this code. If you do not know the FormNumber, you can write a loop to find the form using a text description