Click here to Skip to main content
15,867,990 members
Home / Discussions / C#
   

C#

 
GeneralRe: how to confirm Security risk alert in C# web browser Pin
Richard Deeming25-Feb-14 7:16
mveRichard Deeming25-Feb-14 7:16 
GeneralRe: how to confirm Security risk alert in C# web browser Pin
Bernhard Hiller25-Feb-14 21:39
Bernhard Hiller25-Feb-14 21:39 
QuestionCreating DTO using TDD approach Pin
ramsai197325-Feb-14 1:22
ramsai197325-Feb-14 1:22 
Questionhow to restore a sql database programmatically in c#? Pin
rincy sivan24-Feb-14 23:35
rincy sivan24-Feb-14 23:35 
AnswerRe: how to restore a sql database programmatically in c#? Pin
Nicholas Marty24-Feb-14 23:54
professionalNicholas Marty24-Feb-14 23:54 
AnswerRe: how to restore a sql database programmatically in c#? Pin
OriginalGriff24-Feb-14 23:57
mveOriginalGriff24-Feb-14 23:57 
AnswerRe: how to restore a sql database programmatically in c#? Pin
Raj Mouli26-Feb-14 19:44
Raj Mouli26-Feb-14 19:44 
AnswerRe: how to restore a sql database programmatically in c#? Pin
Raj Mouli26-Feb-14 19:45
Raj Mouli26-Feb-14 19:45 
The following namespaces can be used to access SQL Server 2005 programmatically:

Microsoft.SqlServer.management
Microsoft.SqlServer.Management.NotificationServices
Microsoft.SqlServer.Management.Smo
Microsoft.SqlServer.Management.Smo.Agent
Microsoft.SqlServer.Management.Smo.Broker
Microsoft.SqlServer.Management.Smo.Mail
Microsoft.SqlServer.Management.Smo.RegisteredServers
Microsoft.SqlServer.Management.Smo.Wmi
Microsoft.SqlServer.Management.Trace
SQL
Backup bkpDBFull = new Backup();
/* Specify whether you want to back up database or files or log */
bkpDBFull.Action = BackupActionType.Database;
/* Specify the name of the database to back up */
bkpDBFull.Database = myDatabase.Name;
/* You can take backup on several media type (disk or tape), here I am
 * using File type and storing backup on the file system */
bkpDBFull.Devices.AddDevice(@"D:\AdventureWorksFull.bak", DeviceType.File);
bkpDBFull.BackupSetName = "Adventureworks database Backup";
bkpDBFull.BackupSetDescription = "Adventureworks database - Full Backup";
/* You can specify the expiration date for your backup data
 * after that date backup data would not be relevant */
bkpDBFull.ExpirationDate = DateTime.Today.AddDays(10);

/* You can specify Initialize = false (default) to create a new
 * backup set which will be appended as last backup set on the media. You
 * can specify Initialize = true to make the backup as first set on the
 * medium and to overwrite any other existing backup sets if the all the
 * backup sets have expired and specified backup set name matches with
 * the name on the medium */
bkpDBFull.Initialize = false;

/* Wiring up events for progress monitoring */
bkpDBFull.PercentComplete += CompletionStatusInPercent;
bkpDBFull.Complete += Backup_Completed;

/* SqlBackup method starts to take back up
 * You can also use SqlBackupAsync method to perform the backup
 * operation asynchronously */
bkpDBFull.SqlBackup(myServer);


for more info - http://www.mssqltips.com/sqlservertip/1849/backup-and-restore-sql-server-databases-programmatically-with-smo/[^]
Mouli

QuestionSerialComm Port to send and receive sms Pin
yomag4chi24-Feb-14 21:51
yomag4chi24-Feb-14 21:51 
AnswerRe: SerialComm Port to send and receive sms Pin
Richard MacCutchan24-Feb-14 22:04
mveRichard MacCutchan24-Feb-14 22:04 
AnswerRe: SerialComm Port to send and receive sms Pin
OriginalGriff24-Feb-14 22:29
mveOriginalGriff24-Feb-14 22:29 
Questionhow to prevent form open twice Pin
Aman Susanto24-Feb-14 2:50
Aman Susanto24-Feb-14 2:50 
AnswerRe: how to prevent form open twice Pin
johannesnestler24-Feb-14 3:15
johannesnestler24-Feb-14 3:15 
GeneralRe: how to prevent form open twice Pin
Eddy Vluggen24-Feb-14 6:57
professionalEddy Vluggen24-Feb-14 6:57 
GeneralRe: how to prevent form open twice Pin
johannesnestler24-Feb-14 8:12
johannesnestler24-Feb-14 8:12 
AnswerRe: how to prevent form open twice Pin
BillWoodruff24-Feb-14 6:41
professionalBillWoodruff24-Feb-14 6:41 
AnswerRe: how to prevent form open twice Pin
Richard Deeming24-Feb-14 9:00
mveRichard Deeming24-Feb-14 9:00 
GeneralRe: how to prevent form open twice Pin
BillWoodruff24-Feb-14 13:21
professionalBillWoodruff24-Feb-14 13:21 
SuggestionRe: how to prevent form open twice Pin
azhar9925-Feb-14 20:50
azhar9925-Feb-14 20:50 
QuestionA first chance exception of type 'System.Data.SqlServerCe.SqlCeException' occurred in Microsoft.Phone.Data.Internal.ni.dll Pin
Gene Lim23-Feb-14 22:40
Gene Lim23-Feb-14 22:40 
AnswerRe: A first chance exception of type 'System.Data.SqlServerCe.SqlCeException' occurred in Microsoft.Phone.Data.Internal.ni.dll Pin
Naveen Kumar Krishnan24-Feb-14 1:18
Naveen Kumar Krishnan24-Feb-14 1:18 
GeneralRe: A first chance exception of type 'System.Data.SqlServerCe.SqlCeException' occurred in Microsoft.Phone.Data.Internal.ni.dll Pin
Gene Lim24-Feb-14 2:53
Gene Lim24-Feb-14 2:53 
QuestionSQL SELECT Current User c# Pin
mcgurdan22-Feb-14 9:49
mcgurdan22-Feb-14 9:49 
AnswerRe: SQL SELECT Current User c# Pin
Ravi Bhavnani22-Feb-14 11:13
professionalRavi Bhavnani22-Feb-14 11:13 
QuestionHow do I inherit ComboBox to implement my function Pin
Member 1041329221-Feb-14 21:50
professionalMember 1041329221-Feb-14 21:50 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.