Re: Importing EXCEL to sql database - C# Discussion Boards

Re: How to add .h file(Header file) in c#

PIEBALDconsult31-Dec-10 2:19

PIEBALDconsult

31-Dec-10 2:19

Use the C preprocessor, but the code had better be valid C#.

Importing a WCF method into WP7 App becomes async and doesnt return the list.

Paul Harsent30-Dec-10 7:25

Paul Harsent

30-Dec-10 7:25

I am new to creating WCF projects as well as windows phone 7.

I created a simple method in WCF which just returns a list of an object.

public List<Sticky> GetSticky()
{
    return stickys;
}

I then used it very simply

Sticky[] test = client.GetSticky();

When I import the WCF dll via a service reference into a console app the method acts how it should. When I import the method into a Windows Phone 7 application it become an async method (not sure what this means)and doesnt return a list, it comes up void.

client.GetStickyAsync();

If anyone can help explain what is going on and help me to be a little less confused.

Thanks

Importing EXCEL to sql database

Hema Bairavan30-Dec-10 7:08

Hema Bairavan

30-Dec-10 7:08

Hi all ,

i need a help that i need to import excel to the sql database.
i saw the examples of doing the same, but the thing is that the columns in the excel will get change dynamically. So i want to do as like in SQL import and Export data doing.
It will create the table with respect to the excel (also we have option to choose our own table and map the columns).Like that i need to create the table with respect to the excel every time when i do import . What method should i use, Please help me.

Thanks in advance.

Re: Importing EXCEL to sql database

Not Active30-Dec-10 7:26

Not Active

30-Dec-10 7:26

It seems as though you want the application to be all things to all people which is sure failure.

I know the language. I've read a book. - _Madmatt

Re: Importing EXCEL to sql database

Henry Minute30-Dec-10 9:12

Henry Minute

30-Dec-10 9:12

Do you have SSIS?

If you had to look that up then you probably don't.

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

Re: Importing EXCEL to sql database

PIEBALDconsult30-Dec-10 14:20

PIEBALDconsult

30-Dec-10 14:20

Ha! I had to do that last week!

System.Data.IDataReader dr = db1.ExecuteReader
(
    "SELECT * FROM [" + args [ 2 ] + "]"
) ;

db2.CreateTable ( args [ 3 ] , dr ) ;

db2.InsertData ( args [ 3 ] , dr ) ;

I'll leave the rest as an exercise. Cool | :cool:

Re: Importing EXCEL to sql database

Hema Bairavan31-Dec-10 6:35

Hema Bairavan

31-Dec-10 6:35

Thanks piebald.. i will try this one... thanks and thank you very much for your time..

Re: Importing EXCEL to sql database

Abhinav S30-Dec-10 18:44

Abhinav S

30-Dec-10 18:44

This[^] could help you.

The funniest thing about this particular signature is that by the time you realise it doesn't say anything it's too late to stop reading it.

My latest tip/trick

Re: Importing EXCEL to sql database

RaviRanjanKr31-Dec-10 2:34

RaviRanjanKr

31-Dec-10 2:34

Navigate the Given Link
How to import MS Excel data to SQL Server[^]
Hope it will works for you.

Re: Importing EXCEL to sql database

Ravi Sant31-Dec-10 2:43

Ravi Sant

31-Dec-10 2:43

If you simply google it right way, you get many answers Smile | :)

chk this search:
http://www.google.co.in/search?q=How+to+import+MS+Excel+data+to+SQL+Server&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a[^]

Re: Importing EXCEL to sql database

Hema Bairavan31-Dec-10 6:19

Hema Bairavan

31-Dec-10 6:19

I hope i have clearly mentioned that i need to create the table dynamically with respect to the excel structure ?

tab control with flat buttons

Rafone30-Dec-10 4:19

Rafone

30-Dec-10 4:19

Is there an article describing how to keep the client area of the tabControl from resizing when using flat button apperance?

tia
Rafone

Statistics are like bikini's...
What they reveal is astonishing ...
But what they hide is vital ...

Get Time C#(read only memory) [modified]

arun_pk30-Dec-10 1:05

arun_pk

30-Dec-10 1:05

How can i get the actual time in c#
which will not get change even after we change system clock

*** application /pc were no internet connection

modified on Thursday, December 30, 2010 7:17 AM

Re: Get Time C#(read only memory)

JF201530-Dec-10 1:13

JF2015

30-Dec-10 1:13

Have a look here:

http://nickstips.wordpress.com/2010/02/12/c-get-nist-internet-time/[^]

You will need to get the time from an internet time server. Otherwise you can't be sure if the time of the local pc was changed.

Re: Get Time C#(read only memory)

arun_pk30-Dec-10 1:14

arun_pk

30-Dec-10 1:14

thanks a lot for the reply

i am sorry i for got to update that my application don't have an internet connection

Re: Get Time C#(read only memory)

JF201530-Dec-10 1:17

JF2015

30-Dec-10 1:17

If you don't have internet connection, then you won't have a chance of detecting a changed system time. At least I can't think of any reasonable way. Sorry.

Re: Get Time C#(read only memory)

Keith Barrow30-Dec-10 1:22

Keith Barrow

30-Dec-10 1:22

arun_pk wrote:

i am sorry i for got to update that my application don't have an internet connection

As far as I'm aware, your requirement is impossible: You either use the system clock, or use an external one.

If an Internet clock isn't good, you could use one of the following:
This (it works in Europe) that syncs with the atomic clock signal: http://www.lindy.co.uk/usb-precision-clock/20984.html[^]or http://www.atomicclockrugbymsf.co.uk/ntp-time-server/atomic-clock.html[^]
Or You could also sync with the clock in a connected GPS system, I think these need to be accurate

Sort of a cross between Lawrence of Arabia and Dilbert.[^]
-Or-
A Dead ringer for Kate Winslett[^]

Re: Get Time C#(read only memory)

arun_pk30-Dec-10 1:34

arun_pk

30-Dec-10 1:34

thanks for reply

i hope there should be some way other than using external clock..
coz applications like photoshop and all runs only 30 days ..
even if we change the system time

Re: Get Time C#(read only memory)

Richard MacCutchan30-Dec-10 2:21

Richard MacCutchan

30-Dec-10 2:21

Tut, tut, you are trying to break the rules. Frown | :(

Just say 'NO' to evaluated arguments for diadic functions! Ash

Re: Get Time C#(read only memory)

Keith Barrow30-Dec-10 4:37

Keith Barrow

30-Dec-10 4:37

The photoshop will store the latest system date it has run, if you wind back the clock before windows starts, my guess is you get a free copy of photoshop Smile | :)

There are a few things Photoshop possibly does to help with the problem:

It could "calls home" to get the time off a server as well where an Internet connection is present?

It might keep track of how long it has been running, to make sure it doesn't exceed the limit (e.g. 30 days continuous execution).
Some cleverer algorithm, where it keeps track of when it was used, if the current date time is before the latest used date it does something

I know I've fallen foul of point three, when doing some system date specific testing: the software thought I was spoofing the date, so it ended the license immediately.

Sort of a cross between Lawrence of Arabia and Dilbert.[^]
-Or-
A Dead ringer for Kate Winslett[^]

Re: Get Time C#(read only memory)

Pete O'Hanlon30-Dec-10 4:57

Pete O'Hanlon

30-Dec-10 4:57

They use rather more sophisticated algorithms, and detect such things as the system clock having been wound back; there are things that can be done to check to see that the time is different to what is should be.

I'm not a stalker, I just know things. Oh by the way, you're out of milk.

Forgive your enemies - it messes with their heads

My blog | My articles | MoXAML PowerToys | Onyx

Re: Get Time C#(read only memory)

Trollslayer30-Dec-10 8:35

Trollslayer

30-Dec-10 8:35

Buy the software, sounds like it will be cheaper.

Join the cool kids - Come fold with us[^]

Re: Get Time C#(read only memory)

Bernhard Hiller30-Dec-10 19:54

Bernhard Hiller

30-Dec-10 19:54

Keith Barrow wrote:
You could also sync with the clock in a connected GPS system, I think these need to be accurate

Not necessarily, see my post to the lounge (http://www.codeproject.com/Lounge.aspx?msg=3558840[^]) which shows real data proving the inaccurateness of a GPS unit clock.

Re: Get Time C#(read only memory)

Rob Philpott30-Dec-10 1:35

Rob Philpott

30-Dec-10 1:35

Well, if the clock on the PC is wrong and you have no internet connection, its going to be hard to know what the time is. Impossible perhaps. What you do have is Environment.TickCount, which is the number of very small 'ticks' (order of tens of nanoseconds I think) since start up. If you know the time is correct when you start up, you can use this and a bit of maths to keep telling the correct time even if the clock changes.

Regards,
Rob Philpott.

Re: Get Time C#(read only memory)

arun_pk30-Dec-10 2:04

arun_pk

30-Dec-10 2:04

Hello Rob

will this workout if i dont run the system regularly?

i want to implement a trial version kinda thing
for thirty days
Frown | :(

were i dont have internet Frown | :(

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