Thanks for any insight in advance. Using the MS Building Blocks for Data Access in an ASP.Net app, I have a couple of questions. In theory, via the browser, a user will never be working with more than a single record at any given time, so why use DataSets for DB access? I am accessing the d...more >>

=DDstanbul, Turkey - 22 September 2003 =20 Klik! Software today announced availability of CompareLib v1.0 for = MSAccess, a tool to compare and synchronize the structures of MSAccess = databases. =20 Klik! CompareLib has been especially developed for the aim of comparing = and synchroni...more >>

I am currently looking into making a c# program run more efficiently. The program currently uses some #ziplib classes to open a zip file and read each of the records from it, write them to a file and then run a DTS package against the file. I'm sure that writing the unzipped file to disk is ...more >>

Hi. I am creating a database that tracks organizations and their members. After trying to post several questions in the last couple of weeks, I figured out the basic structure of my database was lacking. I have two tables members memID, memName, etc. orgs orgID, orgName, etc. ...more >>

Hello All, I've been looking everywhere for sample code that shows the proper procedure for updating a SQL database from results stored in an ADO Dataset. There are plenty of examples for filling the Dataset, but none that show all of the code for performing the update once changes hav...more >>

I apologize in advance for the "newbie" question. I have a simple ASP.NET application connecting to an access database. On one page, the database is queried about 10 times each time it is loaded. I have found that the page reads the DB and loads correctly the first 4 times the page is loaded...more >>

Need to create an Access database from my C# application. I have tried using ADOX, but when I have problems and submit questions to newsgroups, I get no response. I'm thinking that maybe ADOX is not what others are using to create Access databases from C#. What are others using? What is the ...more >>

I am getting an ArgumentOutofRangeException. Index out of range. Must be a non-negative value... when I delete all rows from a datatable in a 5-table dataset and then insert the same number of rows or more. The first time I do this, it usually succeeds, but if I run my function again, I ...more >>

VB[WinForm] I am using a Binding Manager loacated in a Data Access Layer. Lets say in a test dataview I have 9 rows and I add a new Row using the BindingManager.AddNew Function. If I look at the BindingManager.Count - at this point I have a count of 10 rows as expected. However ...more >>

This is gonna be a long and tuff (hope not) one ! Hi everyone, please if you help me send me a hint ! I have been on that on full time for 8 hours...Here it is: I have a dynamic stored procedure (see code below) that builds a Transact-SQL statement an executes it. In that Stored procedure th...more >>

Hi. We are in process to update our first VB6 project to VB.NET. We decided to use the migration process to optimize certain areas of the application, including the use of connections. In our VB6 project the connection string is generated dynamically. Our users type the user id and password on...more >>

Hi, I am attempting to replace what I would normally be able to do easily with joins in SQL, with relations and rowfilters. But I am unable to see how to do the following: I would like to select rows from a parent table based on values in two or more child tables. As an example let us...more >>

Ok, I'm looking through the newsgroups and searching the web, but hopefully someone can point me in the proper direction a little faster.... I have a single SQL table as follows: Category CategoryId uniqueidentifer not null Name varchar(50) not null ParentId uniqueidentifer nul...more >>

Hello All, How do I change SqlServer Table's Column name from 'ColumnA' to 'ColumnB' through the script . But the CoulmnA has already data in it, which is not supposed to be destroyed. Thanks for last solution. Regards, -- Ather Ali Shaikh Software Engineer eIntelligence (Pvt.) L...more >>

I've search around endlessly for a solution to this problem but have not found anything yet. I'm using Crystal 9 with .NET. I am not using a DSR to create the report. Instead I am creating a report at run-time, using a .ttx file and using a DataSet as the source. My problem is that I want...more >>

Hi everyone I have a problem opening a connection to an access 2000 db from ASP.NET Sometimes (and only sometimes) i get an exception raised (0x80004005 couldn't lock file) when trying to open the connection, this happens only on the production machine while my development machine behaves we...more >>

Hey people, When a datareader is used for paginh with a datagrid in asp.net, we have to use the custom paging method ? How do we find out the total records returned from the datareader itself ? Any samples of using the grid with datareaders to achieve efficient paging ? Efficient here mea...more >>