Posts by Felipe Dos Santos • 33 points
7 posts
-
0
votes1
answer226
viewsA: How to fill out combobox with SQL query? C#
I found my error, the query should be in Oledbdataadapter and the Oledbcommand line does not exist. In the end the code was this way: private void carregacombo() { Conexao conexão = new Conexao();…
-
0
votes1
answer226
viewsQ: How to fill out combobox with SQL query? C#
I wonder if it is possible to pass data from an SQL query to a combobox using C#. I researched the subject and found examples, but when I adapted to my case , I could not use. I am doing this way:…
-
1
votes1
answer710
viewsA: How to generate a report in excel with tables from a database using C#?
I got what I needed from that code I found on a forum. However I am having difficulties to send the query to a specific column of the spreadsheet and I would like to know if it is possible to use…
-
1
votes1
answer710
viewsQ: How to generate a report in excel with tables from a database using C#?
How to pass the data of a query to the columns and rows of a sheet in excel? Example: OleDbDataAdapter oda = new OleDbDataAdapter("select * from usuario", conexao.cn); DataTable dt = new…
-
1
votes1
answer5598
viewsQ: Multiply two columns in a select
I have two columns (valor_unitario and quantidade) wanted to make a select that multiplied all columns in the field valor_unitario * quantidade. Example: Valor_Unit|Quantidade 15 * 2 + 10 * 1…
-
0
votes1
answer519
viewsA: How to insert date and time in oracle? via c#
INSERT INTO tabela (codigo, datahora ) VALUES (1, TO_DATE(nvl('','19/07/2017 19:49:00'),'DD/MM/YYYY HH24:MI:SS')) Solved :)
-
-3
votes1
answer519
viewsQ: How to insert date and time in oracle? via c#
I’m developing a desktop application and everything was working fine until the time I tried to insert the date and time generated by C# into an oracle table. Can someone teach me the query to insert…