Re: backup database - C# Discussion Boards

dan!sh 13-Dec-09 21:42

13-Dec-09 21:42

Did you read the second and the third code blocks?

The object sender will be the picturebox which fires the event. This means, that if you do a mouse enter on picturebox1, the sender will be picturebox1. If you do mouse enter on picturebox2, sender will be picturebox2. Now, if you cast sender to a picturebox, and change its image, it will change image of only the concerned picturebox.

50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!

Re: Change currently image?

Luc Pattyn13-Dec-09 22:54

Luc Pattyn

13-Dec-09 22:54

d@nish wrote:
Did you read ... ?

I like rhetorical questions. Laugh | :laugh:

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages

Re: Change currently image?

dennis_max2715-Dec-09 20:37

dennis_max27

15-Dec-09 20:37

Fixed the problem now. Thaks for the reply's!!

backup database [modified]

farokhian13-Dec-09 18:36

farokhian

13-Dec-09 18:36

Hi all
I use SQLEXPRESS and this is my connectionstring:

@"Data Source=.\SQLEXPRESS;AttachDbFilename=" + Application.StartupPath + "\\Data\\mydatabase.mdf;" + "Integrated Security=True;User Instance=True";

and i use sqlconnection to connect to my database.
and i execute my backup command like below:
string backup = string.Format("backup database mydatabase TO DISK= '{0}'", addr);
backup.ExecuteNonQuery();

but errormessage is :
Could not locate entry in sysdatabases for database 'mydatabase'. No entry found with that name. Make sure that the name is entered correctly.
BACKUP DATABASE is terminating abnormally.
Changed database context to 'master'.

please somebody help me.

modified on Monday, December 14, 2009 4:15 AM

Re: backup database

dan!sh 13-Dec-09 18:58

dan!sh

13-Dec-09 18:58

To backup and restore restore sql server, I would say make use of classes under SQLDMO namespace. Take a look at SQLServerClass class and the BackupClass class in that namespace. They offer required methods and properties.

50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!

Re: backup database

farokhian13-Dec-09 19:17

farokhian

13-Dec-09 19:17

thx.
I want to know what is the required command for backup and restore?
I want to add a utility to my application that when user need a backup from database or restore to one of his backup databases , my application enable to do it.

Re: backup database

Vimalsoft(Pty) Ltd13-Dec-09 19:54

Vimalsoft(Pty) Ltd

13-Dec-09 19:54

There were previously a lot of Questions ask about this

http://www.codeproject.com/Messages/3119251/Re-back-up-sql-data-programmetically.aspx[^]

There are more just search the Forum for messages posted

Vuyiswa Maseko,

Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code.

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

Re: backup database

farokhian13-Dec-09 22:15

farokhian

13-Dec-09 22:15

I use SQLEXPRESS and this is my connectionstring:

@"Data Source=.\SQLEXPRESS;AttachDbFilename=" + Application.StartupPath + "\\Data\\mydatabase.mdf;" + "Integrated Security=True;User Instance=True";

and i use sqlconnection to connect to my database.
and i execute my backup command like below:
string backup = string.Format("backup database mydatabase TO DISK= '{0}'", addr);
backup.ExecuteNonQuery();

but errormessage is :
Could not locate entry in sysdatabases for database 'mydatabase'. No entry found with that name. Make sure that the name is entered correctly.
BACKUP DATABASE is terminating abnormally.
Changed database context to 'master'.

please somebody help me.

Re: backup database

J4amieC13-Dec-09 22:27

J4amieC

13-Dec-09 22:27

Repeating the same question as if you did not hear the response will not get you further response.

except this one, of course!

Re: backup database

farokhian13-Dec-09 22:49

farokhian

13-Dec-09 22:49

If you pay more attention i modified my question !
I want to know that can i backup from mydatabase in SQLEXPRESS by the code that i notice?

Re: backup database

Vimalsoft(Pty) Ltd13-Dec-09 23:22

Vimalsoft(Pty) Ltd

13-Dec-09 23:22

Because there is no database with the name 'mydatabase' the syntax of the backup database is incorrect. Here are two Sp's use them

For Backup

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go


-- backup a database
ALTER PROCEDURE [dbo].[sp_BackupDatabase]

	@databasename varchar(32),
	@path varchar(256),
	@filename varchar(64)

AS

set nocount on

declare @sql varchar(4000)

select @sql = 		'BACKUP DATABASE ' + ltrim(rtrim( @databasename ))
select @sql = @sql + 	'   TO DISK = ''' + ltrim(rtrim(@path)) + ltrim(rtrim(@filename)) + ''' '
select @sql = @sql + 	'   WITH INIT'
--print @sql
execute ( @sql )

select 'Database successfully backed up!' [Result]

and later you might want to Restore and you can use this

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go



ALTER PROCEDURE [dbo].[sp_RestoreDatabase] 

	@dbname char(32), 				-- the database name to restore as
	@filename char(64), @path char(256)		-- the location of the backuped up database file	(on the SQL Server)

AS

set nocount on

declare @sql nvarchar(3000)
 

-- Restore the database
select @sql = 			' RESTORE DATABASE ' + ltrim(rtrim( @dbname )) + ' FROM DISK = ''' + ltrim(rtrim(@path)) + ltrim(rtrim( @filename )) + ''' ' 
select @sql = ltrim(rtrim(@sql)) + 	'    WITH '
select @sql = ltrim(rtrim(@sql)) + 	'    MOVE ''' + 'TNGoedit_Data' + ''' TO ''' + ltrim(rtrim(@path)) + ltrim(rtrim( @dbname )) + '.mdf' + ''' , '	-- logical file name to physical name
select @sql = ltrim(rtrim(@sql)) + 	'    MOVE ''' + 'TNGoedit_Log' + ''' TO ''' + ltrim(rtrim(@path)) + ltrim(rtrim( @dbname )) + '_log.ldf' + ''' '	-- logical file name to physical name
select @sql = ltrim(rtrim(@sql)) +  '    ,REPLACE,RECOVERY;'
--select @sql = ltrim(rtrim(@sql)) + 	'    MOVE ''' + ltrim(rtrim(@dbname)) + '_Data' + ''' TO ''' + ltrim(rtrim(@path)) + ltrim(rtrim( @dbname )) + '.mdf' + ''' , '	-- logical file name to physical name
--select @sql = ltrim(rtrim(@sql)) + 	'    MOVE ''' + ltrim(rtrim(@dbname)) + '_Log' + ''' TO ''' + ltrim(rtrim(@path)) + ltrim(rtrim( @dbname )) + '_log.ldf' + ''' '	-- logical file name to physical name
print @sql
execute ( @sql )

-- Was the command successful or was there a problem
if ( (select @@Error) = 0 ) begin
	-- Put an entry into oDirect.dbo.tbl_dbRef
	-- execute ( 'sp_DataSet_Save ''' + @xml + ''' ' ) 	

	-- TODO: restore the users

  select 'Restore Successful' [Result]
end
else begin
   select 'Restore Unsuccessful' [Result]
end

what is the diffrennce between String & string

shabi uz zaman13-Dec-09 17:30

shabi uz zaman

13-Dec-09 17:30

what is the diffrennce between String & string

Re: what is the diffrennce between String & string

Abhinav S13-Dec-09 17:33

Abhinav S

13-Dec-09 17:33

There are no differences. string is an alias for String [^].

Some people use String when they are accessing the String class and string when they are declaring a constant.

There's nothing left in my right brain and nothing right in my left brain.

Re: what is the diffrennce between String & string

puri keemti13-Dec-09 21:07

puri keemti

13-Dec-09 21:07

String comes from the .NET class System.String and string (lower case) is a
C# alias for System.String.

What is the difference between static,readonly and constant ?

md_azy13-Dec-09 16:16

md_azy

13-Dec-09 16:16

Hi ,

What is the difference between static,readonly and constant

Thanks and advance,
Azeez.

Re: What is the difference between static,readonly and constant ?

EliottA13-Dec-09 17:22

EliottA

13-Dec-09 17:22

constant is constant

static is static

readonly is readonly.

Honestly, wikipedia isn't available in your native tongue? Or is the first chapter of your book to difficult...

Check out the CodeProject forum Guidelines[^]
The original soapbox 1.0 is back![^]

Re: What is the difference between static,readonly and constant ?

Abhinav S13-Dec-09 17:28

Abhinav S

13-Dec-09 17:28

There are pleny of links available on the internet.
Here - try this one [^].

There's nothing left in my right brain and nothing right in my left brain.

Re: What is the difference between static,readonly and constant ?

dan!sh 13-Dec-09 17:33

dan!sh

13-Dec-09 17:33

EliottA wrote:
Honestly, wikipedia isn't available in your native tongue?

Don't you trust MSDN?

50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!

Re: What is the difference between static,readonly and constant ?

Abhinav S13-Dec-09 17:35

Abhinav S

13-Dec-09 17:35

d@nish wrote:
Don't you trust MSDN?

Never a good sign, it it ? Wink | ;)

There's nothing left in my right brain and nothing right in my left brain.

Re: What is the difference between static,readonly and constant ?

puri keemti13-Dec-09 21:09

puri keemti

13-Dec-09 21:09

Static : - Which shared the value with multiple instance

Readonly :- once define.. you can change the value through constructor only at the time of creating instance..

<br />
Constant :- once define; you can't change it,,

When we have to use abstract and when we have to use interface ?

md_azy13-Dec-09 16:11

md_azy

13-Dec-09 16:11

Hi ,

When we have to use abstract and when we have to use interface in real time coding

Thanks in advance
Azeez.

Re: When we have to use abstract and when we have to use interface ?

puri keemti13-Dec-09 21:15

puri keemti

13-Dec-09 21:15

Interface is lightweight than Abstract....

<br />
Abstract <br />
When you don't clear about the future expansion of the framework... <br />
For creating multiple version application..<br />
For creating products...<br />
For putting common behavior so that drived classes can use it without writing code again & again...

Interface<br />
For defining rules and business policies...<br />
To enforce something....<br />
to overcome the problem of multiple inhetitence

Re: When we have to use abstract and when we have to use interface ?

PIEBALDconsult14-Dec-09 6:24

PIEBALDconsult

14-Dec-09 6:24

You never have to use either.

When defining a group of similar classes you may find it beneficial to define an interface (or more than one) that specifies what things the classes have in common.

If there is some common code that the classes should share, you may want to put that code in a base class. If that base class itself should not be instantiated, then you may want to mark it as abstract.

In the long run, you probably should always define an interface whenever you define a base class.

How to collect and download links with documents automatics?

Member 216810313-Dec-09 11:15

Member 2168103

13-Dec-09 11:15

There are some thousands of xmlfiles i want to have from internet, but instead of downloading them one by one, is it possible to build an application that can do that for me?

Exempelfile: http://somedomain.com/XmlResults/Id=100

so, from id=100 it goes up 1 step upto id=10000 and each step is 1 xmldocument

if someone know how i should start to build it, it would be nice to hear from you.

Thanks!!

Re: How to collect and download links with documents automatics?

Mycroft Holmes13-Dec-09 13:50

Mycroft Holmes

13-Dec-09 13:50

So you need to create a loop that increments the ID value and executes the download.

Look into while or for loops
Use the string object to modify the request statement

string sFile = string.format{"http//somedomain....{0}",ID);

I suggest getting a book on basic C# programing and work through the examples, learning from forum posts is not really a good idea.

Never underestimate the power of human stupidity
RAH

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