Click here to Skip to main content
15,893,663 members
Home / Discussions / C#
   

C#

 
GeneralRe: New to C# - API Usage Pin
firat kocak30-Jun-03 10:29
firat kocak30-Jun-03 10:29 
GeneralRe: New to C# - API Usage Pin
J. Dunlap30-Jun-03 11:14
J. Dunlap30-Jun-03 11:14 
GeneralRe: New to C# - API Usage Pin
J. Dunlap30-Jun-03 11:16
J. Dunlap30-Jun-03 11:16 
GeneralRe: New to C# - API Usage Pin
firat kocak30-Jun-03 11:36
firat kocak30-Jun-03 11:36 
GeneralRe: New to C# - API Usage Pin
J. Dunlap18-Jun-03 8:12
J. Dunlap18-Jun-03 8:12 
GeneralCHANGING SYSTEM VOLUME Pin
ripsi17-Jun-03 14:03
ripsi17-Jun-03 14:03 
GeneralInsert, Update, Delete in C# to MS Access DB Pin
Khang Nguyen17-Jun-03 11:33
Khang Nguyen17-Jun-03 11:33 
GeneralRe: Insert, Update, Delete in C# to MS Access DB Pin
Dimitris Iliopoulos17-Jun-03 13:23
Dimitris Iliopoulos17-Jun-03 13:23 
To read,insert update data in an access db and in general with the oledbprovider there are 2 ways.
The easy way is to use the wizard in the visual studio when yu create a OledbDataadapter from the data tab in the toolbar, which creates a oledbdataadapter which can read data in a dataset, and after that if you change any data in the dataset, using the update method of the oledbdataadapter object you insert any new item and update any changes made in the dataset or in a specified table.This way is fast and doesn't need any special knowledge but allows only easy updates.

The second way is either to create a connection to the db and after that create some oledbCommand objects with sql syntax like

"INSERT INTO [tablename]([field1].[field2]...) VALUES([value1],[value2]...)"
to insert a new row,
"UPDATE [tablename] SET [field1]=[value1] WHERE [criteria]"
to update an existing row,
"DELETE FROM [tablename] WHERE [criteria]

and execute them directly, or create the oledbcommands and creat an oledbadapter object and set the properties updatecommand,insertcommand,deletecommand and selectcommand.This method with the oledbadapter requires the knowledge of using parameters with the commands.



GeneralRe: Insert, Update, Delete in C# to MS Access DB Pin
Khang Nguyen17-Jun-03 13:27
Khang Nguyen17-Jun-03 13:27 
Generalhi everybody Pin
jphuphilly17-Jun-03 11:27
jphuphilly17-Jun-03 11:27 
GeneralRe: hi everybody Pin
Dimitris Iliopoulos17-Jun-03 13:29
Dimitris Iliopoulos17-Jun-03 13:29 
GeneralRe: hi everybody Pin
jphuphilly18-Jun-03 3:12
jphuphilly18-Jun-03 3:12 
GeneralHelp... Pin
karthikv17-Jun-03 9:59
karthikv17-Jun-03 9:59 
GeneralRe: Help... Pin
karthikv18-Jun-03 1:51
karthikv18-Jun-03 1:51 
GeneralRe: Help... Pin
Member 43741223-Jun-03 5:14
Member 43741223-Jun-03 5:14 
GeneralHELP Pin
NiNa0317-Jun-03 7:36
NiNa0317-Jun-03 7:36 
GeneralRe: HELP Pin
Daniel Turini17-Jun-03 7:58
Daniel Turini17-Jun-03 7:58 
GeneralFourCC's Pin
nfactorial17-Jun-03 7:26
nfactorial17-Jun-03 7:26 
GeneralRe: FourCC's Pin
leppie17-Jun-03 7:45
leppie17-Jun-03 7:45 
GeneralRe: FourCC's Pin
nfactorial17-Jun-03 23:01
nfactorial17-Jun-03 23:01 
GeneralFlickering Pin
Rohde17-Jun-03 6:39
Rohde17-Jun-03 6:39 
GeneralRe: Flickering Pin
John Fisher17-Jun-03 7:31
John Fisher17-Jun-03 7:31 
GeneralWin32 API pointer question Pin
albean17-Jun-03 5:44
albean17-Jun-03 5:44 
GeneralRe: Win32 API pointer question Pin
John Fisher17-Jun-03 7:35
John Fisher17-Jun-03 7:35 
GeneralRe: Win32 API pointer question Pin
J. Dunlap17-Jun-03 8:19
J. Dunlap17-Jun-03 8:19 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.