C#

Satips wrote:

For Conversion of String to Byte Array go like this,

public static byte[] StrToByteArray(string str)
{
System.Text.ASCIIEncoding encoding=new System.Text.ASCIIEncoding();
return encoding.GetBytes(str);
}

String fixString = "Whateever";<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 />
for (int fieldCount = 1; fieldCount < message.Length; fieldCount++)<br />
{<br />
fieldArray = fixArray[fieldCount].Split('=');<br />
fixTable.Add(fieldArray[0].ToString(), fieldArray[1].ToString()); <br />
}

String fixString = "Whateever";<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 />
for (int fieldCount = 1; fieldCount < message.Length; fieldCount++)<br />
{<br />
fieldArray = fixArray[fieldCount].Split('=');<br />
fixTable.Add(fieldArray[0].ToString(), fieldArray[1].ToString()); <br />
}<br />
string firstTagString = fixTable["100"].ToString()

String fixString = "Whateever";<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 />
for (int fieldCount = 1; fieldCount < fixArray.Length; fieldCount++)<br />
{<br />
fieldArray = fixArray[fieldCount].Split('=');<br />
fixTable.Add(fieldArray[0].ToString(), fieldArray[1].ToString()); <br />
}<br />
string firstTagString = fixTable["100"].ToString()

try<br />
            {<br />
                string newLine = "M|2696|0|D|I|20070604-19:31:25.177|255|8=FIX.4.2
9=232
35=D
34=2696
49=Qa-QTIP-Sim-A
56=Qa-QTIP-Sim-A-Internal
52=20070604-23:31:25
40=1
MDSNAPID=
6071=5
11=Q8BO7023-1
21=49
55=QQQQ
59=0
5011=12463/2007-06-04-07:31
38=100
109=RajTest
5012=Raj
9040=N
STRATEGY=PassThru
54=1
47=A
100=ARCA
10=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 />
            }

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

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

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