Re: how can I get document name if I know HWND - C# Discussion Boards

Christian Graus9-Jun-09 20:28

9-Jun-09 20:28

Here[^]

Christian Graus

Driven to the arms of OSX by Vista.

"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.

I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp

Blue_Boy9-Jun-09 21:04

Blue_Boy

9-Jun-09 21:04

SELECT * FROM INFORMATION_SCHEMA.TABLES

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

saurabh sahay10-Jun-09 4:14

saurabh sahay

10-Jun-09 4:14

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TableName]') AND type in (N'U'))

how can I get document name if I know HWND

saurabh sahay10-Jun-09 4:21

saurabh sahay

10-Jun-09 4:21

This would be much better

SELECT *
FROM sys.tables
WHERE name = 'mytable'
AND schema_id = SCHEMA_ID('myschema')

sys.tables contains all the tables. So it would be easier to query sys.tables rather than sys.objects

Member 26841029-Jun-09 20:10

9-Jun-09 20:10

with GetWindowText I can take only title

Christian Graus9-Jun-09 20:26

9-Jun-09 20:26

Correct. What do you want to get the 'document name' of ? I mean, a lot of HWNDs point to programs that have no document ( Freecell, for example ).

Member 26841029-Jun-09 21:03

9-Jun-09 21:03

I know about that, but now I need to take information from adobe reader and MS office
From some applications I can take full document name when process created, but I can't take
when office document opened and from Adobe I can take info just only if in the same time opened
only one document

Christian Graus9-Jun-09 21:13

9-Jun-09 21:13

OK, so your question is meaningless. A HWND does not HAVE a document, at least, it's not guarenteed, so no mechanism is going to exist on that level. You need to work out solutions specific to each program you want to interact with, as they will be unique to those applications.

Member 26841029-Jun-09 21:28

9-Jun-09 21:28

I can take information from some applications by hooking CreateFile and close handle,
but i thought to find more safely and universal way.

Christian Graus9-Jun-09 21:40

9-Jun-09 21:40

There can't be a universal way, when not every HWND has a document. If they are all MFC MDI apps, then perhaps there's something you could try, but I am certain that Word at least does not use MFC.

Member 26841029-Jun-09 22:03

9-Jun-09 22:03

I think I' combine managed and unmanaged code by using fileswatcher and hooking
some applications.
Thank you for your opinion.

Dave Kreskowiak10-Jun-09 2:06

Dave Kreskowiak

10-Jun-09 2:06

You're not going to be able to hook the API in managed code. And the FileSystemWatcher will not tell you when an application opens a file.

You simply have no choice but to write interop code for each application you want to interact with.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Member 268410210-Jun-09 9:46

activex component can't create object on a small exe coded on vb dot net

10-Jun-09 9:46

Thank you for answer.
Now I know what to do. I need to check all opened file and then compare with
target windows title.

alonchap9-Jun-09 19:21

Re: activex component can't create object on a small exe coded on vb dot net

9-Jun-09 19:21

Hello,

our coder created an application on vb dot net that opens another exe file with process process.start command, the small exe he coded only checks for credentials and asks you to select the branch you belong to from a list of branches.
the program always showing Activex component can't create object, and all the articles on inet did not help so far, any one got any idea, i could post the code but it's long for a forum

Thanks

Christian Graus9-Jun-09 19:25

Re: activex component can't create object on a small exe coded on vb dot net

9-Jun-09 19:25

Impossible to help based on this. You could check your error log for more info on why the object can't be created.

saanj9-Jun-09 19:29

saanj

9-Jun-09 19:29

Is the ActiveX DLL registered inoto GAC? Just check.

Regards
Saanj

Either you love IT or leave IT...

Re: activex component can't create object on a small exe coded on vb dot net

Christian Graus9-Jun-09 19:34

Re: activex component can't create object on a small exe coded on vb dot net

9-Jun-09 19:34

ActiveX controls can never be registered in the GAC.

alonchap9-Jun-09 19:39

Re: activex component can't create object on a small exe coded on vb dot net

9-Jun-09 19:39

well, he created a log on his small code to say how further it went and it finished okay (that's what i was told), but still it won't work on SOME computers,
what is missing like MDAC or dlls? ocxs?

Christian Graus9-Jun-09 20:29

Re: activex component can't create object on a small exe coded on vb dot net

9-Jun-09 20:29

Well, I would hope you've confirmed the ocx is present and registered.

alonchap9-Jun-09 20:32

Re: activex component can't create object on a small exe coded on vb dot net

9-Jun-09 20:32

HE does not know what OCX , because his small app does not include anything in source

Christian Graus9-Jun-09 20:37

Re: activex component can't create object on a small exe coded on vb dot net

9-Jun-09 20:37

If his app doesn't have a reference to the OCX, how is he calling it ? If you don't know what the OCX is, why does your program require it ?

alonchap9-Jun-09 21:37

Re: activex component can't create object on a small exe coded on vb dot net

9-Jun-09 21:37

There is no OCX inside his code.
Would be best if i could show you the code.

http://pastebin.com/d3971bd44

Thanks

saanj9-Jun-09 20:01

saanj

9-Jun-09 20:01

Yeah Chris, you are right. Thanks for pointing out and sorry from my side for the mistake.

Regards
Saanj

Either you love IT or leave IT...

pass in parameter from c#

Abdul Rahman Hamidy9-Jun-09 18:36

Abdul Rahman Hamidy

9-Jun-09 18:36

Dear All,
I have sql query which is

create proc sp_detail
(
@p varchar(max)
)
as
select * from tblName where code in (@p)

I am passing @p from c# application, but it doesent reterieve any data while there is data

cmd=new SqlCommand("sp_detail",p.con);
cmd.CommandType= CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@p",codes);
DataTable dtResult=new DataTable();
if (cmd.Connection.State!=ConnectionState.Open)
    cmd.Connection.Open();
dtResult.Load((cmd.ExecuteReader(CommandBehavior.CloseConnection)));

codes is a string which contains codes seperated by comma, as 28-2801,28-2802...
what is wrong here

Abdul Rahaman Hamidy
Database Developer
Kabul, Afghanistan

Re: pass in parameter from c#

Christian Graus9-Jun-09 19:10