Visual Basic

Re: problem with database

8-Mar-09 13:18

His requirement is superficial and leads to a problem. The solution is a bad one in a production application. Localized apps will not have the same text in the button.Text property as in the inevitble code he will write.

Accepted solutions are to either
1. visually swap out the button with another, prewired button, or, less likely,
2. change the properties of the button, then rewire the Click event handler.

I go for the simpler solution.

Checking for the text as a "switch" does approximately the same thing as option number 2, but relies unreleliable information to do it.

The inevitable code he will write will consist of putting all the "work" code in the button handler (bad practice!) and throwing in an if statement to branch between two sections of code that really should be in their own methods.

A guide to posting questions on CodeProject[^]

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

problem with database

nazimghori8-Mar-09 0:04

nazimghori

8-Mar-09 0:04

hello every one

I m using sqlserver 2005 as an backend tool and vb.net as front end in my project now when i fire n update query
using datareader and cmd.execute nonquery method.

eg:-

obj.strexecutesql("update regi_mast set regi_numb='" + Me.txt3.Text + "'where regi_numb=" + strid)
obj.lfill(Me.lst1, "select * from regi_mast")
this strid is one label in form which is havng value of listview subitem number..

nw in catch block is having exception like:-

Conversion from string "update regi_mast set regi_numb='" to type 'Double' is not valid.

also i m a beginner..
so plz help me...
thank u...

Colin Angus Mackay8-Mar-09 2:21

Colin Angus Mackay

8-Mar-09 2:21

nazimghori wrote:
strexecutesql

nazimghori wrote:
lfill

These are not .NET methods. Did you create these yourself?

nazimghori wrote:
("update regi_mast set regi_numb='" + Me.txt3.Text + "'where regi_numb=" + strid)

This is vulnerable to a SQL Injection Attack. Please use parameterised queries and read Tips on How to Prevent SQL Injection Attacks[^]

The reason for the issue is that you are enclosing the value for regi_numb in quotes making it a string. You should use parameterised queries to ensure that the correct data types are used.

*Developer Day Scotland - Free community conference Delegate Registration Open

Re: problem with database

nazimghori8-Mar-09 3:39

nazimghori

8-Mar-09 3:39

thank u

lfill and strexecutesql they are the mehtod declared in a seperate class file and through that an object is passed in form for its use....

thanks again

IPTC

pvatanpour7-Mar-09 19:43

pvatanpour

7-Mar-09 19:43

How can I read jpeg's metadata in IPTC format?

Pouya

Re: IPTC

Alan N8-Mar-09 1:36

Alan N

8-Mar-09 1:36

Try this. It contains a good reference containing clear code for a working sample application.

http://www.codeproject.com/script/Forums/View.aspx?fid=1646&msg=2939071[^]

Alan.

key press [modified]

JAYRAJ GIRI7-Mar-09 17:43

JAYRAJ GIRI

7-Mar-09 17:43

If Not (e.KeyChar >= "0" And e.KeyChar < "9" Or e.KeyChar = vbBack) Then
e.Handled = True

modified on Sunday, March 8, 2009 12:49 AM

dan!sh 7-Mar-09 18:41

dan!sh

7-Mar-09 18:41

WTF

Happy Holi[^]

जय हिंद

ABitSmart7-Mar-09 19:21

ABitSmart

7-Mar-09 19:21

"An unhandled exception occurred and the all reply to your post should be terminated."

Have some Beer | [beer]

Luc Pattyn8-Mar-09 1:15

Luc Pattyn

8-Mar-09 1:15

again[^]

Luc Pattyn [Forum Guidelines] [My Articles]

- before you ask a question here, search CodeProject, then Google
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get
- use the code block button (PRE tags) to preserve formatting when showing multi-line code snippets

Move along. Nothing to see here...

0x3c08-Mar-09 2:23

0x3c0

8-Mar-09 2:23

Your IP address has been noted and your location triangulated. As you read this, a highly trained secret agent is on his way. If you do not stop your useless posting habits, he will stand behind you and release a highly trained ninja monkey. I cannot be held responsible for the ninja monkey's actions

Dave Kreskowiak8-Mar-09 6:33

8-Mar-09 6:33

Once again, you have post a snippet of code wihtout explaining anything about a problem you're having with it, or any other type of intelligent question.

A guide to posting questions on CodeProject[^]

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

Christian Graus8-Mar-09 17:13

Christian Graus

8-Mar-09 17:13

You are an idiot. You post this sort of drivel daily. What if your boss finds CP ? What if he realises how utterly useless, even by Indian outsourcing standards, you are ?

Christian Graus

Driven to the arms of OSX by Vista.

Windows hook

robertw0197-Mar-09 12:17

robertw019

7-Mar-09 12:17

Looking to create a global hook to intercept WM_WINDOWPOSCHANGED messages. So far all attempts to create a hook always end up not functioning properly. I create the hook then filter out messages that aren't what I'm looking for, but it always seems to make all non-system processes that are running crash.
My Code:

Public Class WM_WINDOWPOSCHANGED
       Shared Event WindowMoving(ByVal handle As IntPtr)
       Shared hookhandle As Integer
       Shared hookhandler As HookHandler
       Private Sub New()

       End Sub
       Public Shared Sub CreateTheHook()
           'If hookhandle = 0 Then
           '    hookhandle = User32Imports.SetWindowsHookEx(CInt(HookCodes.WH_CALLWNDPROC), hookhandler, Marshal.GetHINSTANCE(Assembly.GetExecutingAssembly().GetModules()(0)), CInt(0))
           '    MsgBox(hookhandle)
           'End If
           hookhandler = New HookHandler(AddressOf ChangeButtonHost)
           hookhandle = User32Imports.CreateSystemHook(Marshal.GetHINSTANCE(Assembly.GetExecutingAssembly().GetModules()(0)), hookhandler)
           If hookhandle <> 0 Then MsgBox("hi")
       End Sub
       Shared Function ChangeButtonHost(ByVal nCode As Integer, ByVal wParam As IntPtr, ByVal lParam As IntPtr)
           If nCode >= 0 Then
               Dim cwps As CWPSTRUCT = DirectCast(System.Runtime.InteropServices.Marshal.PtrToStructure(lParam, GetType(CWPSTRUCT)), CWPSTRUCT)
               Dim winfo As New WindowInfo(cwps.hwnd)
               If cwps.message = &H46 And WindowInfo.IsValid(cwps.hwnd) And winfo.ShowInTaskbar = True Then
                   RaiseEvent WindowMoving(cwps.hwnd)
               End If
           End If
           Return 0 'User32Imports.CallNextHookEx(hookhandle, nCode, wParam, lParam)
       End Function
   End Class

Friend Class User32Imports
       <DllImport("user32.dll", CharSet:=CharSet.Auto, CallingConvention:=CallingConvention.StdCall)> _
       Friend Shared Function SetWindowsHookEx(ByVal idHook As Integer, ByVal lpfn As HookHandler, ByVal hInstance As IntPtr, ByVal ThreadId As Integer) As Integer
       End Function
       <DllImport("user32.dll", CharSet:=CharSet.Auto, CallingConvention:=CallingConvention.StdCall)> _
       Friend Shared Function CallNextHookEx(ByVal idHook As Integer, ByVal nCode As Integer, ByVal wParam As IntPtr, ByVal lparam As IntPtr) As Integer
       End Function

   End Class>

EDIT: CreateSystemHook was my attempt at doing the hook code in C++, that also failed.

Dave Kreskowiak8-Mar-09 6:31

8-Mar-09 6:31

It's not going to work. You can't implement system-wide hooks inside managed code. You'll have to write a C++ "normal" .DLL to handle the hook, then expose an itnerface you can use to talk to managed code, like C# or VB.NET. .NET does not support the exports required of a .DLL to support a system-wide hook. It'll work for a "local" hook. That is, hooking your own application, but not system-wide. You can find Microsoft's documentation on it here[^].

A guide to posting questions on CodeProject[^]

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

robertw0198-Mar-09 6:37

robertw019

8-Mar-09 6:37

Thanks for the response. I've looked at the MSDN docs for hooks, and created a C++ version, but I'm getting the same results.

scofflaw8-Mar-09 9:08

scofflaw

8-Mar-09 9:08

Maybe this CodeProject article will help you:
http://www.codeproject.com/KB/cs/globalhook.aspx

Firefox style url texbox and tabs

robertw0198-Mar-09 15:48

robertw019

8-Mar-09 15:48

Thats for the mouse and keyboard hooks right? Neither will work in this case.

sphlynx7-Mar-09 10:34

sphlynx

7-Mar-09 10:34

Hey guys i'm building an application with a multi tab interface, i have a textbox above and a tabstrip below.

What i want is for the textbox to remember the entry of the active tabpage even after switching back nd forth b/w tabs, for example i want to able to create a new tabpage with a texbox entry "hello", and a second tabpage with a different textbox entry like say "world" but still same textbox and wen i switch b/w tabs, i want the textbox to still hold the textbox entry for each tab... Just like tabs in firefox browser... I tried creating instances of the textbox any time a new tab was created, but it did not work, all tabs still had thesame texbox entry.... Im really hoping u guyz find a solution cuz i've been tryin to solve dis prob for the past three days...

Note, am not creating a browser application and am pretty noobish.
I hope u guys get me.
Thanks in advance

*Developer Day Scotland - Free community conference Delegate Registration Open

Colin Angus Mackay7-Mar-09 14:45

Colin Angus Mackay

7-Mar-09 14:45

The text box would presumably be outside of the tab control. In that case you can handle the event of the user switching tabs to update the text box.

sphlynx wrote:
Im really hoping u guyz find a solution cuz i've been tryin to solve dis prob for the past three days...
...
I hope u guys get me.

It would be easier if you didn't use text-speak.

"Im" has an apostrophe "I'm".
"u" either means you've switched to Dutch or you are lazy. The word is "you".
"guyz" is incorrect. To form a plural in English you generally add an "s", never a "z".
"cuz" is just laziness. The word is "because".
"tryin" is again lazy. The word is "trying".
"dis" is more laziness. The word is "this".
"prob" is seriously lazy. The word is "problem".

Seriously, if I had a child that wrote like this I'd send them to a remedial class.

sphlynx7-Mar-09 23:15

sphlynx

7-Mar-09 23:15

Thnks for d reply, tab switching is not the main thing here, wat i want is for d textbox to remember the text input entered wen tab1 is active, then wen u create a new tab, it clears the textbox and if another text is entered wen tab2 is active, it should also store it, then if u go back to tab1, the textbox should display the text input entered wen tab1 was last active and vice versa...

I dont think the use of proper english should be an issue here am not writing an essay or term paper, if u hav an answer to the question, pls kindly state it, instead of deviating from the issue at hand.
Thanks...

*Developer Day Scotland - Free community conference Delegate Registration Open

Colin Angus Mackay8-Mar-09 2:14

Colin Angus Mackay

8-Mar-09 2:14

sphlynx wrote:
I dont think the use of proper english should be an issue here am not writing an essay or term paper

But it does make it very difficult for me to read. The reason essays and term papers for school, college or universities require you to write in proper English is to prepare you for the real world.

For example, I recently had to scope out some work for a client. In that I had to seek some suppliers for data that was needed for the solution. One potenatial supplier was the Royal Mail. They communicated like you in emails. They lost the sale.

If I can't read what you are tying to say then I find it difficult to help you. You have to help me (understand your problem) to help you (find a solution).

sphlynx wrote:
if u hav an answer to the question, pls kindly state it, instead of deviating from the issue at hand.

I'm not deviating. I am trying to help you. You will find that if you write properly more people are willing to help you. That benefits you. Therefore by pointing this out to you I am helping you. I can work around the odd typo or slight grammatical error if English is your second language, but showing an arrogant disregard to the language you are attempting to communicate in will not help you.

If you want the text box to remember what was in it when a particular tab was active then create some sort of tab state object (i.e. create your own class to put things in) with a property to hold the information in the text box. Add an object of this class to the Tag property of each tab. When the text is updated in the text box then also update the property in your object.

Deleting a file with Administrator privileges in vista using vb.net

sphlynx9-Mar-09 7:14

sphlynx

9-Mar-09 7:14

Thanks i'll try that.

David Jiboye7-Mar-09 8:38

David Jiboye

7-Mar-09 8:38

Hi Everyone,

I am building an app where it will be necessary to delete files from a drive.
This I have noticed will need some administrator privileges. I don't want to adjust
the UAC settings of the project. I just need this privilege at run time. I have been using
the System.Security.AccessControl class but to change the rights has not just been possible.
Can someone help.

Re: Deleting a file with Administrator privileges in vista using vb.net

Dave Kreskowiak8-Mar-09 6:20