Member Avatar for cutexxbaby

hihi...

anyone of you know how to create a auto generate data which can recycle the data after 30 days , i already have a primary key and it is identity specification. Bascially i am doing a web service and gridview consume the data and i need this auto generate data when i new a record in the detail view and refesh it back to the gridview, but the problem is i don't know how to create this auto generate data which i can recycle using it after 30 days( the data is something like a id) and combine with the detail view( or the insert method)

thanks in advance

  • 2 Contributors
  • 1 Reply
  • 108 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by jfarrugia
Member Avatar for jfarrugia

Im not sure exactly what you're after.. but if i am close enough to understanding, you might want to create a scheduled SQL job which runs every 30 days and resets the identity?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.