How to do a SELECT pull qty or weight of sql to a single column on the grid depending on the register?

Question

How to do a SELECT pull qty or weight of sql to a single column on the grid depending on the register?

Navigation

#1 by (0 votes)

0

I have the following doubt, I created a stock table in sql for packaging and raw materials, with registration in the same form. I created one line for weight and another for qtde in sql. And I created a grid with a single column "qtde / weight" I want in a combobox selected by qtde or weight, look in the specific sql table and bring in the same column of the grid. But I can not do this select, can anyone help me?

sql c#

asked by anonymous 02.06.2016 / 20:26

1 answer

MYSQL access by an application How to write text and image together in mysql with asp.net mvc

score 0 · Accepted Answer

If I understood your question and the following: You quoted depending on the register so I suppose you have some field informing the unit of that product. I do not know how the structure of your tables is ... but this should give you an idea of how it should be.

SELECT 
CODIGO,
DESCRICAO,
CASE PRODUTO.UNIDADE
     WHEN 'PESO' THEN PRODUTO.PESO
     WHEN 'QTDE' THEN PRODUTO.QTDE
     END AS QTDE_PESO


FROM PRODUTO
WHERE
//SUAS CONDICOES