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