Re: How to Import data from excel to sql server 2005 - C# Discussion Boards

Re: Drawing wave forms from Wave files

Luc Pattyn5-Dec-11 5:11

Luc Pattyn

5-Dec-11 5:11

Hi,

in C# int and short are signed, however byte is unsigned by default.
I bet you're using an unsigned byte array, in which case your two-byte to integer conversion is wrong.

A simple if(x>=0x8000) x-=0x10000; could fix it.

Smile | :)

Luc Pattyn [My Articles] Nil Volentibus Arduum

Re: Drawing wave forms from Wave files

Federico Paolillo5-Dec-11 5:28

Federico Paolillo

5-Dec-11 5:28

Oh, such a stupid error ! It works ! Thank you very much !

Re: Drawing wave forms from Wave files

Luc Pattyn5-Dec-11 6:08

Luc Pattyn

5-Dec-11 6:08

You're welcome.

Smile | :)

Luc Pattyn [My Articles] Nil Volentibus Arduum

How to Import data from excel to sql server 2005

rahul honey4-Dec-11 23:48

rahul honey

4-Dec-11 23:48

I want to import data from excel to sql server 2005. I am using C# for this purpose. I successfully exported the data of general format
to varchar. But, the problem arises while exporting the data of date type.
I have used date format in excel and want to export it in sql server 2005's datetime field.
The code that I have used is:-

SqlBulkCopy sqlBulk = new SqlBulkCopy(strConnection);
sqlBulk.DestinationTableName = "Data_Master_Inventory";
sqlBulk.ColumnMappings.Add("VendorRegistrationNo", "VendorRegistrationNo");
sqlBulk.ColumnMappings.Add("ProductCode", "ProductCode");
sqlBulk.ColumnMappings.Add("SerialNo", "SerialNo");
sqlBulk.ColumnMappings.Add("VendorProvidedSerialNo", "VendorProvidedSerialNo");
sqlBulk.ColumnMappings.Add("ModelName", "ModelName");
sqlBulk.ColumnMappings.Add("ProductCategoryCode", "ProductCategoryCode");
sqlBulk.ColumnMappings.Add("InventoryDate", "InventoryDate");
sqlBulk.WriteToServer(dReader);

Please provide me necessary solution.

Re: How to Import data from excel to sql server 2005

RavinderaG5-Dec-11 1:36

RavinderaG

5-Dec-11 1:36

Hi Rahul

U can refer these links

http://www.sqlteam.com/article/use-sqlbulkcopy-to-quickly-load-data-from-your-client-to-sql-server

http://www.codeproject.com/KB/database/SqlBulkCopy.aspx

http://www.codeproject.com/KB/database/TransferUsingSQLBulkCopy.aspx

http://stackoverflow.com/questions/2238328/sqlbulkcopy-writetoserver-example-what-am-i-doing-wrong

Thanks
Ravindra

Re: How to Import data from excel to sql server 2005

Richard MacCutchan5-Dec-11 1:58

Richard MacCutchan

5-Dec-11 1:58

Please use the appropriate editor buttons to make your links clickable.

Unrequited desire is character building. OriginalGriff
I'm sitting here giving you a standing ovation - Len Goodman

Re: How to Import data from excel to sql server 2005

#realJSOP5-Dec-11 2:29

#realJSOP

5-Dec-11 2:29

It's gonna be one of those kinds of days...

".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass." - Dale Earnhardt, 1997

Re: How to Import data from excel to sql server 2005

Richard MacCutchan5-Dec-11 2:51

Richard MacCutchan

5-Dec-11 2:51

No change there then. Wink | ;)

Unrequited desire is character building. OriginalGriff
I'm sitting here giving you a standing ovation - Len Goodman

Re: How to Import data from excel to sql server 2005

RaviRanjanKr7-Dec-11 11:51

RaviRanjanKr

7-Dec-11 11:51

hey! Please convert Url to Hyperlink! because it provide better readability and accessibility to other user.

Re: How to Import data from excel to sql server 2005

RaviRanjanKr7-Dec-11 11:49

RaviRanjanKr

7-Dec-11 11:49

Always wrap your code in "pre" tag.

How to take picture from camera(directx.capture)? (please help me)

morteza fakoor4-Dec-11 20:37

morteza fakoor

4-Dec-11 20:37

How to take picture from camera(directx.capture)? (please help me)

Re: How to take picture from camera(directx.capture)? (please help me)

OriginalGriff4-Dec-11 21:18

OriginalGriff

4-Dec-11 21:18

Don't post the same question in both Q&A and the forums - is duplicates work and annoys people.

Ideological Purity is no substitute for being able to stick your thumb down a pipe to stop the water

Re: How to take picture from camera(directx.capture)? (please help me)

#realJSOP5-Dec-11 2:49

#realJSOP

5-Dec-11 2:49

Compensated for 1-voting 'tard...

Re: How to take picture from camera(directx.capture)? (please help me)

#realJSOP5-Dec-11 12:11

#realJSOP

5-Dec-11 12:11

And then he 1-voted my post that called him a 'tard...

Some people... SHEESH!

Re: How to take picture from camera(directx.capture)? (please help me)

OriginalGriff5-Dec-11 20:48

OriginalGriff

5-Dec-11 20:48

Compensated - both of them!

Ideological Purity is no substitute for being able to stick your thumb down a pipe to stop the water

Re: How to take picture from camera(directx.capture)? (please help me)

BillWoodruff6-Dec-11 10:14

BillWoodruff

6-Dec-11 10:14

OriginalGriff wrote:
Compensated - both of them!

Can excess compensation lead to decompensation, triggering an infinitely recursive bi-cycle ?

The front-wheel that turns in my mind contemplating this has so many spokes I experience it as solid, but I know that it is not: I can't see the back wheel Smile | :)

best, Bill

"Anyone who shows me my 'blind spots' gives me the gift of sight." ... a thought from the shallows of the deeply shallow mind of ... Bill

Circumstances in which you would use Tuple in your real-world code ?

BillWoodruff4-Dec-11 14:03

BillWoodruff

4-Dec-11 14:03

Lately I have been exploring the interesting world of the Tuple object in .NET 4. I find it interesting that a Tuple's internal Items (buckets ? ... or whatever is under the hood) can take any objects of any Type, and those objects can be accessed, via the getter, then used without casting.

And, nice that Tuple exposes Sort, Equivalence/Equality, and Comparison.

Given that Tuples are, by design, immutable: I am curious under what circumstances you would choose to use Tuples.

Appreciate any thoughts, and I do realize this is a more "general" kind of question than is usually asked here, but I can't think of a more appropriate forum on CP.

thanks, Bill

"Anyone who shows me my 'blind spots' gives me the gift of sight." ... a thought from the shallows of the deeply shallow mind of ... Bill

modified 5-Dec-11 4:16am.

Re: Circumstances in which you would use Tuple in your real-world code ?

PIEBALDconsult5-Dec-11 1:54

PIEBALDconsult

5-Dec-11 1:54

Very rarely and for short periods only; for real work I write a class/struct. I think they're ridiculous.

Re: Circumstances in which you would use Tuple in your real-world code ?

#realJSOP5-Dec-11 2:32

#realJSOP

5-Dec-11 2:32

I used it in a comment once:

// I would normally use foreach for something like this, but in 
// this case I think it's more tuple than it's worth

modified 5-Dec-11 8:47am.

Re: Circumstances in which you would use Tuple in your real-world code ?

Not Active5-Dec-11 2:40

Not Active

5-Dec-11 2:40

[groan] Comments like that should be in the Lounge Laugh | :laugh:

No comment

Re: Circumstances in which you would use Tuple in your real-world code ?

#realJSOP5-Dec-11 2:48

#realJSOP

5-Dec-11 2:48

If we can't laugh at each other, who CAN we laugh at? Smile | :)

Re: Circumstances in which you would use Tuple in your real-world code ?

Not Active5-Dec-11 3:04

Not Active

5-Dec-11 3:04

John Simmons / outlaw programmer wrote:
who CAN we laugh at

Everyone else who are not us of course. Laugh | :laugh:

No comment

Re: Circumstances in which you would use Tuple in your real-world code ?

SledgeHammer015-Dec-11 10:00

SledgeHammer01

5-Dec-11 10:00

Our bosses?

Re: Circumstances in which you would use Tuple in your real-world code ?

David Skelly5-Dec-11 3:32

David Skelly

5-Dec-11 3:32

There is an article here on CP which suggests some possible uses:

C# 4 - Tuples[^]

Re: Circumstances in which you would use Tuple in your real-world code ?

BillWoodruff5-Dec-11 6:27

BillWoodruff

5-Dec-11 6:27

+5 Thanks for this link ! I am continually urging QA questioners to search CP, so this does remind me I should "practice what I preach." Smile | :)

It would interest me to know the .NET performance aspects of Tuples compared to a solution in which structs were used as the basis for a collection that was sortable, comparable, etc. Anonymous types are another possible answer, but you can't "export" them, so for me they don't belong in this hypothetical comparison.

thanks, Bill

"Anyone who shows me my 'blind spots' gives me the gift of sight." ... a thought from the shallows of the deeply shallow mind of ... Bill

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