Re: C# Modal Dialog returns too quickly - C# Discussion Boards

kbalias13-Jun-05 19:29

13-Jun-05 19:29

Hi all

I need to access an Excel workbook and update certail cells and then print it. I want to use C# to access and update the Excel workbook. I can access it no problem using the ADO method and Microsoft.Jet. However I am struggling to update a specific named cell using the Update sql statement from my C# windows application.

Unfortunately the type of data is more fitting for a spreadsheet type layout, otherwise I would have used a database.

Can anyone assist me in this matter.

Thank you

kobus

of Open File

Mr. Naveed Butt13-Jun-05 16:10

Mr. Naveed Butt

13-Jun-05 16:10

I am trying to open a file from c:\windows\assembly, using opneFileDialog but it does not open it, other files are opened very easily.Why?

Re: of Open File

Daniel Monzert13-Jun-05 20:43

Daniel Monzert

13-Jun-05 20:43

I am not familiar with that but I doubt that c:\Windows\Assembly or c:\winnt\assembly contains any files. It is the global assembly cache, isn't it?

So if you want to open an assembly, try looking in C:\WINNT\Microsoft.NET\Framework\v1.1.4322 or C:\Windows\... and the version of your choice if you installed more than one version of the .NET Framework (ie .net framework 1.0/1.1/2.0).

how to compare the text of two html pages

Mohsen Saad13-Jun-05 14:20

Mohsen Saad

13-Jun-05 14:20

Hi ,
I want to compare the text of two html pages and then highlight the changed text.Do you have any idea on how to do this

converting byte[] to string

scott987uk13-Jun-05 10:01

scott987uk

13-Jun-05 10:01

hi all, hope some one can help me iv got a bit of a prob.

iv got a server and client sending data using sockets and tcp/ip.

The client sends the server some text and the server gets the byte[] array and then converts it into a string.

For the most part it is ok, however there are some characters it can not convert. i am using System.Text.ASCIIEncoding.ASCII.GetString() to turn the byte array into a string.

an example of a character it will not convert is §.

any help would be grate.

Thx

Re: converting byte[] to string

Christian Graus13-Jun-05 14:47

Christian Graus

13-Jun-05 14:47

The character is not an ASCII character. Try System.Text.UnicodeEncoding.Unicode.GetString

Christian Graus - Microsoft MVP - C++

C# Modal Dialog returns too quickly

Glenn E. Lanier II13-Jun-05 11:37

Glenn E. Lanier II

13-Jun-05 11:37

I have created a Windows Form that allows the user to enter a couple of file names, and select a couple of checkbox styled options. I have placed "Browse" buttons by the textbox that holds a filename. When Browse is selected, the OpenFileDialog is displayed. This all works like I expect. However, when I select Open in the OpenFileDialog, it runs the additional code in the Browse_Click method, then returns to the calling form. This is not what I want; I only want it to return when the user selects the AcceptButton or the CancelButton.

The code that shows the form in question:

			<br />
formImportDatabase frmImport = new formImportDatabase();<br />
DialogResult dr = frmImport.ShowDialog();<br />
if (DialogResult.OK == dr) // Control returns to this point after the Open button is selected in OpenFileDialog<br />
{<br />
...<br />
}<br />

The Browse_Click code:

<br />
if (DialogResult.OK == openFileDialog.ShowDialog())<br />
{<br />
   textBoxDestinationDB.Text = openFileDialog.FileName;<br />
}	<br />

How can I keep the dialog box displayed until the AcceptButton or CancelButton is selected?

Thanks,
Glenn

Re: C# Modal Dialog returns too quickly

Christian Graus13-Jun-05 12:33

Christian Graus

13-Jun-05 12:33

I've had this problem recently - the trouble is that if your form is set to close on Accept or Cancel messages, a child form that closes with those messages will close your form as well. Get rid of all automatic form closure handling in your dialog, handle the click for OK and Cancel, and set DialogResult manually before calling this.Close();.

Christian Graus - Microsoft MVP - C++

Re: C# Modal Dialog returns too quickly

Glenn E. Lanier II14-Jun-05 4:38

Glenn E. Lanier II

14-Jun-05 4:38

Thanks. That did the trick, once I went into the generated source and remove the DialogResult.Cancel that had been placed in the browse button section.

Thanks again.

--G

Re: C# Modal Dialog returns too quickly

Robert Rohde13-Jun-05 19:39

Robert Rohde

13-Jun-05 19:39

It is like Christian said. But if I remember correctly you can also set the DialogResult in the BrowsClick event manually to override this nasty behaviour:

public void Browse_Click(object sender, EventArgs args) {
//Do your stuff
if (DialogResult.OK == openFileDialog.ShowDialog())
{
textBoxDestinationDB.Text = openFileDialog.FileName;
} 

//Now reset the wrong DialogResult of this modal form
base.DialogResult = DialogResult.None;
}

Re: C# Modal Dialog returns too quickly

Glenn E. Lanier II14-Jun-05 4:40

Glenn E. Lanier II

14-Jun-05 4:40

Hmmm. I've already implemented Christian's suggestion and it works. I tried what you have above, with the exception of base.DialogResult = DialogResult.None. I'll keep that in mind for future forms. Thanks very much, if I had seen this sooner, it would have resulted in less work for me!

--G

Can someone point me to some nice clean search and replace code?

ArchKaine13-Jun-05 11:24

ArchKaine

13-Jun-05 11:24

To be more specific, I need the code for a text editor / RTF editor that I'm working on and I'm more than a little bit new at this coding thing, so I'm not too certain as to where to look for good clean snippets that provide the functionality that I need. I'd try to write the code myself, but I have at the moment a lack of two things: Time, since I've joined the Naval Reserve, and am studying a lot - and appropriate knowledge, since C# is essentially my first programming language since the "good ol' days" of Level 2 BASIC (anyone out there remember that one?).

Anyhoo, any help than you can all provide would be greatly appreciated.

Specific functionality that I'm trying to implement, but haven't found a clue to:

Global search and replace among all documents in an MDI environment.
Specific search and replace on a per-document basis.
Undo/redo functionality for both of the previous cases would also be good.

Thanks in advance for any help, and if you provide code, you'll be appropriately credited Smile | :)

B Turner

Some say that ignorance is bliss... Blissful, aren't they?

Re: Can someone point me to some nice clean search and replace code?

Christian Graus13-Jun-05 12:36

Christian Graus

13-Jun-05 12:36

The string class has search and replace methods, that is, if your text is one big string, you can use the replace method to do search and replace, or you can use other methods to find the strings without replacing.

I'm not sure how to iterate through all documents in an MDI app, but I'm sure google can help here.

The easiest way to do undo is to make a copy of your document in memory before each action and push them on to a stack. If you want to only store the differences between documents to save memory ( no need with text, I would think ), then you need to get a little more complex.

Christian Graus - Microsoft MVP - C++

Re: Can someone point me to some nice clean search and replace code?

Luis Alonso Ramos13-Jun-05 14:16

Luis Alonso Ramos

13-Jun-05 14:16

Christian Graus wrote:
I'm not sure how to iterate through all documents in an MDI app,

foreach(Form form in this.MdiChildren)
{
    // See if it's a document form
    TextDocumentForm textForm = form as TextDocumentForm;
 
    if(textForm != null)
    {
        // Do whatever with the form
    }
}

Now you know! Poke tongue | ;-P

-- LuisR

Luis Alonso Ramos
Intelectix - Chihuahua, Mexico

Not much here: My CP Blog!

Re: Can someone point me to some nice clean search and replace code?

ArchKaine14-Jun-05 11:42

ArchKaine

14-Jun-05 11:42

I would place this code into the MdiParent, right?

Something tells me that that's the only logical place to put it, but I wanted to be sure.

Thanks again Smile | :)

Brian Turner

Re: Can someone point me to some nice clean search and replace code?

Luis Alonso Ramos14-Jun-05 12:38

Luis Alonso Ramos

14-Jun-05 12:38

Yes, only an MDI parent window (IsMdiParent property set to true) can have MDI children.

-- LuisR

Luis Alonso Ramos
Intelectix - Chihuahua, Mexico

Not much here: My CP Blog!

Re: Can someone point me to some nice clean search and replace code?

ArchKaine14-Jun-05 11:45

ArchKaine

14-Jun-05 11:45

I think that what I need is a code snippet, know of any good places to get that? Reason being is I learn better by having something to emulate. I'm still learning how to implement various classes. I'll post the code that I have so far, when I am able, so that you can all have something to chuckle at Smile | :)

Thanks for the help Smile | :)

Brian Turner

Some say that ignorance is bliss... Blissful, aren't they?

Re: Can someone point me to some nice clean search and replace code?

Christian Graus14-Jun-05 13:52

Christian Graus

14-Jun-05 13:52

string theDocument = LoadString(); // This method does not exist, you need to get the text of the document
theDocument.Replace("oldstring", "newString");

Christian Graus - Microsoft MVP - C++

fonts

dizzybinty13-Jun-05 11:17

dizzybinty

13-Jun-05 11:17

Hi guys,

Is there anyway I can load and view fonts that are not in the font folder? Scenario, I want to open and browse 3 or four differing folders on my computer with different fonts that I don' want to install till I've seen all of them. And being able to print them is a bonus...!

Cheers for any pointers,

Enumerating system fonts is easy....

Re: fonts

Werdna13-Jun-05 19:26

Werdna

13-Jun-05 19:26

You can use PrivateFontCollection class
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdrawingtextprivatefontcollectionclasstopic.asp[^]

getting table schema info in ADO .NET?

Jason Manfield13-Jun-05 11:16

Jason Manfield

13-Jun-05 11:16

Given a table name (e.g. CUSTOMERS), how do I get column names of the table and the data types of the columns the table has?

I am using SQLServer and would like to get that info from my C# code.

Re: getting table schema info in ADO .NET?

Luis Alonso Ramos13-Jun-05 14:20

Luis Alonso Ramos

13-Jun-05 14:20

See this[^].

-- LuisR

Luis Alonso Ramos
Intelectix - Chihuahua, Mexico

Not much here: My CP Blog!

Is there a spawnlp function in c#?

adonisv13-Jun-05 10:26

adonisv

13-Jun-05 10:26

Or something similar? Sniff | :^)

Re: Is there a spawnlp function in c#?

DavidNohejl13-Jun-05 10:59

DavidNohejl

13-Jun-05 10:59

Well you could say what spawnlp does... it would save me from googling.

Take a look at Process Class[^]

David

Re: Is there a spawnlp function in c#?

adonisv13-Jun-05 11:16

adonisv

13-Jun-05 11:16

It's gone from C++ .NET apparently...

_spawnlp, _wspawnlp
Create and execute a new process.

int _spawnlp( int mode, const char *cmdname, const char *arg0, const char *arg1, ... const char *argn, NULL );

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