In terms of performance, speed, or security, what is the best object to use as a DataSource ?
Example, I am creating a DataSource , to popular a GridView :
By SqlDataSource :
this.sqlDataSource1.ConnectionName = "...
I'm creating some unit tests for a class library that does manipulations in a database.
The method being tested is this:
public object ExecuteNoQueryOperation ( string spOrSqlInstructions, CommandType commandType = CommandType.StoredProcedu...
I have a DataView and I'm trying to make a filter, where the 'photo' field is different from NULL
I tried:
dv.RowFilter = "foto <> ''";
But it did not filter.
I searched here on StackOver and recommended:
dv.RowFilter = "Isnull(...
I want to have a higher performance in a query that I perform in the system
Consequently using ADO is much faster than Entity Framework
What% of the% it generates when querying could be used to create a query or use wi...
I am developing a registry system in VB and need help writing the CheckBox information to the SQL Server database.
The column is in bit in the database, I do not know how to pass the parameter so that the user's choice is saved...
I know the question is a little subjective, but maybe someone has already gone through it and can help me.
I have an application developed in C # / Windows Forms / ADO.NET with firebird database.
The "Object reference not set to an instanc...
I have DataTable where with the code:
DT.Column.Add("1ª", gettype(int32))
For I = 1 To 30
DT.Rows.Add(I)
Next(I)
This For enumerates column 1 from 1 to 30. 'DT is declared with a new DataTable , in...
I'm trying to read a .dbf file by following a tutorial I saw on Macoratti's website (obs guess everyone knows). And when you run the method just below, a OdbcException is thrown with the following message: ERROR [IM001] [Microso...
How do I interact with a transaction between two methods that are in different classes?
In my method where I open the transaction it is as follows:
public string InserirFuncionarioM(FuncionariosDTO Funcionario)
{
MySqlTransacti...