Hi I am working with an access database with more than 25000 records (adresses). In vb .net i use the tableadapter and it takes a long time to read all the records (with access it doesnt take much time). Also when I use the update-query it even takes much more time, more then 8 minutes, to ...more >>

I have a dataset with two data tables. I created a data relation object to join the two tables by a common field. On a Windows form, I set up the data binding to a combo box for the first table. This is the "master". I set up the data binding for a datagrid for the second table. This is the ...more >>

We use ADO.NET / SQLProvider against SQL2000 for our web application. We have started to see more and more of these errors: Exception Type: System.Data.SqlClient.SqlException Errors: System.Data.SqlClient.SqlErrorCollection Class: 10 LineNumber: 0 Message: Timeout expired. The ...more >>

Using.. Visual Studio 2005 Team Edition for Software Developers SQL Server 2000 sp4 (on same machine) Net.Framework 2.0 Windows XP (up to date with all patches) Problem.. I'm trying to debug a stored procedure from within visual studio but when I set a breakpoint and then start the app in ...more >>

Hi, I am working inside the DataSet designer. I have 2 tables related by one relation and FK. Both tables have been configured to be updatable (insert,update,delete methods generated). All this is nice. Yet, I need to display a join of these tables selecting only certain columns on each ...more >>

Hi, How does AcceptRejectRule differ from Update rule and Delete rule? -- Thanks in advance, Juan Dent, M.Sc....more >>

Hi folks, I'm using the ADO.NET 1.1 framework and have this ADO.NET dataset I want to use to add and/or update records on the physical SQLServer table it came from. I am using an ADO.NET commandBuilder to automatically generate the update and insert SQL commands. I start with a SQL stateme...more >>

Hello, in a network-winforms-application based on a access database I've got the following problem: user A starts software user B starts software user A deletes row in db user B changes data application of user B makes an update dataadapter.update(datatable). Now I get an concurrency...more >>

Even Microsoft's own data-validation walkthrough article (http://msdn2.microsoft.com/en-us/library/1120xds5.aspx) recommends attaching a handler to the RowChanging event of the DataTable The problem is, that when editing a row, the RowChanging is raised after an attempt to update the row in th...more >>

Hi friends, how ru all, I have a question about creating Data Access Layer and Business Logic Layer using ASP.NET 2.0 and VB.NET, which is the best way, and what is that best and optimized solution for creating DAL and BLL. Thanks, ...more >>

When I sort a number I get a lexicographical sort 1 11 112 1 12 How can I code a sort that will produce a proper numerical order? Adrian. ...more >>

Hello! In ADO the preferred[1] way of specifying the connection string was using an .UDL file. What is the preferred way to do this in ADO.NET? // Anders -- English is not my first, or second, language so anything strange, or insulting, is due to the translation. Please correct me so...more >>

All: I am running a stored procedure via code but need help with the sytax for the output parameter as mine is wrong, Sorry, but I am just learning. Here's my incorrect section, more is listed below: OleDbParameter parameterContributionID = new OleDbParameter("@Contributi...more >>

Greetings All, I am writing a small test app in C# .Net 2.0 that needs to connect to an Oracle 10g database. I need to use Microsoft's data provide System.Data.OracleClient to connect to the database and I need to connect as "SYS." There seems to be no provision for connecting as "SYSDBA"? Am...more >>

Hi, I have a hard time recalling what was the basic rationales for using structs instead of classes in a C# program. Could anyone point out the reasons? -- Thanks in advance, Juan Dent, M.Sc....more >>

I developed a .Net website for Windows 2k3, but the webhosting team doesn't have a 2k3 environment ready to go. So I want to still push my .Net site, so I'm attempting to get the site to run on W2k that is already set up. I'm having a few difficulties on it. Current the site runs fine on 2k3 b...more >>

Hi I have a solution - just a test one - where there are two projects. One is a simple windows form with a text box called txtClient & a command button. The command button eventually calls a SP that has a parameter @ClientName. The other project is a class library that has a class calle...more >>

I'm currently programming an ADO.NET application for SQL server. I notice that the SqlCommand.Paraterers.Add() method require 4 parameters which are parameterName, SqlDbType, Size, and SourceCOlumn. The question is with Size parameter: What is the corrent Size value for SqlDbType.Int, SqlDbTyp...more >>

Hi; This has me confused. I have a dataset which was populated from one database. Can I insert this dataset's rows into a different database table using the same dataAdapter or would I have to create a second adapter? Isn't a dataTable just an memory resident data table ? So I am th...more >>

Are there any decent parsers around that can parse SQL? I'm looking for something that can validate the syntax and also allow access to the columns and tables from the select and where clauses? Thanks for any help, Joe ...more >>

I have deployed a test application (VS 2005) to several workstations. They need to make a connection to our SQL Server 2000 server. Most work fine. On one workstation, we keep getting the error: "An error has occurred while establishing a connection to the server. When connecting to SQL...more >>

System.Transactions: TransactionScope and CommittableTransactions leave open transactions on server. I'm having problems with commited or rolled back transactions leaving open transactions on the database server. The problem is on our web site using .Net 2.0, Windows 2003 server, SQL Serve...more >>

I've recently made a name change on a few database tables. I thought I got all the name changes done in the front end reference. However, this one eludes me. I've checked all the classes listed in the error trace. I've done full text searches across all the documents of the project and I sti...more >>

Hi, I am having problem with DataTable.Select() method. I am using ASP.NET 2.0. I have DataSet which reads data from XML file using DataSet.ReadXML(). Now this dataset has various datatable, created by XML file. I am taking one of the datatable from this dataset and want to filter on that d...more >>

Hello, I have a standalone windows application that uses MS Jet 4.0 to read and write from MS Access database. Rather randomly, I keep getting this exception: System.Data.OleDb.OleDbException: Could not update; currently locked. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHan...more >>

In the line marked *** "one" etc are not allowed. Please tell me why and what I should do to make this code work. Many thanks. Adrian. try { while (carry_on == true) { string one = binR.ReadString(); string two = binR.ReadString(); string three = binR.ReadString()...more >>

Hi I have a data adapter bound to a table. How can I loop through the table via and access each record's column values on the way? Thanks Regards ...more >>

Hi; I know SqlServer well but Oracle is new to me. I have a couple of questions as I get started: 1) Is there a sample somewhere of how to connect to OracleExpress on a remote computer and do a simple select. In other words the bare minimum to access the database. 2) Must the Oracle c...more >>

I have some legacy VB6 code that uses DAO (Microsoft DAO 3.6) to access an access 2000 database. In this app, Access is used soley for data storage - there is no UI component. I have converted the database to SQL Server 2005. Can I use DAO to access the new SQL Server database, or must I change ...more >>

Hi, I get above error when I use the find function on a bindingsource control. The datasource member of the bindingsource is another bindingsource control, where the datamember is a relational member of the datasource The field I'm searching on is absolut in the table behind, I can browse ...more >>

hi, I just downloaded Microsoft Enterprise Library June 2006 and try to integrate it into my asp.net application. As i am going to connect to mySQL database, I need to include the source code in my project so that I can debug better. But I all those examples I found are reference the compiled dl...more >>

Do you all like any books ... particularly VB 2005, VS 2005, WinForms, ADO.net? There are so many, I can't see the forest for the trees! ...more >>

Sorry if this is a basic question but I was wondering how to test the data being read back from a database. I am using a datareader currently and am not sure if that is the best route. In classic asp it went along the lines of setting up the recordset and testing the recordset information as it...more >>

I have to use either sql server or oracle databse in my application. The front end application in vb.net. ...more >>

Hi, I wrote a very simple program to test concurrency with sql server 2005. I used the VS 2005 dataset designer wizard to create my dataset and and tableadapter. When I ran the program, I used the debugger to stop the code before the tableadapter.update(row) method was called. I then ran the s...more >>

I was just curious if most people were using data-bound Web controls to display data rather than just display the info via code. I recall that old Visual Basic used to have bound controls but they weren't very good and no self-respecting programming made much use of this. I hear ..NET data-...more >>

I'm a programmer but not a database administrator and really don't want to be either. After a fair amount of reading and many problems related to SQL and related stuff, I finally figured out how to create a database in Visual Studio and enter some data into it. Now, I'm trying to make a Web si...more >>

I am writing an ASP.NET application that uses SalesForce data as the back end. SalesForce has a web service that exposes the data in their system. Unfortunately the ways that you can select data are very rudimentary. There is no way to do a join between tables in SalesForce and there is no wa...more >>

What is fastest way of accessing mysql by ado.net ...more >>

When we use the SQL to backup a database, we use: backup database Health to disk='c:\Backup.bak' with init This will generate a physical file in disk. Can we backup file to a Stream? ...more >>

If I create a database or attach a database file in the version of SQLServer that comes built-in to Visual Studio, the ConnectionString that VisualStudio automatically creates for connection to this database is a "file-based" connection ("AttachDbFileName=..."). Is there a way to attach a d...more >>

Hello, I have a Newbie question. I am using .NET 2.0 and C#. I have a data entry screen which has about 25 fields. Excepting one field, none of the others fields require inputs. My question What is the best method to insert the records to a SQL db - calling the SQL insert i.e. "insert into......more >>

Hi, How to determinate if an SqlServer instance existed in a Server? ...more >>

I have a table that is composed of an ID and two foreign keys. This table is used to relate two other tables. I'm using a dataview to display the data. The data can be edited, including changed, deleted and added. How should I set up the dataview columns so the user sees the choices from ...more >>

were can I get a music sharring service...more >>

My codes blowing up with the "Thread was being stopped" exception when I try to create a data connection. Here's the line of (MS VC++ .NET 2003) code blowing out: SourceConn = new IBM::Data::DB2::iSeries::iDB2Connection(S"DataSource=ANTIGUA1;DefaultCollect ion=EMBTEST;UserID=PCS;Password=PCS;")...more >>

Hi! I'm reading CSV-file using OleDB provider with SQL-select command and it's working fine. Anyway CSV-file contains "field" containing date values like 20060825, and I'd like to convert it into datetime format when reading it into DataTable like #8/25/2006#. How to do this? Propably I h...more >>

I'm using VB ADO.NET with Northwind database Employees table. I create a WinForm with a ComboBox (cboEmployee) to let user to select or enter full name and store it in strNames string array. I then try to get the matching Employee ID based on the employee name entered. However the ***SqlCo...more >>

Hi, I would like to build a monitor application that monitors the connection = pooling. I know that it is possible to use PerfMon for SQL Server, but I = would like to build my own to deal with other providers. Does anyone have any link to articles or any other information that I = could ...more >>

Sorry if this is a basic question but I was wondering how to test the dataset information as it is being read. ex, I have a table that contains file extentions such as .xls, .doc, ..ppt. What I want to do is test the dataset as they are being written and if the dataset is equal to .xls i want ...more >>