Re: how to export data to sql uploaded in web - C# Discussion Boards

Re: how to export data to sql uploaded in web

fatemehsoleimani14-Jan-14 5:34

14-Jan-14 5:34

thanks guides.
i want to transfer data from local sql to server sql without connect to internet in win application
and i want transfer data in offline mode.
please help me
best regards

modified 14-Jan-14 17:53pm.

Re: how to export data to sql uploaded in web

Pete O'Hanlon14-Jan-14 5:58

Pete O'Hanlon

14-Jan-14 5:58

I'm not sure how many different ways I can say the same thing. If you want to transfer between two different servers, you have to have an active connection. It doesn't have to be a web based connection, but you do need to have a Sql connection to the remote database server, as long as that server is configured to allow you to connect directly to it.

Re: how to export data to sql uploaded in web

Dave Kreskowiak14-Jan-14 7:28

Dave Kreskowiak

14-Jan-14 7:28

OK, so if you don't have a connection between the client and the server, how are you going to get the data over there? Put it on a disk and give it to a kid with a good pair of shoes??

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Re: how to export data to sql uploaded in web

Pete O'Hanlon14-Jan-14 8:06

Pete O'Hanlon

14-Jan-14 8:06

I believe it's called "Man in a Van".

Re: how to export data to sql uploaded in web

Dave Kreskowiak14-Jan-14 11:13

Dave Kreskowiak

14-Jan-14 11:13

I was thinking of "SneakerNet" myself. Big Grin | :-D

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Re: how to export data to sql uploaded in web

Paul Conrad14-Jan-14 15:34

Paul Conrad

14-Jan-14 15:34

Carrier pigeons Poke tongue | ;-P

"I've seen more information on a frickin' sticky note!" - Dave Kreskowiak

Re: how to export data to sql uploaded in web

fatemehsoleimani14-Jan-14 11:59

fatemehsoleimani

14-Jan-14 11:59

thanks guides i am low level please give me Further explanation about transfer data from sql local to sql .
best regards

Re: how to export data to sql uploaded in web

Paul Conrad14-Jan-14 15:40

Paul Conrad

14-Jan-14 15:40

If you mean "low level" such as being a beginner, this might be a bit of a task. Assuming that the two databases contain the same schema, you would want to just copy the data tables from the local sql database to the non local data tables while not conflicting with any referential integrity. It is a pretty trivial task if it is planned out and designed carefully.

Synchronizing between databases google search...[^] might be able to shed some light for you.

Wish you the best of luck Smile | :)

"I've seen more information on a frickin' sticky note!" - Dave Kreskowiak

Re: how to export data to sql uploaded in web

fatemehsoleimani14-Jan-14 22:30

fatemehsoleimani

14-Jan-14 22:30

thanks for guides with use intelligent service in c# might transfer data from local to server in offline?
there are not methoad to transfer data in offline mode?
with in sql server directly with export data might transfer data to server in offline ?

best regards

Re: how to export data to sql uploaded in web

Pete O'Hanlon14-Jan-14 23:13

Pete O'Hanlon

14-Jan-14 23:13

How many times can we tell you this? There are NO ways to transfer the data offline other than to copy the data out to storage like a USB drive and physically carry the device to the remote computer, plug it in there, and upload it from there.

Re: how to export data to sql uploaded in web

Paul Conrad15-Jan-14 5:39

Paul Conrad

15-Jan-14 5:39

He must be a slow learner.... Now that I've read your post, I pretty much rehashed what you said too Roll eyes | :rolleyes:

"I've seen more information on a frickin' sticky note!" - Dave Kreskowiak

Re: how to export data to sql uploaded in web

Pete O'Hanlon15-Jan-14 5:42

Pete O'Hanlon

15-Jan-14 5:42

Well, I awarded your answer 5 because it clearly showed him how to transfer data.

Re: how to export data to sql uploaded in web

Paul Conrad15-Jan-14 5:50

Paul Conrad

15-Jan-14 5:50

Now, it is a matter of whether or not he could implement such a tool if he really needs to do offline transfers of data through USB or removable media. I can only imagine the fun in doing version control on the records being transferred between the databases. Time stamping the rows, dealing with locks on both ends, etc.

"I've seen more information on a frickin' sticky note!" - Dave Kreskowiak

Re: how to export data to sql uploaded in web

Paul Conrad15-Jan-14 5:38

Paul Conrad

15-Jan-14 5:38

fatemehsoleimani wrote:
there are not methoad to transfer data in offline mode

No! As Pete and Dave have said, you need a network connection of some sort to have the two computer transfer information. Now, I am the THIRD person to say this. What part of it do you not understand?

fatemehsoleimani wrote:
sql server directly with export data might transfer data to server in offline

Only way would be through a removable disc media. This would entail writing the local database data to a file, and having some application on the server read this file.

"I've seen more information on a frickin' sticky note!" - Dave Kreskowiak

Re: how to export data to sql uploaded in web

fatemehsoleimani16-Jan-14 4:26

fatemehsoleimani

16-Jan-14 4:26

thanks for guide i am understand that i dont might transfer in offline.
i am need how to transfer data bulk in file in c#?
very very thanks for guide .
i am need example code for this do.
please frther guides me.
best regards

Re: how to export data to sql uploaded in web

Prabhu S M15-Jan-14 0:48

Prabhu S M

15-Jan-14 0:48

If both your servers are accessible from the same network that you're connected from then you can use sql import/export wizard

MySQL connection [solved]

V.13-Jan-14 2:36

13-Jan-14 2:36

Does anyone know what could be wrong here:

Using Odbc to connect to a MySQL database.

Driver={MySQL ODBC 5.2 Driver};Server=[server url];Port=3306;Database=[dbname];User=[usrname];Password=[pwd];Option=3;

I checked the datasource (64 bit, the 32 bit doesn't seem to have a driver) and it looks ok. The only difference is the driver in the Data Sources says: "MySQL ODBC 5.2 Unicode Driver", but I tried that too (and the ANSI version as well).

I always receive the error:
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

I googled this, but nothing worked so far.

Additionally I tried the OleDb version with this stuff: http://dev.mysql.com/downloads/connector/net/[^], but that doesn't work either with this connection string.

(Provider=MySQL Provider;Data Source=[servername];User ID=[usrname];Password=[pwd];Initial Catalog=[dbname];) The driver is "activated".

The parameters I pass are correct and MySQL Workbench is working as well as the ODBC connection.
The code is pretty robust by know and PostgreSQL ODBC works, so I'm pretty sure it's not the code (although you never know.)

Does anyone have an idea?
thanks!

[SOLUTION]
My mistake, I was under the impression that the provider installed OleDb support, but in fact it installs an entire new provider (MySql provider). When interfaced with that it looks like it's working. $Shucks | :-\$
[\SOLUTION]

V.

(MQOTD Rules and previous Solutions )

modified 13-Jan-14 9:27am.

Re: MySQL connection [solved]

OriginalGriff13-Jan-14 6:21

OriginalGriff

13-Jan-14 6:21

Thanks for marking it solved! Thumbs Up | :thumbsup:

Never underestimate the power of stupid things in large numbers
--- Serious Sam

network printer management

iraheb12-Jan-14 0:25

iraheb

12-Jan-14 0:25

can someone help me with finding complete information about the printer that is connected to the network (number of pages printed ,number of pages copied by whom and at what time). My network setup, there is a print server ,2 network printers on the network.
I m new to programming and I need to submit this project ASAP

Re: network printer management

OriginalGriff12-Jan-14 1:47

OriginalGriff

12-Jan-14 1:47

And what have you tried? Where are you stuck?

Never underestimate the power of stupid things in large numbers
--- Serious Sam

Re: network printer management

Marco Bertschi12-Jan-14 5:14

Marco Bertschi

12-Jan-14 5:14

Google is your friend.
a quick search for
c# network printer info[^] turned up the following results to me, which should help you out well.

http://stackoverflow.com/questions/296182/how-to-get-printer-info-in-net[^]
http://stackoverflow.com/questions/2779058/c-sharp-network-printing[^]

Veni, vidi, caecus | Everything summarizes to Assembly code

import dat from excel to sql

fatemehsoleimani10-Jan-14 23:24

fatemehsoleimani

10-Jan-14 23:24

hi ,
i dont english good .i will import data from excel to c# win application and transfer data to sql. but i can't .i will import data from excel(some columnsnot all) to grid and insert bulk to sql .i am low level .please help .
best regards.

Re: import dat from excel to sql

Richard MacCutchan10-Jan-14 23:56

Richard MacCutchan

10-Jan-14 23:56

See Working with MS Excel(xls / xlsx) Using MDAC and Oledb[^] for how to import from Excel.

Veni, vidi, abiit domum

Re: import dat from excel to sql

fatemehsoleimani11-Jan-14 7:31

fatemehsoleimani

11-Jan-14 7:31

very thanks for your help i will study your link
best regards

how to display the value of id result in access database in a datagridview using c#

Member 1049158710-Jan-14 6:02

Member 10491587

10-Jan-14 6:02

i have all result that i want in access database and i will to display to user in their real values in datagridview that i will generate.. any one can give me a example to code that i must use.

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