to add a character value to datarow in vb.net

[riyap]

hi
can anyone let me know
how to add a character value to datarow.item
for example
i wanted to add a status field value with "S" then how can i add it using vb.net
i did in many ways but its still showing value=nothing

                    drTemp1 = dlog2.NewRow
                    drTemp1.Item("status") = "'P'"
                    drTemp1.Item("errMsg") = errMsg
                    dlog2.Rows.Add(drTemp1)
 

i want to add errMsg values and Status = P
i tried with "P" and also convert.tostring("P")
but its just showing me status= nothing
Please let me know

thanks

[nateraaaa]

hi
can anyone let me know
how to add a character value to datarow.item
for example
i wanted to add a status field value with "S" then how can i add it using vb.net
i did in many ways but its still showing value=nothing

                    drTemp1 = dlog2.NewRow
                    drTemp1.Item("status") = "'P'"
                    drTemp1.Item("errMsg") = errMsg
                    dlog2.Rows.Add(drTemp1)
 

i want to add errMsg values and Status = P
i tried with "P" and also convert.tostring("P")
but its just showing me status= nothing
Please let me know

thanks

What is dlog2? Is it a datatable? To add a row column try this:

drTemp1 = dlog2.NewRow
drTemp1("status") = "'P'"
drTemp1("errMsg") = errMsg
dlog2.Rows.Add(drTemp1)

Nathan

[riyap]

What is dlog2? Is it a datatable? To add a row column try this:

drTemp1 = dlog2.NewRow
drTemp1("status") = "'P'"
drTemp1("errMsg") = errMsg
dlog2.Rows.Add(drTemp1)

Nathan

Thanks for the response
i used "P" as you said that was working but
my doubt is how to update this data table in msaccess DB using vb.net
i used
datatables dlog3 has selected values(i.select command values) and dlog2 has updated values(changed new values) so how to relate these 2 datatables and update in db table
if possible can u give me the code
its would be really helpfull

comm=select * from logtable where status="S""
da1.SelectCommand = comm
count1 = da1.Fill(dlog3)
da1.UpdateCommand = cmdBuilder.GetUpdateCommand()
  da1.Update(dlog3)
 

so to relate 2 datatables and update the vlaues