To remove all databindings from a control you can simply call control.DataBindings.Clear(). You might need to set the Textbox's Text to String.Empty to clear it though. "Democracy is two wolves and a sheep voting on what to have for dinner" - Ross Edbert Sydney, Australia

Dear Reehan Bhai, Please change your Insert query as following: String idata="Insert into db1 values("+txtID.Text+","+(rbmale.Checked ? rbmale.Text:tbfemale.Text+")"; I think above query must solve your problem. Regards, Wasif Ehsan

It is not necessary to create a transaction. Transactions are used when you plan on doing several SQL calls and there is the possibility of a problem. If there is a problem, a transaction lets you rollback any change prior to anything being fully committed to the database. In the case of the password, you have the one SQL statement and probably do not want it in a transaction. If you did want a transaction, the commit will need to be AFTER your Execute call. As it is, the Transaction in the code is not doing anything and can probably be removed. Try putting a space between password and the '='.

You don't use the SMTP server of the recipient to send mail, you use your own SMTP server. --- b { font-weight: normal; }

There are several ways to do that. For example when the user logs in, the query you use to check for the login / password could also retrieve the first and last name, and you could pass them to the other page through querystring, or session variables. Another way is when the user logs in, pass the user id with either querystring or session variable and then query again to retrieve the information. What I usually do, is create a 'user' class that contains the details of the user, then when I check login / password I also retrieve all the details of the user, then I store all this information in a 'user' instance and keep this object in a session variable. So as long as this object exists in the session variable, you know the details of the logged in user, if not (session variable is null), then I redirect to the login page. daniero

Store the id of the user in a session variable, so that you can use it to track the user. --- b { font-weight: normal; }

Well, you should install and play around with the application and see its funtionality.

Hi there, As the previous poster, session is created by asp.net for you. In Addition, I just want to give u a link about ASP.NET State Quick Start << >>

The next step is to: 1. Fetch the loggined user's data 2. Then display the data on the profile web page instead of displaying the message "Login successfull" in the redirected page << >>

Man, that's a cool site, I like its design and its navigation, but I just wonder... what do you want to know?? well, you just need to start bashing at your keyboard!! :P. daniero

Hi there, Correct me if i misunderstand... So, just simply fetch data from DB (using SqlDataReader,...) Then, assign the value to the text fields (would be something like firstname.text = dr["firstname"]...) Hope this helps. << >>