problem retrieving values from combo box - C# Discussion Boards

Re: count number of rows in query

7-Dec-04 1:59

If you are firing SQL queary ,then there is no way to get the number of rows get selected.Untile you collect the records in Dataset.

Sreejith Nair
[ My Articles ]

Jay Shankar7-Dec-04 17:00

Jay Shankar

7-Dec-04 17:00

do u want the number of records the query fetches.

If yes, prepare the sql string like the one below

Selcet Count(1) as RecordNum, col2, col3.... from table_name;

here "Count(1) as RecordNum" will give you the number of rows.

Regards,

Jay

Query SPS database?

6-Dec-04 20:57

Hi,

I tried to query a SPS database with a string query.

My code is like this:

\\It needs slashes to turn \" into "
string sQuery;
sQuery="";

The result shows in a textbox is like this:

The question is how I can make the result looks the same in a xml file without the slashes?

I tried to use the result(sResult) to use loadxml method from XmlDocument but not succeed because there are slashes in the string.

XmlDocument doc = new XmlDocument();
doc.LoadXml(sResult);

Any help would be appricated!

How can I dispose a client activated proxy in .Net Remoting?

Bjoern.adG6-Dec-04 20:57

Bjoern.adG

6-Dec-04 20:57

Hallo,

I am using client activated objects in .Net Remoting, therefore the remote objects are destroyed when the lease has expired. But I want do destroy the objects for myself (or close the connection for myself)

Important is that I want to do this from client's side. The objects inherit from MarshalByRefObject so I tried to call RemotingServices.Disconnect(MarshalByRefObject). However these objects are only proxies. Because of this I get an exeption with a message similiar to this. A possibility is to call this method on server's side.

public void CloseConnection()
{
RemotingServices.Disconnect(this);
}

But this requires additional network traffic for a method call each time.

UnregisterChannel(TcpClientChannel) does not work as well, because already existing connections are not destroyed.

I am able to prevent the client from creating new connections, but not from closing already existing ones. Can anybody help me?

Thanks,
Björn

problem retrieving values from combo box

Rashid_Mehmood6-Dec-04 20:06

Rashid_Mehmood

6-Dec-04 20:06

Dear Members
I have two questions, plz guide and oblidge
1). I populated the combo box by binding it with a dataset containing record of a user(i.e registrationNumber and userName). I set userName as the DisplayMember of combo box.
But when I tried to get the value of selected user by writing objCombo.SelectedItem.ToString() or objCombo.SelectedValue.ToString() or objCombo.SelectedText it returns me an object of DataRowView type and not the selected value. Plz guide how can I get the selected value? Plz also guide that is it possible that on selection of registrationNumber, I could get the userName against it?
2). How can I perform only the time manipulation through datetime object?
Regards

Re: problem retrieving values from combo box

sreejith ss nair6-Dec-04 21:24

Re: problem retrieving values from combo box

6-Dec-04 21:24

You can use Combo1.Text property to get the latest selected value from the list.

And suppose if you want to get the username after selecting the registration number, then you have write some logic to get it.

And what you really mean by time manipulation ?
D'Oh! | :doh:

Will you explain it little bit more ?

Sreejith Nair
[ My Articles ]

Skynyrd6-Dec-04 23:05

Skynyrd

6-Dec-04 23:05

U are trying to get the selectedvalue of your combo while ur datasource is filling up. Change ur event handler to SelectionChangeComitted (only fires when user changes the cbo, not code induced changes, as when filling up the datatable ur are linking to).

If ur source table has the userName and the registration Number, then simply bind the displaymember to the username column and the valuemember to the registrationNumber column. Get the selected item info through Text and SelectedValue.

Get data type and Create table

Member 10976996-Dec-04 19:37

Member 1097699

6-Dec-04 19:37

Hi,
I'm working on C# with foxpro database and I want to get type of field in a table of Foxpro database from C#. I also want to create a table in Foxpro database from C#.
Would you tell me How to do it? Thanks for your help.
Regard,

Embedding Win32 dll

Yaakov Davis6-Dec-04 18:43

6-Dec-04 18:43

It is posible to embed a Win32 dll into .Net dll?

Daniel Turini6-Dec-04 20:11

Daniel Turini

6-Dec-04 20:11

No, but you can call it using P/Invoke (search for DllImport).

Yes, even I am blogging now!

sreejith ss nair6-Dec-04 21:36

6-Dec-04 21:36

Yes. You can use Win32 dll's in your .NET dll. The idea P/Invoke is there to help you out. Please refer this link Interoperability

Sreejith Nair
[ My Articles ]

Yaakov Davis7-Dec-04 1:35

7-Dec-04 1:35

I'm afraid my question was misunderstood.

I did use the P/Invoke (and C++ Interop as well) to call some functions in Win32 dll, but when I want to run the program on different computer, I need to copy the dlls I called, to the same directory Where the .Exe resists.

There is any way do embed the dlls into the .exe?

My problem is security. I'm afarid that somebody will replace the dlls with his own.
Strong name isn't an option here, since the dlls are Win32 ones.

Thanks,
Yaakov

sreejith ss nair7-Dec-04 1:53

7-Dec-04 1:53

You Wrote :when I want to run the program on different computer, I need to copy the dlls I called, to the same directory Where the .Exe resists.

No. Each and every Windows operating system contain this Win32.dll file (excluding Windows 95. I think here it is Win16.dll) in it's System32 directory. So you don't want to copy the calling .dll. Refer using DllImport Attribute. Hope you understood.Please see that url that i attached in my last thread. Blush | :O

Sreejith Nair
[ My Articles ]

Yaakov Davis7-Dec-04 2:06

7-Dec-04 2:06

sreejith ss nair wrote:
So you don't want to copy the calling .dll.

Hi.

I DO want to copy the dll, since it isn't a windows dll. it's a dll of some third party API. The program doesn't load without the dll in the running directory.

I'll repeat my problem to make it clear.

I use an external Win32 (i.e. not .Net) dll which contains function foo(). The dll isn't part of Windows. I'm afraid that somebody will place in the folder a dll with the same name, that contains some malicious function foo(), who do some evil job before he calls in turn to the original foo().

I thought I can avoid this, if I find a way to embed the called dll in my application.

I'm open to another suggestion or information.

Thanks for your help.

Anybody please?

Yaakov Davis7-Dec-04 3:46

7-Dec-04 3:46

Yaakov

Dave Kreskowiak7-Dec-04 4:32

Dave Kreskowiak

7-Dec-04 4:32

There is no way to do this. Even if you packaged the .DLL into a resource in your .EXE, you'd still have to unpack it, save the .DLL file to the folder where your app is installed, and then call it.

But, someone that malicious could also just put a replacement .DLL into the folder where your app is installed, either tag it ReadOnly, or some other methdo to keep your app from putting the .DLL down successfully, whatever, and then your app would still call the bad .DLL.

The only method you can use to validate the .DLL is to run some kind of checksum, or some other file validation, on the .DLL file before you call it. But this is no way guarantees that the file your looking at is legitimate and it will also keep your application tied to a specific version of the .DLL file.

But this is a calculated risk that EVERY Windows application takes. There is just no reliable way to do this with a Win32 .DLL. Every Win32 .DLL can be impostered by a custom written replacement, using the same signatures and GUID's as your .DLL.

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

Yaakov Davis7-Dec-04 8:10

7-Dec-04 8:10

Dave Kreskowiak wrote:
...the same signatures and GUID's as your .DLL.

Thanks for making things clear.
How can I get the GUID and the signature?

Yaakov

Dave Kreskowiak7-Dec-04 11:42

Dave Kreskowiak

7-Dec-04 11:42

The GUIDs are scattered abou in the registry. You'll need to search for the object names exposed by the .DLL in order to find them. The function signatures cannot be had unless you have the source code for the .DLL.

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

Another question

Yaakov Davis7-Dec-04 11:54