How to reset the DC number based on the year in c# window ap

Question

Hai In my project am using nearly 40 forms. Here am using delivery details forms. In this am storing the records based on the DC number. In this I want to reset the DC number year by year. How can I reset this in my project. Here this DC number number will be automatically increment in that textbox. Example: DC_No : 1/2014...........................10000/2014 in year 2014 and rest this will in next year like DC_No : 1/2015............................10000/2015 like this. Year by year like wise it will automatically reset. How can I do this in my project. Please anybody help this question I need to finish it quickly. Please suggest any Idea to do this. Thanks in advance. and also am I waiting for your reply.

Raja T · Answer

Good job :)

Pavithra L · Answer

Hai Raja I can solve this problem without using stored procedure. Thanks for your reply.

Raja T · Answer

Hi It can possiable only one sp execute using windowsform and c# on your project. your problem is solved?

Pavithra L · Answer

Hai Raja I understood your method. But It's difficult to use stored procedure for my table. So please tell me the another method without using stored procedure. Please Raja It's urgent reply quickly.

Raja T · Answer

Hi As per my understanding when insert data into table at the time only u can manage. Like bellow steps 1. check before insert record get last inserted year and current year both compare 2.after that if equal no problem insert record in table. 3.If not equal that time u can reset I'd like bellow query DBCC CHECKIDENT ('Ur table name'  RESEED1) My suggestion is use store procedure for above steps easily manage. I hope understanding my suggestions

Pavithra L · Answer

Hai Raja My question is how to reset the DC_No number based on the current financial year. DC_No is like a serial number it will be auto increment in my project. Here i need to reset the DC_No every year. For an example: This year 2015 I can stored the records from 1/2015 to 1000/2015. Then next year 2016 I don't want to stored the record from 10001/2015. This will be reset from 1/2016 to 1000/2016. How can I do this in my project. Now are you cleared about my question. Please reply me quickly.

Raja T · Answer

Hi Pavithra Please confirm you need reset id in database right ? but no there is no code for this ? Your code is just get max DCNO from Table based on year. Please describe your question?

Pavithra L · Answer

Hai Raja Am not using any stored procedure. My code is given below for storing DC_No in database. private int idgeneration() { con.Open(); SqlCommand c1; c1 = new SqlCommand(select MAX (DC_No) from Sample where Year=' + label1.Text + ' con1); id = Convert.ToString(c1.ExecuteScalar()); if (id == ) { eid = 1; } else { eid = Convert.ToInt32(id); eid = eid + 1; } con.Close(); return eid; } But its not working properly. How can I reset this DC number based on the current financial year.

Raja T · Answer

Are you using store procedure for stored data in table? Please show me the code what code for you trying?

Raja T · Answer

How to storing data in db using linequer or using store procedure?

Pavithra L · Answer

Hai Raja How can I do this in my query. Will you please elaborate it quickly.

Raja T · Answer

Hi Pavithra U can check out bellow steps 1. You can check current year and month 2. After that you can rest auto increments I'd like below DBCC CHECKIDENT ('Ur table name'  RESEED0)