Member Avatar for lia_IT

Hello

i have some issues in how to display data in specific format (i am using SQL server 2008 & visual web developer 2008 C#)

- how to display the data input as percentage like this 3%

- i have field which the input should be more than zero (how can i do that, should i do it on the Database or on the visual web developer )

- i want to generate auto unique number for each record like this which start with a letter then numbers , like this G12576

- how can i creat an input mask in SQL for field which contain number & symobls like

this : 1- 00- 260493

  • 2 Contributors
  • 1 Reply
  • 120 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by Ramy Mahrous
Member Avatar for Ramy Mahrous

- i have field which the input should be more than zero (how can i do that, should i do it on the Database or on the visual web developer )

As you like you can do it in BLL (Business logic layer) or you can do it as constrains in database.
About generating strings you can see that http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=59194

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.