Insert in Oracle - C# Discussion Boards

Re: getting substring from a string

Ankit Aneja8-Jun-07 2:33

Ankit Aneja

8-Jun-07 2:33

its still giving index was outside the bounds of array

Ankit Aneja
"Nothing is impossible. The word itself says - I M possible"

Re: getting substring from a string

Manas Bhardwaj8-Jun-07 2:39

Manas Bhardwaj

8-Jun-07 2:39

Can you post your code here?
Also provide the string which you using

Re: getting substring from a string

Ankit Aneja8-Jun-07 2:48

Ankit Aneja

8-Jun-07 2:48

try
{
String fixString = newLine;
string[] fixArray = fixString.Split(Convert.ToChar(1));
//I used 1 because FIX message uses this as delimiter...
Hashtable fixTable = new Hashtable();
string[] fieldArray = null;
for (int fieldCount = 1; fieldCount < fixArray.Length; fieldCount++)
{
fieldArray = fixArray[fieldCount].Split('=');
fixTable.Add(fieldArray[0].ToString(), fieldArray[1].ToString());
}
string firstTagString = fixTable["100"].ToString();

}
catch(Exception ex)
{
String x=ex.ToString();
}

"M|2696|0|D|I|20070604-19:31:25.177|255|8=FIX.4.29=23235=D34=269649=Qa-QTIP-Sim-A56=Qa-QTIP-Sim-A-Internal52=20070604-23:31:2540=1MDSNAPID=6071=511=Q8BO7023-121=4955=QQQQ59=05011=12463/2007-06-04-07:3138=100109=RajTest5012=Raj9040=NSTRATEGY=PassThru54=147=A100=ARCA10=169|0|\r"

Ankit Aneja
"Nothing is impossible. The word itself says - I M possible"

Re: getting substring from a string

Manas Bhardwaj8-Jun-07 3:00

Manas Bhardwaj

8-Jun-07 3:00

Here it is:

try<br />
            {<br />
                string newLine = "M|2696|0|D|I|20070604-19:31:25.177|255|8=FIX.4.29=23235=D34=269649=Qa-QTIP-Sim-A56=Qa-QTIP-Sim-A-Internal52=20070604-23:31:2540=1MDSNAPID=6071=511=Q8BO7023-121=4955=QQQQ59=05011=12463/2007-06-04-07:3138=100109=RajTest5012=Raj9040=NSTRATEGY=PassThru54=147=A100=ARCA10=169|0|\r";<br />
                String fixString = newLine;<br />
                string[] fixArray = fixString.Split(Convert.ToChar(1));<br />
                //I used 1 because FIX message uses this as delimiter...<br />
                Hashtable fixTable = new Hashtable();<br />
                string[] fieldArray = null;<br />
                try<br />
                {<br />
                    for (int fieldCount = 0; fieldCount < fixArray.Length; fieldCount++)<br />
                    {<br />
                        fieldArray = fixArray[fieldCount].Split('=');<br />
                        fixTable.Add(fieldArray[0].ToString(), fieldArray[1].ToString());<br />
                    }<br />
                }<br />
                catch<br />
                {      <br />
                  <br />
                }<br />
                string firstTagString = fixTable["100"].ToString();<br />
                MessageBox.Show(firstTagString);<br />
<br />
            }<br />
            catch (Exception ex)<br />
            {<br />
                MessageBox.Show(ex.Message);<br />
            }

Let me know if this works...

Re: getting substring from a string

Ankit Aneja8-Jun-07 3:25

Ankit Aneja

8-Jun-07 3:25

after this line
string firstTagString = fixTable["100"].ToString();
it jumps out and go to lines after
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}

Ankit Aneja
"Nothing is impossible. The word itself says - I M possible"

Re: getting substring from a string

Manas Bhardwaj8-Jun-07 3:28

Manas Bhardwaj

8-Jun-07 3:28

Dude,
I ran it with the same code...
If it is running for exception than it means ur message did not contain message with tag 100...
nyway, for which company do you work?

Re: getting substring from a string

Ankit Aneja8-Jun-07 5:04

Ankit Aneja

8-Jun-07 5:04

ya
it works fine
catched the exception then read the value
thanks a lot for help

Ankit Aneja
"Nothing is impossible. The word itself says - I M possible"

Insert in Oracle

Walaza8-Jun-07 0:26

Walaza

8-Jun-07 0:26

I am new in Oracle and now I'm am struggling to insert into the Oracle Database. The DB connection is fine. I keep getting the error "ORA-01036:illegal variable name/number". Would anyone please tell me what is wrong with the following code (C#):

// Insert user into Tester Table
public void InsertIntoTester(string fname,string lname,string usrname,string passwd,string address, string email, string tester_id)
{
Connection.Open();
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+")";

//Initializing the command
InsertCommand.CommandType = System.Data.CommandType.Text;
InsertCommand.CommandText = strSQL;

//Clearing the parameters
InsertCommand.Parameters.Clear();

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

InsertCommand.Parameters[0].Value = fname;
InsertCommand.Parameters[1].Value = lname;
InsertCommand.Parameters[2].Value = usrname;
InsertCommand.Parameters[3].Value = passwd;
InsertCommand.Parameters[4].Value = address;
InsertCommand.Parameters[5].Value = email;
InsertCommand.Parameters[6].Value = tester_id;

insertValue = strSQL;
InsertCommand.ExecuteNonQuery();
Connection.Close();
}

Please help..

Mvelo Walaza
Jnr Developer
Telkom SA

Re: Insert in Oracle

Colin Angus Mackay8-Jun-07 0:36

Colin Angus Mackay

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

Colin Angus Mackay

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";

Passing Objects to threads..

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.

Re: Passing Objects to threads..

Manas Bhardwaj8-Jun-07 0:24

Manas Bhardwaj

8-Jun-07 0:24

You can use the static variables for this.

Re: Passing Objects to threads..

Colin Angus Mackay8-Jun-07 0:34

Colin Angus Mackay

8-Jun-07 0:34

And if you have multiple threads starting at once?

Re: Passing Objects to threads..

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?

Re: Passing Objects to threads..

Colin Angus Mackay8-Jun-07 0:55

Colin Angus Mackay

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?

Re: Passing Objects to threads..

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

Re: Passing Objects to threads..

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

Re: Passing Objects to threads..

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();

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

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

PandemoniumPasha

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

blackjack2150

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!

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