Problem Inserting values into Sql server


Home : Code : Forums : Submit : Mailing List : About : Contact

A1VBCode Forums

Home

Members

Calendar

Who's On

Welcome Guest ( Login | Register )

Problem Inserting values into Sql server

Rate Topic

Display Mode

Topic Options

Author

Message

itsmystuff6

Posted 8/24/2010 4:16:19 AM

Forum Newbie

Group: Forum Members
Last Login: 8/24/2010 4:20:40 AM
Posts: 1, Visits: 2

Hi I am new to Vb6 programing.

I have two text boxes on the form. textX and TextY.the user will enter integer values in the text boxes.
I want to connect to sql server database "Temphome" and then insert values in table "coordinates".There are two int fields in the table X ,Y.

How can I do that.I can find the connection code on the internet but having problem finding a simple code which only connects
and insert these values.

thanks
ALI

ItsmyStuff

Post #29538

vb5prgrmr

Posted 8/25/2010 4:07:24 AM

Forum Guru

Group: Forum Members
Last Login: 9/4/2010 3:34:47 PM
Posts: 167, Visits: 786

Okay, for DNS Less connection string that you can use with ADO see http://www.connectionstrings.com. Also, you may want to use your friends (yahoo, google, ask, answers, bing) to search for vb6 ado tutorial and if you find anything about the ADODC (Activex Data Object Data Control) skip it and only read about the ADODB (Activex Data Object DataBase). Then you might want to use your friends to search for Insert SQL Tutorial...

Good Luck

Post #29541

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 1 (1 guest, 0 members, 0 anonymous members)

No members currently viewing this topic.

Forum Moderators: Admin, Mod, Mark, Keithuk

Permissions

All times are GMT -5:00, Time now is 2:04am