Hey guys , I am curently fallen in an adverse situation . I am at the end of my website and this situation occurs as follows:-

I got 2 tables named "userdata" and "userresult" such that when user registers himself to the site , his information is inserted to both the tables . now , the login section of the website uses userdata page and then stores the "mail" column of userdata in session["mail"] .at the end of my exam website , i want to store the result of the exam undertaken by the user in "userresult" table and i m following this code --

 cmdd.CommandText = "update userresult set asp_beginner= " + final.ToString() + "where mail = " + Session["mail"].ToString()";

here "final" stores the result

and i m getting this error :

The multi-part identifier "dean@gmail.com" could not be bound.
here dean@gmail.com is the email id of the user stored in both the tables .

please help friends as soon as possible .

Edited by diafol: apply code tags

6 Years
Discussion Span
Last Post by katherinedamon

it worked as you said sir ! very very thnks a lot . (i m happy)

Edited by katherinedamon: problem solved

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.