wants to insert record in oracle

Question

if (tbsitename.Text != null)
        { 
            tbsitecode.Text = dm.GetData("select nvl(max(to_number(id)),0)+1 from setups_setup").ToString();
            //string code = dm.GetData("select lpad(nvl(max(to_number(code)),0)+1,2,0) from setups_setup where type = 'ISITE'").ToString();

            MessageBox.Show(dm.GetData("select max(id) from setups_setup").ToString());

            //int suc = dm.SetData("Insert into setups_setup(id) values (id)");

            //if (suc > 0)
            //{
            //    tbsitecode.Text = dm.GetData("select max(code) from setups_setup where type = 'ISITE'").ToString();

            //    MessageBox.Show("Record Saved.....");
            //}
        }

Dear ALL, I am new in this group as well as in c#/asp.net. I want to insert record in oracle, there is a primary key ID which I want to generate but the query isn't giving me new ID. If I am running this query in oracle it is working fine. any suggestion please...

Check this http://stackoverflow.com/questions/798766/how-to-create-an-oracle-sequence-starting-with-max-value-from-a-table — Marcus Höglund, Feb 04 '16 at 07:34

score 0 · Answer 1 · edited May 23 '17 at 11:45

0

I think sequence do it for you,
This is sample how to insert with getting value from sequence
Remember - use parameters instead pure query (SQL Injection)

edited May 23 '17 at 11:45

Community

1
1

answered Feb 04 '16 at 07:10

Klaudiusz bryjamus

326
3
12

wants to insert record in oracle

1 Answers1