[codejunky]

I created a registration form and when i test if my mysql insert query is successful nothing happens... also notice the query isn't going through. if i take out my if() statements

 if(rowsAffected >0)
			 {
				 MessageBox::Show("Registration Successful!");
				 login^ f5 =gcnew login();
				 f5->ShowDialog();
			 }
			else
			 {
				 MessageBox::Show("Registration Failed!");
				 Application::Exit();
			 }	

and change it to ExecuteReader();

MySqlDataReader^ myReader; myReader=cmdDataBase->ExecuteReader(); 

the query goes through fine...

Not sure what i'm doing wrong, it seems fine...
how do i submit the insert query and check to see if it was successfully submitted?? ExecuteNonQuery(); doesn't work and not sure why???

private: System::Void registration_button_Click(System::Object^  sender, System::EventArgs^  e) {

			  String^ constring=L"datasource=applicationdata.db.104xxxxx.hostedresource.com;port=3306;username=applicationdatas;password=xxxxxx";
			 MySqlConnection^ conDataBase=gcnew MySqlConnection(constring);
			 MySqlCommand^ cmdDataBase=gcnew MySqlCommand("insert into applicationdatas.app_users (fname, email, password, address, country, state, city, postal_code, phone) VALUES ('"+this->ufullname_txt->Text+"', '"+this->uemail_txt->Text+"', '"+this->upassword_txt->Text+"', '"+this->uaddress_txt->Text+"', '"+this->country_comboBox->Text+"', '"+this->state_comboBox->Text+"', '"+this->city_comboBox->Text+"', '"+this->zipcode_txt->Text+"', '"+this->phone_txt->Text+"') ;",conDataBase);
			 //MySqlDataReader^ myReader;

			 try{
			 conDataBase->Open();
			 //myReader=cmdDataBase->ExecuteReader();
			 	
			 int rowsAffected = cmdDataBase->ExecuteNonQuery();
			 
			 if(rowsAffected >0)
			 {
				 MessageBox::Show("Registration Successful!");
				 login^ f5 =gcnew login();
				 f5->ShowDialog();
			 }
			else
			 {
				 MessageBox::Show("Registration Failed!");
				 Application::Exit();
			 }	

			 conDataBase->Close();
			 

			 }catch(Exception^ex){
			 
			 MessageBox::Show(ex->Message);
			 
			 
			 }

		 }

From what i understand the ExecuteNonQuery(); should give affected rows but for some reason it's not working...

[vividexstance]

What db library is this that you're using?

[codejunky]

vividexstance, on 18 April 2013 - 01:49 PM, said:

What db library is this that you're using?

MySQL Connector Net 6.6.5

[codejunky]

codejunky, on 18 April 2013 - 03:44 PM, said:

vividexstance, on 18 April 2013 - 01:49 PM, said:

What db library is this that you're using?

MySQL Connector Net 6.6.5

The code is working 100% fine aside from the if statement in my try catch block.
I must be having some confusion as to how the ExecuteReader(); and ExecuteNonQuery(); are used.
My understanding is that ExecuteNonQuery(); should give affected rows of insert, select, and delete query.
ExecuteReader(); "Sends the CommandText to the Connection and builds a SqlDataReader."

When I use ExecuteNonQuery(); nothing happens... the query doesn't get sent and the check for affected rows in my if statement does nothing either.

When I use ExecuteReader(); the query goes through fine, but I have no way to check it... that I know of.

[codejunky]

Got it figured out...

codejunky, on 18 April 2013 - 04:11 PM, said:

codejunky, on 18 April 2013 - 03:44 PM, said:

vividexstance, on 18 April 2013 - 01:49 PM, said:

What db library is this that you're using?

MySQL Connector Net 6.6.5

The code is working 100% fine aside from the if statement in my try catch block.
I must be having some confusion as to how the ExecuteReader(); and ExecuteNonQuery(); are used.
My understanding is that ExecuteNonQuery(); should give affected rows of insert, select, and delete query.
ExecuteReader(); "Sends the CommandText to the Connection and builds a SqlDataReader."

When I use ExecuteNonQuery(); nothing happens... the query doesn't get sent and the check for affected rows in my if statement does nothing either.

When I use ExecuteReader(); the query goes through fine, but I have no way to check it... that I know of.

[Skydiver]

Congratulations on figuring it out.

Out of curiosity, why are you torturing yourself using C++/CLI? Writing that code in C# would have been easier and less verbose.

[codejunky]

Yeah good plan. =)

Skydiver, on 18 April 2013 - 08:01 PM, said:

Congratulations on figuring it out.

Out of curiosity, why are you torturing yourself using C++/CLI? Writing that code in C# would have been easier and less verbose.