Re: activex component can't create object on a small exe coded on vb dot net - C# Discussion Boards

Re: how can I get document name if I know HWND

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.

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

Re: how can I get document name if I know HWND

Member 26841029-Jun-09 21:28

Member 2684102

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.

Re: how can I get document name if I know HWND

Christian Graus9-Jun-09 21:40

Christian Graus

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.

Re: how can I get document name if I know HWND

Member 26841029-Jun-09 22:03

Member 2684102

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.

Re: how can I get document name if I know HWND

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

Re: how can I get document name if I know HWND

Member 268410210-Jun-09 9:46

Member 2684102

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.

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

alonchap9-Jun-09 19:21

alonchap

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

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

Christian Graus9-Jun-09 19:25

Christian Graus

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.

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

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

Christian Graus

9-Jun-09 19:34

ActiveX controls can never be registered in the GAC.

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

alonchap9-Jun-09 19:39

alonchap

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?

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

Christian Graus9-Jun-09 20:29

Christian Graus

9-Jun-09 20:29

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

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

alonchap9-Jun-09 20:32

alonchap

9-Jun-09 20:32

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

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

Christian Graus9-Jun-09 20:37

Christian Graus

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 ?

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

alonchap9-Jun-09 21:37

alonchap

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

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

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

Christian Graus

9-Jun-09 19:10

This is a SQL question, really. You're passing the parameter in fine. If you enter your parameter as a variable and run the SQL, does it work then ? Might the issue be your parameter being escaped on the way in ?

Re: pass in parameter from c#

Abdul Rahman Hamidy9-Jun-09 19:23

Abdul Rahman Hamidy

9-Jun-09 19:23

the thing is, if i use simpl select statement from c# application every thing works fine as
select * from community where code in ('28-2801','28-2802',...)
but when the store procedure is executed, i got the statement of that from profiler as follows
exec sp_details @p=N'28-2801,28-2802'

while these code exits in database, when i execute this statement from sql, it doesent retrieve a value while if i execute it like this
exec sp_details @p=N'28-2801'
then it returns a rows
with single code it retrieve data, but when passing it seperated by comma nothing is retrieved.
any error there?

Abdul Rahaman Hamidy
Database Developer
Kabul, Afghanistan

Re: pass in parameter from c#

Christian Graus9-Jun-09 19:24

Christian Graus

9-Jun-09 19:24

The error seems obvious to me. Passing in your parameter means you specify the whole lot in one set of quotes, when you need to place quotes inside the string. So the value you pass in, needs to have those single quotes around each value, as in

Abdul Rahman Hamidy wrote:
'28-2801','28-2802'

and not

Abdul Rahman Hamidy wrote:
'28-2801,28-2802'

Re: pass in parameter from c#

Abdul Rahman Hamidy9-Jun-09 19:44

Abdul Rahman Hamidy

9-Jun-09 19:44

i thought the same as you, but i have done following from sql server, still i am getting no records

<br />
declare @codes varchar(max)<br />
select @codes=cast(quotename('28-2801','''')+','+quotename('28-2802','''') as varchar(max))<br />
print @codes --prints '28-2801','28-2802'<br />
exec [sp_detail] @codes

this doesent work too.
i think first i have to execute the statement in sql server, then i can simply can execute from c#.
in above statement any thing goes worong?

Abdul Rahaman Hamidy
Database Developer
Kabul, Afghanistan

Re: pass in parameter from c#

Christian Graus9-Jun-09 20:39

Christian Graus

9-Jun-09 20:39

hmmm.... perhaps there's a reason that I don't know why you can't pass in a string like that. Have you tried string mashing the sql in your proc, or just creating the SQL in code instead of using a proc ?

I think at this point you'd be better asking in the SQL forum ( where this question belonged from the start ), because that's where the SQL heavyweights will be hanging out .

Re: pass in parameter from c#

saurabh sahay11-Jun-09 5:37

saurabh sahay

11-Jun-09 5:37

Asking in the SQL forum would be best

problem with datatable.importrow

prasadbuddhika9-Jun-09 17:58

prasadbuddhika

9-Jun-09 17:58

i'm trying to get a selected range of data from a data set into a new data set,i use an array(dr2) of data rows and from that i get one row at a time and add it to new datatable(dt2), after it is added to a data set.

DataSet ds2 = new DataSet();
            DataTable dt2 =new DataTable();

            for (int start = startindex ;start < startindex+5 ; start++)
            {
                DataRow dd = dr2[start];
                dt2.ImportRow(dd);
            }

            ds2.Tables.Add(dt2);

            return ds2;

but the problem is when the dataset is returned it has the table with correct no of row, but the rows contain no data, what might be the problem

Re: problem with datatable.importrow

prasadbuddhika9-Jun-09 18:07

prasadbuddhika

9-Jun-09 18:07

sorry to disturb you people , i just found the solution , i missed the clone the table ,
thanx.

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