Questions tagged as 'ado.net'

Tagged questions
0
answers

Error creating ADO.NET Entity Data Model file

Good morning, I am trying to create an ADO.NET Entity Data Model file, with connection to the MySql (Workbench) database, however or from the error, or the Entity Data Model screen closes. So I have two scenarios: 1) I create my MVC projec...
asked by 06.11.2018 / 16:25
1
answer

Data from the same table for different Views?

I have found it difficult to solve the following problem: Assuming I have the following structure in the database: Id int identity primary key CodigoBanco char(3) Descricao varchar(100) Endereco varchar(300) Bairr...
asked by 25.10.2018 / 03:59
1
answer

Best way to ensure query isolation

I have the following scenario: A table in SQL Server that contains records of processes that can be run across multiple services ( Windows Services in C # ). Something like: CREATE TABLE Processo ( Id INT IDENTITY NOT NULL,...
asked by 18.04.2018 / 19:00
0
answers

Delete duplicate lines postgresql

My code automatically inserts data into a database, causing the DB to become too large, and sometimes with repeated information. For this, I want to use the Slowly Changing Dimension (SCD) method so that: - A record with a given id will be added...
asked by 15.03.2017 / 15:01
0
answers

Query of dataset that shows last ID created giving error

I am making a people registration form which when I finish entering the data it shows a MessageBox saying with which ID the person was registered. For this I use a% w of% of my query (I'm using Entity Framework model first), but fo...
asked by 10.11.2016 / 15:47
2
answers

Static DataTable, how to load?

I need to create a method, which when the user logs into the system, when the initial menu is loaded, it loads a Static DataTable , so that I can use DataTable in future, to populate some ComboBox , without have the need to ma...
asked by 23.07.2016 / 01:03
2
answers

Error trying to add a self-incrementing column to a datagridview

I'm trying to add a autoincrementable column in a datagridview but I can not figure out what's missing to work properly. My program reads the data from a database table and displays it in datagridview . I need to add a autoincrem...
asked by 30.05.2016 / 18:53
0
answers

Firebird ADO.NET

I updated the "Firebird ADO.NET Data provider" to version 4.10.0 and I am sometimes getting the following exception in my application. Exception information: Exception type: NullReferenceException Exception message: Object reference...
asked by 26.04.2016 / 17:17
1
answer

My search in BD oracle does not work

I have a method, using Ado.Net to bring DB information (Oracle 11g). There is information in the table (6 records) and when I run it by C# no record comes. See the code below: public class ConexaoBanco { string conexao = Con...
asked by 18.03.2016 / 12:27
1
answer

How to add more than one DataRelation to a Dataset in C #?

Is it possible to add more than one DataRelation to a DataSet? I need three columns in separate tables to be related.     
asked by 09.01.2016 / 17:45