Insert values into dataset

Posted by sudha.s on Stack Overflow See other posts from Stack Overflow or by sudha.s
Published on 2012-09-11T09:36:14Z Indexed on 2012/09/11 9:37 UTC
Read the original article Hit count: 188

Filed under:
|
|

Am using vb.net.Having dataset contain column name as phone .it contain set of phone number. i want to add 0 to each phone number and store it in another dataset.

my code
--------
cmd = New OracleCommand("select substr(PHONE,-10)as PHONE from  reports.renewal_contact_t where run_date=to_date('" + TextBox1.Text + "','mm/dd/yyyy') and  EXP_DATE =to_date('" + TextBox2.Text + "','mm/dd/yyyy') and  region not in('TNP')", cn)
                ada = New OracleDataAdapter(cmd)
                ada.Fill(ds, "reports.renewal_contact_t ")
                Dim ds1 As New DataSet
                ds1 = ds.Clone()
                For Each q In ds.Tables(0).Rows
                    phone = z + q("PHONE").ToString
                    For Each q1 In ds1.Tables(0).Rows
                        q1("PHONE") = phone
                    Next
                Next



   my problem is am not getting values in ds1.Please help me to correct it.

© Stack Overflow or respective owner

Related posts about for-loop

Related posts about dataset