C#

public delegate void ControlTSBoolConsumer(ContextMenuStrip cms, ToolStripMenuItem tsmi, bool choice);
private void SetTSEnabled(ContextMenuStrip cms, ToolStripMenuItem tsmi, bool choice)
{
   if (cms.InvokeRequired)
      cms.Invoke(new ControlTSBoolConsumer(SetTSEnabled), new object[] { cms, tsmi, choice });
   else
      tsmi.Enabled = choice;
}

Mohamed El-Wehishy wrote:

when i run this code

Mohamed El-Wehishy wrote:

it throw an exception

private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                SqlConnection cn = new SqlConnection("initial catalog=vvvvvvvvvvv;server=.;integrated security=sspi");
                SqlCommand cmd = new SqlCommand("back_up_database", cn);
                cmd.CommandType = CommandType.StoredProcedure;

                cn.Open();

                int i = cmd.ExecuteNonQuery();

                cn.Close();



                if (i > 0)
                {
                    MessageBox.Show("Your database is backed up");
                }
            }
            catch(Exception ex)
            {
                MessageBox.Show("Sorry we can not back up your database");
            }
        }

ALTER proc [dbo].[back_up_database]
as
ALTER DATABASE [vvvvvvvvvvv]
SET OFFLINE
go
BACKUP DATABASE [vvvvvvvvvvv]
TO DISK = 'D:\SQLServerBackups\vvvvvvvvvvv.Bak'
with NO_COMPRESSION
go
ALTER DATABASE [vvvvvvvvvvv]
SET ONLINE
go

Dewald wrote:

feel I should know the answer to this but I rarely use inheritance aggressively

public interface IFoo
{
    void Common();
    void Different();
}

public abstract class Bar : IFoo
{
    void Common()
    {
        //Common code here
    }

    public abstract void Different();
}
  
public abstract class Baz : Bar
{
    public abstract void Different()
    {
        //Baz implmentation
    }
}

public abstract class Quux : Bar
{
    public abstract void Different()
    {
        //Quux implmentation
    }
}