sql sintax help

[PT Exorcist]

command2.Parameters.Add("Nicks", nick);
command2.Parameters.Add("Address", ftp);
command2.CommandText = "UPDATE T_Users {0} WHERE Index LIKE '" + dr["Index"] + "'";

I know this is vb.net forum but you should understand it. I'm getting an error that leads me to believe its some sintax problem.

Any suggestions?

[Pirate]

Try


Either this :
command2.CommandText = "UPDATE T_Users {0} WHERE Index LIKE '" + dr[Index] + "'";

or this

command2.CommandText = "UPDATE T_Users {0} WHERE Index LIKE ' + dr[Index] + ' ";

[PT Exorcist]

hmm still the same error

any ideas?

[Edneeis]

You don't have any set or parameters in your query.

command2.CommandText = String.Format("UPDATE T_Users SET  Nicks = @Nick, Address = @Address WHERE Index LIKE '{0}'",dr[Index])
command2.Parameters.Add("@Nicks", nick);
command2.Parameters.Add("@Address", ftp);

[PT Exorcist]

thanks, that was it