C# Discussion Boards - CodeProject

zaboboa11-Nov-05 4:25

11-Nov-05 4:25

Hello,

Is it possible to populate the range of cells in Excel from the datagrid?
Instead of populating it cell by cell.

Thank you.

Re: Excel Range object

Dwayner7911-Nov-05 8:15

Dwayner79

11-Nov-05 8:15

try here
http://www.xtremevbtalk.com/

They have a stronger Excel group there. .NET stuff, you are way better here.

*****************
"We need to apply 21st-century information technology to the health care field. We need to have our medical records put on the I.T." —GW

How to get dependancies of SQL Functions?

pubududilena11-Nov-05 1:37

pubududilena

11-Nov-05 1:37

hi all,
In our Application ,we have to use 175 SQL Functions.So there are many dependancies between each other.
That mean ,If we creating a function,we have to use several function to create it.
So I need to create a function relation ship between each other.(like relatinship between Tables)

Is there a way to get dependancies and relation in functions?

thanks in advance.

Re: How to get dependancies of SQL Functions?

Colin Angus Mackay11-Nov-05 4:17

Colin Angus Mackay

11-Nov-05 4:17

pubududilena wrote:
Is there a way to get dependancies and relation in functions?

You can use sp_depends[^]

My: Blog | Photos

"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious

Window Form like Google Desktop ???

faviochilo11-Nov-05 1:28

faviochilo

11-Nov-05 1:28

Hi guys

I don't remember where (in COdeProject) is a sample of an window form that is part oh the Windows Desktop . It's similar to "Google Desktop Sidebar"

can you write the link please ??

Thanks

Which function is like "getch()" in Console App?

Lane Yu11-Nov-05 1:15

Lane Yu

11-Nov-05 1:15

Hi, i'm starting to learn C#. Laugh | :laugh:

I want to output a pause(such as "press any key to continue...") in a console application. I just need a function like "getch()" in C language. Which object and method to use?

Thanks.

Re: Which function is like &quot;getch()&quot; in Console App?

J4amieC11-Nov-05 1:56

J4amieC

11-Nov-05 1:56

Console.Read();
or
Console.ReadLine();

Re: Which function is like &quot;getch()&quot; in Console App?

Febret11-Nov-05 1:57

Febret

11-Nov-05 1:57

Console.ReadKey should do the trick.

Bye!

Re: Which function is like &amp;quot;getch()&amp;quot; in Console App?

J4amieC11-Nov-05 2:32

J4amieC

11-Nov-05 2:32

There is no ReadKey method on System.Console WTF | :WTF:

Re: Which function is like &amp;amp;quot;getch()&amp;amp;quot; in Console App?

Febret11-Nov-05 2:40

Febret

11-Nov-05 2:40

Whoops: Console.ReadKey is on Framework 2.0 only, sorry D'Oh! | :doh:

Re: Which function is like &amp;amp;amp;quot;getch()&amp;amp;amp;quot; in Console App?

Lane Yu11-Nov-05 3:35

Lane Yu

11-Nov-05 3:35

You mean i'm helpless unless downloading Framework2.0? Sigh | :sigh:

Re: Which function is like &amp;amp;amp;amp;quot;getch()&amp;amp;amp;amp;quot; in Console App?

J4amieC11-Nov-05 4:14

J4amieC

11-Nov-05 4:14

No, you're only helplessuntil you go back and read the replies properly WTF | :WTF:

Re: Which function is like &amp;amp;amp;amp;quot;getch()&amp;amp;amp;amp;quot; in Console App?

Febret11-Nov-05 4:18

Febret

11-Nov-05 4:18

Of course not Big Grin | :-D

In Framework 1.0 / 1.1 You have to use Console.Read(), as J4amieC suggested.

Bye!

Re: Which function is like &amp;amp;amp;amp;amp;quot;getch()&amp;amp;amp;amp;amp;quot; in Console App?

Lane Yu11-Nov-05 4:27

Lane Yu

11-Nov-05 4:27

But Console.Read() is not as getch().
I only want a single char from keyboard without echo.

Confused | :confused:

Re: Which function is like getch() in Console App?

Rob Philpott11-Nov-05 5:15

Rob Philpott

11-Nov-05 5:15

Not sure this is possible using just the Console object prior to .NET 2.0 - it's a very minimalist implementation. Should be straightforward enough using P/Invoke with the Platform SDK though.

Take a look at: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dllproc/base/console_reference.asp[^], and drop me a line if you get stuck.

Regards,
Rob Philpott.

Re: Which function is like getch() in Console App?

Lane Yu11-Nov-05 5:48

Lane Yu

11-Nov-05 5:48

I see.
I'm a begginer of C#. So far I don't know how to call a Windows API.
So I think I should learn more firstly.

Thanks all of you. Big Grin | :-D

Re: Which function is like &amp;amp;amp;amp;amp;amp;quot;getch()&amp;amp;amp;amp;amp;amp;quot; in Console App?

Febret11-Nov-05 6:05

Febret

11-Nov-05 6:05

I see: if you want to read a single character from the user (any charachter, not an enter key press), and you don't want that character to be shown, the only way to do it on .Net 1.0 /1.1 (the 2.0 Console.ReadKey does the same thing) is to import _getch from msvcrt.dll.

You can use this code (by reinux from http://www.codeproject.com/useritems/PressAnyKeyToContinue.asp):

[DllImport("msvcrt.dll")]
private static extern int _getch();

public static int Getch()
{
	try
	{
		return _getch();
	}
	catch
	{
		return Console.Read();
	}
}

Insert this into a class and then you should be able to use Getch() to do what you need.

Bye!

DirectoryEntry.Properties["memberOf"]

Chris_Green11-Nov-05 0:58

Chris_Green

11-Nov-05 0:58

I'm curious about DirectoryEntry.Properties["memberOf"] and "Domain Users". Let's assume that I know a little about AD and that I can properly get the DirectoryEntry to any domain user. Now, every group that the user belongs to is in the memberOf property except for one exception. "Domain Users", is it a special case? Is it implied that if I get a valid DirectoryEntry that, of course, the user is a member of "Domain Users" and therefore "Domain Users" isn't in the memberOf property?

Should you put config files in the GAC with assemblies?

pliu_200011-Nov-05 0:52

pliu_2000

11-Nov-05 0:52

Hi,
This is my first post here so please be gentle Smile | :)

I know it is possible to copy config files into the GAC such that an assembly can read from it based on its own location. This avoids having to partially hard code a location for the config file. However, is this good practice? What is the best approach for doing this?

Thanks in advance Big Grin | :-D

Re: Should you put config files in the GAC with assemblies?

S. Senthil Kumar11-Nov-05 2:58

S. Senthil Kumar

11-Nov-05 2:58

Really? I thought GAC stood for "Global *Assembly* Cache"?

Regards
Senthil
_____________________________
My Blog | My Articles | WinMacro

Re: Should you put config files in the GAC with assemblies?

pliu_200011-Nov-05 3:09

pliu_2000

11-Nov-05 3:09

<I though GAC stood for "Global *Assembly* Cache"?>

Precisely my point, hence why I asked if this was good practice and if there was a "good" way of referencing configuration information from the GAC.

If the only solution is to hard reference the config file then that is what I have to do. However, if there is another way, then I would really be interested.

Btw - thanks for the reply Wink | ;)

IME and Language Bar

jonny511-Nov-05 0:05

jonny5

11-Nov-05 0:05

Anyone know how to programitically switch language when the focus hits a textbox? I am writing a dual-language application and want to switch to Thai from English when the user tabs into a textbox, rather than have the user goto the language bar to do so....

Thanx!

Jon Humphreys
ActivePlanet Software
Bangkok, Thailand

How to use parameter for oracle?

rushing10-Nov-05 22:14

rushing

10-Nov-05 22:14

I have create a storage procedure Insert_Data in Oracle, which return a parameter new_ID.
Now I use the OledbCommand to execute the procedure.
How to get the returned parameter new_ID?
Thanks!

Check if a file is used by an other process

holgerl10-Nov-05 22:13

holgerl

10-Nov-05 22:13

I'm writing a program (Vis. C# .NET) to move files, depending from content, to a backup server. Sometimes the file cannot be deleted afdter copying because it is opened by an other process. The best would be to have a test a first that gives me a result if a specific file is opened by an other process or not.

How this can be done ? At least I need a boolean answer if the file is opened in this moment by anything other or not. The better way would be to have an answer which process has opened it.

Can anybody give me a hint for a good solution ?

Holger

Re: Check if a file is used by an other process

jonny511-Nov-05 0:13

jonny5

11-Nov-05 0:13

I would think that you could just try to open the file for exclusive read access - that should throw an exception. As for the ultimate, you would have to use interop and Win32 functions to delve into the finer details. The OpenFile() Win32 function might do a better job than .Net for what you want. This site really helps with the interop stuff....

http://pinvoke.net

Jon Humphreys
ActivePlanet Software
Bangkok, Thailand

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