Editing Info in a DataTable

[Prasun]

Hello:

How can you you edit data in a datatable? I already have the datatables
created. I want to know how i can refer to the columns in the data table and
what commands do i have for editing info in the table. I want to be able to
move the values in one column to another in the same table

Thanks
Prasun

 

[Guest]

If I understand you correctly ... To edit a value in a column in a DataTable,
follow this pattern:

int [iRowNum] = 0;
oMyDt[iRowNum]["Age"].Value = 7;

or to copy a column value form one column to another, do this:

int [iRowNum] = 0;
oMyDt[iRowNum]["FirstName"].Value = oMyDt[iRowNum]["Nickname"].Value;


-- John Papa
http://codebetter.com/blogs/john.papa

 

[Prasun]

Thank You for the help...
Will this work in VB.NET. I will try and see

Thank You
Prasun

If I understand you correctly ... To edit a value in a column in a
DataTable,
follow this pattern:

int [iRowNum] = 0;
oMyDt[iRowNum]["Age"].Value = 7;

or to copy a column value form one column to another, do this:

int [iRowNum] = 0;
oMyDt[iRowNum]["FirstName"].Value = oMyDt[iRowNum]["Nickname"].Value;


-- John Papa
http://codebetter.com/blogs/john.papa

Hello:

How can you you edit data in a datatable? I already have the datatables
created. I want to know how i can refer to the columns in the data table
and
what commands do i have for editing info in the table. I want to be able
to
move the values in one column to another in the same table

Thanks
Prasun

 

[Prasun]

Hmmm,
Ican't seem to adjust the code for VB.NET. I am a beginner. Could i get
help with the VB.NET syntax for this code

Thank You
Prasun

Thank You for the help...
Will this work in VB.NET. I will try and see

Thank You
Prasun

If I understand you correctly ... To edit a value in a column in a
DataTable,
follow this pattern:

int [iRowNum] = 0;
oMyDt[iRowNum]["Age"].Value = 7;

or to copy a column value form one column to another, do this:

int [iRowNum] = 0;
oMyDt[iRowNum]["FirstName"].Value = oMyDt[iRowNum]["Nickname"].Value;


-- John Papa
http://codebetter.com/blogs/john.papa

Hello:

How can you you edit data in a datatable? I already have the datatables
created. I want to know how i can refer to the columns in the data table
and
what commands do i have for editing info in the table. I want to be able
to
move the values in one column to another in the same table

Thanks
Prasun

 

[Guest]

Sure.

oMyDt(iRowNum)("Age") = 7

or to copy a column value form one column to another, do this:

Dim iRowNum as Int = 7
oMyDt(iRowNum)("FirstName") = oMyDt(iRowNum)("Nickname")


.... Just noticed, I had a typo in the C# code. There is no value property.
sorry ;-)


-- John Papa
http://codebetter.com/blogs/john.papa

Hmmm,
Ican't seem to adjust the code for VB.NET. I am a beginner. Could i get
help with the VB.NET syntax for this code

Thank You
Prasun

Thank You for the help...
Will this work in VB.NET. I will try and see

Thank You
Prasun

If I understand you correctly ... To edit a value in a column in a
DataTable,
follow this pattern:

int [iRowNum] = 0;
oMyDt[iRowNum]["Age"].Value = 7;

or to copy a column value form one column to another, do this:

int [iRowNum] = 0;
oMyDt[iRowNum]["FirstName"].Value = oMyDt[iRowNum]["Nickname"].Value;


-- John Papa
http://codebetter.com/blogs/john.papa

:

Hello:

How can you you edit data in a datatable? I already have the datatables
created. I want to know how i can refer to the columns in the data table
and
what commands do i have for editing info in the table. I want to be able
to
move the values in one column to another in the same table

Thanks
Prasun

 

[Prasun]

Thank You. Much appreciated

Sure.

oMyDt(iRowNum)("Age") = 7

or to copy a column value form one column to another, do this:

Dim iRowNum as Int = 7
oMyDt(iRowNum)("FirstName") = oMyDt(iRowNum)("Nickname")


... Just noticed, I had a typo in the C# code. There is no value property.
sorry ;-)


-- John Papa
http://codebetter.com/blogs/john.papa

Hmmm,
Ican't seem to adjust the code for VB.NET. I am a beginner. Could i get
help with the VB.NET syntax for this code

Thank You
Prasun

Thank You for the help...
Will this work in VB.NET. I will try and see

Thank You
Prasun

If I understand you correctly ... To edit a value in a column in a
DataTable,
follow this pattern:

int [iRowNum] = 0;
oMyDt[iRowNum]["Age"].Value = 7;

or to copy a column value form one column to another, do this:

int [iRowNum] = 0;
oMyDt[iRowNum]["FirstName"].Value = oMyDt[iRowNum]["Nickname"].Value;


-- John Papa
http://codebetter.com/blogs/john.papa

:

Hello:

How can you you edit data in a datatable? I already have the
datatables
created. I want to know how i can refer to the columns in the data
table
and
what commands do i have for editing info in the table. I want to be
able
to
move the values in one column to another in the same table

Thanks
Prasun