immaduddinahmed (7/19/2013)
I AM MAKING A APPLICATION IN c# THERE IS A GRID THAT SHOWSSHIFT ID , SHIFT AND DATE
USER SEARCH DATE AND IN GRID DATE , SHIFT AND SHIFT ID SHOWS
THEN USER CHANGE SHIFT AND ON SHIFT TABLE THAT SHIFT NAME CHANGE OF THAT ID.
SHIFT ID AND DATE COME FROM SHIFT DETAILS TABLE
THIS IS A DATA
SHIFT ID----------DATE
-----1------------1/1/2013
-----2------------2/1/2013
-----3-----------4/5/2013
-----4------------6/24/2013
AND SHIFT COME FROM SHIFT TABLE
THIS IS A DATA OF SHIFT TABLE
SHIFT ID----------SHIFT
-----1------------A
-----2------------B
-----3-----------C
-----4------------D
WHEN USER EXECUTE UPDATE QUERY ITS CHANGES SHIFT COLUMN VALUE OF SHIFT TABLE
I HOPE U UNDER STAND SIR
ONE THING MORE HE CAN ONLY CHANGE A SHIFT FROM THE GRID HE CANNOT CHANGE ID
:ermm: Really no need to start posting in all caps when the people here are actually trying to help you considering your tone. "don't fix values plz" isn't a valid response to someone who is attempting to generate code out of thin air because you haven't posted a single line of your own.
No-one is here to work for you.