Add columns and row after creating datable in C#

Question

1.00/5 (2 votes)

See more:

I have one datable consist around 25000 record

datable look like this

Id   Name   Lname   bday
1    abc    hdhd    25-02-1991
2    cnd     dhdhd  7-05-1995
3    dhdhd   ddjd   15-07-1993
4    dhhdd   ddddhd 05-09-1999

i am converting above datable after fetching record from Excel

now i want to add 2 more column plus record also column are created_by, created_date(todays date)

For e.g

Id   Name   Lname   bday         created by      created date
1    abc    hdhd    25-02-1991     rajesh           2023-06-28
2    cnd     dhdhd  7-05-1995      rajesh           2023-06-28
3    dhdhd   ddjd   15-07-1993     rajesh           2023-06-28
4    dhhdd   ddddhd 05-09-1999     rajesh           2023-06-28

can i do that without using any loop or datable column expression will do that??

What I have tried:

i google it ,i found column expression like something there but i get example of loop i dont wana use loop because there somthing 4,5 lack record

Posted 27-Jun-23 20:23pm

Akshay malvankar

Updated 27-Jun-23 20:59pm

Add a Solution

Comments

Graeme_Grant 28-Jun-23 2:30am

This is your 49th question. By now you know, no code, no help. We don't write your code for you. Update your question please.

Akshay malvankar 28-Jun-23 2:35am

hi Graeme_Grant your right but not evertime we can shared code because you know client may take action,just wana help on though can we do this or not?? otherwise thanks for your reply ,i get answer from other platform just puting above question

Graeme_Grant 28-Jun-23 3:03am

If you share code, explain why it does not work, supply full error messages, then we can look at it and point you in what we think is the right direction based on the information supplied. No code = no help. If you do not want to share client code, make a mock project to show the issue, this is not a breach of confidentiality or copyright infringement.

DO NOT waste your time and ours. You are being paid, not us, so you need to stop being lazy and make the effort. Programming is problem solving, not asking others to solve your problems. Do the work!

Richard MacCutchan 28-Jun-23 3:37am

It would take less than 5 minutes to create a mocked up code sample to demonstrate your problem. And it is highly unlikely that any client would complain if you showed a few lines of code that have absolutely no commercial value.

Graeme_Grant 28-Jun-23 3:39am

I just re-read his comment and apparently spammed multiple sites like CP and got an answer on one. Do we want to flag him as a spammer?

Richard MacCutchan 28-Jun-23 4:13am

As OriginalGriff mentions below, he is fast gaining a reputation as a Help Vampire. So I think we leave him for now and just keep watch.

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)

OriginalGriff · Answer 1 · 2023-06-27T20:59:00

This is your 49th question, pretty much all of which can be answered with a trivial google, or a little knowledge of the classes you are playing with.

In this case, it's simple to work out what you need to do by thinking about a DataTable and what it is made up of: DataRow and DataColumn elements.
Since you want to create a new column with a preset default value, you look at the DataColumn class[^]
You will find it has properties, including the DataColumn.DefaultValue Property[^] which does exactly what you think it will.

So, why waste half an hour or longer waiting for us to tell you that, when one minute of thinking on your part and a quick bit of reading would have got you what you needed?
You are showing all the signs of being a Help Vampire - and trust me, you don't want people thinking of you that way!