UPDATE Statements

To update a table, use the standard UPDATE SQL syntax. The RSSBus ADO.NET Provider for Facebook supports updating only one row at a time. Hence the primary key Id is always required.

C#

  
  String connectionString = "Access Token=AZ153165481Z351381AAZZ;Offline=false;";
  using (FacebookConnection connection = new FacebookConnection(connectionString)) {
    FacebookCommand cmd = new FacebookCommand("UPDATE Statuses SET Message='Sample status message' WHERE Id = @myid", connection);
    FacebookCommand.Parameters.Add(new FacebookParameter("myid","165189190181_1985180351"));
    cmd.ExecuteNonQuery();
  }

VB.NET

  
  Dim connectionString As [String] = "Access Token=AZ153165481Z351381AAZZ;Offline=false;"
  Using connection As New FacebookConnection(connectionString)
    Dim cmd As New FacebookCommand("UPDATE Statuses SET Message='Sample status message' WHERE Id = @myid", connection)
    FacebookCommand.Parameters.Add(New FacebookParameter("myid", "165189190181_1985180351"))
    cmd.ExecuteNonQuery()
  End Using