an exception with this code

Mohamed El Wehishy

hi guys when i run this code it throw an exception but it run well inside SQL Server 2008

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

so what is the problem thanks, Mohamed El-Wehishy

Not Active

Mohamed El-Wehishy wrote:

when i run this code

What do you mean? Run it where/how?

Mohamed El-Wehishy wrote:

it throw an exception

What exception?

only two letters away from being an asset

Lost User

Don't you think maybe this belongs in the Database section as opposed to the C# section?

Check out the CodeProject forum Guidelines[^] The original soapbox 1.0 is back![^]

Md Marufuzzaman

You should post it to the General Database forum..:)

Thanks Md. Marufuzzaman

Don't forget to click [Vote] / [Good Answer] on the post(s) that helped you. I will not say I have failed 1000 times; I will say that I have discovered 1000 ways that can cause failure – Thomas Edison.

Mohamed El Wehishy

ok man this is my code

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");
        }
    }

when i run this code it throw exception but when i execute the stored procedure

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

it completed successfully so what is wrong thanks for your interest Mohamed El-Wehishy

Not Active

Read the previous response. What is the exception that is being thrown????

only two letters away from being an asset

Luc Pattyn

why, WrongForumException, the most popular of all; what else could it be? :)

Luc Pattyn

I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages

Local announcement (Antwerp region): Lange Wapper? Neen!

Mohamed El Wehishy

hi guys please redirect me to a link or tutorial which help me i can not understand the reason thanks Mohamed El-Wehishy

Not Active

You can't understand the reason for what? You still haven't given any useful information

only two letters away from being an asset

Not Active

I wouldn't say that. The original post should have made in clearer, but it does appear to be C# related question. If he/she could only understand what an exception is, we'll all know more.

only two letters away from being an asset

Luc Pattyn

You're right. While the OP started with SQL in the C# forum, it now figures in the DB forum showing C# code; and we may be about to find out what the exception is. :)

Luc Pattyn

I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages

Local announcement (Antwerp region): Lange Wapper? Neen!