Click here to Skip to main content
15,910,009 members
Home / Discussions / C#
   

C#

 
QuestionDirectX ClickEvent? Pin
Expert Coming22-May-07 15:00
Expert Coming22-May-07 15:00 
AnswerRe: DirectX ClickEvent? Pin
andre_swnpl22-May-07 21:24
andre_swnpl22-May-07 21:24 
QuestiondataGridView_DoubleClick Pin
balanjingot22-May-07 14:36
balanjingot22-May-07 14:36 
AnswerRe: dataGridView_DoubleClick Pin
Gopal.S22-May-07 18:27
Gopal.S22-May-07 18:27 
GeneralRe: dataGridView_DoubleClick Pin
balanjingot22-May-07 20:35
balanjingot22-May-07 20:35 
GeneralRe: dataGridView_DoubleClick Pin
Gopal.S22-May-07 21:01
Gopal.S22-May-07 21:01 
GeneralRe: dataGridView_DoubleClick Pin
balanjingot22-May-07 21:35
balanjingot22-May-07 21:35 
QuestionI'm getting demolished by an easy SELECT statement, help. Pin
ThisIsMyUserName222-May-07 14:10
ThisIsMyUserName222-May-07 14:10 
Here's my problem. I don't know how to compare a range (because .NET does not support the BETWEEN clause) and return a single row based on that range.

Here's an example of a working query that is being executed on a specific table in a dataset.

---
query = "Name = 'jim' AND Address = '123 Lane' AND Age = '25' AND Homes = '2'";
---

Here's what I want to do: (does not return anything, but compiles)

---
query = "Name = 'jim' AND Address = '123 Lane' AND Age >= '23' AND Age <= '27' AND Homes >= '1' AND Homes <= '3'";
---

In this example I'm trying to return this row if the user entered any age in between 23 and 27, and any amount of homes in between 1 and 3. You could say the age threshhold range is set to 2 and the home threshhold range is set to 1.

Our test subject jim falls into this range, so I would want him returned, yet it does not work. I tried using () around certain parts and it doesn't work as well. Little help?
AnswerRe: I'm getting demolished by an easy SELECT statement, help. Pin
kubben22-May-07 14:21
kubben22-May-07 14:21 
GeneralRe: I'm getting demolished by an easy SELECT statement, help. Pin
ThisIsMyUserName222-May-07 14:33
ThisIsMyUserName222-May-07 14:33 
AnswerRe: I'm getting demolished by an easy SELECT statement, help. Pin
Expert Coming22-May-07 14:31
Expert Coming22-May-07 14:31 
GeneralRe: I'm getting demolished by an easy SELECT statement, help. Pin
ThisIsMyUserName222-May-07 14:36
ThisIsMyUserName222-May-07 14:36 
GeneralRe: I'm getting demolished by an easy SELECT statement, help. Pin
Expert Coming22-May-07 14:41
Expert Coming22-May-07 14:41 
GeneralRe: I'm getting demolished by an easy SELECT statement, help. Pin
Expert Coming22-May-07 14:43
Expert Coming22-May-07 14:43 
GeneralRe: I'm getting demolished by an easy SELECT statement, help. Pin
ThisIsMyUserName222-May-07 14:54
ThisIsMyUserName222-May-07 14:54 
GeneralRe: I'm getting demolished by an easy SELECT statement, help. Pin
ThisIsMyUserName222-May-07 14:49
ThisIsMyUserName222-May-07 14:49 
GeneralRe: I'm getting demolished by an easy SELECT statement, help. Pin
Expert Coming22-May-07 14:55
Expert Coming22-May-07 14:55 
GeneralRe: I'm getting demolished by an easy SELECT statement, help. Pin
ThisIsMyUserName222-May-07 15:01
ThisIsMyUserName222-May-07 15:01 
AnswerRe: I'm getting demolished by an easy SELECT statement, help. Pin
Dave Herren22-May-07 15:21
Dave Herren22-May-07 15:21 
GeneralRe: I'm getting demolished by an easy SELECT statement, help. Pin
ThisIsMyUserName222-May-07 15:33
ThisIsMyUserName222-May-07 15:33 
AnswerRe: C# Consoles & Windows Forms Pin
Dave Herren22-May-07 15:08
Dave Herren22-May-07 15:08 
QuestionArray Shift Register Pin
cmarcus22-May-07 12:45
cmarcus22-May-07 12:45 
AnswerRe: Array Shift Register Pin
Guffa22-May-07 12:59
Guffa22-May-07 12:59 
GeneralRe: Array Shift Register Pin
cmarcus23-May-07 2:22
cmarcus23-May-07 2:22 
GeneralRe: Array Shift Register Pin
Martin#23-May-07 3:32
Martin#23-May-07 3:32 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

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