01.SqlConnection objConn = new SqlConnection();
02.SqlCommand objCmd = new SqlCommand();
03.String strConnString, strSQL;
04.strConnString = "Data Source=(local)\\SQLEXPRESS;Initial Catalog=myDatabase;Integrated Security=SSPI;";
05.objConn = new SqlConnection(strConnString);
06.objConn.Open();
07.
08.SqlDataAdapter dtAdapter;
09.DataTable dt = new DataTable();
10.strSQL = "select max(Auto_ID) from tbl_ID;";
11.dtAdapter = new SqlDataAdapter(strSQL, objConn);
12.dtAdapter.Fill(dt);
13.
14.if (dt.Rows.Count > 0)
15.{
16. this.textBox1.Text = (string)dt.Rows[0]["Auto_ID"].ToString() +1;
17.}
18.
19.objConn.Close();
20.objConn = null;
