Questions tagged as 'ado.net'

Tagged questions
1
answer

Search for uncommitted data

I was doing tests regarding transactions and I saw that if I conduct a search of the registered and uncommitted data they are returned. In the entity framework this does not happen, and from what I researched behind the scenes he works with tran...
asked by 13.12.2014 / 00:41
2
answers

Return last record from table

I'm trying to make a method that returns the last record of the table but gives error:    "Coditem" operation failed public int UltimoItem() { con = conexao.obterConexao(); try { cmd = new SqlComm...
asked by 04.10.2017 / 21:48
3
answers

Error while passing SqlParameter

I have a method to return a query , but it is giving error. Class Data.cs: public static SqlDataReader retornaQuery(SqlCommand query, List<SqlParameter> parameters) { try { //Instância...
asked by 08.08.2014 / 18:08
1
answer

Problem in converting a query in vb.net to a procedure with varchar

Until the% of call of the parameters takes all data correctly, the problem is at the time of going to the procedure via ADO.net, that for example, I pass the values, function and in the procedure it picks up only the first character....
asked by 28.11.2017 / 11:57
2
answers

DataReader opens and gives error for not closing

I have DataReader on my website to read the data the bank brings. I have a problem with VS, but I do not know how to do it.    There is already an open DataReader associated with this Command that must be closed first Would there be...
asked by 18.10.2016 / 14:24
1
answer

How to select the contents of a column from a DataSet C #

Is there a better way to fetch the contents of a specific column? I have information that is repeated in a "template" column I want to retrieve this content only once. I'm doing this, but maybe it has a better way to do it. public Data...
asked by 04.07.2018 / 03:26
1
answer

Ado.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 use of Entity. I'm kind of confused about that. Ado.Net and Entity give dancing?     
asked by 06.12.2017 / 18:51
2
answers

Connect application to Postgresql?

Rstou wanting to connect a simple C # application 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 class with the get's and set's of entities to manipulat...
asked by 24.06.2015 / 13:22
1
answer

Parameters of SqlCommand and ExecuteReader [closed]

I can not get values from the database and direct a form according to what "profile" is in the users table, if I take the% login , however, I need to verify the user's profile, my code looks like this: using System; using System.Collection...
asked by 23.12.2014 / 01:11
2
answers

Failed to convert nvarchar value 'VINET' to int data type

I have this error: Falha ao converter o nvarchar valor 'VINET' para o tipo de dados int. Below my code: private void button1_Click(object sender, EventArgs e) { try { SqlConnection dataConn...
asked by 30.06.2014 / 00:58