http://www.codeproject.com/KB/books/1861004982.aspx
Friday, 20 May 2011
2 year exp asp.net interview question
http://www.dotnetspider.com/forum/231146-year-exp-asp-net-interview-question.aspx
Installing Oracle 10g – step by step guide
http://faq.programmerworld.net/database/installing-oracle-10g.html
State Management Techniques in ASP.NET
http://www.codeproject.com/KB/aspnet/state_management_intro.aspx
MySql Database Backuup And Restore Code
Backup:
DateTime Time = DateTime.Now;int year = Time.Year;
int month = Time.Month;
int day = Time.Day;
int hour = Time.Hour;
int min = Time.Minute;
//int second = Time.Second;
//int millisecond = Time.Millisecond;
//Save file to C:\ with the current date as a filename
string path = Application.StartupPath + "\\"+ "dbbackup"+"\\";
path = path + year + "-" + month + "-" + day + "-" + hour + "-" + min + ".sql";
//path = "C:\\Documents and Settings\\user\\Desktop\\dbbackup\\" + year + "-" + month + "-" + day +".sql";
StreamWriter file = new StreamWriter(path);
ProcessStartInfo psi = new ProcessStartInfo();
psi.FileName = "mysqldump";
psi.RedirectStandardInput = false;
psi.RedirectStandardOutput = true;
psi.Arguments = string.Format(@"-u{0} -p{1} -h{2} {3}", "root", "password", "localhost", "inventory");
psi.UseShellExecute = false;
Process process = Process.Start(psi);
string output;
output = process.StandardOutput.ReadToEnd();
file.WriteLine(output);
process.WaitForExit();
file.Close();
process.Close();
MessageBox.Show("Database Backup Completed Successfully");
Restore:
int x = 10; int y = 10;
files = Directory.GetFiles(Application.StartupPath + "\\" + "dbbackup", "*.sql");
for (int i = 0; i < files.Length; i++)
{
split = files[i].Split('\\');
foreach (string file in split)
{
if (file.EndsWith(".sql"))
{
LinkLabel lb = new LinkLabel();
lb.Location = new Point(x, y);
lb.Name = file;
lb.Text = file;
lb.Width = 300;
dbfilepanel.Controls.Add(lb);
y = y + 20;
lb.Click += new EventHandler(lb_Click);
in lb_Click Event:
string dbfile = ((Control)sender).Name;
string respath = Application.StartupPath + "\\" + "dbbackup" + "\\" + dbfile;
/* for restoring the database */
StreamReader file = new StreamReader(respath);
ProcessStartInfo proc = new ProcessStartInfo();
string cmdArgs = string.Format(@"-u{0} -p{1} -h{2} {3}", "root", "password", "localhost", "inventory");
proc.FileName = "C:\\Program Files\\MySQL\\MySQL Server 5.1\\bin\\mysql.exe";
proc.RedirectStandardInput = true;
proc.RedirectStandardOutput = false;
proc.Arguments = cmdArgs;
proc.UseShellExecute = false;
Process p = Process.Start(proc);
string res = file.ReadToEnd();
file.Close();
p.StandardInput.WriteLine(res);
p.Close();
MessageBox.Show("Database Restore Completed Successfully");
Wednesday, 11 May 2011
SQL Server 2005 Database Backup & Restore by using C#
Introduction
The following article describes accessing a SQL Server 2005 database backup and restoring it programmatically using C#.NET 2.0 and SMO. This article provides coding samples to perform the task.SQL Server Management Objects (SMO) is a collection of objects that are designed for programming all aspects of managing Microsoft SQL Server.
The following namespaces can be used to access SQL Server 2005 programmatically:
Microsoft.SqlServer.managementMicrosoft.SqlServer.Management.NotificationServicesMicrosoft.SqlServer.Management.SmoMicrosoft.SqlServer.Management.Smo.AgentMicrosoft.SqlServer.Management.Smo.BrokerMicrosoft.SqlServer.Management.Smo.MailMicrosoft.SqlServer.Management.Smo.RegisteredServersMicrosoft.SqlServer.Management.Smo.WmiMicrosoft.SqlServer.Management.Trace
Pre-Requisite
You need to reference the following namespaces before using this code:- Microsoft.SqlServer.Management.Smo;
- Microsoft.SqlServer.Management.Common;
- Microsoft.SqlServer.Management.Smo.Backup
- Microsoft.SqlServer.Management.Smo.Restore
Backup database
Collapsepublic void BackupDatabase(String databaseName, String userName,
String password, String serverName, String destinationPath)
{
Backup sqlBackup = new Backup();
sqlBackup.Action = BackupActionType.Database;
sqlBackup.BackupSetDescription = "ArchiveDataBase:" +
DateTime.Now.ToShortDateString();
sqlBackup.BackupSetName = "Archive";
sqlBackup.Database = databaseName;
BackupDeviceItem deviceItem = new BackupDeviceItem(destinationPath, DeviceType.File);
ServerConnection connection = new ServerConnection(serverName, userName, password);
Server sqlServer = new Server(connection);
Database db = sqlServer.Databases[databaseName];
sqlBackup.Initialize = true;
sqlBackup.Checksum = true;
sqlBackup.ContinueAfterError = true;
sqlBackup.Devices.Add(deviceItem);
sqlBackup.Incremental = false;
sqlBackup.ExpirationDate = DateTime.Now.AddDays(3);
sqlBackup.LogTruncation = BackupTruncateLogType.Truncate;
sqlBackup.FormatMedia = false;
sqlBackup.SqlBackup(sqlServer);
}Restore Database
Collapsepublic void RestoreDatabase(String databaseName, String filePath,
String serverName, String userName, String password,
String dataFilePath, String logFilePath)
{
Restore sqlRestore = new Restore();
BackupDeviceItem deviceItem = new BackupDeviceItem(filePath, DeviceType.File);
sqlRestore.Devices.Add(deviceItem);
sqlRestore.Database = databaseName;
ServerConnection connection = new ServerConnection(serverName, userName, password);
Server sqlServer = new Server(connection);
Database db = sqlServer.Databases[databaseName];
sqlRestore.Action = RestoreActionType.Database;
String dataFileLocation = dataFilePath + databaseName + ".mdf";
String logFileLocation = logFilePath + databaseName + "_Log.ldf";
db = sqlServer.Databases[databaseName];
RelocateFile rf = new RelocateFile(databaseName, dataFileLocation);
sqlRestore.RelocateFiles.Add(new RelocateFile(databaseName, dataFileLocation));
sqlRestore.RelocateFiles.Add(new RelocateFile(databaseName+"_log", logFileLocation));
sqlRestore.ReplaceDatabase = true;
sqlRestore.Complete += new ServerMessageEventHandler(sqlRestore_Complete);
sqlRestore.PercentCompleteNotification = 10;
sqlRestore.PercentComplete +=
new PercentCompleteEventHandler(sqlRestore_PercentComplete);
sqlRestore.SqlRestore(sqlServer);
db = sqlServer.Databases[databaseName];
db.SetOnline();
sqlServer.Refresh();
}The portion of code uses full backup features. If you want, you can perform incremental and differential backup as well.Updates: June 8, 2008
In order to use this code, your SQL Server authentication mode needs to be configured as Mixed Mode authentication. If you use Windows Authentication, then you need to modify theServerConnection: CollapseSqlConnection sqlCon = new SqlConnection ("Data Source=Bappi; Integrated Security=True;");
ServerConnection connection = new ServerConnection(sqlCon);Modify the ServerConnection portion of both code samples using this code in order to use Windows Security.
Subscribe to:
Posts (Atom)