Click here to Skip to main content
15,908,264 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
HTML
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;

public partial class UpdateProfile : System.Web.UI.Page
{
    SqlConnection conn = null;
    protected void Page_Load(object sender, EventArgs e)
    {
        
        if (!IsPostBack)
        {
     
            divPatientUpdate.Visible = false;
        }
    }

   

    protected void btnCancel_Click(object sender, EventArgs e)
    {
        btnCancel.Enabled = true;
    }


   
    protected void btnEdit_Click(object sender, EventArgs e)
    {

        if (btnEdit.Text == "Edit")
        {
            txtZip.Enabled = true;
            txtLastName.Enabled = true;
            txtFirstName.Enabled = true;
            txtEmail.Enabled = true;
            txtContactNo.Enabled = true;
            txtAge.Enabled = true;
            rbtnFemale.Enabled = true;
            rbtnMale.Enabled = true;
            cmbCity.Enabled = true;
            cmbState.Enabled = true;
            btnEdit.Text = "Save";
        }
        else
        {
            if (btnEdit.Text == "Save")
            {
                UpdateData();
            }
        }
    }

   

    private void UpdateData()
    {
        SqlConnection conn = null;
        SqlCommand cmd = null;
        try
        {
            conn = new SqlConnection(ConfigurationManager.ConnectionStrings["PConnStr"].ConnectionString);
            string sql = "Update Patient set P_FName=@fname,P_LName=@lname,Age=@age, State=@state ,City=@city ,Email_id=@email ,Sex=@sex ,ContactNo=@contactno, Zip=@zip where P_FName in(select UserName from Login where P_LName=UserName)";
            conn.Open();
            cmd = new SqlCommand(sql, conn);
            cmd.Parameters.AddWithValue("@fname", txtFirstName.Text);
            cmd.Parameters.AddWithValue("@lname", txtLastName.Text);
            cmd.Parameters.AddWithValue("@age", txtAge.Text);
            cmd.Parameters.AddWithValue("@state", cmbState.Text);
            cmd.Parameters.AddWithValue("@city", cmbCity.Text);
            cmd.Parameters.AddWithValue("@email", txtEmail.Text);
            cmd.Parameters.AddWithValue("@contactno", txtContactNo.Text);
            cmd.Parameters.AddWithValue("@zip", txtZip.Text);
            if (rbtnFemale.Checked)
            {
                cmd.Parameters.AddWithValue("@sex", rbtnFemale.Text);
            }
            else
            {
                cmd.Parameters.AddWithValue("@sex", rbtnMale.Text);
            }
         
            cmd.ExecuteNonQuery();
           
            Label1.Visible = true;
            Label1.Text = "Updated Successfully";
        }

        catch (Exception ex)
        {

            Label1.Text = ex.ToString();
            Label1.Visible = true;
        }
        finally
        {
            if (conn.State == ConnectionState.Open)
            {
                conn.Close();
            }
        }

    }

   
    protected void Button1_Click(object sender, EventArgs e)
    {
       
        SqlDataAdapter da = null;
        DataSet dsUser = null;
        SqlDataReader dr;
        try
        {
            conn = new SqlConnection(ConfigurationManager.ConnectionStrings["PConnStr"].ConnectionString);
            conn.Open();
            string sql = "Select * from Patient where P_FName=@fname AND P_LName=@lname";
            SqlCommand cmd = new SqlCommand(sql, conn);
            cmd.Parameters.AddWithValue("@fname",T1.Text);
            cmd.Parameters.AddWithValue("@lname",T2.Text);  
            dr = cmd.ExecuteReader();
            if (dr.Read())
            {
                txtAge.Text = dr[3].ToString();
                txtContactNo.Text = dr[8].ToString();
                txtEmail.Text = dr[6].ToString();
                txtFirstName.Text = dr[1].ToString();
                txtLastName.Text = dr[2].ToString();
                txtZip.Text = dr[9].ToString();
                cmbState.Text = dr[4].ToString();
                cmbCity.Text = dr[5].ToString();
                string m = dr[7].ToString();
                
                if (m == "Male")
                {
                    rbtnMale.Checked = true;
                }
                else
                {
                    rbtnFemale.Checked = true;
                }
                divPatientUpdate.Visible = true;
                
                
            }
            else
            {
                Label3.Text = "This record does not exist";
                Label3.Visible = true;
            }


        }
        catch (Exception ex)
        {
            Label3.Text = ex.ToString();
            Label3.Visible = true;
        }
    }



    
}
Posted

1 solution

Add a WHERE clause to your UPDATE statement.

UPDATE ...
WHERE ID = @id


@id would be the id, or primary key, of the row you want to update.
 
Share this answer
 
Comments
lara shaikh 6-Mar-12 3:41am    
I had also tried by including where clause with primary key but it's throwing an exception "System.Data.SqlClient.SqlException: Must declare the scalar variable "@id". "
[no name] 6-Mar-12 7:16am    
Ok, what is the problem then?

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900