Questions tagged as 'ado'

1
answer

Error opening MySQL connection via ADODB

I am trying to connect a VB application, Visual Studio 2017, using ADODB as connection, but it has several errors for different connection options. I have already checked the drivers for the ODBC data sources and there is the MySQL 64bit Driver...
asked by 02.06.2017 / 03:38
1
answer

ADODataSet Delphi Edit

I have ADODataSet with the following query DECLARE @ID_CONTRATO_EMPRESARIAL INTEGER = :ID_CONTRATO_EMPRESARIAL BEGIN WITH V1 AS ( select C.ID_CONTRATO, COUNT(CASE AD.FUNCIONARIO WHEN 'TRUE' THEN 1 ELSE NULL END) FUNCIONARIOS, C...
asked by 24.05.2016 / 15:06
1
answer

How to perform a CRUD in C # with MySQL and ADO [closed]

I need to do the relationship between tables 1: N and N: N. Table produto : public int id {get; set;} public string produto {get; set;} public list<tamanhos> tamanhos {get; set;} Table tamanhos : public int produto_id...
asked by 23.03.2016 / 04:39
1
answer

How to change and maintain mapping of classes and properties using ADO.net

When using a database I have tables and columns with names like: - tb_user usu_id usu_name usu_data_nasc - tb_product pro_id pro_name pro_desc_resumida pro_desc_completa When you use ADO.NET Entity Data Model - &g...
asked by 07.06.2017 / 13:40
2
answers

Connection methods in ASP .NET [closed]

I am a beginner in ASP and C #. I have doubts and this is the real reason to ask here. Before you can read how the question policy is, understand that I am a beginner and really need help. I have a question of how to connect to my ASP applic...
asked by 21.02.2018 / 17:43
0
answers

ADO Recordset returns nothing

I can not make ADO Recordset return the records of a MySQL table. I am using VB.NET in Visual Studio. I can establish communication with the database, I make the connection, create tables, all via connection object (as below) but at the time of...
asked by 03.06.2017 / 01:55