how to auto increment a column in a specific format

Question

I have a column name JobCode , i want it to increment automatic in the formate A-1, A-2....A-200 then it should start from B-1,B-2...B-200 and so on upto Z-1...Z-200....!! i want to code to save the column value into sql server database.

Vulpes · Answer

I realize all that but, as they can't be generated automatically, the purpose of my previous post was to show how the job codes could be generated manually and (by printing them to the console) to check that the method was working correctly. As far as a Windows Forms application is concerned, all you need to do is to incorporate this field and method into your Form class: static string lastJobCode = null; private static string GetNextJobCode() { if (lastJobCode == null) { lastJobCode = "A-1"; return "A-1"; } int number = int.Parse(lastJobCode.Substring(2)); string newJobCode; if (number { newJobCode = lastJobCode[0] + "-" + (number + 1).ToString(); } else { char jobLetter = lastJobCode[0]; if (jobLetter { jobLetter = (char)(jobLetter + 1); newJobCode = jobLetter + "-1"; } else { // start again at A-1, say newJobCode = "A-1"; } } lastJobCode = newJobCode; return newJobCode; } Each time you add a new customer to the database you then need to call the GetNextJobCode() method to get the job code for that customer. When the application starts, you'll need to run a query (from Form_Load say) to get the last job code added to the database (if there is one) and then set the lastJobCode field to that value. The generation of subsequent job codes will then start from there.

Jignesh Trivedi · Answer

hi, please refer below blog link, it might help you. http://beta.c-sharpcorner.com/Forums/Thread/163919/hi-how-to-auto-increment-for-text-and-char-in-sql-table.aspx

Mustaq Khan · Answer

Thank you....

Mustaq Khan · Answer

Thanks for u r reply....... But i want the code in Window appln C#...i don't want to print Jobcode...... i only want the jobCode to increment automatically with every new customer in the database..!!!

Vulpes · Answer

To my knowledge, auto increment fields can only be simple integers in SQL Server. However, it's fairly easy to generate the job codes yourself as the following console application shows: using System; class Test { static string lastJobCode = null; private static string GetNextJobCode() { if (lastJobCode == null) { lastJobCode = "A-1"; return "A-1"; } int number = int.Parse(lastJobCode.Substring(2)); string newJobCode; if (number { newJobCode = lastJobCode[0] + "-" + (number + 1).ToString(); } else { char jobLetter = lastJobCode[0]; if (jobLetter { jobLetter = (char)(jobLetter + 1); newJobCode = jobLetter + "-1"; } else { // start again at A-1, say newJobCode = "A-1"; } } lastJobCode = newJobCode; return newJobCode; } static void Main() { for(int i = 1; i { Console.Write("{0, -8}", GetNextJobCode()); } Console.ReadKey(); } } The output should be: A-1 A-2 A-3 A-4 A-5 A-6 A-7 A-8 A-9 A-10 A-11 A-12 A-13 A-14 A-15 A-16 A-17 A-18 A-19 A-20 A-21 A-22 A-23 A-24 A-25 A-26 A-27 A-28 A-29 A-30 A-31 A-32 A-33 A-34 A-35 A-36 A-37 A-38 A-39 A-40 A-41 A-42 A-43 A-44 A-45 A-46 A-47 A-48 A-49 A-50 A-51 A-52 A-53 A-54 A-55 A-56 A-57 A-58 A-59 A-60 A-61 A-62 A-63 A-64 A-65 A-66 A-67 A-68 A-69 A-70 A-71 A-72 A-73 A-74 A-75 A-76 A-77 A-78 A-79 A-80 A-81 A-82 A-83 A-84 A-85 A-86 A-87 A-88 A-89 A-90 A-91 A-92 A-93 A-94 A-95 A-96 A-97 A-98 A-99 A-100 A-101 A-102 A-103 A-104 A-105 A-106 A-107 A-108 A-109 A-110 A-111 A-112 A-113 A-114 A-115 A-116 A-117 A-118 A-119 A-120 A-121 A-122 A-123 A-124 A-125 A-126 A-127 A-128 A-129 A-130 A-131 A-132 A-133 A-134 A-135 A-136 A-137 A-138 A-139 A-140 A-141 A-142 A-143 A-144 A-145 A-146 A-147 A-148 A-149 A-150 A-151 A-152 A-153 A-154 A-155 A-156 A-157 A-158 A-159 A-160 A-161 A-162 A-163 A-164 A-165 A-166 A-167 A-168 A-169 A-170 A-171 A-172 A-173 A-174 A-175 A-176 A-177 A-178 A-179 A-180 A-181 A-182 A-183 A-184 A-185 A-186 A-187 A-188 A-189 A-190 A-191 A-192 A-193 A-194 A-195 A-196 A-197 A-198 A-199 A-200 B-1 B-2 B-3 B-4 B-5 B-6 B-7 B-8 B-9 B-10 B-11 B-12 B-13 B-14 B-15 B-16 B-17 B-18 B-19 B-20 B-21 B-22 B-23 B-24 B-25 B-26 B-27 B-28 B-29 B-30 B-31 B-32 B-33 B-34 B-35 B-36 B-37 B-38 B-39 B-40 B-41 B-42 B-43 B-44 B-45 B-46 B-47 B-48 B-49 B-50 B-51 B-52 B-53 B-54 B-55 B-56 B-57 B-58 B-59 B-60 B-61 B-62 B-63 B-64 B-65 B-66 B-67 B-68 B-69 B-70 B-71 B-72 B-73 B-74 B-75 B-76 B-77 B-78 B-79 B-80 B-81 B-82 B-83 B-84 B-85 B-86 B-87 B-88 B-89 B-90 B-91 B-92 B-93 B-94 B-95 B-96 B-97 B-98 B-99 B-100 B-101 B-102 B-103 B-104 B-105 B-106 B-107 B-108 B-109 B-110 B-111 B-112 B-113 B-114 B-115 B-116 B-117 B-118 B-119 B-120 B-121 B-122 B-123 B-124 B-125 B-126 B-127 B-128 B-129 B-130 B-131 B-132 B-133 B-134 B-135 B-136 B-137 B-138 B-139 B-140 B-141 B-142 B-143 B-144 B-145 B-146 B-147 B-148 B-149 B-150 B-151 B-152 B-153 B-154 B-155 B-156 B-157 B-158 B-159 B-160 B-161 B-162 B-163 B-164 B-165 B-166 B-167 B-168 B-169 B-170 B-171 B-172 B-173 B-174 B-175 B-176 B-177 B-178 B-179 B-180 B-181 B-182 B-183 B-184 B-185 B-186 B-187 B-188 B-189 B-190 B-191 B-192 B-193 B-194 B-195 B-196 B-197 B-198 B-199 B-200 C-1 C-2 C-3 C-4 C-5 C-6 C-7 C-8 C-9 C-10 C-11 C-12 C-13 C-14 C-15 C-16 C-17 C-18 C-19 C-20 C-21 C-22 C-23 C-24 C-25 C-26 C-27 C-28 C-29 C-30 C-31 C-32 C-33 C-34 C-35 C-36 C-37 C-38 C-39 C-40 C-41 C-42 C-43 C-44 C-45 C-46 C-47 C-48 C-49 C-50 C-51 C-52 C-53 C-54 C-55 C-56 C-57 C-58 C-59 C-60 C-61 C-62 C-63 C-64 C-65 C-66 C-67 C-68 C-69 C-70 C-71 C-72 C-73 C-74 C-75 C-76 C-77 C-78 C-79 C-80 C-81 C-82 C-83 C-84 C-85 C-86 C-87 C-88 C-89 C-90 C-91 C-92 C-93 C-94 C-95 C-96 C-97 C-98 C-99 C-100 C-101 C-102 C-103 C-104 C-105 C-106 C-107 C-108 C-109 C-110 C-111 C-112 C-113 C-114 C-115 C-116 C-117 C-118 C-119 C-120 C-121 C-122 C-123 C-124 C-125 C-126 C-127 C-128 C-129 C-130 C-131 C-132 C-133 C-134 C-135 C-136 C-137 C-138 C-139 C-140 C-141 C-142 C-143 C-144 C-145 C-146 C-147 C-148 C-149 C-150 C-151 C-152 C-153 C-154 C-155 C-156 C-157 C-158 C-159 C-160 C-161 C-162 C-163 C-164 C-165 C-166 C-167 C-168 C-169 C-170 C-171 C-172 C-173 C-174 C-175 C-176 C-177 C-178 C-179 C-180 C-181 C-182 C-183 C-184 C-185 C-186 C-187 C-188 C-189 C-190 C-191 C-192 C-193 C-194 C-195 C-196 C-197 C-198 C-199 C-200

how to auto increment a column in a specific format

Answers (5)