How to Insert,Update and Delete a record into DataTable?

[Prince]

Hi All,

Can anyone tell me how to Insert,Update and Delete a record into
already existing DataTable?

Looking forward for the reply...

Thanx in advance...

Regards,
Prince

 

[Aamir]

Hi

To insert recorde you will have to create a DataRow object and append
it to the data table...

For Eg

DataRow myRow;
myRow = myDataTable.NewRow();
myRow.Columns["Col1"].Value = "Abc";
myRow.Columns["Col2"].Value = "Xyz";
myDataTable.Rows.Add(myRow);

To update datatable

myDataTable.Rows[0]["Col1"].value = "abc..."; //Thats enough;

To delete from datatable

myDataTable.Rows.RemoveAt(2);

or

myDataTable.Rows.Remove(myRow);

Hope this is helpfull

Thanx
Aamir

 

[Prince]

Hi Aamir,

Thanx for ur reply and it is useful for me...
but in the below statement
myRow.Columns["Col1"].Value = "Abc";

I think Columns is not applicable bcoz when when I keep dot
after
myRow, I am not able to see the Columns...

Looking forward for ur reply...

Regards,
Prince

 

[Aamir]

Sorry Its Item property not column... you can use index also...

myRow.Item["Col1"] = value;
or
myRow["Col1"] = value;

Regards
Aamir

 

[Prince]

Hai Aamir...


ya its working fine...

Thanx for ur immediate response...

bye...

Regards,
Prince