How to add same value for all rows in a datatable?

[veenna]

hi,

i have one datatable with some rows in it.
Now i want to add a new column to it and i want to give same id for all the rows.
i have tried using default value. but it is not working.

How to update the column value with out using loop?


Regards
Veena

[PRR]

Try this

DataTable myTable = new DataTable("Bytes");
 
            DataColumn myColumn = new DataColumn();
            myColumn.DataType = System.Type.GetType("System.String");
            myColumn.AllowDBNull = false;
            myColumn.Caption = "Name";
            myColumn.ColumnName = "Name";
            myColumn.DefaultValue = "Sun";
 
            myTable.Columns.Add(myColumn);
 
            DataRow myRow;
            for (int i = 0; i < 10; i++)
            {
                myRow = myTable.NewRow();  
                myTable.Rows.Add(myRow);
            }
 
 
            foreach (DataRow dr in myTable.Rows)
            {
                Console.WriteLine(dr[0].ToString());
            }
 
 

The default value for all rows[0] will be "Sun"

[veenna]

thank u for ur reply.

How can i do this with out using loop?

thanks
veena

[PRR]

I have used loop to create rows. You can do away with that

DataRow myRow = myTable.NewRow();  
                myTable.Rows.Add(myRow);
 
myRow = myTable.NewRow();  
                myTable.Rows.Add(myRow);
 

[veenna]

hi prr,

in my datatable rows are there already. so what i am trying to do is just add one column at the last with same value.

if i set default value and i creating new row it is working fine.but it is not adding default value for existing rows.

thanks
veena

[PRR]

Could you post some code?