change RegistrationID in the database.

Priya Jindal

10y1.4k.NET

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..

18 Replies

Know the answer? Post it — somebody with the same question will find it here.

Priya Jindal10y ago
i have corrected that still it not working.. giving the same error
0
Vipul Malhotra10y ago
it is because both your "if" and "else" condition gives the same "updated Successfully" popup
0
Priya Jindal10y ago
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("");
Response.Redirect("Default2.aspx");
}
else
{
Response.Write("");
}
con.Close();
0
Vipul Malhotra10y ago
it is because both your "if" and "else" condition gives the same "updated Successfully" popup
0
Priya Jindal10y ago
without filling anythng when im click on update button it is showing suiccessfully updated..
0
Vipul Malhotra10y ago
ok, and what is the error encountered?
0
Priya Jindal10y ago
RegistrationID
0
Vipul Malhotra10y ago
what is the name of this table?
0
Priya Jindal10y ago
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("");
Response.Redirect("Default2.aspx");
}
else
{
Response.Write("");
}
con.Close();
0
Priya Jindal10y ago
query im using is:
string query = "Update RegistrationID set RegistrationNum = '" + TextBox2.Text +"' where RegistrationNum= '"+ TextBox1.Text +"'";
0
Priya Jindal10y ago
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 firstly,it 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..
0
Vipul Malhotra10y ago
ok, what is the query that you are using and what error are you getting in it?
0
Priya Jindal10y ago
yes its registrationNum
0
Vipul Malhotra10y ago
There is no RegistrationID in the table schema. Is it the same as "RegistrationNum"?
0
Priya Jindal10y ago
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
0
Vipul Malhotra10y ago
Could you please provide the sql for your table creation, for better understanding
0
Priya Jindal10y ago
It is not the primary key.. a key is generated automatically.and then a user can verify it after clicking the submit button..
0
Vipul Malhotra10y ago
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?
0