2 Replies - 434 Views - Last Post: 23 August 2013 - 08:09 PM Rate Topic: -----

#1 pc20912  Icon User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 58
  • Joined: 14-April 13

UPDATE - sql through Tab Pages - VB.Net

Posted 23 August 2013 - 04:51 AM

cmd.CommandText = "Select * from StuInfo where StuID ='" & SelectedID & "' order by PayDateDB desc"
cmd.Parameters.AddWithValue("@StuID ", SelectedID)
DA.SelectCommand = cmd
DA.Fill(DS)
DT = DS.Tables(0)

RecCount = DT.Rows.Count

TabControl1.TabPages.Clear()
If RecCount > 0 Then
For Each DR In DT.Rows
newPage = New TabPage
StuClassTXT = New TextBox
StuNameTXT.Text = DR("STUClassDB") ' MS-Access Field Name
newPage.Controls.Add(StuClassTXT)
StuAMTXT = New TextBox
StuAMTXT.Text = DR("StuAMTXTDB") ' MS-Access Field Name
newPage.Controls.Add(StuAMTXT)
RecCount += -1
TabControl1.TabPages.Add(newPage)
Next
Endif



When change (Edit) details any tab page,
How can I use UPDATE command to Database

Is This A Good Question/Topic? 0
  • +

Replies To: UPDATE - sql through Tab Pages - VB.Net

#2 DarenR  Icon User is offline

  • D.I.C Lover

Reputation: 461
  • View blog
  • Posts: 3,156
  • Joined: 12-January 10

Re: UPDATE - sql through Tab Pages - VB.Net

Posted 23 August 2013 - 05:00 AM

view here

http://www.fmsinc.co...date-query.html

im not a fan of access so i'll just give you the link
Was This Post Helpful? 0
  • +
  • -

#3 pc20912  Icon User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 58
  • Joined: 14-April 13

Re: UPDATE - sql through Tab Pages - VB.Net

Posted 23 August 2013 - 08:09 PM

Thanks for reply,
from that reply here says how to use UPDATE statement,
but I need how to use with Tab Pages
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1