|
Wrong forum - this is for C# queries, not SQL. In future use this: Database Discussion Boards - CodeProject[^] or this: http://www.codeproject.com/Questions/ask.aspx[^]
But...try this:
SELECT quantity, Price, [Returns], (quantity * Price) * CASE WHEN [Returns] = 0 THEN 1 ELSE -1 END As Total FROM MyTable; Or if Returns is a BIT column:
SELECT quantity, Price, [Returns], (quantity * Price) * (1 - [Returns] * 2) As Total FROM MyTable;
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
Your good example, especially your 2nd query, I do not think writing like this that runs smoothly: (quantity * Price) * (1 - [Returns] * 2) As Total
Your very good example, Thank you very much.
|
|
|
|
|
You're welcome!
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
Below code need to implement to measure the angle in a image. but after stretching the image found the mouse click position and line starting position is not correct.
Line starts some points after the mouse click point. if the image is not stretched no issues
private void pictureBox1_VisibleChanged(object sender, EventArgs e)
{
pictureBox1.SizeMode = PictureBoxSizeMode.StretchImage;
}
private void pictureBox1_Click(object sender, EventArgs e)
{
MouseEventArgs me = (MouseEventArgs)e;
if (me.Button == System.Windows.Forms.MouseButtons.Right)
{
switch (clickProgress)
{
case 1:
pts[2] = pts[0];
pts[1] = pts[0];
clickProgress--;
break;
case 2:
pts[2] = pts[0];
clickProgress--;
break;
case 3:
clickProgress--;
break;
}
}
if (me.Button == System.Windows.Forms.MouseButtons.Left)
{
if (clickProgress < 3)
{
pts[clickProgress] = me.Location;
if (clickProgress == 0)
{
pts[1] = pts[0];
pts[2] = pts[0];
}
clickProgress++;
}
}
updateBitmap();
}
private void pictureBox1_MouseMove(object sender, MouseEventArgs e)
{
if (clickProgress > 0 && clickProgress < 3)
pts[clickProgress] = e.Location;
updateBitmap();
}
private void updateBitmap()
{
if (pictureBox1.Image == null)
{
Bitmap bmp = new Bitmap(pictureBox1.Width, pictureBox1.Height);
pictureBox1.Image = bmp;
}
using (Graphics g = Graphics.FromImage(pictureBox1.Image))
{
g.Clear(Color.Black);
if (pic != null)
{
int width = pictureBox1.Width;
int height = pictureBox1.Height;
float scaleW = pictureBox1.Width * 1.0f / width;
float scaleH = pictureBox1.Height * 1.0f / height;
float scale = scaleW;
if (scale > scaleH)
scale = scaleH;
int nw = (int)(scale * width);
int nh = (int)(scale * height);
if (picScaled == null)
{
RectangleF sourceRect = new RectangleF(0, 0, width, height);
RectangleF destinationRect = new RectangleF(0, 0, nw, nh);
picScaled = new Bitmap(nw, nh);
Graphics gi = Graphics.FromImage(picScaled);
gi.DrawImage(
pic,
destinationRect,
sourceRect,
GraphicsUnit.Pixel);
gi.Dispose();
}
{
RectangleF sourceRect = new RectangleF(0, 0, nw, nh);
RectangleF destinationRect = new RectangleF(
pictureBox1.Width / 2 - nw / 2,
pictureBox1.Height / 2 - nh / 2,
nw,
nh);
g.DrawImage(
picScaled,
destinationRect,
sourceRect,
GraphicsUnit.Pixel);
}
}
Pen greenPen = new Pen(Brushes.Green);
greenPen.Width = 3.0F;
Pen redPen = new Pen(Brushes.Red);
redPen.Width = 3.0F;
if (clickProgress > 0)
g.DrawLine(greenPen, pts[0], pts[1]);
if (clickProgress > 1)
g.DrawLine(redPen, pts[0], pts[2]);
redPen.Dispose();
greenPen.Dispose();
}
pictureBox1.Invalidate();
if (clickProgress > 1)
{
Point p0 = new Point(pts[1].X - pts[0].X, pts[1].Y - pts[0].Y);
Point p1 = new Point(pts[2].X - pts[0].X, pts[2].Y - pts[0].Y);
double l0 = (p0.X * p0.X + p0.Y * p0.Y);
double l1 = (p1.X * p1.X + p1.Y * p1.Y);
double d = ((double)p0.X * p1.X + (double)p0.Y * p1.Y) / Math.Sqrt(l0 * l1);
if (d > +1) d = +1;
if (d < -1) d = -1;
if (l0 > 0 && l1 > 0)
label1.Text = (Math.Acos(d) * 180 / Math.PI).ToString("0.0", System.Globalization.CultureInfo.InvariantCulture);
}
else
{
label1.Text = "";
}
}
|
|
|
|
|
Um. What do you suppose PictureBoxSizeMode.StretchImage does?
It takes the image in the Picturebox and "distorts" it to fit the size and shape of the container. That doesn't affect mouse locations within the image, it just affects the image as displayed.
So if you click the mouse on two points in the distorted PictureBox that correspond to the start and end points of a line (on the distorted image) and draw a line (on the underlying image graphics context) using the mouse coordinates it will be drawn as is - the coordinates you draw from and to will not be "mapped" into the distorted image but drawn exactly as you requested on the undistorted image. As a result, they aren't in "the right place" - which is why when you remove StretchImage from the PictureBox it works fine: the coordinates don't change at all, but now they match with the image.
Two options:
1) Don't use StretchImage
2) Convert the mouse location points so they aren't relative to the distorted image. That means looking at the box dimensions, the image dimensions and working out teh X and Y scalign factors you need to apply to "undistort" the click location.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
modified 11-Jun-16 6:58am.
|
|
|
|
|
Hello,
I have a requirement of getting an event when all the Windows are in minimized state. How can I know when all other applications (except mine) are in minimized state using c#?
Please help me.
|
|
|
|
|
As far as I know there is no event that signals this - you can look at each window fairly easily though and enumerate those that are visible: List the currently running desktop windows in C# - C# HelperC# Helper[^] - a couple of small changes there would give you a list of "open" windows. But you'd have to check it periodically yourself.
The other option is a lot more complex, and a lot more fraught with crash-and-burn potential: CBT Hooking. This entails adding a global hook to the system and watching for minimize, restore, and maximize events making their way through. You can do this in C# - though it's not simple - but it's not a trivial task (and I'd back up my PC before I started trying as you can seriously destabilize your system if you get it wrong). Google for "CBT Hooking C#" and you'll find info, if you are brave enough!
[edit]Typo[/edit]
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
modified 11-Jun-16 3:27am.
|
|
|
|
|
I am new to c#. The example given by you gives some Titles which are running in system tray and some other titles also, I want window titles which are open but not in minimized state... can you help me where I need to edit the code ?
|
|
|
|
|
Just change the IsWindowVisible part to check if it's minimised with the IsIconic function (Windows)[^]
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
Ola Pessoal desde ja eu agradeço o tempo disponibilizado para tentar resolver o meu Problema...
VAMOS AO PROBLEMA
Estou tentando criar um instalador para a minha aplicação C# VS 2012 EM CAMAMADAS
Estou tendo Problemas na minha conexão
essa e a minha string de conexão
Agora no Inno Setup
Defino la no Application name : SIFA
Application versine : 1.0 Next>>
Application destination base folder :
eu escolho custom C:\
Application Files_ Application main executable file Clico em Browse...
e escolho SIFA/GUI/bin/Debugu ou Release/GUI ....... ja tentei tanto com debug quanto com release
depois de clicar e GUI... agora eu clico em ADD FILES e escolho meu banco de dados SQL Compact
Next>> preencho o restante q e mais facil e mais de configuração .....
Beleza instalador criado agora e executo o instalador e instala normalmente...
esta la na pasta C:\SIFA...
mas quando eu executo ele abre Normalmente, mas quando eu clico em algum botão que faz requisição ao banco de dados aparece essa mensagem de erro
OBS: e quando eu executo o programa usando o VISUAL STUDIO mesmo com a conexão apontando para C:\\SIFA\\DataSifa (Imagem 2) ele executa e le o banco de dados sem nem um problema (ele le o banco q foi instalado na pasta c:\SIFA)
Obrigado por sua Atenção.... Espero que tenha ficado Claro a minha duvida
|
|
|
|
|
Unfortunately this is a mainly English language site, and I doubt that many of the subscribers will be able to speak Portuguese
=========================================================
I'm an optoholic - my glass is always half full of vodka.
=========================================================
|
|
|
|
|
This is an English language site, and questions should be posted in English - as should answers.
But from what Google Translate offers, I suspect it's a permissions problem.
I'd strongly suggest that you should store the DB in a more sensible folder: Where should I store my data?[^] may help you there.
Este é um site de idioma Inglês, e as perguntas devem ser afixados em Inglês - como deveria respostas.
Mas do que Google Translate ofertas, eu suspeito que é um problema de permissões.
Eu sugiro fortemente que você deve armazenar o DB em uma pasta mais sensato: Onde devo armazenar meus dados? [ ^ ] pode ajudá-lo lá.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
how can we save image from live view automatically?
|
|
|
|
|
Please read the articl at the top of this page called How to get an answer to your question
=========================================================
I'm an optoholic - my glass is always half full of vodka.
=========================================================
|
|
|
|
|
Lots of ways, take your pick. You could write code. You could use an application that has that feature built-in. You could use a camera. Many options.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
Live view from what? How are you receiving the data? What code do you currently have? Is this a desktop application?
Please supply more information so that we can begin to offer you some help.
This space for rent
|
|
|
|
|
Dear Friends/Mates,
Please help me to Convert Amibroker AFL to DLL setup file with license manager. I have installed Amibroker software and .net for amibroker but i want to know how to convert Amibroker AFL to DLL setup file with license manager. I am waiting for your help.
Many thanks in advance
|
|
|
|
|
As you have bought AmiBroker, I would expect their online support[^] to be the best source for information like this.
This space for rent
|
|
|
|
|
No, it is a trial version.
|
|
|
|
|
So you're going to buy it then? Or are you looking for help to crack the application?
This space for rent
|
|
|
|
|
Trial or no, it is not part of the Framework. Any decent sales-team would happilly provide you with access to their support team 
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
Hi all,
i have a MyPanel type custom control,
MyPanel panel1;
i pass this to another temp variable
MyPanel temp=panel1;
now i remove some control from temp,
but here the remove control also remove from panel1.
please help how can i stop this.
thanks in advance.
|
|
|
|
|
What you're seeing here is the behaviour you'd expect because you are passing a reference of panel1. In other words, you are passing the object itself and not a copy of the object. If you want the behaviour to be different, you're going to have to pass a copy or clone of panel1 to the other location.
This space for rent
|
|
|
|
|
Le@rner wrote: the remove control also remove from panel1.
Of course it does, they are one and the same object. If you want a different object in temp then you need to make a copy.
|
|
|
|
|
It's a little hard to get your head round, but it's pretty simple when you do.
So let's ignore it for a moment, and talk about cars.
Suppose you get in your car and put your mobile in the glovebox.
If you later get in my car and open the glove box, will your mobile be there?
No - it's in your car, not mine: they are separate instances of the generic class "Car", and you do not expect items to magically move between them!
But...suppose my wife an I both share a car. If she puts her mobile in the glove box of "her car" and I later look in the glove box of "my car" what will I see? Her mobile of course! Why? Because "her car" and "my car" are different references to the same actual vehicle - the same instance of the generic class "Car".
In computer terms, the two scenarios are like this:
Car yourCar = new Car("Blue");
Car myCar = new Car("Red");
yourCar.GloveBox.Add(yourMobile);
if (myCar.GloveBox.Contains(yourMobile))
throw new UniverseException("How did that happen?");
And
Car myCar = new Car("Red");
Car herCar = myCar;
herCar.GloveBox.Add(herMobile);
if (myCar.GloveBox.Contains(herMobile))
Console.WriteLine("Found it dear! You left it in the glovebox again!");
You are doing the same thing with your class:
MyPanel panel1 = new MyPanel();
MyPanel temp = panel1;
temp.Controls.Remove(button1); This is because classes are what is called a Reference Type: a variable of the class doesn't contain the actual class, but a reference to it in the same way that "my car" doesn't contain the actual car, but refers to a specific vehicle.
Integers and so forth are Value Types: they do contain the actual value so when you say
int i = 666;
int j = i;
j = j / 2;
Console.WriteLine("{0}:{1}", i, j);you will get "666:333" - and any other result would make maths very difficult to do!
If you embed the integer in a class:
public class MyClass
{
public int i;
}
...
MyClass m1 = new MyClass;
m1.i = 666;
MyClass m2 = m1;
m2.i = m2.i / 2;
Console.WriteLine("{0}:{1}", m1.i, m2.i);you will get "333:333" because the references m1 and m2 are "talking about" the same instance of MyClass.
Some of this may make it easier to understand: Using struct and class - what's that all about?[^] - but it gets a bit advanced from the section "It's never that easy, is it?" so you might want to stop there for the moment!
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
