title: How can I add auto numbering in visual c# 2010? using ms Access?
body: <p>I'm using autonumber but it doesn't work for me. I want auto numbering in my StudentID number.</p>
  
  <pre><code>OleDbCommand system = new OleDbCommand();
  system.CommandType = CommandType.Text;
  system.CommandText = 
  "insert into Student(ID, Lastname, Middlename, Firstname, Address, DateofBirth, Birthplace, Contact_number, emailaddress, guardian_name, Guardian_contact) values ('" + txtStudentIDnumber.Text + "','" + txtlastname.Text + "','" + txtfirstname.Text + "','" + 
  txtmiddlename.Text + "','" + txtaddress.Text + "','" + txtdateofbirth.Text + "','" + txtbirthplace.Text + "','" + txtcontactnumber.Text + "','" + txtemailaddress.Text + "','" + txtGuardianname.Text + "','" + txtguardiancontact.Text + "')";
  system.Connection = mydatabase;
  
  
  
  if (MessageBox.Show("Save data?", "Confirm Save", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
  </code></pre>