C# Discussion Boards - CodeProject

3-Aug-13 1:11

I am working on new project and i want to make a backup for my database and restore it again using c# but i don`t want to install SQL server on pc`s client.
So, i need to work on two points:
1- How to protect this database file ".mdf" with password.
2- Backup and Restore for this single file ".mdf"
Can any one help me?

NOTE: I DON`T WANT TO INSTALL SQL SERVER FULL Version, Just lite one to UNDERSTAND .mdf FILE

eng. Awad A. Bekhet
BSc. of Computer Engineering
Embedded Systems Engineer
htttp://about.me/AwadBekhet

modified 3-Aug-13 12:01pm.

Code-Hunt3-Aug-13 1:55

Code-Hunt

3-Aug-13 1:55

for password protection you can use MEDIAPASSWORD option

e.g. backup database abc to disk='c:\abc.bak' with MEDIAPASSWORD='1234'

and for you other question have to check.. Poke tongue | ;-P

Awad Bekhet3-Aug-13 2:13

3-Aug-13 2:13

thanks for reply
but i am using smo class not sql query

Code-Hunt3-Aug-13 2:19

Code-Hunt

3-Aug-13 2:19

smorestore-database-name-change.aspx[^]

you can check this link..hope it will help Smile | :)

Awad Bekhet3-Aug-13 4:08

3-Aug-13 4:08

Thanks

I had already did it, Thumbs Up | :thumbsup:

backup and restore, but there is must be a server (installed sql sever) Frown | :(

, can i do this with no server.... Sigh | :sigh:

jschell3-Aug-13 5:16

jschell

3-Aug-13 5:16

I am curious how you are managing to use SQL Server without installing SQL Server?

Awad Bekhet3-Aug-13 5:59

3-Aug-13 5:59

I mean NO SQl SERVER MANAGEMENT STUDIO(FULL Version), off course, lite version will be installed to understand .mdf file

Pete O'Hanlon3-Aug-13 21:59

Pete O'Hanlon

3-Aug-13 21:59

Make your mind up. Here you state it's just Management Studio you don't want to install, yet you state above that you don't want to install any Sql Server.

I was brought up to respect my elders. I don't respect many people nowadays.

CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier

Eddy Vluggen3-Aug-13 5:54

Eddy Vluggen

3-Aug-13 5:54

awad bekhet wrote:
NOTE: I DON`T WANT TO INSTALL SQL SERVER

You can't use Sql Server without installing it. Try Microsoft Access.

Bastard Programmer from Hell Suspicious | :suss:

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

Awad Bekhet3-Aug-13 6:00

3-Aug-13 6:00

I mean NO SQl SERVER MANAGEMENT STUDIO(FULL Version), off course, lite version will be installed to understand .mdf file

Eddy Vluggen3-Aug-13 22:58

Eddy Vluggen

3-Aug-13 22:58

There is no Sql Server Lite. Sql Server needs a full database-server to operate. SQLite is a different database-format altogether.

Bastard Programmer from Hell Suspicious | :suss:

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

Awad Bekhet3-Aug-13 23:40

3-Aug-13 23:40

That version which was been installed with visual studio, whats its name ? I mean it.

Eddy Vluggen4-Aug-13 8:22

Eddy Vluggen

4-Aug-13 8:22

Awad Bekhet wrote:
That version which was been installed with visual studio, whats its name

Sql Server Express[^]; a free version of the server-software. It's limited to 4Gb, which is still a lot. Take note that a lot of installers can install this on your behalf.

Awad Bekhet wrote:
I mean it.

Are you sure? (Abort, Retry, Fail)?

Bastard Programmer from Hell Suspicious | :suss:

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

html encode for datagridview

Richard Deeming5-Aug-13 1:35

Richard Deeming

5-Aug-13 1:35

Eddy Vluggen wrote:
It's limited to 4Gb

Unless you're using 2008 R2 or higher, where the size limit was increased to 10Gb.
http://blogs.msdn.com/b/sqlexpress/archive/2010/04/21/database-size-limit-increased-to-10gb-in-sql-server-2008-r2-express.aspx[^]

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

leone3-Aug-13 0:33

leone

3-Aug-13 0:33

Hi, i need a solution for my datagridview to recognise html codes. It is a winform datagridview, not an asp one.

Dave Kreskowiak3-Aug-13 7:12

Dave Kreskowiak

3-Aug-13 7:12

You're going to have to provide a bit more detail than that to get any kind of a useful answer. What do you mean by "recognize HTML code"??

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

leone5-Aug-13 0:56

leone

5-Aug-13 0:56

Html tags are not being interpreted by datagridview. And tags appear in the datagridview.

Dave Kreskowiak5-Aug-13 2:29

Dave Kreskowiak

5-Aug-13 2:29

Of course not, it's not an HTML control and doesn't understand HTML at all.

Frankly, you'd have to build your own HTML rendering engine to get the DGV to support HTML tags. NOT EASY!

Why do you want to do this? What's are the requirements driving this?

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

madhubsu@gmail.com5-Aug-13 2:01

madhubsu@gmail.com

5-Aug-13 2:01

still now its not clear to me perfectly. Can you tell your requirement little bit more elaborately?

leone5-Aug-13 4:07

leone

5-Aug-13 4:07

ok. the problem is that i have some data in my db. But they are in html format. So what control do you advise to show them in winform applications.(data depends on sql query.)

Dave Kreskowiak5-Aug-13 4:53

Dave Kreskowiak

5-Aug-13 4:53

The only control that will render HTML is the WebBrowser control. You'll, of course, have to generate an HTML page with the data in it for the WebBrowser to render.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak