hassanasp wrote:
com.Parameters.AddWithValue("@School_NameAr", Me.textBox1.Text) com.Parameters.AddWithValue("@School_NameEn", Me.textBox2.Text) com.Parameters.AddWithValue("@School_Edara ", Me.textBox3.Text) com.Parameters.AddWithValue("@School_Address", Me.textBox4) com.Parameters.AddWithValue("@School_City", Me.textBox5) com.Parameters.AddWithValue("@School_Nation ", Me.textBox6.Text) com.Parameters.AddWithValue("@School_Phone", CType(Me.textBox7.Text, Integer)) com.Parameters.AddWithValue("@School_Fax", CType(Me.textBox8.Text, Integer)) com.Parameters.AddWithValue("@School_Email", Me.textBox9.Text) 'com.Parameters.AddWithValue("@School_City", Me.textBox8.Text) com.Parameters.AddWithValue("@School_Country", Me.textBox10.Text) com.Parameters.AddWithValue("@School_Abbrev", Me.textBox11.Text) com.Parameters.AddWithValue("@School_FirstYear", Me.textBox12.Text)
I've bolded two lines above. You will notice that the lines in bold are missing something that the other lines have. That is the .Text property. And, by the way, naming your text boxes as textBox1, textBox2, etc. won't win you any friends. Please give them better names because the person that comes after you to maintain your code will curse you for it. And if you end up having to maintain the code you'll end up cursing yourself.
Upcoming FREE developer events: * Developer Day Scotland My website | blog