Database Updating

[Harrild]

ok i am working on a database program i was wondering can you add a new record to a database using textboxes if so how?

[Psyrus]

Harrild,

This is using ADO.

Say you have two textboxes, txtBandName and txtSong. You also have to columns in the DB one named BandName the other Song. To insert a record you would use the following SQL string:

SQL = "INSERT INTO BANDS (BandName, Song) VALUES ('" & txtBandName & "', '" & txtSong & "')"

This would be passed to the Recordset object's open method like this:

rstBands.open SQL,DataConn

I haven't tried it using the Grid and ADO data control's RecordSource property so I'm not totally sure if you can. Maybe someone else can shed a little light on it.

[Harrild]

ok looks simple enough...i think. so thats it all i need to do is edit that for an update button (i got 7 fields to add in to one database at once)?

[Psyrus]

It's more involved than that. But that is where all the action of inserting a record happens. If you'd like I can email you some of my code from class that could get you started, well if I can find it that is. We finished up with that about a week ago and I'm still looking for the class disks.

[Harrild]

Psyrus thanks i would gladly appreciate it if you could email me the code
send it to [email protected] please.

[Psyrus]

Check your email Harrild, you should have it.

[Harrild]

yep i got it i just need SP3 now....

[Psyrus]

Sorry, I was hoping you had it. Does anyone know if you need SP3 to use components from a program(source code) written in VB6 w/SP3 in one that doesn't have it? Did you try it Harrild? Did it work or did you get an error about missing components or something?

[Harrild]

no it didnt work w/o SP3...and i cant download it either cos i aint got no hard disk space left....

[Psyrus]

I think you can open the files in Word or Notepad, not sure which, to view the source code. I've only heard/read it before, never tried it.

[Dougz999]

I think it is easier using ADO like this

once you have your open recordet - AdoRS

adors.addnew
adors.movelast

adors!band = txtBand.text
adors!song = txtSong.text

adors.update

If you are doing a group update you might be better using the begintrans commit trans method to stop data being half written.