I need to print data from a DataGridViewer, which gets the products launched for sale.
What is the best way to print this information in Report?
I tried to use the Table component, but I can not pass the information to it, since it needs to be b...
I have an application that has 4 layers, which are as follows: Dominio, Infra, Servico, Web in the domain I have a folder named Poco with all my Classes/Tabelas , in Layer Infra , to test CodeFirst eu I created a...
I have a project in ASP.Net MVC and I am putting the authentification manually. Everything is going well, but I used as a reference an already ready project that uses the EntityFramework, but I want to use linq for my operations.
The problem is...
How do I bring only part of the text in a field in the sql server?
I have the query below that in the Description column, it returns a text with lots of information, for example.
Nome Cliente Data do ultimo Tramite Descrição
Teste...
When I retrieve records from a SQL database Serve with PHP errors appear in the accent.
But in the bank, the accents are correct. Is there any way to handle this with PHP? I do not have permissions to change the bank collation .
Collatio...
UPDATE tbl_venda
SET produto=1
WHERE produto=3
The problem is that there are more than 10,000 lines of sales and the pc hangs.
I would if it was possible to make 100 in 100, 500 in 500, not to get heavy.
I'm having an error connecting the database to my CodeIgniter project, I'm using SQL Server.
$db['sql'] = array(
'dsn' => 'DRIVER={SQL Server}; SERVER=HOSTPT-01407; DATABASE=localidade;',
'hostname' => 'HOSTPT-01407',
'us...
I came across a system where most of the field binding rules are done in the application and not in the database (with the exception of the primary key).
As I have no experience with many systems, I would like to know if this is common and br...
How to change the NULL value in sql server for example 'NONE', how to leave this fixed?
My result is coming like this:
Florida United States NULL 16
Nevada United States NULL 17
Nevada United States Cell Phone 7
Nevada Unite...
How to add the count result of different tables in SQL Server?
Example:
Table WORKS has 755614 Records
SELECT count(*) from OBRAS;
TITLES table has 85106 Records
SELECT count(*) from TITULOS;
AUTHORS table has 19029 Records...