Wrox Programmer Forums
Go Back   Wrox Programmer Forums > C# and C > C# 1.0 > C#
|
C# Programming questions specific to the Microsoft C# language. See also the forum Beginning Visual C# to discuss that specific Wrox book and code.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the C# section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 20th, 2004, 07:08 AM
Authorized User
 
Join Date: Mar 2004
Posts: 23
Thanks: 0
Thanked 0 Times in 0 Posts
Default load tables into database

hi,
i have a tables in dataset ( not exists in database ).
how can i load these tables from dataset into database (in sql server ) ?
i tried:
 adapter.update(dataset)
but it's doesn't work

thank

 
Old July 20th, 2004, 07:22 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 996
Thanks: 2
Thanked 11 Times in 11 Posts
Send a message via Yahoo to melvik
Default

Excuse me but u were not clear, How do u wanna update a table witch is not in DB?! did u retrieve it from other tables?!

Always:),
Hovik Melkomian.
 
Old July 20th, 2004, 08:58 AM
Authorized User
 
Join Date: Mar 2004
Posts: 23
Thanks: 0
Thanked 0 Times in 0 Posts
Default

hey
yes, i retrieved it from one database(suppose "DB1") and i made changes in data and i want to put my changes in other database as new table. i have already create the new database(this is not my problem), i'm just want to load the tables in my dataset into my new database (because i want to do queries on this new database).
i hope the explansion more clear
thanks a lot
koby

 
Old July 20th, 2004, 10:21 AM
Friend of Wrox
 
Join Date: Jul 2004
Posts: 623
Thanks: 0
Thanked 1 Time in 1 Post
Default

you should use SqlCommandBuilder just biuld one then Update your adapter.

--------------------------------------------
Mehdi
I'm waiting for your better idea.
 
Old July 20th, 2004, 12:31 PM
Friend of Wrox
 
Join Date: Jul 2004
Posts: 623
Thanks: 0
Thanked 1 Time in 1 Post
Default

but wait no..
It doesn't work!!!!
you know better than me SqlCommandbuilder just update one Table in the dataset(with INSERT,DELET,UPDATE commands)not making new table in DB
I think you Should again execute your query in your new DB but withot executing query I don'know
can anyone help us?

--------------------------------------------
Mehdi
I'm waiting for your better idea.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Load access 2003 database in memory Koeno Pro VB Databases 2 September 21st, 2008 12:27 PM
load a image from database pedrocosta24306 BOOK: Access 2003 VBA Programmer's Reference 0 January 5th, 2007 11:35 PM
load Database into program memory... sumsin C++ Programming 0 March 10th, 2005 12:57 PM
Failed to load database information r_ganesh76 Crystal Reports 4 October 7th, 2004 03:04 AM
Sql loader failing to load into multiple tables amol_mudholkar Oracle 0 August 12th, 2004 03:32 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.