Welcome to Tech Support Forum home to more then 136,000 problems solved. Issues have included: Spyware, Malware, Virus Issues, Windows, Microsoft, Linux, Networking, Security, Hardware, and Gaming Getting your problem solved is as easy as:
1. Registering for a free account
2. Asking your question
3. Receiving an answer

Registered members:
* Get free support
* Communicate privately with other members (PM).
* Removal of this message
* See fewer ads.
* And much more..

 



Want to know how to post a question? click here Having problems with spyware and pop-ups? First Steps
Go Back   Tech Support Forum > The IT Pro > Programming
User Name
Password
Site Map Register Donate Rules Blogs Mark Forums Read


Programming A discussion forum for programs and programming used in tech-related businesses.

Reply
 
LinkBack Thread Tools
Old 07-23-2007, 08:37 AM   #1 (permalink)
Registered User
 
Join Date: Aug 2005
Location: Ohio
Posts: 207
OS: VISTA


C# - Writeing to Access

Hi ive got a prblem I have gotten my code to read from database but i can't get it to use the INSERT * INTO comand the code i am tying is

Code:
OleDbCommand aCommand = new OleDbCommand("INSERT INTO Table2 (FirstName , LastName , Student ID , GPA) ('Joey', 'Grey', 2256, 3.4)", aConnection);
but does not work, evry thing i have found on the web is utter rubbish please help
Damion is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Reddit!
Reply With Quote
Important Information
Join the #1 Tech Support Forum Today - It's Totally Free!

TechSupportForum.com is a leading support website for your computer needs. We offer free, friendly and personalized computer support. Why pay to have your computer fixed when you can do it for free.

Join TechSupportforum.com Today - Click Here

Old 07-23-2007, 01:39 PM   #2 (permalink)
Registered User
 
Join Date: Aug 2005
Location: Ohio
Posts: 207
OS: VISTA


Re: C# - Writeing to Access

ok i got it working was missing the word VALUES

it would be like this for anyone who would like to know

Code:
OleDbCommand aCommand = new OleDbCommand("INSERT INTO Table2 VALUES ('Joey', 'Grey', 2256, 3.4)", aConnection);
Damion is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Reddit!
Reply With Quote
Reply


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off




All times are GMT -7. The time now is 04:58 AM.



Copyright 2001 - 2009, Tech Support Forum
Home Tips Plus | Outdoor Basecamp | Automotive Support Forum

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85