How to generate automatic number depending on date and shift in data gridview column

Question

Hi all Please help me I am attaching image.Send me code in C# if u know thankin g u

Dorababu Meka · Answer

24-09-12-A.M-1 for (int i = 0; i { if (dataGridView1.Rows[i].Cells[0].Value == null) { DateTime dt = DateTime.Now; string str = dt.ToString("dd-MM-yyyy-t.\M"); str=str+"-"+i; // Here you will get like 24-09-2012-P.M-0 if you want to change for 1 means assign I to another variable and increment it by 1 dataGridView1.Rows[i].Cells[0].Value = str; } } Later part if you need to increment it by 1; for (int i = 0; i { if (dataGridView1.Rows[i].Cells[0].Value == null) { DateTime dt = DateTime.Now; string str = dt.ToString("dd-MM-yyyy-t.\M"); int i1 = i; i1 = i1 + 1; str = str + "-" + i1; dataGridView1.Rows[i].Cells[0].Value = str; } }

arun darly · Answer

HI THANKS FOR REPLYING ME I want to generate code fore auto generation of number is in the above mentioned type current date and selected shift +1 That is today date is 24-09-12, and if selected shift is A.M then Number should generate like 24-09-12-A.M-1, 24-09-12-A.M-2, 24-09-12-A.M-3……… thanking you Normal 0 false false false EN-US X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable{mso-style-name:"Table Normal";mso-tstyle-rowband-size:0;mso-tstyle-colband-size:0;mso-style-noshow:yes;mso-style-priority:99;mso-style-parent:"";mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-para-margin-top:0in;mso-para-margin-right:0in;mso-para-margin-bottom:10.0pt;mso-para-margin-left:0in;line-height:115%;mso-pagination:widow-orphan;font-size:11.0pt;font-family:"Calibri","sans-serif";mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;mso-bidi-font-family:"Times New Roman";mso-bidi-theme-font:minor-bidi;}

Dorababu Meka · Answer

Try this in shift event for (int i = 0; i { if (dataGridView1.Rows[i].Cells[0].Value == null) { int num = new Random().Next(1, 100); dataGridView1.Rows[i].Cells[0].Value = num.ToString(); } }

How to generate automatic number depending on date and shift in data gridview column

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (3)