autocode generate with the help of name

[abneeshupadhyay]

x = new OracleConnection("Data Source=cstr;Persist Security info=true;user id=dispatch;password=dispatch;unicode=true");
            x.Open();
            string p;
            string q;
            string st1 = textBox3.Text + "%";
            y = new OracleCommand("select CUST_CODE from CUST_ADD where substr(CUST_NAME,0,1) like '" + st1 + "'", x);
            q = y.CommandText;

            z = y.ExecuteReader();


            int r;
            y = new OracleCommand("select NVL(MAX(to_number(substr(CUST_CODE,2,3))),0)+1 from CUST_ADD where substr(CUST_CODE,0,1) like '" + st1 + "'", x);
          
            r = y.GetHashCode();
            z = y.ExecuteReader();
         

            if (z.HasRows)
            {
                if (z.Read())
                {

                    if (r <= 9)
                    {
                        p = q + "00" + r ;
                        textBox1.Text = p;
                        textBox1.Text = z[0].ToString();
                    }

                    else if (r <= 99)
                    {
                        p = q + "0" + r;
                        textBox1.Text = p;
                        textBox1.Text = z[0].ToString();
                    }
                    else
                    {
                        p = q + r;
                        textBox1.Text = p;
                        textBox1.Text = z[0].ToString();
                    }

                }

            }
         
            //z.Dispose();
            y.Dispose();
            x.Close();

PLZ SEE THIS CODE AND IF ANY ERROR THAN PLEASE HELP ME

[sashi]

What is the problem that you're facing with this code?

[ThatThatGuy]

You should check it... if there are any errors.... you'll receive compiler complaints immediately.... on program compilation

[semomaniz]

Please do not double post the question.

Original Post http://bytes.com/topic/c-sharp/answe...rate-help-name

[tlhintoq]

TIP: When you are writing your question, there is a button on the tool bar that wraps the [code] tags around your copy/pasted code. It helps a bunch. Its the button with a '#' on it. More on tags. They're cool. Check'em out.
#

[tlhintoq]

PLZ SEE THIS CODE AND IF ANY ERROR THAN PLEASE HELP ME

So you don't even know if there is a problem? You just want other people to do your debugging for you?

When you *know* you have a problem... and you have made an actual effort of your own to resolve it... Post the relevant code along with the error message and what you have done to try to resolve it.