How to save row records in gridview using loginid to another table?

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

Dear Friends,

How to save respected row records in gridview using user login to another table based on button filed? If end user try to click on save button if the user is not login I need to redirect login page, if the user is already login I need to save in another table.

Ex: Just like wish list or save items etc...

Thanks in advance.

Posted 15-Sep-14 19:58pm

Member 10021658

Add a Solution

Comments

[no name] 16-Sep-14 2:55am

show your code please

2 solutions

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)

mhegazy94 · Answer 1 · 2014-09-15T20:30:00

Solution 1

you talk about 2 different task once the user click the button here call a method to check for the user is logged in or not which return a Boolean then check for this return if true go on and save the data otherwise redirect to log in page

additional information copied from redundant solution 2 by same person after comment from OP
if you mean by number 1 the quantity , try to save it to variable and the convert it to string or use the following

SQL

"insert into savetable(userid,productid,Quantity) values(" + Userid.Value.tostring() + "," + str+ "," + 1.tostring() + ") ";

Posted 15-Sep-14 20:30pm

mhegazy94

Updated 16-Sep-14 1:59am

v2

Comments

Member 10021658 16-Sep-14 2:49am

Thanks for reply. Forget about login credentials, now how to save the row records using the login
email id?

[no name] 16-Sep-14 3:16am

explain more please , do u want saving the login email id in database ,
please show your code

Member 10021658 16-Sep-14 3:30am

protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
int i = GridView1.SelectedIndex;

string str = GridView1.Rows[i].Cells[1].Text;

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Constring"].ConnectionString);
a.Open();

string strinsert = "insert into savetable(userid,productid,Quantity) values('" + Userid.Value + "','" + str+ "','" + 1 + "') ";

SqlCommand cmd = new SqlCommandstrinsert , con);
cmd.ExecuteNonQuery();
a.Close();
}

Member 10021658 16-Sep-14 3:31am

But I don't want to use these type of code I need to insert normal insert query only.

[no name] 16-Sep-14 7:38am

if you mean by number 1 the quantity , try to save it to variable and the convert it to string or use the following

"insert into savetable(userid,productid,Quantity) values(" + Userid.Value.tostring() + "," + str+ "," + 1.tostring() + ") ";

Prasanth Radhakrishanan · Answer 2 · 2014-09-23T18:44:00

Solution 3

try this

string insert=("insert into savetable(userid,productid,Quantity) values(" + Userid.Value.tostring() + ",'" + str+ "'," + 1.tostring() + ") ");

Posted 23-Sep-14 18:44pm

Prasanth Radhakrishanan