Posted on: 10/23/2012 2:15:36 AM | Views : 233

Hello,
 
started coding 1 week ago! very hard usign web matrix 2 and razor.
getting there...
 
The forums are hard to know where to post!
 
Anyway
 
i have a form to complete but also has to pull data down
 
Here is my code
 
@{ var NatRef=Request["NatRef"]; var id=Request["Job_ID"]; var FacEditNo=Request["FacEdit"]; var db = Database.Open("CAJE"); var SQLSELECTB = "SELECT * FROM nationalprofiles where job_Id=@0"; var TNRD = db.QuerySingle(SQLSELECTB,NatRef); var NRT=TNRD.jobtitle; var DESC="TNRD." + @FacEditNo; } @DESC
What i would like to happen is i have a variable 'FacEditNo' requested from 'FacEdit'
I would then like to return data from my database where 'NatRef' is the current one (request via h ...

Go to the complete details ...