My problem is:
I HAVE A 3 COLUMNS(ID,NAME&CITY) IN TABLE T1.
IN MY TABLE MY (ID) COLUMN HAS NO VALUE. BUT OTHER TWO COLUMN HAS ITS OWN SAME VALUE.
eg: OUR (NAME) COLUMN HAS ONLY CONTAIN "VICKY" IN WHOLE COLUMN. AND
(CITY) COLUMN HAS ONLY CONTAIN "DELHI" IN WHOLE COLUMN.
MY REQUIREMENT IS THAT, I WANT TO INSERT THE VALUE IN ID COLUMN AS 1,2,3 AND SO ON.
if you're using SQL Server, declare the ID column as an Identity column. google this out yourself. You need to specify it as an identity field with a seed and increment value and SQL Server will handle the rest itself.
You can use the Management studio >> right click table>> modify>>select the ID column>> beneath it you'd see the properties, scroll down a little and you'll see something like "Identity Specification", in that change the 'no' to 'yes' and there you'll have it.
a/c to your advice i did. but folloeing errors occured. because in id column contain null value
- Unable to modify table.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'ID', table 'Zaid.dbo.Tmp_T1'; column does not allow nulls. INSERT fails.
[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
please check http://www.golsinc.com/app7/
i need to make it in such way that when user moves his pointer inside the image, it generates coordinated inside the textbox. after one click it stores the value the when again user moves his pointer then movement looks inside 2nd textbox.
likewise he does for 3rd textbox.
Currently in this application i am not able to show changing values on mouse move. all 3 types of clicks creates rectsngle, square and tringle.
Any Movie, Software, Song, Game and many more.... Only at Developer's Solution
Search Any Torrent You Want
A Software for Torrent search only....
Must check it
ARe you using a masterpage with your website. The favicon has to go in your masterpage.
Below is the code I am using and it works fine:
Try deleting the cache in your browser and then closing and opening it again.
The answers posted by me are suggestions only and cannot be used in anyway against me.