Re: Passing Objects to threads.. - C# Discussion Boards

8-Jun-07 0:36

You are injecting the values in to the SQL command and they you are passing the same data in as parameters. Please stick with the parameters and alter your SQL String so that you are actually using the parameters that you set up.

Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
* Reading: Developer Day 5

Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton

My website

Re: Insert in Oracle

Walaza8-Jun-07 0:46

Walaza

8-Jun-07 0:46

I'm not sure I understand what you are saying. Would you please alter the code that I sent to you to reflect that what you are saying? thanx in advance for your response.

Mvelo Walaza
Jnr Developer
Telkom SA

Re: Insert in Oracle

Colin Angus Mackay8-Jun-07 0:53

Passing Objects to threads..

8-Jun-07 0:53

Walaza wrote:
string strSQL;
string insertValue= "'"+fname+"',"+"'"+lname+"',"+"'"+usrname+"',"+"'"+passwd+"',"+"'"+address+"',"+"'"+email+"',"+"'"+tester_id+"'";

strSQL = " INSERT INTO TESTER (FIRSTNAME, LASTNAME, USRNAME, PASSWD, ADDRESS, EMAIL, TESTERID) VALUES ("+insertValue+")";

This injects the values into the SQL. This is the source of a SQL Injection Attack, so you don't want to be injecting values.

Walaza wrote:
InsertCommand.Parameters.Add(":FIRSTNAME",System.Data.OracleClient.OracleType.VarChar,255);
InsertCommand.Parameters.Add(":LASTNAME",System.Data.OracleClient.OracleType.VarChar,255);
InsertCommand.Parameters.Add(":USRNAME",System.Data.OracleClient.OracleType.VarChar,255);
InsertCommand.Parameters.Add(":PASSWD",System.Data.OracleClient.OracleType.VarChar,255);
InsertCommand.Parameters.Add(":ADDRESS",System.Data.OracleClient.OracleType.VarChar,255);
InsertCommand.Parameters.Add(":EMAIL",System.Data.OracleClient.OracleType.VarChar,255);
InsertCommand.Parameters.Add(":TESTERID",System.Data.OracleClient.OracleType.VarChar,255);

What you want to do is alter the SQL String you've set up so that it doesn't inject values into the string.

So... Change insertValues to be a string that contains the parameter names rather than injecting the actual values. So it reads something like this:

string insertValue= ":FIRSTNAME, :LASTNAME, :USRNAME, :PASSWD, :ADDRESS, "+
                    ":EMAIL, :TESTERID";

Eytukan8-Jun-07 0:20

Eytukan

8-Jun-07 0:20

How do I pass objects to threads? VS2005 let me say, t.start((object)obj); but VS2003 (1.1) doesnt. Why? How do I do that in .net 1.1?

Press: 1500 to 2,200 messages in just 6 days? How's that possible sir?
Dr.Brad :Well,I just replied to everything Graus did and then argued with Negus for a bit.

Manas Bhardwaj8-Jun-07 0:24

Manas Bhardwaj

8-Jun-07 0:24

You can use the static variables for this.

Colin Angus Mackay8-Jun-07 0:34

8-Jun-07 0:34

And if you have multiple threads starting at once?

Manas Bhardwaj8-Jun-07 0:50

Manas Bhardwaj

8-Jun-07 0:50

Didnt get you Confused | :confused:

How can you have threads starting at once?

Colin Angus Mackay8-Jun-07 0:55

8-Jun-07 0:55

In a multithreaded environment you can have mulitple things happening at the same time, especially in a multicore or multiprocessor environment.

So, how does your solution work if you want to start several threads at the same time?

Manas Bhardwaj8-Jun-07 1:03

Manas Bhardwaj

8-Jun-07 1:03

In .Net 1.1 the ThreadStart never takes a parameter, so you the method which is called on a new thread will have to access the object stored some where else. But keep in mind to make thread safe.
Though this is now possible in 2.0 using Annonymous Methods.
Hope, it is clear now

AikinX8-Jun-07 0:55

AikinX

8-Jun-07 0:55

If threads need different parameters we can name each thread (or group of) and use static hash table (dictionary) to store the parameters.

P.S. I think it is good way to solve this. But I have never worked with FW 1.1. May be it has a different recommended solution

convert this cyrillic output from the console app to unicode [modified]

andre_swnpl8-Jun-07 1:37

andre_swnpl

8-Jun-07 1:37

you could do this:

create a class that will execute on the thread.

public class ThreadObj
{
private int t1;
private string t2;

public int T1
{
get
{
return t1;
}
set
{
t1 = value;
}
}

public string T2
{
get
{
return t2;
}
set
{
t2 = value;
}
}

public void MyThreadMethod()
{
string t = t2;
}
}

then call this with :

ThreadObj o = new ThreadObj();
o.T2 = "Hello";
o.T1 = 1;

System.Threading.ThreadStart ts = new System.Threading.ThreadStart(o.MyThreadMethod);

System.Threading.Thread tr = new System.Threading.Thread(ts);
tr.Start();

drweb868-Jun-07 0:00

drweb86

8-Jun-07 0:00

Hello friends!

I was programming redirection of output from console process(C# .Net 2.0), but when i'm outputing it on form it outputs illegal characters(cyrillic characters).

Could you help me how to convert this cyrillic output from the console app to unicode?

Thanks.

-- modified at 6:15 Friday 8th June, 2007

Re: convert this cyrillic output from the console app to unicode

PandemoniumPasha8-Jun-07 0:17

8-Jun-07 0:17

hi,

did you try System.Text.UnicodeEncoding... or System.Text.Encoding.Unicode....

hope that helps

regards
Smile | :)

GEneric List

Tauseef A7-Jun-07 23:55

Tauseef A

7-Jun-07 23:55

Hello guys

in dot net 2.0 we have generic list in system.collection.generic ,

but not in dot net 1.1 , so how can we achieve that functionaly in dot net 1.1 , is there any way ?

thanks in advance

hello

Re: GEneric List

blackjack21508-Jun-07 0:07

8-Jun-07 0:07

I think not. Generics have been introduced to C# with version 2.0 of the language.

Re: GEneric List

Christian Graus8-Jun-07 0:32

Christian Graus

8-Jun-07 0:32

You write a class that contains an ArrayList and offers typesafe methods to add and remove items from the list.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"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 )

Re: GEneric List

leppie8-Jun-07 1:25

leppie

8-Jun-07 1:25

Use the C++ preprocessor :p

xacc.ide-0.2.0.57 - now with C# 2.0 parser and seamless VS2005 solution support!

VSTO Outlook AddIn in C#

NK0077-Jun-07 23:53

NK007

7-Jun-07 23:53

Hi,

I have created an Outlook AddIn in C#. After installing successfully it on client machine I am getting an error while loading it in Outlook 2007. "Not Loaded. A runtime eror occurred while loading". I am using .Net 2.0, Visual Studio 2005, MS Office 2007 and VSTO2005 SE. Even I tried to set and reset project property "Trust Assembly Location". But same problem.

Please reply as soon as possible.

Thanks & Regards

Read Registry Key

blackjack21507-Jun-07 23:47

7-Jun-07 23:47

Hi.
I want to find out the path to the AcrobatReader executable file in case it is installed on the local computer.
For this I must search the registry.

What key should I look for?

I saw with regedit.exe that \HKEY_CLASSES_ROOT\acrobat\DefaultIcon has the exact value I need(path to acrord32.exe). But is this right?

object obj =                Microsoft.Win32.Registry.ClassesRoot.OpenSubKey("acrobat").OpenSubKey("DefaultIcon").GetValue(""); <br />
            return obj.ToString();

The above code works, but I don't know that this is the proper way to do it.
What other keys would be indicated?
Note: I must not rely on the fact that AcrobatReader is the default program associated with pdf files, so searching for the default program associated with pdf is rulled out.
Thank you.

PandemoniumPasha7-Jun-07 23:55

7-Jun-07 23:55

hi
if you look for [HKEY_LOCAL_MACHINE\SOFTWARE\Adobe\Acrobat Reader] and it does not return a null value then you have the software installed. then you can open sub-keys to check the version and the location of the exe file.

hope this helps
regards Smile | :)

blackjack21508-Jun-07 0:05

8-Jun-07 0:05

Thanks.
But this approach has some issues:
* Nowhere in it's subkeys have I found a reference to the actual exe file, just to the install folder. Have you?
* More importantly, I see that the subkey structure depends on the version of AcrobatReader installed on the machine

Anyway, if I don't find anything better I'll go for a combination of the two solutions.

PandemoniumPasha8-Jun-07 0:31

8-Jun-07 0:31

hi again

i did found the location from the key - 'InstallPath' and the executable file from the key - 'Language\next'

as for the subkey structure, it depends on the version, but a little research will solve that as well.

i have versions 8 and 5 in my machine and their subkeys are:
v8 - HKEY_LOCAL_MACHINE\SOFTWARE\Adobe\Acrobat Reader\
v5 - HKEY_LOCAL_MACHINE\SOFTWARE\Adobe\Adobe Acrobat\

hope this helps
regards
Smile | :)

blackjack21508-Jun-07 0:40

8-Jun-07 0:40

Thanks again.
Could you please share the full name of the InstallPath key for your versions?

I have version 7 and mine is:
HKEY_LOCAL_MACHINE\SOFTWARE\Adobe\Acrobat Reader\7.0\InstallPath

PandemoniumPasha8-Jun-07 0:55