Comments by Member 11160992

Member 11160992 26-Mar-15 3:25am View

A million thanks to Original Griff, i didn't even think about reserved word. Thanks again sir.

Member 11160992 26-Mar-15 3:21am View

Nope, checked everything, but exhausted however the same syntax for updating password is working fine. Below is the syntax

//int number = int.Parse(comboBox1.Text);
OleDbConnection oleDbConnection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=users.mdb;Persist Security Info=False");
OleDbCommand update = new OleDbCommand("UPDATE users SET pass = '" + textBox36.Text + "' where code = 1", oleDbConnection);
oleDbConnection.Open();
update.ExecuteNonQuery();
oleDbConnection.Close();

Member 11160992 26-Mar-15 3:19am View

Deleted

Nope, checked everything, but exhausted however the same syntax for updating password is working fine. Below is the syntax

//int number = int.Parse(comboBox1.Text);
OleDbConnection oleDbConnection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=users.mdb;Persist Security Info=False");
//OleDbCommand update = new OleDbCommand("UPDATE user_details SET first_name,last_name,course_name,DOJ,father_name,reg_fees='" + textBox1.Text + "','" + textBox4.Text + "','" + textBox8.Text + "','" + textBox7.Text + "','" + textBox2.Text + "','" + textBox3.Text + "' where code = " + number + "", oleDbConnection);
OleDbCommand update = new OleDbCommand("UPDATE users SET pass = '" + textBox36.Text + "' where code = 1", oleDbConnection);
oleDbConnection.Open();
update.ExecuteNonQuery();
oleDbConnection.Close();

MessageBox.Show("Updated the password Successfully", "Update Password", MessageBoxButtons.OK, MessageBoxIcon.Information);

Member 11160992 26-Mar-15 2:58am View

Hi, thanks for reply. No special characters are there. I am passing as simple as abc

Member 11160992 14-Mar-15 5:31am View

this.listbox1.ColumnCount=3
I can find "coulmn width" property but cannot find "Column count" property. When I am trying to add it programmatically, its giving me error.

Member 11160992 14-Mar-15 5:03am View

Thanks man! Do you know how to define "how many columns am I going to have" ? I found the below syntax but it's not working.

THISFORM.lst1.ColumnCount = 3

I am using visual studio 2005

Member 11160992 18-Oct-14 3:43am View

Yeah!! i checked that and found it useful. I will try to convert my code to avoid SQL injections. Thanks again.

Member 11160992 18-Oct-14 1:43am View

Thanks NaibedyaKar (Mindfire) for this quick solution. @Ryan Since i am not aware of sql injection, i am Ok with this code until i get any problem. I tried this code and it worked well. Thanks again my friends.

Member 11160992 17-Oct-14 8:12am View

Please assist me.

Comments by Member 11160992 (Top 9 by date)