C# Discussion Boards - CodeProject

Re: C# Register for COM Interop option

1-Sep-07 22:57

George_George wrote:
Register for COM Interop

It would, I guess, automatically create necessary type libraries and called regsvr32 also for you.

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

George_George2-Sep-07 1:51

George_George

2-Sep-07 1:51

Hi Vasudevan,

For C# managed COM, it should be mscoree.dll other than regsvr32 which is acting as the host for all COM components, right?

regards,
George

Save

Assaf821-Sep-07 17:56

Assaf82

1-Sep-07 17:56

Hello
This is the code of save data in the SQLDataBase:
con.Open();
str3 = "INSERT INTO [CreditCard].[dbo].[CreditCardInfo] ([CreditTypeID],[CreditcardNumber],[Name],[BankID],[ExpiryDate],[EntryDate],[MachineTypeID]) VALUES((" & crId & "),(" & crNum & "),('" & Name & "'),(" & bnkId & "),('" & dtm & "'),('" & now & "'),(" & mId & "))";
cmd = new SqlCommand(str3, con);
adap.SelectCommand = cmd;

Thanks in advance

Assaf

Rami Said Abd Alhalim1-Sep-07 19:58

Rami Said Abd Alhalim

1-Sep-07 19:58

hi Assaf :
what is the problem in this code?

Rami Abdalhalim

Assaf821-Sep-07 22:12

Assaf82

1-Sep-07 22:12

the problem is this line of the insert statment is always blue
the tool tip that appearis:
"operator '&' cannot be applied to operands of type 'string'and 'int'"

i don't what the problem and this not usually that i have this problem.

Thanks in advance

Assaf

Vasudevan Deepak Kumar1-Sep-07 22:53

1-Sep-07 22:53

A neater stored procedure would have been more easier to debug. Can you see the formed SQL statement in Quick Watch window in the Query Analyser? That should be easier to identify and isolate the malady.

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

Guffa1-Sep-07 23:15

Guffa

1-Sep-07 23:15

The problem is not in the SQL statement. He's using the & operator from VB in C# code...

---
single minded; short sighted; long gone;

Vasudevan Deepak Kumar1-Sep-07 23:23

1-Sep-07 23:23

Yep. Alongside with that, the vulnerability might play havoc for him in the long run. Wouldn't it?

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

Guffa1-Sep-07 23:33

Guffa

1-Sep-07 23:33

Yes, it definitely will.

But not as long as he can't even compiler the code. Smile | :)

---
single minded; short sighted; long gone;

Paul Conrad2-Sep-07 5:21

Paul Conrad

2-Sep-07 5:21

Vasudevan Deepak Kumar wrote:
A neater stored procedure would have been more easier to debug

I agree. Just have the parameters be the fields that are being updated.

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

Waiting for Thread to Join

Guffa1-Sep-07 23:14

Guffa

1-Sep-07 23:14

You can't use the & operator to concatenate strings in C#. Use the + operator.

---
single minded; short sighted; long gone;

Brad Wick1-Sep-07 15:32

Brad Wick

1-Sep-07 15:32

I have the following function, but I am trying to have the application wait until the thread completes before it moves on but the application just appears to lock. can someone tell me what I might be doing wrong?

private void UploadTicketChnges(bool WaitForThreadToFinish)
{
TicketChanges TixChanges = new TicketChanges(mysql, mysqlcmd);
TixChanges.AppEventID = AppEventID;
TixChanges.AppMemberEmail = AppMemberEmail;
TixChanges.AppMemberPassword = AppMemberPassword;
TixChanges.configAPIURL = configAPIURL;
TixChanges.configDatabaseTable = configDatabaseTable;
new Thread(new ThreadStart(TixChanges.ProcessChanges)).Start();

if (WaitForThreadToFinish)
{
// wait for all the threads to finish
Thread.CurrentThread.Join();
}
}

Luc Pattyn1-Sep-07 16:21

Luc Pattyn

1-Sep-07 16:21

Brad Wick wrote:
Thread.CurrentThread.Join();

"Thread.Join() blocks the calling thread until a thread terminates."

Confused | :confused:

you want the current thread to wait until the current thread has finished Confused | :confused:

Luc Pattyn [Forum Guidelines] [My Articles]

this weeks tips:
- make Visual display line numbers: Tools/Options/TextEditor/...
- show exceptions with ToString() to see all information
- before you ask a question here, search CodeProject, then Google

Brad Wick1-Sep-07 17:45

Brad Wick

1-Sep-07 17:45

Yes I would like the main application that calls the thread to wait until its finished. I know this is not what threading is all about, but when I call the thread for the very first time I want it to wait until its completed. The other time's it is called is inside a timer which I don't care about it waiting until it's finished.

Luc Pattyn2-Sep-07 1:02

Luc Pattyn

2-Sep-07 1:02

The only Join that makes sense is someOtherThread.Join() which makes the
current thread wait on someOtherThread.

As I said before

Thread.CurrentThread.Join() makes no sense, it makes the current<br />
thread wait until the current thread is finished, which is never since it is waiting...<br />
<br />
:) <br />
<br />
<div class="ForumSig">Luc Pattyn <a href="http://www.codeproject.com/scrapbook/ForumGuidelines.asp">[Forum Guidelines]</a> <a href="http://www.codeproject.com/script/articles/list_articles.asp?userid=648011">[My Articles]</a><br />
<br />
<hr>this weeks tips:<br />
- make Visual display line numbers: Tools/Options/TextEditor/...<br />
- show exceptions with ToString() to see all information<br />
- before you ask a question here, search CodeProject, then Google<br />
<hr></div>

Steve Hansen2-Sep-07 7:32

Steve Hansen

2-Sep-07 7:32

Thread processThread = new Thread(new ThreadStart(TixChanges.ProcessChanges));
processThread.Start();
if (WaitForThreadToFinish)
{
processThread.Join();
}

guitar tuner in C#?

DeepToot1-Sep-07 9:11

DeepToot

1-Sep-07 9:11

I was looking for some examples and couldnt find any.

Anyone know of a C# example of a guitar tuner?

I would like to build one that have the same options as the tuner

on www.get-tuned.com/guitar_tuner.php

this is a flash example shown here.

Any help or direction would be appreciated.

Steve Welborn
Software Engineer
Inrange Consulting

Christian Graus1-Sep-07 13:14

Christian Graus

1-Sep-07 13:14

I don't think C# can play a tone without using p/invoke, although I could be wrong. Playing a wav file is very easy, that may be the other way to do it.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

PIEBALDconsult1-Sep-07 13:18

PIEBALDconsult

1-Sep-07 13:18

As of .net 2 there is System.Console.Beep which can play tones.

Vasudevan Deepak Kumar1-Sep-07 22:54

1-Sep-07 22:54

PIEBALDconsult wrote:
System.Console.Beep which can play tones.

I was actually searching for something equivalent to the classic PLAY command in QBasic. Would this be matching that requirement too?

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

Paul Conrad2-Sep-07 5:23

Paul Conrad

2-Sep-07 5:23

Vasudevan Deepak Kumar wrote:
QBasic

I remember that from the old days :-> I actually still have the QuickBasic 4.5 compiler on this machine, though I haven't used it in some time Laugh | :laugh:

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

PIEBALDconsult2-Sep-07 5:46

PIEBALDconsult

2-Sep-07 5:46

Dunno, never used QBasic. Never used any BASIC on PCs, only on PDPs and VAXen.

But I do have a copy of Turbo BASIC lying around here somewhere.

Colin Angus Mackay2-Sep-07 1:00

Colin Angus Mackay

2-Sep-07 1:00

Christian Graus wrote:
I don't think C# can play a tone without using p/invoke

You required a p/invoke in .NET 1.x as my article A Simple Beep - Reminiscing about ZX Spectrum Audio[^] demonstrates. Big Grin | :-D

Upcoming FREE developer events:
* Glasgow: Agile in the Enterprise Vs. ISVs, db4o: An Embeddable Database Engine for Object-Oriented Environments, Mock Objects, SQL Server CLR Integration, Reporting Services ...

My website