C#

private void WatchForChanges()
{
  CurrencyManager cm = (CurrencyManager)dataGrid1.BindingContext[
    dataGrid1.DataSource, dataGrid1.DataMember];
  cm.ItemChanged += new ItemChangedEventHandler(
    this.CurrencyManager_ItemChanged);
}
private void CurrencyManager_ItemChanged(object sender,
  ItemChangedEventArgs e)
{
  // ...
}

public void AttachDatabase(string name, string mdfFile, string ldfFile)
{
  using (SqlConnection conn = new SqlConnection(
    "Data Source=.;Initial Catalog=master;Integrated Security=SSPI"))
  {
    SqlCommand cmd = conn.CreateCommand();
    cmd.CommandText = "exec sp_attach_db @dbname, @filename1, @filename2";
    cmd.Parameters.Add("@dbname", SqlDbType.NVarChar, 128).Value = name;
    cmd.Parameters.Add("@filename1", SqlDbType.NVarChar, 260).Value = mdfFile;
    cmd.Parameters.Add("@filename2", SqlDbType.NVarChar, 260).Value = ldfFile;
 
    conn.Open();
    cmd.ExecuteNonQuery();
    conn.Close();
  }
}

"You can have everything in life you want if you will just help enough other people get what they want." --Zig Ziglar

The Second EuroCPian Event will be in Brussels on the 4th of September

Can't manage to P/Invoke that Win32 API in .NET? Why not do interop the wiki way!

My Blog