Re: Delete Query String in Oledb - C# Discussion Boards

AnonymousTwo17-Jul-05 6:09

17-Jul-05 6:09

Hi Brian,

Doesn't [^\n] stand for anything but new line character?

Basically I'm trying to get the body of a procedure or function by the name. For example:

create function dbo.user_id(in @user_name char(128) default
null)
returns integer
on exception resume
begin
declare id integer;
select user_id into id
from SYS.SYSUSERPERMS where
user_name = isnull(@user_name,current user);
return(id)
end

What I need is the part between begin and end.

Thanks for helping !

Re: Regular expression efficiency

Brian Delahunty17-Jul-05 7:30

Brian Delahunty

17-Jul-05 7:30

Anonymous wrote:
Doesn't [^\n] stand for anything but new line character?

Ah, yes... mis read your expression.

This regex will do:

(?smnx-i)begin\n(?<StoredProcBody>.*)end

The body is stored in the named capture StoredProcBody

Regards,
Brian Dela Smile | :)

Blog^

Co-author of The Outlook Answer Book... Go on, pre-order^ it today!

Regular Expression Library builder^

C# Obfuscations - need your input on my questionnaires please

Chua Wen Ching17-Jul-05 1:55

Chua Wen Ching

17-Jul-05 1:55

Dear all,

I am not too sure whether I can post this here.

I hope I am not advertising. I am working on a community project to share to the public on obfuscation.

I had prepared a set of questionnaires and hope you can fill in. I know it is quite trouble some.

http://nos.blogsome.com/2005/07/17/noos-questionnaires/

Thank you.

Cheers.

Regards,
Chua Wen Ching
Visit us at http://www.necoders.com

listview autoarrange

Sabry190517-Jul-05 1:52

Sabry1905

17-Jul-05 1:52

now i can get the window handle of the desktop listview , but till now i dont know how to set it to autoarrange icons, is there any way can do this

Re: listview autoarrange

Alex Korchemniy17-Jul-05 14:29

Alex Korchemniy

17-Jul-05 14:29

Why?

Alex Korchemniy

Re: listview autoarrange

Sabry190517-Jul-05 21:15

Sabry1905

17-Jul-05 21:15

coze i am devloping a software that manage desktop icons Smile | :)

Delete Query String in Oledb

pakFari16-Jul-05 23:55

pakFari

16-Jul-05 23:55

hi, there are two query string i want to combine them
string str = "xyz";
double waist = 123;
string query1 = "delete from Trouser where Company = " + "'" + str + "'";
string query2= "delete from Trouser where Waist = " + waist ;

i want to make them one using "where" clause. plz help me i will be very thankful to u.

Re: Delete Query String in Oledb

Colin Angus Mackay17-Jul-05 1:23

Colin Angus Mackay

17-Jul-05 1:23

If we ignore the gaping hole in the security of your application (May I suggest that you read SQL Injection Attacks and Tips on How to Prevent Them[^]) you can easily combine the two statements into one by using OR in the WHERE clause.

e.g.

DELETE FROM Trouser WHERE Company = 'abc' OR Waist = 123

That will delete the row where any of the conditions are true. Compare this with AND where all the conditions must be true in order for the row to be deleted.

Does this help?

My: Blog | Photos
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More

redirect shortcut key

Sabry190516-Jul-05 23:54

Sabry1905

16-Jul-05 23:54

i want to redirect (windows logo key +D) to another windows shortcut key (windows logo+M), is there any way to do this using C# ? Smile | :)

Re: redirect shortcut key

Alex Korchemniy17-Jul-05 14:32

Alex Korchemniy

17-Jul-05 14:32

See: RegisterHotKey function in MSDN

Tip: perform a search on google "registerhotkey site:msdn.microsoft.com"

Alex Korchemniy

Re: redirect shortcut key

Sabry190517-Jul-05 21:20

Sabry1905

17-Jul-05 21:20

i know this, but its still not the solution coze first i have to catch the message of (win logo+D) then disable it -(all the time when my program is running)- and then send another message (win logo+M)
thats all Smile | :)

getting registered file extensions

g00fyman16-Jul-05 20:53

g00fyman

16-Jul-05 20:53

hi to all,

i am trying to get all registered file extensions on a system so i can filter queries to the filesystem that is displayed in a ListView Control

i am iterating the subkeys of CLASSES_ROOT but i am getting alot of keys that do not appear within the display of the Windows 'add new file type' list box. is there a way to only get this list of extensions ?

i will paste my code which basically just gets all subkey names starting with '.'

<br />
public IList<string> GetFileTypes()<br />
        {<br />
            IList<string> fileTypes = new List<string>();<br />
            RegistryKey root = Registry.ClassesRoot;<br />
            string[] subkeys = root.GetSubKeyNames();<br />
<br />
            foreach (string key in subkeys)<br />
            {<br />
                if (key.StartsWith("."))<br />
                {<br />
                    fileTypes.Add(key.Substring(1));<br />
                }<br />
            }<br />
            return fileTypes;<br />
        }<br />

thanx to all,
g00fy

Re: getting registered file extensions

g00fyman17-Jul-05 2:05

g00fyman

17-Jul-05 2:05

ok so i can get them now without any problems, the same as MS file types window but the icon is not displayed, y is this so ?

i am definitley getting the icons (both large and small) i can see it when debugging, but they dont appear in listview control, my code is long so i will have to email if someone can help but i am basically

...

iterating the registry keys to find file types, adding the small and large icons to thier respective imagelists (iteratively) and then adding the string array of extension and description to the listviews items list (also iteratively).

...

this is all done in InitaliseValuesInControl()

<br />
public FileTypeControl()<br />
        {<br />
            InitializeComponent();<br />
<br />
            handler = new IconHandler();<br />
            fileEntries = new Dictionary<string, FileType>();<br />
<br />
            InitaliseValuesInControl();<br />
<br />
        }<br />

i have tried to pull all code from InitializeComponent() and put it into the InitaliseValuesInControl() method so i was drawing the control after the imagelists and item list were populated but it still doesnt display the image.

any ideas please ?

kind regards,
g00fy

Re: getting registered file extensions

g00fyman17-Jul-05 3:34

g00fyman

17-Jul-05 3:34

I fixed it, found an overload method i could use

Big Grin | :-D

SHGetFileInfo icon and dispose

CiNN16-Jul-05 17:03

CiNN

16-Jul-05 17:03

I am using a dllimport of SHGetFileInfo to retrieve a file icon, and then add it to an image list.
is there something i need to disposse ?

this line

<br />
this.iconsListSmall.Images.Add( FileGetIcon( fi.FullName, true ) );<br />

and this function

<br />
        public static Icon FileGetIcon( string strPath, bool bSmall )<br />
        {<br />
            <br />
            SHFILEINFO info = new SHFILEINFO( true );<br />
            uint cbFileInfo = ( uint )Marshal.SizeOf( info );<br />
            SHGFI flags;<br />
            if ( bSmall )<br />
                flags = SHGFI.Icon | SHGFI.SmallIcon | SHGFI.UseFileAttributes;<br />
            else<br />
                flags = SHGFI.Icon | SHGFI.LargeIcon | SHGFI.UseFileAttributes;<br />
<br />
            SHGetFileInfo( strPath, 256, out info, cbFileInfo, flags );<br />
            return System.Drawing.Icon.FromHandle( info.hIcon );<br />
        }<br />

Re: SHGetFileInfo icon and dispose

Alex Korchemniy17-Jul-05 14:35

Alex Korchemniy

17-Jul-05 14:35

Well if you search google: "SHGetFileInfo site:msdn.microsoft.com"

You will see towards the bottom of the page: If SHGetFileInfo returns an icon handle in the hIcon member of the SHFILEINFO structure pointed to by psfi, you are responsible for freeing it with DestroyIcon when you no longer need it.

Alex Korchemniy

Re: SHGetFileInfo icon and dispose

CiNN17-Jul-05 15:06

CiNN

17-Jul-05 15:06

so should i

<br />
icotmp = FileGetIcon( fi.FullName, true );<br />
this.iconsListSmall.Images.Add( icotmp );<br />

<br />
DestroyIcon( icotmp.Handle );<br />

<br />
icotmp.Dispose();<br />

or should i free it in FileGetIcon() before returning the copied icon in a system.drawing.icon

<br />
FileGetIcon()<br />
..<br />
DestroyIcon( info.hIcon  );<br />
Icon ico = System.Drawing.Icon.FromHandle( info.hIcon );<br />
return ico;<br />

Take screenshots using C#?

Lord Kixdemp16-Jul-05 16:25

Lord Kixdemp

16-Jul-05 16:25

Hello! (Two posts in a row!) Big Grin | :-D

Question now is, how do I take screenshots in C#? I searched for articles but the only one I found was for C++... Frown | :(

Thanks!

Darth_Sulfur (Sulfurik)
http://www.SulfurSoft.tk
ftp://tsfc.ath.cx
http://tsfc.ath.cx
hotline://tsfc.ath.cx

Re: Take screenshots using C#?

bneacetp16-Jul-05 17:02

bneacetp

16-Jul-05 17:02

See if this article helps you out. http://www.codeproject.com/csharp/cscapturescreen1.asp[^]

John 3:16: "For God so loved the world, that he gave his only begotten Son, that whosoever believeth in him should not perish, but have everlasting life."

Re: Take screenshots using C#?

Lord Kixdemp16-Jul-05 18:45

Lord Kixdemp

16-Jul-05 18:45

Yep, just what I needed! Thanks! Wink | ;)

Darth_Sulfur (Sulfurik)
http://www.SulfurSoft.tk
ftp://tsfc.ath.cx
http://tsfc.ath.cx
hotline://tsfc.ath.cx

Paint control?

Lord Kixdemp16-Jul-05 16:18

Lord Kixdemp

16-Jul-05 16:18

Hello everybody! Big Grin | :-D

OK, does anyone know of a paint control, similar to the one in MS Paint?
Thanks! Wink | ;)

Darth_Sulfur (Sulfurik)
http://www.SulfurSoft.tk
ftp://tsfc.ath.cx
http://tsfc.ath.cx
hotline://tsfc.ath.cx

Re: Paint control?

Tomas Petricek17-Jul-05 1:53

Tomas Petricek

17-Jul-05 1:53

You can look at this project: http://www.eecs.wsu.edu/paint.net/index.htm[^]

Tomas Petricek (Microsoft C# MVP)
www.eeeksoft.net | Photos | ASP.NET Multi-column layout control

Re: Paint control?

Lord Kixdemp17-Jul-05 6:11

Lord Kixdemp

17-Jul-05 6:11

Thanks!

I'll try to extract the thing from the code. Thanks! Wink | ;)

Darth_Sulfur (Sulfurik)
http://www.SulfurSoft.tk
ftp://tsfc.ath.cx
http://tsfc.ath.cx
hotline://tsfc.ath.cx

Asynchronous Comms

Anonymous16-Jul-05 13:15

Anonymous

16-Jul-05 13:15

Does anyone know how to write a function in c# to connect with a modem and report back to the caller the result using th MS Comm Control in .Net?

Thanks
Chris

bandwidth usage

Mohamad Al Husseiny16-Jul-05 10:37

Mohamad Al Husseiny

16-Jul-05 10:37

i want to know how much bandwidth the computer connected
to the internet used and when the internet is idle
i mean no app or user access the internet
thanks in advance

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