{"id":2444,"date":"2021-10-28T06:34:59","date_gmt":"2021-10-28T06:34:59","guid":{"rendered":"https:\/\/lgildv5i97.onrocket.site\/answers\/?post_type=question&#038;p=2444"},"modified":"2021-10-28T06:35:50","modified_gmt":"2021-10-28T06:35:50","slug":"move-to-next-record-each-time-in-vb-net","status":"publish","type":"question","link":"https:\/\/computing.net\/answers\/programming\/move-to-next-record-each-time-in-vbnet\/22978.html","title":{"rendered":"Move To Next Record Each Time In Vb.Net"},"content":{"rendered":"<p>Dim i As Integer<br \/>\nDim con As New SqlConnection(&#8220;Data Source=QADCOM7026;Initial Catalog=stu_info1;Integrated Security=True&#8221;)<br \/>\ncon.Open()<br \/>\nDim adp As New SqlDataAdapter(&#8220;select * from stu_info&#8221;, con)<br \/>\nDim builder As New SqlCommandBuilder(adp)<br \/>\nDim ds As New DataSet()<br \/>\nadp.Fill(ds, &#8220;stu_info&#8221;)<\/p>\n<p>If (i &lt; ds.Tables(0).Rows.Count &#8211; 1) Then<br \/>\ni = i + 1<\/p>\n<p>textBox1.Text = ds.Tables(0).Rows(i)(&#8220;First_name&#8221;).ToString()<br \/>\ntextBox2.Text = ds.Tables(0).Rows(i)(&#8220;Last_name&#8221;).ToString()<br \/>\ntextBox3.Text = ds.Tables(0).Rows(i)(&#8220;Address&#8221;).ToString()<br \/>\ntextBox4.Text = ds.Tables(0).Rows(i)(&#8220;Phone_no&#8221;).ToString()<br \/>\ntextBox5.Text = ds.Tables(0).Rows(i)(&#8220;City&#8221;).ToString()<br \/>\nElse<br \/>\nMessageBox.Show(&#8220;this is first record&#8221;)<\/p>\n<p>End If<\/p>\n<p>this is my coding in vb.net,i want to move next record each time but it shows only one next record,kindly provide me help plz<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"iawp_total_views":3},"question-category":[55],"question_tags":[],"class_list":["post-2444","question","type-question","status-publish","hentry","question-category-programming"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question\/2444","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question"}],"about":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/types\/question"}],"author":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/comments?post=2444"}],"wp:attachment":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/media?parent=2444"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question-category?post=2444"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question_tags?post=2444"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}