Advertisement
Guest User

Untitled

a guest
Jul 20th, 2017
52
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.56 KB | None | 0 0
  1. StringBuilder cmdStr = new StringBuilder();
  2. cmdStr.AppendFormat("UPDATE poplugin_data SET username='{0}', ", username);
  3. foreach(string key in idict.Keys)
  4. {
  5. cmdStr.AppendFormat("{0}='{1}', ", key, idict[key]);
  6. }
  7. cmdStr.Remove(cmdStr.Length - 2, 2);
  8. cmdStr.AppendFormat(" WHERE id={0}", Int32.Parse(id));
  9.  
  10. cmd.CommandText = cmdStr.ToString();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement