Importing EXCEL to sql database - C# Discussion Boards

sarang_k30-Dec-10 17:47

30-Dec-10 17:47

Hi all,

I am having one header file i.e., .h file in c++ and i want to add it to my c# windows application.

How can i do this ?

Thanks in advance.

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

Not Active30-Dec-10 17:50

Not Active

30-Dec-10 17:50

You can't. C# has no concept of a header file. You need to create a class or struct.

Please at least look at some documentation on the language before you try using it.

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

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

Bernhard Hiller30-Dec-10 19:41

Bernhard Hiller

30-Dec-10 19:41

Add a C++ project to your projects. In the C++ project, create a class implementing the header file's methods and properties, then reference that C++ project from your C# projects. That's a few steps more complicated than we would like to have it, but it is feasible.

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

DaveyM6931-Dec-10 0:05

DaveyM69

31-Dec-10 0:05

As Mark says, you can't.

You will need to recreate all the functions prototypes and constants in a C# class. Any structures that are used will also need to be recreated. You will need to make use of the contents of the System.Runtime.InteropServices[^] namespace.

You may find www.pinvoke.net[^] useful as most of the Windows things have already been done there.

Dave

Binging is like googling, it just feels dirtier.
Please take your VB.NET out of our nice case sensitive forum.
Astonish us. Be exceptional. (Pete O'Hanlon)

BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)

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

Ravi Sant31-Dec-10 0:11

Ravi Sant

31-Dec-10 0:11

You don't and can't use a header file in C#.

One of the advantages of using C# over C++ is precisely the fact that it doesn't use header files.

You can only use C++ header files indirectly in C# by referencing a C++ library,
which allows you to access anything declared as public in the header files
that were compiled into it.

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[^]

Last Visit: 31-Dec-99 18:00 Last Update: 4-May-24 5:15

Refresh

ᐊ Prev 1...2797 2798 2799 280028012802 2803 2804 2805 2806 Next ᐅ

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