Hi We have an MS Access application which runs on the server but some laptop users need the app to work offline. Our solution has been to use Access replication which automatically syncs data (both ways) when laptop is connected to the network. We are looking to rewrite the app to vb.net/sq...more >>

I'm writing a Winforms project under Dot Net 2.0. One of my tables has a multiple field primary key. One of the key segments is a fixed char field used to determine the order in which the records are displayed in a grid. (S + a 2 digit number. This is entirely due to some legacy code restri...more >>

Hi, I have clarification about ADO.Net transaction and ExecuteDataset; In the "Microsoft Data Access Application Block for .NET" project the following code uses transaction for ExecuteDataset() What the purpose of using transaction in the ExecuteDataset()? I think transaction is not use w...more >>

Datatable how trap enter to Edit Mode? ...more >>

Hi All, I want to start some kind of debate or poll on Linq, the question is: Do you think is a good idea to work with Linq in the future? Most of the articles out there are not very impartial, and are embracing Linq as an evolution, while MVPs or wannabes are making tutorials as they go, w...more >>

How do I ensure that all database operations are rolled back when database connectivity is lost during the middle of a transaction? using (DbConnection connection = db.CreateConnection()) { connection.Open(); DbTransaction transaction = connection.BeginTransaction(); try ...more >>

It appears to me that using the SetModified() doesn't force the data changes into the database. I'm thinking it is doing comparisons between the DataRowVersion's. I say this because of my following problem. I have a scenario where the best way to handle the data is to take datatable table1....more >>

I was just wondering how most of you organize your data-access code. I know there's stored procedures, data source objects, data controls, and plain old C# and VB that we can choose from. Although I prefer a simple approach, it looks like a multi-tiered approach is warranted and I just want...more >>

Hi, I am creating my own data access layer (I know I am re-inventing the wheel but I like the challenge). At the moment I am able to pass in a HashTable with the key and parameter value and I use the key to get the SqlDbType from a config file. From there I set up the parameters requir...more >>

I'm probably missing the obvious. I have a dataset that is built in code (it has a single datatable) that I want to populate a datagrid based on an SQL statement that I want to run against the dataset. I can't work out though how to create a dataview from the dataset using an SQL stateme...more >>

After a decade of experience with VB versions, I recently installed VS.net 2005 professional. I ran into security roadblocks when I moved a small test app off my C: drive and onto a network file server. Searching through support.microsoft.com gives lots of complicated explanations and sugg...more >>

We have been provided with a set of typed DataSets which we wish to merge into the one DataSet, adding any additional relationships between DataTables as appropriate. We wish to use Visual Studio.NET 2005 to visualise and manipulate the various tables in order for all of the typed methods that...more >>

Hello, I've got a webpage, done with visual studio express web developer, which shows the result of a store procedure. I've got a problem, that sometimes my sql server 2000 replies with the results of the stored procedure quickly enough, but sometimes it's busy and the CommandTimeout of ...more >>

I have an ASP.NET 1.1 page to call a stored procedure in the SQL Server 2005. If I use the NVARCHAR(MAX) data type in a SQL Server 2005 stored proc, What should I use for parameter size for SqlParameter in Visual Basic.NET 2003 in order to pass in correct parameter? Thanks... -- Regards...more >>

When using Stored Procedures and SqlParameters when do you need to specify the SqlParameter.Size property? From the documentation and examples I have seen where Integers had a size set and examples where Integers did not have a size set. When inserting into a text field what would you set...more >>

hi i'm using VS.NET 2005 +SP1 C#, and i connect access database by ADO.NET 2.0. i'm using Dataset to (insert,update,delete) and in get data i use (Datareader), but my problem when i do this: 1 - insert data (by dataset). 2- get data (by datareader). when i run this commands i can't get latest...more >>

Hi, We are in the process of upgrading from SQL Server 2000 to 2005. We have one stored procedure that returns the result of a join on two tables, table A and B. Part of the result set is the primary key for Table A. Because of the nature of the join, data in table B can result in multi...more >>