.NET (Core and Framework)

Re: Fastest way to import fixed len file into sql table

15-Mar-13 3:53

Use a bulk loader. Most database engines provide a dedicated program to do this.

I was brought up to respect my elders. I don't respect many people nowadays.

CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier

byka15-Mar-13 4:37

byka

15-Mar-13 4:37

can I call sql builk insert from .net?

Re: Fastest way to import fixed len file into sql table

Pete O'Hanlon15-Mar-13 4:43

Re: Fastest way to import fixed len file into sql table

15-Mar-13 4:43

Yes.

I was brought up to respect my elders. I don't respect many people nowadays.

CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier

Simon_Whale15-Mar-13 4:49

Simon_Whale

15-Mar-13 4:49

Have a read of this, assuming it's SQL Server

BULK INSERT (Transact-SQL)[^]

Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch

Re: Fastest way to import fixed len file into sql table

M. Eugene Andrews15-Mar-13 8:33

M. Eugene Andrews

15-Mar-13 8:33

As other responders have said, use the System.Data.SqlClient.SqlBulkCopy class.

Also, implement your own IDataReader in a class to read the file. The SqlBulkCopy contains a method called WriteToServer which has an overload that takes an IDataReader.

Once this is done, you can simply create an IDataReader using a TextReader (via the class you made) and now you can simply read a row and write the row without using a lot of memory with DataTable or DataSet objects.

Re: Fastest way to import fixed len file into sql table

AmitGajjar19-Mar-13 21:07

AmitGajjar

19-Mar-13 21:07

Hi,

You have not mention is that one time or you have text feed in one folder.

Anyway, You can create one SSIS package that can import your file data into sql server. you can schedule your SSIS package if that file is frequently updating. even you can execute package from your Code behind. you can also use bulk insert as other suggested.

Thanks
-Amit Gajjar (MinterProject)

real-time geolocation

ibrahimCA12-Mar-13 19:54

12-Mar-13 19:54

use a WCF service (WCF Application) and a PDA windows mobile 6.0 how can we draw the position marker on google maps in another project (application winforms).
Application uses winforms web browser to appear Gmap.
and implementation of WCF services hosted on an IIS server.

I have implemented the methods in the WCF service that will be called for by the PDA and returned the postion of GPS (latitude and longitude) until here everything is fine, but I do not know how to get back this position in application winforms for to draw marker

Pete O'Hanlon12-Mar-13 20:56

12-Mar-13 20:56

From your description, it sounds as though you're getting your geolocation back from the WCF service. If you are, you should realise that what you are getting is the location of the machine that hosts the service (providing it has the ability to get the geolocation) and not your PDA.

I was brought up to respect my elders. I don't respect many people nowadays.

CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier

ibrahimCA12-Mar-13 22:28

12-Mar-13 22:28

yes I can access the server that hosts the WCF service
service that contains two methods:

public double getLatitude(double latitude)
{
    return latitude;
}
public double getLongitue(double longitude)
{
    return longitude;
}

but the back office side (application winforms): I can not get the result returned by this 2 function,
for use the results returned to draw the marker on gmap (with web browser)

Pete O'Hanlon12-Mar-13 22:34

12-Mar-13 22:34

I'm confused here. You're sending a value to your WCF service and then you're retrieving the same value? What's the point of that?

I was brought up to respect my elders. I don't respect many people nowadays.

CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier

ibrahimCA12-Mar-13 22:42

12-Mar-13 22:42

Yes, I want to retrieve the same values using a marker to draw on google maps.

I can not find a way (on the application of winforms) to retrieve this same values that returned by the methods

Pete O'Hanlon12-Mar-13 23:15

12-Mar-13 23:15

Let me see if I've got your architecture straight. You have a PDA that you are using to send values to a WCF service. You have a Windows Forms application running somewhere else that you want to retrieve these same values and display them. Is this correct?

I was brought up to respect my elders. I don't respect many people nowadays.

CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier

ibrahimCA12-Mar-13 23:26

12-Mar-13 23:26

yes, winforms application is apart, it can just connect to the service

Pete O'Hanlon12-Mar-13 23:30

12-Mar-13 23:30

Then your initial premise is wrong. You can't pass a value in from one side and expect the same value to be available at the other side without doing some work. What you could do is write the value to a database at the server, and read it from there using a separate WCF call.

I was brought up to respect my elders. I don't respect many people nowadays.

CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier

ibrahimCA12-Mar-13 23:42

12-Mar-13 23:42

Thank you for your help Pete O'Hanlon

Pete O'Hanlon12-Mar-13 23:48