IE -Com problems - C# Discussion Boards

afronaut27-Dec-02 6:43

27-Dec-02 6:43

How, usually, do you all solve this problem? I'm of course referring to inserts with an apostrophe (single quote) in them.

I have some ideas on how to solve it - either to use a Replace type method or to write a stored procedure (I'm using Access, so it should be one of those Access Query things).

Is there a standard approach which is best?

*->>Always working on my game, teach me
*->>something new.
cout << "dav1d\n";

Re: The O'Mally problem

Nick Parker27-Dec-02 9:01

Nick Parker

27-Dec-02 9:01

afronaut wrote:
Is there a standard approach which is best?

I will assume you are using C# since you are posting in this forum, however I always typically write a little function to handle this as it can be used throughout an application. Another Access Query really isn't necessary for something like this. Something like the following works well in C#:

    string CleanSql(string s)
{
    return s.Replace("'", "''");
}

Nick Parker

You see the Standards change. - Fellow co-worker

Re: The O'Mally problem

Philip Painter29-Dec-02 11:55

Philip Painter

29-Dec-02 11:55

We use stored procedures and set up the parameters with, for example "O'Mally", just as they are and it all works swimmingly.

Philip Painter

Web Page in the Web browser control loses focus

kiranj27-Dec-02 6:25

kiranj

27-Dec-02 6:25

Hi,
I am using C# windows forms and I have dragged and and dropped MS web browser control on to the form.
When I navigate to a web page ex:www.hotmail.com and change the focus to another application on the desktop using ALT + TAB and come back to my application again, the web page in the web browser control would have lost focus.

I am using using the following command to navigate
object o=null;
axWebBrowser1.Navigate( textBox1.Text,ref o, ref o, ref o, ref o);

Any idea how to get back the focus

Thanks
Kiran

going from vs.net to commandline

grv57526-Dec-02 22:03

grv575

26-Dec-02 22:03

Compiled an assembly with visual studio and am now trying to get it to compile on a box with just the sdk and command-line tools.

It's missing the mshtml reference which I think is a com object. Trying to get a type library from the winnt\system32 dll file fails. How would I compile it with just the sdk then?

Re: going from vs.net to commandline

Stephane Rodriguez.27-Dec-02 8:08

Stephane Rodriguez.

27-Dec-02 8:08

First of all, the mshtml.dll file you refer to is not the native dll we are used to with C/C++, but the interop assembly, which is located in <program files>\Microsoft.NET\Primary Interop Assemblies\Microsoft.mshtml.dll

The way to compile your code is to reference this assembly with the /reference option.

The command line is detailed here[^].

Programatically displaying dropdown menus from toolbars

Arun Bhalla26-Dec-02 16:08

Arun Bhalla

26-Dec-02 16:08

Hi,

I'd like to programatically display a dropdown menu from a toolbar. To be specific, I'm developing an Explorer bar, and I'd like to give it a menu. As far as I know, the only way to do that is to use a toolbar. So I have a couple buttons (File, Edit), and they both have dropdown Menus. When a user clicks on the File button, I want it to popup the File dropdown menu, just as it might if the user clicked on the dropdown arrow.

I don't see a natural way to do it within the API yet. I tried using Show(), but the only problem is that I'd need to calculate the correct location for the dropdown menu to popup. Any better solutions?

Thanks,
Arun

IE -Com problems

Calamitous26-Dec-02 9:58

Calamitous

26-Dec-02 9:58

hi @ll!
I have the following problem....
I try to access the IE DOM as COM from C# -> no problem for first. Then I try to get a spezific element of the Document in the Internet Explorer (v6). For this I need to recurse through all frames. It works (its only a part of course, all the source would be too much Wink | ;)

until "X.item(ref newIDoc);" I think (or I'm sure the error is caused because) in the msdn the ".item" is descripted as follows:
"HRESULT item(
VARIANT* pvarIndex,
VARIANT* pvarResult
);"
but I don't know how to do this in C#.

object newIDoc = new object();
newIDoc = I;
mshtml.IHTMLFramesCollection2 X;
X = iDoc.frames;
X.item(ref newIDoc); //-> error

An unhandled exception of type 'System.Runtime.InteropServices.COMException' occurred in xcwrapper.dll
Additional information: Mitglied nicht gefunden.

Anyone any Idea?
thx anyway
mfg Manuel

Re: IE -Com problems

Stephane Rodriguez.26-Dec-02 10:32

Stephane Rodriguez.

26-Dec-02 10:32

frame = X.item(i) is a way to access the ith element of a collection. There is no point in passing the doc instance as param.

Re: IE -Com problems

Calamitous26-Dec-02 11:33

Calamitous

26-Dec-02 11:33

hi!
I see...
that sounds pretty well Smile | :)

(sometimes you bite in a problem like this, and it could be such easy.... Smile | :)

anyway
that causes this problem:
Argument '1': cannot convert from 'ref short' to 'ref object'
u know what I can do here?
thx indeed
mfg Manuel

Re: IE -Com problems

Stephane Rodriguez.26-Dec-02 20:35

Stephane Rodriguez.

26-Dec-02 20:35

Calamitous wrote:
Argument '1': cannot convert from 'ref short' to 'ref object'
u know what I can do here?

API automatically generated by the type lib discoverer comes short in many places, including that one. In fact, you need to know to hack the C++ IDL interface counterpart before you get the C# stuff working.

For your issue, the simplest thing I can see is as follows :

short i = 2; // example
object oi = i;

frame f = X.frames.item(ref oi);

Start ILDASM via code?

Roger Alsing26-Dec-02 4:07

Roger Alsing

26-Dec-02 4:07

hi i use ildasm.exe in my tool , how should i do to start it via the .net environment variables?
currently my code looks like

<br />
Process p=new Process ();<br />
p.StartInfo.FileName =@"C:\WINNT\Microsoft.NET\Framework\v1.0.3705\ilasm.exe";<br />

i need to be able to start it via the environment vars and not use a hardcoded path.
so how do i access the environment vars and how would the aboce code look with the environment vars in it?

//Roger

Re: Start ILDASM via code?

Daniel Turini26-Dec-02 4:21

Daniel Turini

26-Dec-02 4:21

Call this function[^] via DllImport.

[edit]And I never tried it, but you can try the RuntimeEnvironment.GetRuntimeDirectory method[/edit]

I see dumb people

Re: Start ILDASM via code?

Roger Alsing26-Dec-02 5:23

Roger Alsing

26-Dec-02 5:23

oke this solved it halfway..
i need the path for ilasm.exe to... and for some reason ilasm and ildasm are located in differet folders.

"C:\Program\Microsoft Visual Studio .NET\FrameworkSDK\Bin\ildasm.exe"
and C:\WINNT\Microsoft.NET\Framework\v1.0.3705\ilasm.exe

why?

RuntimeEnvironment.GetRuntimeDirectory () returns the path where ilasm is located , but how can i get the other path to? and are they always located at different locations?

//Roger

Re: Start ILDASM via code?

Daniel Turini26-Dec-02 5:27

Daniel Turini

26-Dec-02 5:27

Because ILDASM is a programmer tool, it is located on the Framework SDK path, not in the Framework path.
I'm not sure if this is the right way, but you can obtain it at HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\.NETFramework\sdkInstallRoot

I see dumb people

Re: Start ILDASM via code?

David Stone26-Dec-02 11:00

David Stone

26-Dec-02 11:00

Daniel Turini wrote:
sdkInstallRoot

Looks like that would only be part of the SDK. So that wouldn't work if you were installing to a box with only the runtime.

I don't know whether it's just the light but I swear the database server gives me dirty looks everytime I wander past.
-Chris Maunder

Microsoft has reinvented the wheel, this time they made it round.
-Peterchen on VS.NET

Re: Start ILDASM via code?

Anonymous27-Dec-02 1:09

Anonymous

27-Dec-02 1:09

can i execute "vsvars.bat" first?

vsvars.bat is tha batch file that registers the .net environment variables .
so could i somehow execute that batch in the context of my program so my program can retrive the paths from the environment variables then?

i actually peeked inside a quite wellknown obfuscator (and they use ilasm and ildasm)
and they retrive the path to both of them via the environmentvariable "path" , but that variable dont contain the .net paths unless vsvars.bat have been executed.
(they also display a mysterious dos window before their app starts , and i beleve they actually executes vsvars.bat in there somehow)..

so any ideas how i could start that bat file so that the vars are visible to my app?

//Roger

Re: Start ILDASM via code?

David Stone27-Dec-02 10:34

David Stone

27-Dec-02 10:34

Well, there are a couple problems with that. That batch file is only included with the .NET Framework SDK. End-users will only have the .NET Framework Runtime. So they won't have ILDASM or VSVars32.bat.

And, you can run VSVars32.bat, but why not just hardcode the path? I don't think it's gonna change until you upgrade to another .NET Framework version.

DataGrid row color

Anonymous26-Dec-02 2:20

Anonymous

26-Dec-02 2:20

Hi.
How can I colour some rows of a DataGrid?
I have to colour some row where one boolean or more value of the database is
true or false.
Demetrio

Wink | ;)

internet connection is up

karanba26-Dec-02 2:13

karanba

26-Dec-02 2:13

I detect the internet connection with the following method
//*************************************
try
{
server = DNS.GetHostByName("www.yahoo.com");
}
catch(Exception)
{
Console.WriteLine("Internet Connection not found"); // fail
return ;
}
//***********************************************
But it takes times to find if internet connection is up. I need a faster method.
Is there any?

karanba

Re: internet connection is up

J. Schermerhorn26-Dec-02 10:55

J. Schermerhorn

26-Dec-02 10:55

Try using the Win32 InternetGetConnectedState() function.

-John

Re: internet connection is up

karanba27-Dec-02 0:46

karanba

27-Dec-02 0:46

Can you give me a short code example how to use this function in C#. Is there any resource to add with the project...
thanks.

karanba

Re: internet connection is up

grv57527-Dec-02 2:31

grv575

27-Dec-02 2:31

[System.Runtime.InteropServices.DllImport("wininet.dll")]
public static extern bool InternetGetConnectedState(IntPtr lpSFlags, int dwReserved);

if (!InternetGetConnectedState(new IntPtr(0), 0))
{
// not connected
}

Re: internet connection is up

J. Schermerhorn27-Dec-02 2:37

J. Schermerhorn

27-Dec-02 2:37

Try and use the following code. Other than the using System.Runtime.InteropServices, I have not added an additional resources to the project. I hope this helps you.

-John

<code>
using System;
using System.Runtime.InteropServices;

namespace CSProject
{
	/// <summary>
	/// Summary description for Class1.
	/// </summary>
	class ConsoleApp
	{
		/// <summary>
		/// The main entry point for the application.
		/// </summary>
		[STAThread]
		[DllImport("wininet.dll")]
		public static extern bool InternetGetConnectedState(double dFlags);

		static void Main(string[] args)
		{
			double dFlags = 0;
			bool bResult = InternetGetConnectedState(dFlags);
			
                            Console.WriteLine("Internet Connection: {0}", bResult.ToString());
                            //
			// TODO: Add code to start application here
			//
		}
	}
}
</code>

Re: internet connection is up

karanba27-Dec-02 7:44

karanba

27-Dec-02 7:44

Thanx All a get what I need
Smile | :)

karanba

Last Visit: 31-Dec-99 18:00 Last Update: 23-Sep-24 12:26

Refresh

ᐊ Prev 1...14937 14938 14939 149401494114942 14943 14944 14945 14946 Next ᐅ

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