从首页重定向到new.aspx后如何更新new.aspx页中的值 [英] Ho w to update value in new.aspx page after redirecting from first page to new.aspx

问题描述

从first.aspx页面重定向后，请让我知道如何在new.aspx页面中更新值，我在以下代码中尝试过，但仅在更改后出现prevoius值时无法更新这些值.

Hi,
Please let me know how to update values in new.aspx page after redirecting from first.aspx page, i tried in the following code but am unable to update the values only the prevoius values is appearing after the changes made.

protected void Button3_Click(object sender, EventArgs e)

    {
        string EmpNo = TextBox1.Text;
        string EmpName = TextBox2.Text;
        string Designation = DropDownList1.SelectedItem.Text;
        string Department = DropDownList2.SelectedItem.Text;
        decimal Salary = Convert.ToDecimal(TextBox3.Text);

                if (!string.IsNullOrEmpty(Request.QueryString["EmpNo"]))
        {
            EmpNo = Request.QueryString["EmpNo"].ToString();

            
            SqlConnection con = new SqlConnection("Server=TCT-SW24;uid=sa;password=******; database=sreeramdasari;");
            
            String query = string.Empty;
            query = string.Format("update EmployeeDetails set EmpName='{1}', Designation='{2}',Department='{3}',Salary='{4}' where EmpNo='{0}'", EmpNo, EmpName, Designation, Department, Salary, con);
            //query = string.Format(("Update EmployeeDetails set EmpName=@EmpName, Designation=@Designation,Department=@Department,Salary=@Salary where EmpNo=@EmpNo"), con);
            //query = string.Format("Update EmployeeDetails set EmpName={1}, Designation={2},Department={3},Salary={4} where EmpNo={0}", EmpNo, EmpName, Designation, Department, Salary, con);
            SqlCommand cmd = new SqlCommand(query, con);
            cmd.CommandType = CommandType.Text;



            cmd.Parameters.AddWithValue("@EmpNo", EmpNo);
            cmd.Parameters.AddWithValue("@EmpName", EmpName);
            cmd.Parameters.AddWithValue("@Designation", Designation);
            cmd.Parameters.AddWithValue("@Department", Department);
            cmd.Parameters.AddWithValue("@Salary", Salary);
            cmd.Connection = con;
            con.Open();
            cmd.ExecuteNonQuery();
            Label6.Text = (" Record Updated Successfully");
            Label6.Enabled = true;
            TextBox1.Enabled = false;
            con.Close();
        }
    }

谢谢与问候
Sreeraam_d

Thanks&Regards
Sreeraam_d

推荐答案

您的代码完全错误.查询中可能存在SQL攻击.请注意.
可能会按照以下代码段帮助您.

Your code is totally wrong.There may be SQL attack in your query.Beware.
May be following snippet help you.

protected void Button3_Click(object sender, EventArgs e)
 
    {
        string EmpNo = TextBox1.Text;
        string EmpName = TextBox2.Text;
        string Designation = DropDownList1.SelectedItem.Text;
        string Department = DropDownList2.SelectedItem.Text;
        decimal Salary = Convert.ToDecimal(TextBox3.Text);
 
                if (!string.IsNullOrEmpty(Request.QueryString["EmpNo"]))
        {
            EmpNo = Request.QueryString["EmpNo"].ToString();
 
            
            SqlConnection con = new SqlConnection("Server=TCT-SW24;uid=sa;password=******; database=sreeramdasari;");
            
            String query = string.Empty;
            query = string.Format(("Update EmployeeDetails set EmpName=@EmpName, Designation=@Designation,Department=@Department,Salary=@Salary where EmpNo=@EmpNo"), con);
           
            SqlCommand cmd = new SqlCommand(query, con);
            cmd.CommandType = CommandType.Text;
 

 
            cmd.Parameters.AddWithValue("@EmpNo", EmpNo);
            cmd.Parameters.AddWithValue("@EmpName", EmpName);
            cmd.Parameters.AddWithValue("@Designation", Designation);
            cmd.Parameters.AddWithValue("@Department", Department);
            cmd.Parameters.AddWithValue("@Salary", Salary);
            cmd.Connection = con;
            con.Open();
            cmd.ExecuteNonQuery();
            Label6.Text = (" Record Updated Successfully");
            Label6.Enabled = true;
            TextBox1.Enabled = false;
            con.Close();
        }
    }

这篇关于从首页重定向到new.aspx后如何更新new.aspx页中的值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！