public void getNewNumbers() { technovisionDataSetTableAdapters.order_summaryTableAdapter t = new technovisionDataSetTableAdapters.order_summaryTableAdapter(); string newID = t.getMaxId().ToString(); if (newID == "") { newID = "0"; } newID = (int.Parse(newID) + 1).ToString(); if (newID.Length < 4) { while (newID.Length < 4) { newID = "0" + newID; } } newID = DateTime.Now.ToString("yy") + newID; txt_order_no.Text = newID; lbl_receiptNo.Text = "R" + newID; }