OracleCommand cm= new OracleCommand("alter table temp add ["+TextBox1.Text+"] varchar2(10)",conn);

conn.Open();

cm.ExecuteNonQuery();

conn.Close(); 

when execute this code one error will fire it;s ORA-00904:invalid identifier

 give me Some solution

 

I do not believe that oracle uses [ ] characters to delimit a column name.

Instead, it uses double-quote " marks. 

That said, I advise you NOT to modify your code to include double-quote marks around the column name! 

By default, oracle will force identifiers to upper case and does not allow spaces in an identifier.  If you put " marks around the column name, it will store it in whatever case your user entered it into.

However, EVERY SINGLE TIME you want to access that column with a lowercase name, you will have to remember to put the " marks around it.

Oracle programmers are not used to doing this, which means you will probably have a bunch of errors in your code to find and debug. 

 Here is the solution -

=============================

OracleCommand cm = new OracleCommand("alter table addressmaster add " + TextBox1.Text + " varchar2(10)", conn);

conn.Open();
cm.ExecuteNonQuery();

conn.Close(); 

==============================

You have to remove [ and ].

And at my end all insert,update,delete operations on this column are working. 

 thanks for reply

i will used ur code but one error come

it's ORA-01735: invalid ALTER TABLE option

give some solution

 Can u plz show me full code and the value u r passing in text box.

  protected void btnADD_Click(object sender, EventArgs e)
    {
        cminsert = new OracleCommand("insert into domain_master values(domainid_Sequence.NextVal ,'" + txtDomainName.Text + "','" + txtRemarks.Text + "','" + txtTotalPoints.Text + "')", connDom);      
        connDom.Open();
        cminsert.ExecuteNonQuery();
        connDom.Close();
        altertemp();
        txtDomainName.Text = "";
        txtRemarks.Text = "";
        txtTotalPoints.Text = "";        

    }
    protected void altertemp()
    {
            OracleCommand cm = new OracleCommand("alter table temp add " + txtDomainName.Text + " varchar2(70)", connDom);
            connDom.Open();
            cm.ExecuteNonQuery();
            connDom.Close();           
    }

it's give me error ORA-01735: invalid ALTER TABLE option

What value are you passing in? Oracle has very particular rules for column names. Max 30 characters in length.  Must be a letter of the alphabet, a digit, or an _ character.  Cannot start with a digit.  Cannot have spaces in it unless you put double quote marks " around it (and that's a darn fool thing to do!)