Re: error while backup DB from C# "Backup failed for Server" - C# Discussion Boards

Re: in microsoft report viewer i want change datasource in run time

30-Nov-10 10:18

i add data set &
add 4 table in this data set and design 4 reports for each table
i want to choose the report & set datasource to report and show in microsoft report view
i try this code but failed

ReportOfEng.LocalReport.ReportEmbeddedResource = "follow_up.Report1.rdlc";
     ReportDataSource ds = new ReportDataSource();
     ds.Name = dataSet11.Movements.TableName;
     ds.Value = dataSet11.Movements;
     ReportOfEng.LocalReport.DataSources.Clear();
     ReportOfEng.LocalReport.DataSources.Add(ds);
     this.movementsTableAdapter1.Fill(dataSet11.Movements);
     this.ReportOfEng.RefreshReport();

then in runtime when i btnclick
this message appear in report
"data source instance has not been supplied for dataset"

so what i can do Big Grin | :-D

Pete O'Hanlon30-Nov-10 11:32

30-Nov-10 11:32

Well, LocalReport.DataSources has been cleared, and yet you haven't done a LocalReport.DataSources.Add.

I have CDO, it's OCD with the letters in the right order; just as they ruddy well should be

Forgive your enemies - it messes with their heads

Re: in microsoft report viewer i want change datasource in run time

Nabawoka30-Nov-10 19:24

30-Nov-10 19:24

i add the datasource in program but i forget to add in this block code Wink | ;)

so the error appear in the report
so again what can i do Big Grin | :-D

I Get it :D:D ;)

Nabawoka30-Nov-10 22:12

30-Nov-10 22:12

depend on RadioButton Check Big Grin | :-D

if (rdbEng.Checked==true)
{
    ReportsOfRun.Reset();
    ReportsOfRun.LocalReport.ReportEmbeddedResource = "follow_up.Report_Eng.rdlc";
    ds.Name = "DataSetReport_Eng_Table";
    ds.Value = Eng_TableBindingSource;
    //ReportsOfRun.LocalReport.DataSources.Clear();
    ReportsOfRun.LocalReport.DataSources.Add(ds);
    ReportsOfRun.DocumentMapCollapsed = true;
    this.Eng_TableTableAdapter.Fill(this.DataSetReport.Eng_Table,int.Parse(txtEngCode.Text));
}
else if (rdbMonth.Checked==true)
{
    ReportsOfRun.Reset();
    ReportsOfRun.LocalReport.ReportEmbeddedResource = "follow_up.Report_Month.rdlc";
    ds.Name = "DataSetReport_Month_Table";
    ds.Value = Month_TableBindingSource;
    //ReportsOfRun.LocalReport.DataSources.Clear();
    ReportsOfRun.LocalReport.DataSources.Add(ds);
    ReportsOfRun.DocumentMapCollapsed = true;
   this.Month_TableTableAdapter.Fill(this.DataSetReport.Month_Table, txtMonth.Text);
}

thanx to how try to help me

Re: I Get it :D:D ;)

Pete O'Hanlon30-Nov-10 22:24

30-Nov-10 22:24

Well done, and well done for showing your solution. That's a bit of class that is. Big Grin | :-D

I have CDO, it's OCD with the letters in the right order; just as they ruddy well should be

Forgive your enemies - it messes with their heads

error while backup DB from C# "Backup failed for Server" [modified]

Nabawoka30-Nov-10 9:53

Re: error while backup DB from C# "Backup failed for Server"

30-Nov-10 9:53

i call this method by button and this exception appeare
exception "Backup failed for Server"

public void BackupDatabase(String databaseName,  String destinationPath)
{
    Backup sqlBackup = new Backup();

    sqlBackup.Action = BackupActionType.Database;
    sqlBackup.BackupSetDescription = "FollowUPBackUP:" + DateTime.Now.ToShortDateString();
    sqlBackup.BackupSetName = "FollowUP";

    sqlBackup.Database = databaseName;

    BackupDeviceItem deviceItem = new BackupDeviceItem(destinationPath, DeviceType.File);
    string instantname = @".\sqlexpress";
    ServerConnection connection = new ServerConnection(instantname);
    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(10);
    sqlBackup.LogTruncation = BackupTruncateLogType.Truncate;

    sqlBackup.FormatMedia = false;

    sqlBackup.SqlBackup(sqlServer);
}

modified on Wednesday, December 1, 2010 1:17 AM

Henry Minute30-Nov-10 13:36

Henry Minute

30-Nov-10 13:36

I'm pretty sure that the error message was longer than just "Backup failed for Server". If it was then it might help people, to help you, if you edited your question to include the full message.

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

How to block shutdown/logoff in Windows Vista?

turbosupramk330-Nov-10 9:43

30-Nov-10 9:43

Hi,

I'm trying to write code to block shutting down or logging off in Windows Vista.

I've tried this code but it does not work
http://community.bartdesmet.net/blogs/bart/archive/2006/10/25/Windows-Vista-_2D00_-ShutdownBlockReasonCreate-in-C_2300_.aspx

Has anyone done this and do they have a working example?

Thanks for reading!

Pete O'Hanlon30-Nov-10 10:10

30-Nov-10 10:10

Why would you want to do this?

I have CDO, it's OCD with the letters in the right order; just as they ruddy well should be

Forgive your enemies - it messes with their heads

turbosupramk330-Nov-10 10:22

30-Nov-10 10:22

Hi Pete,

Are you able to help?

I'm having a problem with remote desktop logging off the local machine when the remote session is ended. Even if this is only a temporary work around until I figure out why this is happening with vista and not xp, I would like to implement it immediately.

Pete O'Hanlon30-Nov-10 11:08

30-Nov-10 11:08

I've used a version of this code in the past, and it works fine. What problem are you having with it?

I have CDO, it's OCD with the letters in the right order; just as they ruddy well should be

Forgive your enemies - it messes with their heads

turbosupramk330-Nov-10 11:18

30-Nov-10 11:18

It won't compile and there are duplicate code entries as well as some other things I had to do to get it to compile.

I have something that compiled and did work as far as stopping me from logging off when I'm in front of the machine, but it still doesn't seem to block the machine from logging off when the remote desktop session is disconnected.

Pete O'Hanlon30-Nov-10 11:21

30-Nov-10 11:21

I'm not aware of anything that will prevent this happening when the remote desktop session disconnected.

I have CDO, it's OCD with the letters in the right order; just as they ruddy well should be

Forgive your enemies - it messes with their heads

turbosupramk31-Dec-10 3:07

1-Dec-10 3:07

Somehow it isn't an issue when I take an XP machine and remote desktop into a Vista machine. The session is saved when the XP machine is disconnected, etc.

When it is vista to vista, the problems start occurring. There has to be a way to emulate what is happening with XP.

Pete O'Hanlon1-Dec-10 3:30

1-Dec-10 3:30

I'm sorry that I can't help you. I'll be watching this with a lot of interest. I hope you get it resolved soon.

I have CDO, it's OCD with the letters in the right order; just as they ruddy well should be

Forgive your enemies - it messes with their heads

turbosupramk32-Dec-10 9:44

2-Dec-10 9:44

Thanks!

This worked last night, I'll continue to test it throughout the week. I wrapped it in a c# application that blocks logging off without verification first. The same can be done for XP, but the first command is a bit different, it is " tscon 0 /dest:console " instead.

I through the wait commands in, because a few times that I was testing it would release the session before the lock command could run and then it would not lock the machine, so an unlocked desktop was left sitting at the office, not something I wanted to happen. Thanks for the help and encouragement Pete.

tscon.exe RDP-Tcp#0 /dest:console

wait 1

rundll32.exe user32.dll, LockWorkStation

wait 1

exit

Pete O'Hanlon3-Dec-10 11:11

3-Dec-10 11:11

Good job.

I have CDO, it's OCD with the letters in the right order; just as they ruddy well should be

Forgive your enemies - it messes with their heads

Rebooting to safe mode...

Jacob D Dixon30-Nov-10 7:08

Jacob D Dixon

30-Nov-10 7:08

How could one reboot a local computer to safe mode using C#?

I have used google to search for this and not finding much. I did find a question posted for the exact same thing here on codeproject from '06 but the reply the guy got was this was not possible.

I see this for shutting down or rebooting:
http://pinvoke.net/default.aspx/wtsapi32/WTSShutdownSystem.html[^]

Before you say this cannot be done, I currently use a Windows application that can reboot a computer to safe mode. Not sure how they do it, but they are somehow.

Henry Minute30-Nov-10 7:52

Henry Minute

30-Nov-10 7:52

I have never tried this but your question intrigued me so I did a little googling.

If the OS on the computer is XP or before how about temporarily editing Boot.ini to add a /SAFEBOOT switch (source[^]), with a runonce registry entry to reset afterwards.

I'm not sure how Vista and Weven work but a similar technique might be possible.

Jacob D Dixon30-Nov-10 8:20

Jacob D Dixon

30-Nov-10 8:20

Well you came up with more than I did. I was hoping to get around manually editing the boot ini file with my code. Even if I did that would it go off once it booted into safe mode or will it continue to boot into safe mode every time it reboots?

Note:
I guess I could try opening reflector and finding this code and how they are doing it. Do you know if this is legal for me to do?

Henry Minute30-Nov-10 9:26

Henry Minute

30-Nov-10 9:26

Jacob D Dixon wrote:
Note:
I guess I could try opening reflector and finding this code and how they are doing it. Do you know if this is legal for me to do?

Probably not, if you use the code directly. Although if it's not obfuscated there is no harm in just having a look, to satisfy your curiosity.

I used to do a similar thing back in the DOS days with the Autoexec.bat and Config.sys for some programs (Games mostly) that required non standard settings.

In your situation, make a copy of Boot.ini, rename it Boot.ini.safe (safe mode), or similar. Make another copy and rename it Boot.ini.std (standard mode). Modify the .safe file to include the /SAFEBOOT stuff.

BTW: Try the next bit out manually first, to make sure that it works.

I used to do the next bit using batch files, you could do the same, or write a small app to do it.
1. Delete Boot.ini
2. Depending on whether you're going from standard to safe, or the other way, copy the Boot.ini.safe/Boot.ini.std file as Boot.ini.
4. When going to Safe mode add the entry to Runonce in the registry to run the app/batch that prepares for standard boot on next restart.
3. Restart.

[Edit]
Just discovered that step 4, above won't work See Notes section in this[^].

Hmmm and it seemed like such a good idea. Frown | :(

[/Edit]

Jacob D Dixon1-Dec-10 3:44

Jacob D Dixon

1-Dec-10 3:44

LOL.

Let me give some things a try. Your suggestions got me further than I was. There are some things that I want to know how this application does stuff. It also provides like a VNC redirecting type function where the control center application is on your computer, then you have the server, then you have agents (which could be on a different network behind a different firewall). So the agent started the VNC with the server, then somehow the server redirects all that traffic to the control center.

It is all a learning curb for me. So my way of learning is trying to duplicate the server / client application they made (slimmed down version of course).

Let me try some things and also snoop around in their code and I'll let you know what info I come up with. thanks for the information you already provided!