Visual Basic

Check database structure for select file

10-Oct-04 20:05

In MSDOS mode type the following command:

net view /network then press enter if you want to output the result to the text file use the following command:

net view /network >ComputerList.txt and press enter.

A thousand mile of journey, begin with the first step.

APO-CEDC
Save Children Norway-Cambodia Office

Re: Quick Coding Help

Matt Philmon12-Oct-04 18:33

Matt Philmon

12-Oct-04 18:33

1) Look at how to write PING. There are plenty of samples out there.

2) If you just need to know if the files are the same or different, just generate a CRC for each and compare. Once, again, many samples, including on here.

Mekong River9-Oct-04 23:06

9-Oct-04 23:06

Hi, I have an Ms access database file which give my user an opportunity to get it file path via OpenDialog control in VB.NET. Then I proceed the connection and SQL string to the table that I have design in Ms access. My Ms access table contain 1 table named tblTest with three field Id, Name and Sex. But sometime the user select difference database from OpenFileDialog control so the structure of database is difference. How could I write the code that check the database the user select have 1 table with 3 fields? Because I want to check the table structure before my application allow my user to continuse his/her work with it.

A thousand mile of journey, begin with the first step.

APO-CEDC
Save Children Norway-Cambodia Office

gthompson200510-Oct-04 16:33

gthompson2005

10-Oct-04 16:33

If the file names for each file that the each user will be using are the same. I would suggest having the program recognizing that file name, and acting upon that.

Mekong River10-Oct-04 18:29

10-Oct-04 18:29

Thank you for your comment, But file name is not importance, the file could change to any valide name (but the extnesion .mdb must not change) but the structure (the number of table, field and relation structure) is the importance point. If user made a change to database structure, it would be problem when my application looking for the specific table to present the data it will have the problem.

A thousand mile of journey, begin with the first step.

APO-CEDC
Save Children Norway-Cambodia Office

gthompson200512-Oct-04 1:31

gthompson2005

12-Oct-04 1:31

Well then your probably going to have some problems, as if each user as the ability to use Access to change the number,name of the tables then it could change at any point, and you'll be getting a call as to why this is happening. I'm not sure about your situation for this purpose, but i would suggest making it to where they can't change the content, and structure of the database without using your program. Then all you have to worry about doing is recognizing the names of tables and having your program act on that. The current situation, seems like it could be quite problematic if the user can change stuff regarding the database file.

Mekong River12-Oct-04 3:23

12-Oct-04 3:23

Thank you very much for your valuable idea, What I have to do are check the structure of database that user select whether it is the right database that I design. The second step is prevent my database from the user if they want to change the structure. Smile | :)

A thousand mile of journey, begin with the first step.

APO-CEDC
Save Children Norway-Cambodia Office

Open/View file in VB.NET

Mekong River9-Oct-04 23:00

9-Oct-04 23:00

Hi, I have a question relate to the file operation in VB.NET.

1. In VB6 if I want to .exe file I have to write the code call shell... But in VB.NET I have a button that will open the file (c:\abc.doc or c:\abc.xls or c:\abc.pdf). How could I write the code to open these file?

2. I want to preview the file (*.doc or *.xls or *.pdf) that I supply its location in RichTextBox control, how to I do that?

Please give me some sample to work with it

A thousand mile of journey, begin with the first step.

APO-CEDC
Save Children Norway-Cambodia Office

Anonymous10-Oct-04 21:20

Anonymous

10-Oct-04 21:20

Dim ProcID As Integer
' Run Calculator.
ProcID = Shell("C:\Windows\system32\calc.exe", AppWinStyle.NormalFocus)
' The preceding path is for Windows XP;
' The Windows 2000 path is C:\WINNT\system32\calc.exe.

Mekong River10-Oct-04 22:12

10-Oct-04 22:12

Thank you very much for your comment, but what I want is open Ms word file from VB.Net. Smile | :)

A thousand mile of journey, begin with the first step.

APO-CEDC
Save Children Norway-Cambodia Office

Mekong River10-Oct-04 22:37

10-Oct-04 22:37

Bingo, Now I could do it. I got the information from http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dno2k3ta/html/odc_vbnetcallsvba.asp[^]. Smile | :)

A thousand mile of journey, begin with the first step.

APO-CEDC
Save Children Norway-Cambodia Office

Dave Kreskowiak11-Oct-04 5:08

11-Oct-04 5:08

The man from SCN-CO wrote:
2. I want to preview the file (*.doc or *.xls or *.pdf) that I supply its location in RichTextBox control, how to I do that?

You can't. The RichTextBox control knows nothing of the file formats for Word, Excel, or Acrobat.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Mekong River11-Oct-04 16:00

11-Oct-04 16:00

So, what should I do that? Do you have any other solution to recommend to me?

A thousand mile of journey, begin with the first step.

APO-CEDC
Save Children Norway-Cambodia Office

Dave Kreskowiak12-Oct-04 0:41

12-Oct-04 0:41

I don't know of any component that will do this for you. Don't even think of interpreting these file formats yourself. Word and Excel use multiple stream OLE file formats that are extremely difficult to understand and parse, not to mention render on your own. Acrobat uses a simpler, single stream format, but documentation is difficult to find because you have to pay to get at the developer documents from Adobe.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Mekong River12-Oct-04 4:22

12-Oct-04 4:22

I read Visual Basic .Net Programming author by Harold Davis, ISBN: 81-7656-627-6. In chapter 9 on page 218 I fould that RichTextBox control control could read and display the content of *.rtf file. In my opinion, could I convert Ms word *.doc file to *.rtf file and open it in RichTechBox? Do you have any idea?

A thousand mile of journey, begin with the first step.

APO-CEDC
Save Children Norway-Cambodia Office

Dave Kreskowiak12-Oct-04 5:28

12-Oct-04 5:28

It's entirely possible to do. But, since the .RTF format doesn't support alot of the formatting that Word does, the converted .RTF will not look the same as the Word version. Also, Excel doesn't export to an .RTF and neither does Acrobat AFAIK.

Also, if your going to go through the process of having Word convert the doc to RTF, why use a RichTextBox control to display the preview? Why not just use a visible Word control to do the preview?

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Mekong River12-Oct-04 15:39

12-Oct-04 15:39

Dave Kreskowiak wrote:
It's entirely possible to do. But, since the .RTF format doesn't support alot of the formatting that Word does, the converted .RTF will not look the same as the Word version. Also, Excel doesn't export to an .RTF and neither does Acrobat AFAIK.

Yes, I think so RTF might not support as much as possible like Doc file. But the document that my user will use is type in a simple word document with Bold, Italic, Underline... but no graphic or any special formatted.

Dave Kreskowiak wrote:
Also, if your going to go through the process of having Word convert the doc to RTF, why use a RichTextBox control to display the preview? Why not just use a visible Word control to do the preview?

Because there a lot of document that will display for each topic, my user ask me for an opportunity to preview before they open the document that they want. I also have a sample code that I just check from the internet on how to open Microsoft word or excel from VB.Net. I could do it!!! but what I want is preview the file before my user open it.

I don't know that RichTextBox could support *.htm file or not but I have to try first if it is possible I might consider *.htm instead of *.rtf to preview in the RichTextBox control.

Thank you very much for your comment.

A thousand mile of journey, begin with the first step.

APO-CEDC
Save Children Norway-Cambodia Office

Dave Kreskowiak12-Oct-04 18:05

12-Oct-04 18:05

The man from SCN-CO wrote:
I don't know that RichTextBox could support *.htm file

No, the RichTextBox doesn't support rendering HTML either. Just plain text or .RTF documents, that's it...

Getting a preview of all these document types is going to require a mountain of controls and code. Be sure that the end result is going to be worth the effort. If this functionality doesn't offer much to the main function of the application, it's probably not going to be worth it. At least, not in version 1.0...

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Mekong River13-Oct-04 0:01

13-Oct-04 0:01

Ok, Thank you very Dave. Now I have an idea, I will put the field for my user to note any comment about the document that they add. So when they browse it they will see the note and remind them of is the content of the document that they add. Thank for your comment.

A thousand mile of journey, begin with the first step.

APO-CEDC
Save Children Norway-Cambodia Office

Dave Kreskowiak13-Oct-04 3:11

13-Oct-04 3:11

And your going to store this information how and where? How are you going to retrieve the comment when the user selects the file?

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Mekong River13-Oct-04 4:03

Sample code for sample database form

13-Oct-04 4:03

Dave Kreskowiak wrote:
And your going to store this information how and where?

I alread create a field in my database (ms access) with Memo datatype for my user to type any comment that they want.

Dave Kreskowiak wrote:
How are you going to retrieve the comment when the user selects the file?

Each document that I design in the table consist of ID, FilePath and Comment. So when the user select the file ID the path of the file with display on linklabel and the comment will display on the text box (and easy to update or delete). I think it is simple, do you think so?

A thousand mile of journey, begin with the first step.

APO-CEDC
Save Children Norway-Cambodia Office

Mekong River9-Oct-04 4:17