Question

我的设想如下。

I m使用ASP。 NET 2.0和VB。 NET。

我有一个标识页。如果我是现有的用户,当我登录时,我的用户细节在相应的文本Boxes中消失。我现在要改变其中一个领域。我编辑了一份记录,然后点击Edit hton,以更新记录。它没有更新,而是从文字箱中产生现有价值。

我如何能够做到这一点?

 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"

Answer 1

For your requirement you have to run a sql command same as that u are using to populate the textboxes with the user details. That is supposing you are using this in the login button click event

  string strSql="select * from customers where id=" + txtLoginId.Text;
  SqlConnection con=new SqlConnection(strCon); 
  con.Open();

  SqlDataAdapter da=new SqlDataAdapter();
  da.SelectCommand=new SqlCommand(strSql,con);
  DataSet dset=new DataSet();
  da.Fill(dset);
  con.Close();

您将不得不在登峰点击活动中使用:

string strSql="update EmployeeTable set password =  " + txtPassword.Text + " ";
SqlConnection con=new SqlConnection(strCon); 
con.Open();
SqlCommand cmd=new SqlCommand(strsql, con);
cmd.ExecuteScalar();
con.Close();

Hope this will clear you confusion. This is just an example. For a real time situation its advisable to use stored procedures only for any database query.

友情链接