ado.net

ADO.NET: query a DataTable on a timeout

Hello, I have an in-memory DataTable that contains two fields of type DateTime, respectively LastAction and LastHeartbeat meaning the last time an entity sent an activity log message and the last time the entity sent a heartbeat ("I'm alive") log message. I'm building a method to query the data table with various criteria, including the...

.NET 4.0 application to use Microsoft ADO Ext. 6.0 for DDL and Security

I try to compile Xsd2Db solution in .NET 4.0 framework. I add a reference to "Microsoft ADO Ext. 6.0 for DDL and Security" and use it in this way - using System; using System.IO; using ADOX; namespace Xsd2Db.Data { /// <summary> /// Summary description for JetDataSchemaAdapter. /// </summary> public sealed class JetDataSchemaAdap...

Ado.Net RecordSet member equivalent?

I'm currently re-writing a Vb6 program relying on ADO into C# w/ ADO.NET. I've run into several places in the original code with stuff like this: Dim rs As New Recordset rs.CacheSize = 500 Call rs.Open(sSql, cnMeta, adOpenForwardOnly, adLockReadOnly) Is there an equivalent (or even a need for an equivalent) to ADO.RecordSet.CacheSize...

Assign value from ADODB.Recordset

Hi, in VBA I assign variables with values retreived from a recordset like this: variable1 = rs("column1") variable2 = rs("column2") Can I do the same in C#? ...

JDBC and ADO.Net: API comparison

What are the analogies between the objects found in JDBC and the ones found in ADO.Net? I know the object model in JDBC and ADO.Net are not exactly the same, but I think some analogies can be found among them (and key differences worth stating). That would be useful for those who knows one API and wants to learn the other, serving as a...

Databinding in .NET - Datatables, Dataviews and BindingSources

Hello, When binding to datatables in visual studio, it sets the datasource of a bindingsource to the selected datatable - which is fine and is what is expected. However, the datasource is actually pointing to a dataview of that datatable. I'm currently implementing custom business object base classes which include collection classes. I...

ADO.NET Data Services and eager loading?

I'm using sharepoint 2010 listdata.svc service who uses ADO.NET Data Services. I'm wondering if it's possible to do eager loading with this service without writing own DTO objects. Thanx in advance ...

SQL Backup to Isolated storage from ADO.NET

Hi All, Is it possible to create an SQL server database backup using c# ADO.net and outputting the .BAK file to Isolated storage? Thanks ...

Why bother setting the size parameter of a command object parameter?

Our data access layer uses command objects to communicate with sql server. In most cases I've hard-coded the field size (that matches the column size in sql server) into the command param builder. Such as: SqlParameter param = new SqlParameter("@name", NVarChar, 4000); What's the advantage to specifying a value here (4000 in this ex...

Why does this T-SQL function always return true?

Hi I wrote this function and now its always returning true... can anybody help me? Create FUNCTION dbo.ValidateCenter ( @Center_ID nvarchar(50), @Password nvarchar(50) ) RETURNS bit AS BEGIN declare @Res bit if exists(Select * From TPasswords Where (Center_ID = @Center_ID) and (isSecurity = 0) and (Pass = @Passw...

Total rows that we can add to datatable

Hi, I wants to know whether there is any limit for number of rows that we can add to datatable. I am doing this in C# and .NET 2005. Actually my application is reading large text file around 40 MB,application reads text file line by line and adds it as row in datatable once all file reads then calls update method to update data to datab...

How do you install an ADO.NET managed data provider onto SQL Server 2005?

I'm trying to install the sforce managed data provider on SQL Server 2005 but as there is no installer, just a dll, I'm not sure on how to go about it. Any ideas? ...

What next after ADO.net

I have been using ADO.net since 2002/2003 and most of the application I have developed so far use ADO.net (I do use business objects in my application but underlying data access is through ADO.net) Question: What is/will be next paradigm of data access technology assuming you are using .net framework and SQL Server? I am hearing LINQ ...

Data binding in DataGridView

I've created a database (which contain some tables) in SQL Server 2005. In the Server Explorer of Visual Studio 2010 I have connection with this database. And I've added to form DataGridView object. In the DataGridView Task I've chosen the Data Source. Visual Studio screenshot: http://img221.imageshack.us/img221/8573/snapshot4c.png ...