Re: OdbcCommand not taking - C# Discussion Boards

Not Active10-Jul-06 6:50

10-Jul-06 6:50

First question would be why are you using OdbcCommand rather than SqlCommand? It appears you are connecting to a Sql Server database.

Re: OdbcCommand not taking

HahnTech10-Jul-06 10:16

HahnTech

10-Jul-06 10:16

Well some sites use MS SQL others use Postgrsql. When you write code that is flexible and not just MS you can't always take the easy way.

Ronald Hahn, CNT - Computer Engineering Technologist

New Technologies Analyst

HahnTech Affiliated With Code Constructors
Edmonton, Alberta, Canada
Email: rhahn82@telus.net

Re: OdbcCommand not taking

Not Active10-Jul-06 11:33

Not Active

10-Jul-06 11:33

True enough. You didn't mention anything about the databases you were using. From the evidence you provided it seemed only SQL Server.

You might want to look at the Microsoft Enterprise Library and the Data Application block to assist in writing a more generic data access layer.

Re: OdbcCommand not taking

HahnTech10-Jul-06 13:23

HahnTech

10-Jul-06 13:23

Thanks for the link. I need all the help i can get with this two DBS thing.

Ronald Hahn, CNT - Computer Engineering Technologist

New Technologies Analyst

HahnTech Affiliated With Code Constructors
Edmonton, Alberta, Canada
Email: rhahn82@telus.net

Re: OdbcCommand not taking

Colin Angus Mackay10-Jul-06 12:20

Colin Angus Mackay

10-Jul-06 12:20

HahnTech wrote:
Well some sites use MS SQL others use Postgrsql. When you write code that is flexible and not just MS you can't always take the easy way

Ummm.....

You are going to have to write different SQL queries anyway for each database because of the differences in the way SQL is implemented in each database. If you write a proper DAL (Data Access Layer) you can swap in and out the DAL depending on the datbase you are using. The rest of the application uses interface(s) to the DAL, so both have the same public methods. However, inside each of the DAL classes the datbase code is optimised for the appropriate database.

Scottish Developers events:
* .NET debugging, tracing and instrumentation by Duncan Edwards Jones and Code Coverage in .NET by Craig Murphy
* Developer Day Scotland: are you interested in speaking or attending?
My: Website | Blog

Re: OdbcCommand not taking

Guffa10-Jul-06 7:06

Guffa

10-Jul-06 7:06

Parameters in ODBC don't have names. Use "?" in the query to identify the parameters, and add the parameters to the parameter collection in the same order as they appear in the query.

---
b { font-weight: normal; }

Re: OdbcCommand not taking

HahnTech10-Jul-06 10:19

HahnTech

10-Jul-06 10:19

Cool Thanks for the help. I Guess I'm going to just to Replace() on the input string then. The attraction of using parameters was that it allowed a bit of latitude in how the sql strings where made.

Ronald Hahn, CNT - Computer Engineering Technologist

New Technologies Analyst

HahnTech Affiliated With Code Constructors
Edmonton, Alberta, Canada
Email: rhahn82@telus.net

Re: OdbcCommand not taking

led mike10-Jul-06 10:39

led mike

10-Jul-06 10:39

HahnTech wrote:
I Guess I'm going to just to Replace() on the input string then.

Why? Just use '?'

Select System_id From [DFIParmsHTS].[docsadm].[ExtGroup] where CustNumber = ?

then

cmdSelect.Parameters.Add("", vfx.TNM);

"Just about every question you've asked over the last 3-4 days has been "urgent". Perhaps a little planning would be helpful?"
Colin Angus Mackay in the C# forum

led mike

Re: OdbcCommand not taking

HahnTech10-Jul-06 11:34

HahnTech

10-Jul-06 11:34

Yeah that would work Great if I was always only going to use one where clause or if this was the only sql statement in the program. But tomorrow or a week from now, myself or some one else will have to edit the sql to return a smaller range and forget that its ordinal specific then spend 2h trying to figure out why its not working. Replace() is ordinal unspecific and works all the time. I envy all you programmers that get to use a static DB schema.

Ronald Hahn, CNT - Computer Engineering Technologist

New Technologies Analyst

HahnTech Affiliated With Code Constructors
Edmonton, Alberta, Canada
Email: rhahn82@telus.net

Re: OdbcCommand not taking

led mike10-Jul-06 12:08

led mike

10-Jul-06 12:08

Stored Procedures

"Just about every question you've asked over the last 3-4 days has been "urgent". Perhaps a little planning would be helpful?"
Colin Angus Mackay in the C# forum

led mike

Re: OdbcCommand not taking

HahnTech10-Jul-06 13:21

HahnTech

10-Jul-06 13:21

Too many sites to manage and a moving Db schema make them too hard to manage.

Ronald Hahn, CNT - Computer Engineering Technologist

New Technologies Analyst

HahnTech Affiliated With Code Constructors
Edmonton, Alberta, Canada
Email: rhahn82@telus.net

Re: OdbcCommand not taking

Guffa10-Jul-06 12:26

Guffa

10-Jul-06 12:26

If you are not going to use parameters, be sure to encode the values properly when you put the query together, or your application will be wide open for SQL injections.

---
b { font-weight: normal; }

SendMessage problem

psyonara10-Jul-06 5:52

psyonara

10-Jul-06 5:52

I am using SendMessage from the Win32 API to send keystrokes to the foreground window. The keystrokes do not arrive, though, somehow. I have checked, and the handle to the window that I get is correct. When I use SendMessage to send a character to the application itself it works, but not to another window.

I use the following API functions:

<br />
[DllImport("user32.dll")]<br />
public static extern int SendMessage(IntPtr hWnd, int msg, IntPtr wParam, IntPtr lParam);<br />
		<br />
[DllImport("user32.dll")]<br />
public static extern IntPtr GetForegroundWindow();<br />

And the following to send the message:

<br />
char a = new char();<br />
a = 'A';<br />
this.WindowState = FormWindowState.Minimized;<br />
IntPtr handle = GetForegroundWindow();<br />
SendMessage(handle, (int)Win32API.Messages.Char, (IntPtr)a, (IntPtr)0);<br />

The char enum is set to 0x0102, which is equivalent to WM_CHAR.

Does anyone know what I'm doing wrong? I would appreciate some help!

Thanks!

Re: SendMessage problem

LongRange.Shooter10-Jul-06 8:16

LongRange.Shooter

10-Jul-06 8:16

Is the window within your application space? Security will prevent you from sending keystrokes to a window that is not within your application space unless you have a remoting solution that specifically marshals the request between each boundary.

Re: SendMessage problem

mav.northwind10-Jul-06 9:02

mav.northwind

10-Jul-06 9:02

You could try sending the additional messages that get generated when you press a key, as well (WM_KEYDOWN, WM_KEYUP)...

Regards,
mav

--
Black holes are the places where god divided by 0...

Hiding a control

joshp121710-Jul-06 5:21

joshp1217

10-Jul-06 5:21

Without Using Visible how can you hide a user control?

Re: Hiding a control

Ravi Bhavnani10-Jul-06 5:31

Ravi Bhavnani

10-Jul-06 5:31

Move it offscreen or set its size to (0,0).

/ravi

My new year's resolution: 2048 x 1536
Home | Music | Articles | Freeware | Trips
ravib(at)ravib(dot)com

Re: Hiding a control

joshp121710-Jul-06 5:45

joshp1217

10-Jul-06 5:45

Moving the control offscreen? How is this done?

Re: Hiding a control

Ravi Bhavnani10-Jul-06 5:55

Ravi Bhavnani

10-Jul-06 5:55

Change its Location property.

/ravi

My new year's resolution: 2048 x 1536
Home | Music | Articles | Freeware | Trips
ravib(at)ravib(dot)com

Re: Hiding a control

Jun Du10-Jul-06 5:59

Jun Du

10-Jul-06 5:59

Set a location (x, y) beyond the screen. Lets say, if your screen is 1280x1024, set (x, y) to (1600, 0).

Best,
Jun

Re: Hiding a control

Christian Graus10-Jul-06 8:17

Christian Graus

10-Jul-06 8:17

But check the Screens property as well, you may be moving it onto the second monitor.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

Re: Hiding a control

Andrew Lygin10-Jul-06 8:48

Andrew Lygin

10-Jul-06 8:48

MyControl.Parent = null;

This.Left

joshp121710-Jul-06 5:11

joshp1217

10-Jul-06 5:11

Can anyone tell me how exactly does this "this.Left" method work in conjunction with a form or user control?

Re: This.Left

Ravi Bhavnani10-Jul-06 5:17

Ravi Bhavnani

10-Jul-06 5:17

It returns the x coordinate of the control's left edge.

/ravi

My new year's resolution: 2048 x 1536
Home | Music | Articles | Freeware | Trips
ravib(at)ravib(dot)com

Re: This.Left

Not Active10-Jul-06 5:19

Not Active

10-Jul-06 5:19

Gets or sets the distance, in pixels, between the left edge of the control and the left edge of its container's client area.

Seems pretty straight forward to me

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