how to add auto generate number using sql

[siddarthan]

I have an asp.net project with sql backend.

I generate auto number using the code which has been given already, but it shown an error caused by giving the line in my code:

"Select @@identity;" in

The error is...

Keyword, identifier, or string expected after verbatim specifier: @

[Rabbit]

It would help to see the code. And also help to know which SQL backend you're using as there are many. Is it MySQL? Oracle? SQL Server? DB2? Some other one?

[siddarthan]

mine is sql server 2000.and the particular field must have primary key or its optional

[Rabbit]

What about the code I asked for?

[siddarthan]

string query5 = "select prostock from inventory where Proname='" + pnamedrp.Text + " ' and prostock=prostock<75";
        {
            Response.Write("<script>alert('Purchase Product')</script>");
        }
            SqlCommand comd = new SqlCommand("insert into sales values(@billno,@Cid,@Proid,@Proname,@protype,@sellingprice,@quantity,@cost)", con);
            comd.Parameters.AddWithValue("@billno", billno.Text);
            comd.Parameters.AddWithValue("@Cid", custrid.Text);
            comd.Parameters.AddWithValue("@Proid", procode.Text);
            comd.Parameters.AddWithValue("@Proname", pnamedrp.SelectedItem.Text);
            comd.Parameters.AddWithValue("@protype", protypee.SelectedItem.Text);
            comd.Parameters.AddWithValue("@sellingprice", proprice.Text);
            comd.Parameters.AddWithValue("@quantity", proqunty.Text);
            comd.Parameters.AddWithValue("@cost", amt.Text);
            comd.ExecuteNonQuery();
            con.Close();

in this billno want to generate automatically.

[siddarthan]

protected void insrtbtn_Click(object sender, EventArgs e)
    {
        dataTable.Rows.Add(procode.Text, pnamedrp.SelectedItem.Text, protypee.SelectedItem.Text, proprice.Text, proqunty.Text, amt.Text + "");
        salegrid.DataSource = dataTable;
        salegrid.DataBind();
        setupTable();
        updateTotal();
        con.Open();
        string query5 = "select prostock from inventory where Proname='" + pnamedrp.Text + " ' and prostock=prostock<75";
        {
            Response.Write("<script>alert('Purchase Product')</script>");
        }
            SqlCommand comd = new SqlCommand("insert into sales values(@billno,@Cid,@Proid,@Proname,@protype,@sellingprice,@quantity,@cost)", con);
            comd.Parameters.AddWithValue("@billno", billno.Text);
            comd.Parameters.AddWithValue("@Cid", custrid.Text);
            comd.Parameters.AddWithValue("@Proid", procode.Text);
            comd.Parameters.AddWithValue("@Proname", pnamedrp.SelectedItem.Text);
            comd.Parameters.AddWithValue("@protype", protypee.SelectedItem.Text);
            comd.Parameters.AddWithValue("@sellingprice", proprice.Text);
            comd.Parameters.AddWithValue("@quantity", proqunty.Text);
            comd.Parameters.AddWithValue("@cost", amt.Text);
            comd.ExecuteNonQuery();
            con.Close();

            // Write query for stock update

            con.Open();
            SqlCommand cmd = new SqlCommand("update inventory set prostock=prostock-" + proqunty.Text + " where Proid='" + procode.Text + "';", con);
            cmd.ExecuteNonQuery();
            con.Close();               
    }

in this bill no want to generate automatically. may be more one product can buy in same bill no

[Rabbit]

I don't see @@identity anywhere in your code. At this point, I don't know what your question is anymore.

[siddarthan]

i got answer in some other way.. thank you..

[Rabbit]

Could you post that answer here in case someone else stumbles upon this thread?