如何使用ASP.NET更新mysql中的用户数据 [英] How to update user data in mysql using ASP.NET

问题描述

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Configuration;
using MySql.Data.MySqlClient;


public partial class profile : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        Label1.Text = Session["user"].ToString();
    }

    protected void Button2_Click(object sender, EventArgs e)
    {
        MySqlConnection con = new MySqlConnection();
        string str = ConfigurationManager.ConnectionStrings["netConnectionString"].ConnectionString;
        con.ConnectionString = str;
        con.Open();

        if (con.State.ToString() == "Open")
        {
            MySqlCommand cmd = new MySqlCommand("update users Set education=@c,about=@d,interest=@e where user_name="Session["user"].ToString"",con);
            cmd.Parameters.AddWithValue("@c", TextBox1.Text);
            cmd.Parameters.AddWithValue("@d", TextBox2.Text);
            cmd.Parameters.AddWithValue("@e", TextBox3.Text);
            cmd.ExecuteNonQuery();
            Label5.Text = "Well done profile updated!!";
        }
    }
}

我想从我的个人资料中更新用户信息这个错误（其中user_name =Session [user]。ToString）见上面的代码请帮帮我

I want to update user information from its profile i am getting error at this (where user_name="Session["user"].ToString") see above code please help me

推荐答案

重写你的新MySqlCommand：

Rewrite your new MySqlCommand to this:

MySqlCommand cmd = new MySqlCommand("UPDATE users SET education=@c,about=@d,interest=@e WHERE user_name=@userName", con);
            cmd.Parameters.AddWithValue("@c", TextBox1.Text);
            cmd.Parameters.AddWithValue("@d", TextBox2.Text);
            cmd.Parameters.AddWithValue("@e", TextBox3.Text);
            cmd.Parameters.AddWithValue("@userName", Session["user"].ToString());
            cmd.ExecuteNonQuery();
            Label5.Text = "Well done profile updated!!";

您不应该像这样给出会话值。用这种方式：

You should not give the session value like that. Use it this way:

user_name='"+Session.Contents["user"]+"'

sql查询中的
。

快乐编码：）

in the sql query.
Happy Coding :)

这篇关于如何使用ASP.NET更新mysql中的用户数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！