I am wanting to replicate between a local MSDE database and SQL Server 2K. I am not sure how this should be approached. 1. Do the tables on each side need to be identical? 2. Do I create the database locally and then create a mirror of it on the SQL server or can I replicate data held within...more >>

Hello there, I've been reading up so many postings on this topic for days now and have tried most suggestions to resolve my error without success - I was hoping some fresh thoughts on the issue might help come up with a solution. The problem is this: I have a long running sql query that,...more >>

Hi, I want to migrate an ASP aplication to ASP .NET, but it is being more difficulty that what I think initial. In my ASP aplication I have a recordset turn off (that's the name that I call him). And you ask me, WHAT'S THAT? Well... I need to load to a dropdown control the name of people tha...more >>

So I've got a result set coming back that consists of 4 columns "name", "source", "sourcePath", and "Total". What happens is that the data in the sourcePath column is lost and replaced with the data from the "source" column. Further, the column formerly known as "sourcePath" is now "source1". I ...more >>

Hi, I have a OleDbCommand select statement as [string sqlStatement = "SELECT * FROM Contact WHERE Department LIKE '*" + strSearch + "*' ORDER BY Contact.ContactId;";], which retrieve data from MS Access database. The statement always return 0 record. But if I take out the two "*"s, then it wi...more >>

I've seen code snippets where ADO.NET datasets are created programmatically as their own class, which inherits from System.Data.DataSet. The code usually resembles, the following with tables, relationships and constraints created in the user defined class. class DataSet : System.Data.DataSet { ...more >>

Specifically, the stuff in the square brackets at the beginning of the class decl.. How does it apply to the class? thx. /// <summary> /// Data Access Object for Message /// </summary> [ Transaction( TransactionOption.Required ) ] sealed public class DAOMessage : DAOBase { ...more >>

Specifically, the stuff in the square brackets at the beginning of the class decl.. How does it apply to the class? thx. /// <summary> /// Data Access Object for Message /// </summary> [ Transaction( TransactionOption.Required ) ] sealed public class DAOMessage : DAOBase { ...more >>

Hello, Can somebody tell me what I'm doing wrong here, please? I'm using ADO.Net from an ASP.Net page to insert records into an Access table. It works OK, except that the value written to the text field ('Name') is always right-padded with spaces to the width of the field. Here is the relevan...more >>

[This followup was posted to microsoft.public.dotnet.framework.adonet and a copy was sent to the cited author.] Hello everybody. I have a problem with ADO.NET when I try to connect to a SQL server database. My C# code call a stored procedure that is used to normalize a database in which the...more >>

Hi, I'm using a Access database with a dot.net application. To get last insert Id(Autogenerated) from a specific tabel, I have used "Select Max(Id) from table" to populate a datareader. I then use "Reader.getint32" to get the id. This works fine when there is something in the tabel. But when t...more >>

I am trying to delete a record from a database using ADO.NET (with VB.NET), but because there are relationships defined in my MSDE db it produces a referential integrity error. In Access it automatically cascade deletes! How can I do this with MSDE? ...more >>

Hi, I was just reading about the new MARS (multiple active results set) technology that will be included in the forthcoming ADO.NET 2.0. If I'm understanding it correctly, with the new ADO.NET, you'll be able to execute multiple queries simultaneously over the *same connection.* That's ver...more >>

Hi. For my current project, I have to write a stored procedure that calls VB.NET code. Is there any sites that provide info on how to do this? Thanks a lot for information....more >>

Hi, Using the clone method I copied the structure and constraints of a table. Now using this clone table, can I create a new table in the database ? If yes, is it by the update method of the dataadapter ? Help appreciated. Thank You ...more >>

Hello, this is my first attempt of calling a Microsoft Access stored SQL statement which expects a value to be passed to it. I think I am having a problem generating the Parameter for running this procedure in my C# application. I run the following SQL Statement in Access and it runs just f...more >>

Hi everybody I am trying to take an existing datarow from a datatable, modify its Primary Key value and reinsert into the datatable as a NEW (datarowstate.added) row. The code below i the track I have been pursuing, but I keep getting the error that the datarow already belong to another table. ...more >>

Dear All, We are facing problem for OleDBConnection if my connection to database is killed or database server is restarted. it gives error: System.Data.OleDb.OleDbException: Session closed/terminated Problem: 1. For executing SQL query we create new OleDBConnection, execute that que...more >>