Saturday, May 22, 2010

How can i backup from dataBase in c#.NET?

If you know please send me its code.

How can i backup from dataBase in c#.NET?
SqlConnection cnn = new SqlConnection("Data Source=ariesdell; Initial Catalog=Northwind;Integrated Security=SSPI");


SqlCommand cmd = new SqlCommand("backup database northwind to disk = 'c:\Northwind.bak'");





try {


cnn.Open();


cmd.Connection = cnn;


cmd.ExecuteNonQuery();


}


catch (Exception ex)


{


MessageBox.Show(ex.Message);


}

snapdragon2

No comments:

Post a Comment