Guest User

Untitled

a guest
Aug 12th, 2018
149
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.00 KB | None | 0 0
  1. Edited value does not change while updating in website
  2. DBCmd.CommandText = "update IOMFNewMember set FirstName=@FirstName,MiddleName=@MiddleName,LastName=@LastNa,Gender=@Gender,DateofBirth=@DateofBirth,MartialStatus=@MartialStatus,DateofWedding=@DateofWedding,Nationality=@Nationality,ResidenceCountry=@ResidenceCountry,DateofJoiningIOMf=@DateofJoiningIOMf,EmailId=@EmailId,mobileno=@mobileno,AtPresent=@AtPresent,familykuwait=@familykuwait,DateofDeath =@DateofDeath where UserName=@Entery and MemberID=@MemberID"
  3.  
  4. string strSql="select * from customers where id=" + txtLoginId.Text;
  5. SqlConnection con=new SqlConnection(strCon);
  6. con.Open();
  7.  
  8. SqlDataAdapter da=new SqlDataAdapter();
  9. da.SelectCommand=new SqlCommand(strSql,con);
  10. DataSet dset=new DataSet();
  11. da.Fill(dset);
  12. con.Close();
  13.  
  14. string strSql="update EmployeeTable set password = '" + txtPassword.Text + "'";
  15. SqlConnection con=new SqlConnection(strCon);
  16. con.Open();
  17. SqlCommand cmd=new SqlCommand(strsql, con);
  18. cmd.ExecuteScalar();
  19. con.Close();
Add Comment
Please, Sign In to add comment