I have a column in db that is D_EMISSAO and has a date yyyyddmm in it.
I have to show the data that is related to column D_EMISSAO if it does not exceed 6 months according to the date D_EMISSAO with the current dat...
I would like to do a SELECT that would repeat the first column, but when all the records were over, I would change the data in the first column and repeat all the records again.
I'll give you an example to illustrate better, as it's complicat...
I would like to know how to insert two ids into two tables.
For example, there are 5 tables one is a student, which has the following information:
+--------+------------+
| ID_ALU | nome |
+--------+------------+
| 1 | aluno 1 |...
I have the following scenario:
Users table
Table users access
In the usuariosacessos table, each row has the id of the user, the name of the feature, and a field stating whether or not you have access.
In my specifi...
I have an action in an API that should return a template, however the fields that must be returned are entered in the request. I can query with the System.Linq.Dynamic.Core package, but the performance is pretty bad. What other alternative can I...
I'm working with EF6 Code-first, SQL-Server database.
I encountered the following error when saving an object with DateTime property.
The conversion of a datetime2 data type to a datetime result in an out-of-range value.
↵The statemen...
When trying to execute my project I got the error:
System.NullReferenceException: 'Object reference not set to
an instance of an object. '
I have a bank class with the constructor:
public bd()
{
conexao = new SqlConnection(Confi...
I have the following query:
SELECT finpag.cod_forn
,sicforn.nome
,finpag.data_pagto
,finempe.cod_reduzido
,finpag.num_empenho
,finpag.ano_empenho
,num_liquid
,ano_liquid
,valor_transacao...
Good afternoon, how can I populate a dropdown with data from a database using pure Ado.net (code) and without using Entity framework?
I have two tables in my database that relate. First I must register a department and when registering a user...
I'm using the Microsoft 6.0 JDBC driver in a one-time project API using Java (JRE 1.8) with resteasy using Eclipse Oxygen and Tomcat 7 (I tried with other versions and presented the same behavior). My connection code is as follows:
public cl...