I want to Add a new column in datatable

Question

1.00/5 (2 votes)

See more:

My datatable is like this

Dayid Starttime EndTime
1 10:00 12:00
2 11:00 1:00
3 9:00 5:00

I want to change the column Dayid and .I want to give days instead of dayid..like 1-sunday,2-monday....like this..how can i do this..plz help me.....

Posted 4-Nov-12 23:55pm

Member 9492907

Add a Solution

5 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)

Amir Jalilifard · Answer 1 · 2012-11-05T00:20:00

Solution 1

C#

yourdatatable.Columns["Dayid"].ColumnName = "YourDesiredName";
Then get days and add as its value for your row column with foreach loop:

foreach(DataRow myRow in table.Rows)
{

    myRow[1]["YourDesiredName"] = "day";


}

Posted 5-Nov-12 0:20am

Amir Jalilifard

StackQ · Answer 2 · 2012-11-05T00:29:00

Solution 2

U can drop ur column and then add it, then insert ur day like-monday,tuesday..manually. Also there are many approaches for it-->u have to check w3schools

SQL

ALTER TABLE ur_table_name
DROP COLUMN Dayid

then add it again-->

SQL

ALTER TABLE ur_tablename
ADD Dayid varchar(10)

after that u can put monday,tuesday.....

Posted 5-Nov-12 0:29am

StackQ

Comments

Member 9492907 5-Nov-12 6:55am

I am not talking about the tables in sql..It is a datasource for a repeater...I want to check the dayid using a loop then only replace the value

StackQ 5-Nov-12 7:00am

means u want to check this column for each value of column dayid,and if there is value like (1,2,3....) then replace it (1 replace with monday,then 2 with tuesday and so on) and if there is already (monday,tuesday,3,4) then only want to replace 3 and 4 with their respective values. m i right?

Guptha Ch · Answer 3 · 2012-11-05T04:00:00

Just create an enumerator variable for days and give the index as 1 for the initial variable and cast the value from database to enum field so that it'll display the respective day name.

enum Days
{
Monday=1,
Tuesday,
Wednesday,
...
Sunday
};

Days day=new Day(5);
day contains 'Friday'

Khalid Farhan · Answer 4 · 2012-11-05T04:26:00

Solution 4

Change column name using this command sp_RENAME 'Table_Name.dayid', 'days ' , 'COLUMN'

Posted 5-Nov-12 4:26am

Khalid Farhan

surendra00 · Answer 5 · 2012-11-05T05:53:00

Solution 5

simply type in sqlserver

use databasename

alter table tablename add columnname datatype constraint

where datatype==may be int ,varchar whatever

and constraint like null or not null etc

and then check your table

Posted 5-Nov-12 5:53am

surendra00