Saturday 7 October 2017

Database Application in urdu/hindi part 18 (how to take backup of database)

SqlConnection sqlCon = new SqlConnection(@"YOURCONNECTIONSTRING");

         string database = sqlCon.Database.ToString();
    try
    {
     
            string cmd = "BACKUP DATABASE [" + database + "] TO DISK='" + textBox1.Text + "\\" + "database" + "-" + DateTime.Now.ToString("yyyy-MM-dd--HH-mm-ss") + ".bak'";

            using(SqlCommand command = new SqlCommand(cmd,sqlCon))
            {
                if(sqlCon.State!=ConnectionState.Open)
                {
                    sqlCon.Open();
                }
                command.ExecuteNonQuery();
                sqlCon.Close();
                MessageBox.Show("database backup done successefully");
                BackupButton.Enabled = false;
            }
     

    }
    catch
    {

    }

Pass Dynamically Added Html Table Records List To Controller In Asp.net MVC

Controller Code: using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.Mvc; using ...