Clipboard.SetData("MyClassFormat", new MyClass("42"));
if (Clipboard.ContainsData("MyClassFormat"))
{
	MyClass o = Clipboard.GetData("MyClassFormat") as MyClass;
	if (o != null)
	{
		// do stuff here, such as execute a method
		// o.MyMethod();
		// or set a property
		// o.MyProperty = "xyz";
	}
}
else
{
	MessageBox.Show("Ain't nothing there!!");
}

from a solution provided by Einar Kvandahl in Message #1135004

First, if you are not using Stored Procs and simply sending an INSERT INTO statement, just add a "SELECT SCOPE_IDENTITY() at the end of your query and be sure to execute your query by reading the result back (into a datareader or dataset for example).

Your query string should look like this:

string Sql = "INSERT INTO MyTable (ColumnOne) VALUES ('Bob') SELECT SCOPE_IDENTITY() AS MyPK";

  int MyPK = 0;
  SqlCommand sc = new SqlCommand(Sql, new SqlConnection(this.TestConnection));
  sc.Connection.Open();
  SqlDataReader rd = sc.ExecuteReader(CommandBehavior.CloseConnection);

  while (rd.Read())
  {
	MyPK = Convert.ToInt32(rd["MyPK"]);
  }

-- The Stored Proc
CREATE PROCEDURE MySP 
          @PK        int     = NULL OUTPUT,
          @ColumnOne char(8) = NULL,
          @ColumnTwo char(4) = NULL
AS
  INSERT MyTable (ColumnOne, ColumnTwo)
         SELECT @ColumnOne, @ColumnTwo

  SELECT @PK = SCOPE_IDENTITY()

  Command.CommandText = "MySP";
  Command.Parameters.Add("@PK", 0);
  Command.Parameters["@PK"].Direction = ParameterDirection.InputOutput;
  Command.Parameters.Add("@ColumnOne", OneValue);
  Command.Parameters.Add("@ColumnTWo", TwoValue);

  Command.ExecuteNonQuery();

  MyNewPK = Command.Parameters["@PK"].Value;

from two solutions provided by Éric Moreau and Bonnie Berent in Messages #1090511 and #930339

Say you have a GridView that contains 3 columns: Employee ID, Employee Name, Select Link. The first column is marked as not visible because we don't want to display the Employee ID field.

When the user clicks the Select link in column3, we can capture the row and column as such:

e.Item.Cells[0].Text.Trim()

Now ASP.NET 2.0 comes along and this same WebForm cannot be used as is. With the Employee ID column still invisible, a blank value is returned. The only way to make this work is to make the Employee ID visible again. Clearly not a viable workaround.

Here's a better idea:

There's a new GridView property in 2.0 called DataKeyNames. We can set that to our ID column name. Then, in the GridView's SelectedIndexChanged event (which fires if we have any link or command button with a command name of "SELECT"), we can do this:

int MyID = (int)this.MyGridView.SelectedDataKey.Values["MyIDColumn"];

from a solution provided by Kevin Goff in Message #1098765

private void MyButton_Click(object sender, System.EventArgs e)
{
    // Move the Focus elsewhere
    this.MySpecialTextBox.Focus();
}

private void MyForm_Load(object sender, System.EventArgs e)
{
    // Start the Form with the Focus on a certain control
    this.ActiveControl = this.MySpecialTextBox;
}

from a solution provided by Kevin McNeish in Message #1080245