Con = new SqlConnection("Data Source=PSTLCORPSERV;Initial Catalog=Error;Persist Security Info=True;User ID=sa;Password=sqlserver12#");
            Con.Open();
            Cmd = new SqlCommand("select issue_no from error", Con);
            Data = Cmd.ExecuteReader();
            while (Data.Read() != false)
            {
 
                auto = Data.GetString(0);	
 
            }
            try
            {
 
                int newid = Int32.Parse(auto);
                int id = newid + 1;
                this.textBox1.Text = id.ToString() + "";
 
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message + ex.Source);
            }
 
            Data.Close();