Insert space and number from gridview

Firuz

Hi! I have gridview with two column. Id and number. Id begin 1 continue till 300.

But I want insert id and number from gridview into TableNumber like this:

If id in( 1 , 9) then add three space before number .

If id in( 10 ,9 9) then add two space before number .

If id in( 100, 999) then add one space before number .

For example:

" 1"

" 2"

" 3"

" 4"

" 5"

" 6"

" 7"

" 8"

" 9"

" 10"

" 11"

" 100"

" 101"

How I can solve this?

Shashika...

0 1

Hi,

Please refer below SP

SQL

CREATE Procedure InsertNumber
	@ID INT
AS 
BEGIN
	INSERT INTO TableNumber(Id,Number)	
	VALUES(@Id,REPLACE(STR(@Id, 3), SPACE(1), ' '))
END

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html