Hai
You cant make auto increment coloum without primary key,in database design time,but in coding u can do.
first make it id as integer,read id coloumn if dont have value assign 1,i have value then increment with 1,these thing u do when insert value.
And above ur code in insert query u use 3 fields and try to add 4 vlaues
INSERT INTO dbo .tbl_categorynmpics
(category,
last_updated,
priority)
VALUES ( @category,
@imageurl,
Getdate(),
@priority )
where the coloumn for imageurl ?
And u ask like this ? if u insert value it automatic increment value,if u insert and delete or remove value always it appear next increment value even thoung last value is not availabe in table,so remove auto increment and try to give id via codingd
Best
Regards