Re: how to restore a sql database programmatically in c#? - C# Discussion Boards

how to confirm Security risk alert in C# web browser

Abhinaw Kumar Singh25-Feb-14 2:16

25-Feb-14 2:16

I am developing a application with a WebBrowser control that login to site, but it give security alert:

Revocation information for the security certificate for this site is not available. Do you want to proceed?

I want to that its automatically confirm this alert using code.

I find many question on this issue but they are not useful in my case.

Re: how to confirm Security risk alert in C# web browser

Pete O'Hanlon25-Feb-14 3:11

Pete O'Hanlon

25-Feb-14 3:11

You shouldn't attempt to confirm this automatically. This is a security notification for the user and you should not attempt to circumvent it because you will be hiding potential issues from the client.

Re: how to confirm Security risk alert in C# web browser

Abhinaw Kumar Singh25-Feb-14 6:18

Abhinaw Kumar Singh

25-Feb-14 6:18

yes I know that, but I want to do it for my use.

Re: how to confirm Security risk alert in C# web browser

Richard Deeming25-Feb-14 7:16

Richard Deeming

25-Feb-14 7:16

Don't try to find code to hide the issue with the certificate. Instead, fix the issue with the certificate.

If the certificate really is valid, then there's a problem on the computers which are displaying the message. Fix that problem instead. There are some suggestions in this Microsoft Knowledgebase article[^] which might help.

There is no good reason to hide this error from your users.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: how to confirm Security risk alert in C# web browser

Bernhard Hiller25-Feb-14 21:39

Bernhard Hiller

25-Feb-14 21:39

Installing the certificate of that site on your computer might help.

Creating DTO using TDD approach

ramsai197325-Feb-14 1:22

ramsai1973

25-Feb-14 1:22

Hi All,

I'm new to TDD. I need to return a DTO containing the the details of the Customers referenced by CustomerID in C# as given below.

The Output DTO should contain the following properties:

int CustomerID
String CustomerName
String[] Addresses

Given below are the data repository classes with properties:

Customer class
{
public int CustomerID {get; set;}
public string CustomerName {get; set;}
public int[] AddressId {get; set;}
}

Address class
{
public int AddressId {get; set;}
public string Street {get; set;}
public string City {get; set;}
}

Note: Should be a TDD approach

Please help me with sample code

Thanks in advance,
Ram

how to restore a sql database programmatically in c#?

rincy sivan24-Feb-14 23:35

rincy sivan

24-Feb-14 23:35

hi
how to restore a sql database programmatically in c#?

Re: how to restore a sql database programmatically in c#?

Nicholas Marty24-Feb-14 23:54

Nicholas Marty

24-Feb-14 23:54

Use the RESTORE command and connect to the database server with an user that has access to do restores. (e.g. server admin)

You can just use the normal SqlConnection and SqlCommands to do that

Important Note: The path to the backup you provide are relative to the SqlServer. If it is not the same server as your application you need to copy the files to the server (or a network share?) first where the database server can restore the backup from.

Re: how to restore a sql database programmatically in c#?

OriginalGriff24-Feb-14 23:57

OriginalGriff

24-Feb-14 23:57

Try this: Backing up an SQL Database in C#[^] - it includes code for backup and restore.

Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952)
Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)

Re: how to restore a sql database programmatically in c#?

Raj Mouli26-Feb-14 19:44

Raj Mouli

26-Feb-14 19:44

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

Mouli

Re: how to restore a sql database programmatically in c#?

Raj Mouli26-Feb-14 19:45

Raj Mouli

26-Feb-14 19:45

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

SerialComm Port to send and receive sms

yomag4chi24-Feb-14 21:51

yomag4chi

24-Feb-14 21:51

Sir, kind you help me with code to read and send sms through the internet and gsm modem.

Thank you.

Re: SerialComm Port to send and receive sms

Richard MacCutchan24-Feb-14 22:04

Richard MacCutchan

24-Feb-14 22:04

Firstly, please read http://www.codeproject.com/Messages/1278604/How-to-get-an-answer-to-your-question.aspx[^]. Secondly, posting your question into Google will find lots of information to get you started.

Re: SerialComm Port to send and receive sms

OriginalGriff24-Feb-14 22:29

OriginalGriff

24-Feb-14 22:29

Google is your friend: Be nice and visit him often. He can answer questions a lot more quickly than posting them here...

A very quick search using your subject as the search term gave three quarters of a million hits: SerialComm Port to send and receive sms[^]

In future, please try to do at least basic research yourself, and not waste your time or ours.

how to prevent form open twice

Aman Susanto24-Feb-14 2:50

Aman Susanto

24-Feb-14 2:50

hi every body, i use dynamically toolstripmenu to generate menu, i don't know how to prevent form open twice, please help.

this is my code :

ToolStripMenuItem SubMenu = new ToolStripMenuItem(sdr1["description"].ToString(), null, new EventHandler(klikMenu));

private void klikMenu(object sender, EventArgs e)
{
string sFormName = "AIO_System." + ((ToolStripMenuItem)sender).Tag.ToString();
System.Reflection.Assembly asm = System.Reflection.Assembly.GetExecutingAssembly();

Form frm = (Form)asm.CreateInstance(sFormName); <======
if(!IsFormOpen(frm.GetType()))
{
frm.Owner = this;
frm.Show();
}
else
frm.Focus();
}
}

private bool IsFormOpen(Type formType)
{
foreach (Form form in Application.OpenForms)
if (form.GetType().Name == form.Name)
return true;
return false;
}

Re: how to prevent form open twice

johannesnestler24-Feb-14 3:15

johannesnestler

24-Feb-14 3:15

If it's always the same Form, just cache it, and hide/reshow/bring to front as apropiate. The problem is you are creating always a new Form (via reflection), this is also not very "fast" so caching the "frm" variable has another advantage (just make it a member and initialize if null).

Re: how to prevent form open twice

Eddy Vluggen24-Feb-14 6:57

Eddy Vluggen

24-Feb-14 6:57

johannesnestler wrote:
The problem is you are creating always a new Form (via reflection), this is also not very "fast" so caching the "frm" variable has another advantage

I'd like to point out that reflection is not "slow". Creating a form is always an expensive operation, even if you call the constructor directly.

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

Re: how to prevent form open twice

johannesnestler24-Feb-14 8:12

johannesnestler

24-Feb-14 8:12

yes, that's a good and valid point, in this case the "impact" by reflecting the type is neglectible. Thank you for pointing that out.
But what luck for me, that my advice isn't totally wrong - and in general it's always a good habit to do "maximum caching of type information" when reflecting...

Re: how to prevent form open twice

BillWoodruff24-Feb-14 6:41

BillWoodruff

24-Feb-14 6:41

You can do this without using Reflection; you can use Activator.CreateInstance:

Form newForm = (Form) Activator.CreateInstance(Type.GetType(YourNameSpace + "." + YourNewFormName));

Keep in mind that when you create a new Form of some specific Type, like a new "Form4," and cast it to the generic Type 'Form: the new Form has an empty string for its 'Name property. So, you can't test if the new Form exists in the Application.OpenForms collection by using its Name. To fix that: give the new Form a Name when you create it:

Form newForm = (Form) Activator.CreateInstance(Type.GetType(YourNameSpace + "." + YourNewFormName));
newForm.Owner = this;
newForm.Name = YourNewFormName;
newForm.Show();

I'd like to suggest you define your own List<string> of currently opened secondary Form names; it will simplify testing for an instance being already opened. You can also pre-define a string with your NameSpace plus "." to make creating a new Form simpler.

“The best hope is that one of these days the Ground will get disgusted enough just to walk away ~ leaving people with nothing more to stand ON than what they have so bloody well stood FOR up to now.” Kenneth Patchen, Poet

modified 24-Feb-14 12:51pm.

Re: how to prevent form open twice

Richard Deeming24-Feb-14 9:00

Richard Deeming

24-Feb-14 9:00

Looking at your code, the problem appears to be with the frm.Focus(); line:

You create a new instance of the form type;
You check to see if there is an open form of the same type;
If there is, you call the Focus method on the new form instance;

I suspect that calling Focus on an invisible form causes it to be shown.

Try something like this instead:

private Form FindOpenFormOfType(Type formType)
{
    foreach (Form form in Application.OpenForms)
    {
        if (form.GetType() == formType)
        {
            return form;
        }
    }
    
    return null;
}

private void klikMenu(object sender, EventArgs e)
{
    string sFormName = "AIO_System." + ((ToolStripMenuItem)sender).Tag.ToString();
    System.Reflection.Assembly asm = System.Reflection.Assembly.GetExecutingAssembly();
    Type formType = asm.GetType(sFormName);
    
    Form frm = FindOpenFormOfType(formType);
    if (frm == null)
    {
        frm = (Form)Activator.CreateInstance(formType);
        frm.Owner = this;
        frm.Show();
    }
    else
    {
        frm.Focus();
    }
}

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: how to prevent form open twice

BillWoodruff24-Feb-14 13:21

BillWoodruff

24-Feb-14 13:21

Richard Deeming wrote:
I suspect that calling Focus on an invisible form causes it to be shown.

In Windows Forms calling 'Focus on an instantiated, but hidden, Form will not cause it become visible.

Your code would work "as is" if you removed the modifier ".Tag" in the line where 'sFormName is constructed ... but, we can't know, from the information the OP presented, what they've done to create a 'Tag property for the ToolStripMenuItems ... that's not shown in the code posted here.

Re: how to prevent form open twice

azhar9925-Feb-14 20:50

azhar99

25-Feb-14 20:50

if(frm != null)
{
MessageBox.Show("already running");
}

A first chance exception of type 'System.Data.SqlServerCe.SqlCeException' occurred in Microsoft.Phone.Data.Internal.ni.dll

Gene Lim23-Feb-14 22:40

Gene Lim

23-Feb-14 22:40

SQL

I have added a new column to my database table. When I have added this new columnm, the first chance exception start appearing. When I debugged it, it stated the code line
MLongListSelector.ItemsSource = c.ToDoList.ToList(); is the next statement to execute that causes the problem. What have I done wrong there?

using (DatabaseContext c = new DatabaseContext(DatabaseContext.ConnectionString))
        {
            c.CreateIfNotExists();
            c.LogDebug = true;
            //output todolist data from database
            MLongListSelector.ItemsSource = c.ToDoList.ToList();
        }

Re: A first chance exception of type 'System.Data.SqlServerCe.SqlCeException' occurred in Microsoft.Phone.Data.Internal.ni.dll

Naveen Kumar Krishnan24-Feb-14 1:18

Naveen Kumar Krishnan

24-Feb-14 1:18

Check the column name and connection to database

Re: A first chance exception of type 'System.Data.SqlServerCe.SqlCeException' occurred in Microsoft.Phone.Data.Internal.ni.dll

Gene Lim24-Feb-14 2:53

Gene Lim

24-Feb-14 2:53

I have finally solved it . There was a problem in creating the database. instead of CreateIfNotExist() i used If(!DatabaseExist()){CreateDatabase();}
This solved it. It doesn't really make sense to me as it is actually the same thing. But it works.

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