how to delete data from table which is stored in session

Question

0.00/5 (No votes)

See more:

I want to delete user data from table whenever user login his/her email stored in session so i want to perform that if user click on delete button then through session it deleted his/her data from table so is it possible or not? if it is then how please describe me through code.

Posted 21-Oct-15 0:11am

Member 12059614

Add a Solution

Comments

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 21-Oct-15 6:35am

So when delete is clicked, run a query and delete all user related records. Where is the issue?

Member 12059614 21-Oct-15 6:42am

There is error occurred when i declare session name in code.
My code is like this:
cn.Open()
Dim query As String
query = "delete * from tabdata where email='" + Session + "'"
Try
MsgBox("Account deleted succsessfully")
Response.Redirect("Homepage.aspx")
Catch ex As Exception
Response.Write("<script>alert('" + ex.ToString() + "');</script>")
End Try
End Sub

3 solutions

Solution 3

Use

delete from tabdata where email='" + Session["EmailSession"].ToString() + "'"

That should be Session["EmailSession"] is your email session name.

Posted 21-Oct-15 23:06pm

Sagar Haridas Shinde

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

mhemant · Accepted Answer · 2015-10-21T00:33:00

Solution 1

You must be storing data table as a object in session. so when you click button is clicked, you again put the new modified object for data table in session. That means remove it from session and add it again

Posted 21-Oct-15 0:33am

mhemant

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Accepted Answer · 2015-10-21T01:03:00

Solution 2

Quote:
query = "delete * from tabdata where email='" + Session + "'"

That should be Session["Email"] or something like that, not Session.

Also use parameterized query instead of concatenation, otherwise it will be prone to SQL injection attacks.

Posted 21-Oct-15 1:03am

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)