bebakhshid
یک شنبه 25 مرداد 1383, 20:37 عصر
سلام
ایراد این sql چیه
Dim command1 As String = _
"INSERT INTO tblusers" & _
"(user_type_id, user_name, email, password, addr1, city, state, postalcode, country, phone, fax, signature)" & _
"VALUES(" & _
"0," & _
TextBox1.Text.Trim & "," & TextBox2.Text.Trim & "," & TextBox3.Text.Trim & "," & TextBox4.Text.Trim & "," & TextBox5.Text.Trim & "," & TextBox6.Text.Trim & "," & TextBox7.Text.Trim & "," & TextBox8.Text.Trim & "," & TextBox9.Text.Trim & "," & TextBox10.Text.Trim & "," & TextBox11.Text.Trim & ")"
SqlCommand1.CommandText = command1
SqlCommand1.Connection.Open()
SqlCommand1.ExecuteNonQuery()
Server.Transfer("webform2.aspx")
SqlCommand1.Connection.Close()
Response.Redirect("webform2.aspx")
ایراد این sql چیه
Dim command1 As String = _
"INSERT INTO tblusers" & _
"(user_type_id, user_name, email, password, addr1, city, state, postalcode, country, phone, fax, signature)" & _
"VALUES(" & _
"0," & _
TextBox1.Text.Trim & "," & TextBox2.Text.Trim & "," & TextBox3.Text.Trim & "," & TextBox4.Text.Trim & "," & TextBox5.Text.Trim & "," & TextBox6.Text.Trim & "," & TextBox7.Text.Trim & "," & TextBox8.Text.Trim & "," & TextBox9.Text.Trim & "," & TextBox10.Text.Trim & "," & TextBox11.Text.Trim & ")"
SqlCommand1.CommandText = command1
SqlCommand1.Connection.Open()
SqlCommand1.ExecuteNonQuery()
Server.Transfer("webform2.aspx")
SqlCommand1.Connection.Close()
Response.Redirect("webform2.aspx")