C# Discussion Boards - CodeProject

the Registry and DOS commands

14-Dec-09 4:28

google "activedirectory"

.45 ACP - because shooting twice is just silly
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001

backup

farokhian14-Dec-09 3:47

farokhian

14-Dec-09 3:47

Hi all
I have a problem that became huge.
I want to make a backup from my database and if i attach my database to microsoft sql 2005 and use this connectionstring i can backup from my database correctly:
string connectionstring="Data Source=.;DataBase=mydatabase;Integrated Security=true"

but when i detach it from microsoft sql 2005 and add it to SQLEXPRESS and use SQLEXPRESS of visual studio by this connectionstring=@"Data Source=.\SQLEXPRESS;AttachDbFilename=" + Application.StartupPath + "\\Data\\mydatabase.mdf;" + "Integrated Security=True;User Instance=True";

but it didn't work and error delare that

"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."

and because of some reason i want to use SQLEXPRESS.
what should i do?

note:This is my sql command for backup:
backup = string.Format(@"backup database mydatabase to disk='{0}'",addr);
backup.ExecuteNonQuery();

Antonio JVS14-Dec-09 2:40

Antonio JVS

14-Dec-09 2:40

Anyone knows how to handle (read/write) the registry to search for a path, and how to send DOS commands for example to send SQL commands to attach and dettach a database from the SQL server?

Md. Marufuzzaman14-Dec-09 3:01

Md. Marufuzzaman

14-Dec-09 3:01

Antonio JVS wrote:
example to send SQL commands to attach and dettach a database from the SQL server?
Quote Selected Text

Try the following:
SQL Express Command-Line Utility

Thanks
Md. Marufuzzaman

Don't forget to click [Vote] / [Good Answer] on the post(s) that helped you.

I will not say I have failed 1000 times; I will say that I have discovered 1000 ways that can cause failure – Thomas Edison.

Antonio JVS14-Dec-09 3:47

Antonio JVS

14-Dec-09 3:47

Just need to send DOS commands like "sqlcmd -S ..." to register a database in the SQL and use it in the path it puts it, I'm in the begining of my application and see the best way to use the database.

Re: the Registry and DOS commands [modified]

S. Brozius14-Dec-09 3:18

S. Brozius

14-Dec-09 3:18

For reading the registry, Windows XP and up provide the DOS-tool REG.EXE, with which you can read AND write registry-keys.

Nah... What's up, Doc?
CCC's solved : 1
If a bus station is where a bus stops, and a train station is where a train stops, why do I have a work station on my desk?

EliottA14-Dec-09 3:28

EliottA

14-Dec-09 3:28

There are registry classes that you can use to interact with the registry. See this link.[^]

To issue DOS commands you can write a batch file on the fly and then execute it.

Here are some more relevant classes / enumerations for registry interaction

Registry Class Link[^]
RegistryHive Enumeration Link[^]
RegistryKey Class Link[^]
RegistryKeyPermissionCheck Enumeration Link[^]
RegistryValueKind Enumeration Link[^]
RegistryValueOptions Enumeration Link[^]

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

modified on Monday, December 14, 2009 9:37 AM

Antonio JVS14-Dec-09 3:54

Antonio JVS

14-Dec-09 3:54

thaks it did help, just don't know how to create a batch file on the fly and execute it I'm new to C# and never used it on VB.

How to read a file from any kind of documents and display its contents?

EliottA14-Dec-09 4:08

EliottA

14-Dec-09 4:08

I suggest you get a begginners book and start from chapter one, this would fall under basic IO functions and then using the systems.diagnostics.process class to execute the batch file you created.

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

CoderForEver14-Dec-09 2:00

Re: How to read a file from any kind of documents and display its contents?

14-Dec-09 2:00

Hi my friends ........ I want to do term weighting by an approach called Composite measure(Tf*idf) ... it has its own formula ....
But what I want to do is to read files like(Word 2003,2007 pdf files etc.... ) then to take each word as an array .... I can read all files line by line by the following code

<br />
try<br />
                {<br />
                    // Create an instance of StreamReader to read from a file.<br />
                    // The using statement also closes the StreamReader.<br />
                    using (StreamReader sr = new StreamReader(textBox1.Text,Encoding.ASCII,true))// Where textbox1.text is a path<br />
                    {<br />
                        String line;<br />
                        // Read and display lines from the file until the end of <br />
                        // the file is reached.<br />
                        while ((line = sr.ReadLine()) != null)<br />
                        {<br />
                         richTextBox1.Text =richTextBox1.Text +Environment.NewLine+ line;<br />
<br />
                            //MessageBox.Show(line);<br />
                        }<br />
                    }<br />
                }<br />

and to check the content of the file i tried to display it on a Richtextbox1 .... but it displays encrypted file .....
What I want to know is
1. How can I put each words(separated by Space and newline) in to array ... just to know each word (here displaying the content is not necessary)
2. How can I display the content of each file on Richtextbox1 ... but not in an encrypted form ....

Thanks for your help

OriginalGriff14-Dec-09 2:06

OriginalGriff

14-Dec-09 2:06

The first thing you need to know is: Word and PDF files (as well as many others) are not necesarily line based text documents. Instead they are frequently binary files - which explains why they look encrypted.
The second thing you need to know is: Word and PDF files can be encrypted. So that may be why they lookm encrypted.

Google for "Word File Format" and "PDF File Format" - this will provide a starting point for you to gather the information you are going to need.

All those who believe in psycho kinesis, raise my hand.

Re: How to read a file from any kind of documents and display its contents?

CoderForEver14-Dec-09 2:42

Re: How to read a file from any kind of documents and display its contents?

14-Dec-09 2:42

So how can i decrypt them? .... or can you tell me how to work on them please?
Just u can see my first question.
Thank you

#realJSOP14-Dec-09 2:51

Re: How to read a file from any kind of documents and display its contents?

14-Dec-09 2:51

Ummm...[^]

CoderForEver14-Dec-09 2:59

Re: How to read a file from any kind of documents and display its contents?

14-Dec-09 2:59

got noting ... just http://75.11.0.157/homenet/stupid.htm on z title bar .... What that supposed to mean?

#realJSOP14-Dec-09 3:01

Re: How to read a file from any kind of documents and display its contents?

14-Dec-09 3:01

Okay, how about this one[^]?

Eddy Vluggen14-Dec-09 3:03

Eddy Vluggen

14-Dec-09 3:03

I couldn't open them either, using Chrome. It works in FF though Smile | :)

I are Troll Suspicious | :suss:

Re: How to read a file from any kind of documents and display its contents?

#realJSOP14-Dec-09 4:27

Re: How to read a file from any kind of documents and display its contents?

14-Dec-09 4:27

It's a picture and a caption - nothing special, and certainly nothing exotic. If Chrome can't open something that simple, I'd certainly entertain the idea of using one of the alternative browsers for my regular web-browsing pleasures...

Eddy Vluggen14-Dec-09 5:37

Eddy Vluggen

14-Dec-09 5:37

John Simmons / outlaw programmer wrote:
It's a picture and a caption - nothing special, and certainly nothing exotic.

content="IE=EmulateIE7"

..and some css to position all that Big Grin | :-D

John Simmons / outlaw programmer wrote:
If Chrome can't open something that simple, I'd certainly entertain the idea of using one of the alternative browsers for my regular web-browsing pleasures...

You could also entertain the idea of installing multiple browsers. It's not a marriage, and I'm not going to commit to a single system Smile | :)

I are Troll Suspicious | :suss:

Re: How to read a file from any kind of documents and display its contents?

#realJSOP14-Dec-09 6:28

Re: How to read a file from any kind of documents and display its contents?

14-Dec-09 6:28

Well, IE 6 and 8 show it just fine without any special compatibility tags.

OriginalGriff14-Dec-09 4:11

OriginalGriff

14-Dec-09 4:11

Gets my five!

All those who believe in psycho kinesis, raise my hand.

Re: How to read a file from any kind of documents and display its contents?

OriginalGriff14-Dec-09 4:22

OriginalGriff

14-Dec-09 4:22

Decrypt: First, find out the password...

Because they aren't stored as straight text, you can't just read them and identify the words. The files contain heaps of other stuff: font, size, colour, location, lines, boxes, italics, bold, pictures, spreadsheets, etc. etc. etc. If all you are interested in is the text of the document and doing some textual analysis, then the best thing you can do is to throw away as much of the formatting as possible, and save the file as a straight .TXT file from Word and/or PDF. You can then read the whole thing in, and use string.Split (with space and reasonable puncuation) to break it into words.

All those who believe in psycho kinesis, raise my hand.

Re: How to read a file from any kind of documents and display its contents?

CoderForEver14-Dec-09 2:45