3
Answers

Change row order and order value

i have a gridview that has up and down button. i need to reorder the gridview row by clicking the up and down button also need to change the row order value when clicking the up and down button not the row id. How do i do that?..


Answers (3)
0
tejal bhesaniya
NA 53 13.2k 12y
SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[YourTable]') if it exist then it will display the result,,,with table name ,,,tpe and everything
0
Naresh Avari
NA 811 1.6m 12y
Select your database and open new query window and

EXEC sp_tables @table_type = "'table'"


0
Jignesh Trivedi
NA 61k 14.2m 12y
hi,

there are two tables sys.tables and sys.objects, in which data base maintain table information
please try.

select * from sys.tables where name = 'Table1'

select * from sys.objects where type = 'U' and type_desc = 'USER_TABLE'


hope this will help you.