change RegistrationID in the database.

Question

change registrationID in the database..

old ID -- textbox1.text

new ID -- textbox2.text

when user enter its old id and new id then on click of submit button old id will be replaced by new id in database..

db: RegistrationNum-- varchar(200)

simply i want to check that the value which i am inserting in the oldRegID.Text exists into the database..

if yes, then it will update that id with the text inserted into the NewRigID.Text..

Else it will give an error--"Please enter your old registrationID Correctly"

This is what i want..

Priya Jindal · Answer

i have corrected that still it not working.. giving the same error

Vipul Malhotra · Answer

it is because both your if and else condition gives the same  updated Successfully popup

Priya Jindal · Answer

error which im facing is : 1. when i am updating registrationnum then im getting not updated successfully bt when im checking the database it is updated. 2. while clicking on submit button even thou it is blank it is showing successfully submitted.. string query = Update RegistrationID set RegistrationNum = ' + TextBox2.Text +' where RegistrationNum= '+ TextBox1.Text +'; SqlConnection con = new SqlConnection(Data Source=PRIYA\SQLEXPRESS;Database=training;Integrated Security=True;); con.Open(); SqlCommand cmd = new SqlCommand(query con); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); if (dt.Rows.Count > 0) { Response.Write( alert('updated Successfully') ); Response.Redirect(Default2.aspx); } else { Response.Write( alert('Not updated') ); } con.Close();

Vipul Malhotra · Answer

it is because both your if and else condition gives the same  updated Successfully popup

Priya Jindal · Answer

without filling anythng when im click on update button it is showing suiccessfully updated..

Vipul Malhotra · Answer

ok and what is the error encountered?

Priya Jindal · Answer

RegistrationID

Vipul Malhotra · Answer

what is the name of this table?

Priya Jindal · Answer

string query = Update RegistrationID set RegistrationNum = ' + TextBox2.Text +' where RegistrationNum= '+ TextBox1.Text +'; SqlConnection con = new SqlConnection(Data Source=PRIYA\SQLEXPRESS;Database=training;Integrated Security=True;); con.Open(); SqlCommand cmd = new SqlCommand(query con); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); if (dt.Rows.Count > 0) { Response.Write( alert('updated Successfully') ); Response.Redirect(Default2.aspx); } else { Response.Write( alert('updated Successfully') ); } con.Close();

Priya Jindal · Answer

query im using is: string query = Update RegistrationID set RegistrationNum = ' + TextBox2.Text +' where RegistrationNum= '+ TextBox1.Text +';

Priya Jindal · Answer

i want to check weather the registrationnum exists. if ye then only it will update else it will give an error.. What i m doing is firstlyit is generating a unique number --> then a user have to register it --> after registring if he want to change the registrationnum of only which exist in the database can be changed else it will give an error registrationNum incorrect..

Vipul Malhotra · Answer

ok what is the query that you are using and what error are you getting in it?

Priya Jindal · Answer

yes its registrationNum

Vipul Malhotra · Answer

There is no RegistrationID in the table schema. Is it the same as  RegistrationNum?

Priya Jindal · Answer

RegistrationNum varchar(200) Name varchar(200) EmailID Varchar(200) Contact_number int organisation_Name varchar(50) organisation_Address varchar(200) pincode int NominatorName varchar(50) mobileNumber int

Vipul Malhotra · Answer

Could you please provide the sql for your table creation for better understanding

Priya Jindal · Answer

It is not the primary key.. a key is generated automatically.and then a user can verify it after clicking the submit button..

Vipul Malhotra · Answer

Is RegistrationID a Primary Key in your table? if yes then it's not possible to change that. Also how far have your reached in implementing it?