Most voted "ado.net" questions
It’s a set of software components that programmers can use to access data and data services. Created by Microsoft for use with the . Net Framework, it is now used on a smaller scale giving way to more complex technologies.
Learn more…122 questions
Sort by count of
-
0
votes2
answers1041
viewsFailed to convert nvarchar'VINET' value to int data type
I have that mistake: Falha ao converter o nvarchar valor 'VINET' para o tipo de dados int. Down with my code: private void button1_Click(object sender, EventArgs e) { try { SqlConnection…
-
0
votes2
answers5572
viewsConnect application to Postgresql?
Rstou wanting to connect a simple application made in C# to a Postgresql database, what I would like to know is if the procedure is similar to Java, in which I have to create a connection class, a…
-
0
votes3
answers558
views -
0
votes1
answer98
viewsHow to add more than one Datarelation to a Dataset in C#?
Is it possible to add more than one Datarelation to a Dataset? Need three columns in separate tables to be related.
-
0
votes0
answers89
viewsFirebird ADO.NET
I updated the "Firebird ADO.NET Data Provider" to version 4.10.0 and am sometimes receiving the following exception in my application. Exception information: Exception type: NullReferenceException…
-
0
votes1
answer71
viewsOracleexception is not fired!
Someone has already come across the following problem: When an error occurs that should be of the type Oracleexception, but in its place an exception is triggered, then the oracle treatment is not…
-
0
votes1
answer134
viewsAdo.Net and Entity in the same project
I took a test to do and it is mandatory to use Ado.Net, but it would be a differential the use of Entity. I’m a little confused about this. Ado.Net and Entity gives ball?
-
0
votes1
answer351
viewsError trying to open SQL connection - Server Version - System.Invalidoperationexception - Connection is closed
Hello. When trying to open a connection using the class SqlConnection of lib SqlClient my class conexao - formerly null - is as follows: That class conexao is the type SqlConnection and receives the…
-
0
votes1
answer202
viewsMy oracle BD search does not fetch result
I have a method, using Ado.Net to bring information from BD(Oracle 11g). There is information in table(6 records) and when run by C# no record. See the code below: public class ConexaoBanco { string…
-
0
votes2
answers131
viewsError while trying to add an auto-incrementable column to a datagridview
I’m trying to add a column self-adjusting in a datagridview but I am not able to figure out what is missing to work properly. My program reads the data from a database table and displays in a…
-
0
votes2
answers124
viewsStatic Datatable, how to load?
I need to create a method, that when the user logs into the system, when the initial menu is loaded, it loads a Static DataTable, so that I can use the DataTable, for some popular ComboBox, without…
-
0
votes2
answers1356
viewsDatareader opens and gives error by not closing
I have a DataReader on my website to read the data that the bank brings. There when two people enter different computers, and even different browsers, opens a connection, but at the time I will read…
-
0
votes0
answers41
viewsDataset query showing last created ID giving error
I’m making a people registration form which when I finish entering the data it shows a MessageBox telling which ID the person was registered with. For that I use a query of my dataset(I’m using…
-
0
votes0
answers86
viewsDelete duplicated postgresql lines
My code automatically inserts data into a database, making the BD too large and sometimes with repeated information. For this, I want to use the Slowly Changing Dimension (SCD) method so that: - A…
-
0
votes2
answers269
viewsReturn last record from table
I’m trying to make a method that returns the last record of the table but gives error: Failure in operation"coditem" public int UltimoItem() { con = conexao.obterConexao(); try { cmd = new…
-
0
votes1
answer37
viewsProblem in converting a query into Vb.net for a varchar model
Until the function call of the parameters picks all the data correctly, the problem is time to pass to the Procedure via ADO.net, that for example, step the values, @OPE_NROOPERACAO = '34567,32135'…
-
0
votes1
answer65
viewsBest way to ensure consultation isolation
I have the following scenario: A table in SQL Server that contains process records that can be run on multiple services (Windows Services in C#) from multiple servers. Something like: CREATE TABLE…
-
0
votes1
answer471
viewsHow to select the contents of a column coming from a Dataset C#
Is there a better way to search for the content of a specific column? I have information that repeats in a "template" column I want to retrieves this content only 1 time. I’m doing it like this, but…
-
0
votes1
answer37
viewsData 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…
-
-1
votes1
answer376
views -
-4
votes1
answer67
viewsStatic Methods X Nonstatic Methods for Data Access Layer
I’m creating a layer in ADO.NET for data access and painted a question. It is good practice to have my methods of accessing data as Static instead of always having to instantiate the object and call…
-
-4
votes1
answer202
viewsHow does this class work?
DataSet OleDbConnection OleDbCommand OleDbDataAdapter OleDbDataReader I still can not understand this class in .net. What are these datasets and etc? I’m wearing this: using System; using…