increment value of textbox and save it in the database

[Salin786]

I have a text box invoice no on windows form and i need to retrieve data from database and everytime user click on the add button the invoice no should increment by 1

[PsychoCoder]

Bytes.com isn't a code or homework service, we're a community of like minded people who come together to help those who are willing to help themselves.

Show us what you've tried and we will do everything we can to nudge you in the right direction but we will not just do the work for you.

[Salin786]

private void button3_Click(object sender, EventArgs e)
        {
            con.Open();
            da = new SqlDataAdapter("Select UserId from tab_userinformation ",con);
            ds = new DataSet();
            da.Fill(ds);
            textBox1.Text = ds.Tables[0].Rows[0][0].ToString();
            con.Close();
        }

[Salin786]

textbox.text = Convert.ToString(Convert.ToInt(textbox.text) + 1)

incrementing the User id Bt i am getting it 302 instead of 301

[Salin786]

i have just put it up my code

[PsychoCoder]

I'm not understanding what it is you're having trouble with, or what you're trying to accomplish for that matter.

[hoemach]

Have you tried DMax +1?

[adriancs]

use auto-increment int primary key and column data type.
the database will do it for you automatically.