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

Re: OpenDialogFile Issue

OriginalGriff5-Dec-11 20:47

OriginalGriff

5-Dec-11 20:47

Take away in huge chunks: problem goes away. Put back smaller chunks: problem comes back. Your bug is now in a smaller bit of code, so repeat the process until you have a manageable code size that demonstrates the problem.

I do like to be able to replicate bugs before I try to fix them... Big Grin | :-D

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

Re: OpenDialogFile Issue

BillWoodruff6-Dec-11 9:54

BillWoodruff

6-Dec-11 9:54

Got my five on this one, which I think deserves posterity via some "idiom."

My suggestion: "kill code until live: resurrect code until death."

Actually it's a technique I use quite often to isolate bugs, along with trying to reproduce the bug "outside" the original context by creating a special test-case mini-app, or replacement class, or whatever.

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

Re: OpenDialogFile Issue

SilimSayo5-Dec-11 9:14

SilimSayo

5-Dec-11 9:14

How are you implementing your pages? are you using a tab control? On which pade is the rich text box?

Drawing wave forms from Wave files

Federico Paolillo5-Dec-11 4:45

Federico Paolillo

5-Dec-11 4:45

Hello everybody, and sorry for my bad English, I'm trying to draw Wave forms from a wave file.
I know that in .Wav files data are codified by the PCM technique, and that i have 16 it for each amplitude coded.

So I came up with this code:

private void Plot()
{

    int Num = 0;

    WaveChart.Series.FindByName("WaveSerie").Points.Clear();

    Double Dx = 1 / Ws.CurrentHeader.SampleRate;

    for (int i = 0; i < Ws.CurrentBuffer.Length; i += 2)
    {

        Num = ((Ws.CurrentBuffer[i + 1] * 256) + Ws.CurrentBuffer[i]);

        //Console.WriteLine(Boh);

        WaveChart.Series.FindByName("WaveSerie").Points.AddXY(Dx * i, Num);

    }

}

It just take the 2 bytes read form the .Wav file, and merge them in order to make a 16 bit number, then It tries to draw the point obtained.

But it don't work, because I get an incorent drawing:

http://postimage.org/image/q647gboon/[^]

The correct Wave form is this [From Audacity]:

http://postimage.org/image/9bbrgrwcb/[^]

Ws is just a Class which read a .Wav file and puts in CurrentHeader the file header and in CurrentBuffer the Wave data.

Num is the number obtained by merging the 2 bytes from current buffer, it is the wave amplitude.

Where is the mistake ? Thank you, and sorry again for my English.

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 | :)

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