AspdotnetCodes.com
Search
Articles
Books
Resources
Asp.Net News
Downloads
Free Tech Magazines
Asp.Net Web Hosting
Archives
Softwares
Newsletter
Suggest Us
Link to Us
Feeds Subscription
Articles
Questions & Answers
Tips & Tricks
 sample programe with code & design
Posted by Bhawana on  5/28/2010 11:33:21 PM Category: Asp.Net 2.0
Add to my favorites
Email to friend
a simple program of insert, delete, update in asp.net , connecting with oledb

thanks

Post Your Reply Post New Question

 Viewer's Reply
Insert, Update, Delete using Oledb
Answered By Moderator1 on 5/29/2010 10:04:36 PM
Hi,

Below I'm provide some sample code to use OledbCommand object. Please change the insertSQL query according to your requirement.

string insertSQL="Insert into TableName values ('"+ Value1 +"', '"+ Value2 +"')"
OleDbConnection myConnection = new OleDbConnection("YourConnectionString");
OleDbCommand myCommand = new OleDbCommand(myExecuteQuery, myConnection);
myCommand.Connection.Open();
myCommand.ExecuteNonQuery();
myConnection.Close();
 
Post Your Reply If you still have problem, post it again under this reply for better response.

 
Sponsored by
Simply SQL - Free 111 Page Preview!
Run Your Own Web Server Using Linux & Apache - Free 191 Page Preview
The Art & Science of JavaScript - Free 100 Page Preview!