I'm getting an OracleClient does not exist error, however I see the System.Data.OracleClient in the Assembly Cache. Is there something else I have to do for the namespace to be imported? Thanks! --Steve ...more >>

What namespace do I need to import to get the object OdbcConnection? And where would i find out such information? Thanks! --Steve ...more >>

Where's the best place to setup an application wide SQL connect string for a C/S style application? We want to read the value from the registry. Also I'm thinking about using the DataAccess block. -Bill ...more >>

In the DataAccess block example, they create a database connection in GetConnection method of the sample form (Form1) which is called at the beginning of each of their examples. But in their SQLHelper Class they also create connections in many of the methods such as ExecuteDataset. What's goi...more >>

Hi, I'm, wondering about what the best way to approach the following problem is: I have a an application that has a list of users whose data needs updated in a database (SQL Server). Now, the only way I currerntly know how to do this update is to either repeatedly execute an SQL string or r...more >>

Using Excel 2000 under Win 2K Pro with MS ActiveX Data Objects 2.5 Library: I would like to be able to determine if a database has been modified since my last read. I create my database connection thus: Dim db as ADODB.Connection Set db = New ADODB.Connection With db ...more >>

im not great at sql and need to nest these statements ( for speed) but cant get it i would appreciate any help thanks" SELECT qryExistingPersons.Person, qryExistingPersons.SumOfInvoiceAmount, qryExistingPersons.CheckNum, qryExistingPersons.Deal, qryExistingPersons.Reference FROM qryExistingPe...more >>

I am trying to dynamically change a DataTable by clearing the table, columns, rows, and PrimaryKey -- recreating the column collection, recreating the PrimaryKey, and finally adding the new rows However, after invoking DataTable.Clear() along with clearing all the other information, the table stil...more >>

Hi all, this might be a simple question, but then again maybe not. I'm binding a text box in a Windows form to a column that does not allow nulls. The problem is, if I do AddNew, the user leaves the field blank, and I call EndCurrentEdit, I get a "null not allowed" exception. What I want is to pu...more >>

Trying to use the System.Data.OracleClient provider. I can create the connection but when I try to open it the browser craps out and I get a page that says "Server Application Unavailable - The web application you are attempting to access on this web server is currently unavailable. Please hit the...more >>

I have written my own DataAdapter for my DBase IV file(s). The Insert, Update and Delete calls all report success when I call Update(...) on the DataAdapter. Unfortunately, when I recall the data, only the Inserts and Deletes actually worked. For some reason, the UpdateCommand is returning th...more >>

Hi. Who is the responsible for the installation of the classic ADO pia (adodb.dll)? Is it installed by the .NET Framework package or by the MDAC package? Thank you. Julian ...more >>

Hello: I have a dataset field: Description='STRUCTURES. SWALE INLET TYPE D-3(36" DIA.) (<10' DEEP)' I want to save several fields including the description into a SQL table. The replace("'","''") should pass the string as : 'STRUCTURES. SWALE INLET TYPE D-3(36" DIA.)(<10'' DEEP)' Bu...more >>

Hi: Is there any way to perform aggreate functions and grouping on a Dataset or Table. The reason is that I have all the detail information on a dataset and I need to provided summary information too. So I was wondering if there is anything on the ADO.NET to allow me to do this without going...more >>

Hi, We are running a W2K3SBS with W2K3 STD as a member server. We then purchased 5 TS CAL's (per user), installed TS Licensing and the TS Server on the member server. When I go to TS Licensing I can see the 5 CAL's are available and 0 issued. However when users who are members of the mobile...more >>

Hi We migrated our web server from a single processor, 1 GB RAM to a dual-processor blade server with 2 GB RAM and we hit this problem. We did not make any changes to the pool size i.e. using the default settings. We had encountered this problem occasionally (1-2 times a month) much earlier i...more >>

I'm new to .Net, but have 8+ years using VB. I'm having a problem using data binding in a windows Forms project. The scenario: I have a simple form with a series of text boxes and associated labels for containing input which all goes into the same table. In addition there is a ComboBox co...more >>

I am using SQL Server 2000 as the backend for an application in C#. Is there a way to do a join on tables in different databases or do you have to do some in memory slight of hand to accomplish it? Any help is greatly appreciated. ...more >>

why download free... :( ...more >>

My company is considering scaling up a database application that previously used Microsoft Access. The database has about 25-30 tables in it. The amount of daily transactions to the database is fairly small for that number of tables, but is growing. The web application that uses this database ...more >>

I have a data set full of data, and a list box, I want to be able to filter that set of data to a specific clase then put the returned filtred data into the list box... how would i do this? I already tried a few ways but haven't found one that doesn't cause an exception yet... thanks! ...more >>

Please forgive the newbie-ness of this question, but I was perusing the MSDN site and found reference to the System.Data.OracleClient namespace within ADO.NET. So I went into my project and typed "using System.Data.OracleClient" and...it doesn't appear to exist. Same thing on my laptop. Same thin...more >>

Hi all, I am just wandering, is it possible to programmatically detect each column's data type of SalDataReader, DataSet.Tables[i], DataTable? Thanks for any suggestion! -- WWW: http://hardywang.1accesshost.com ICQ: 3359839 yours Hardy ...more >>

Hi! I have a problems with DBNULLs I have a date field and couple of other fields, when I save my data, if it was a null when I got the data I want to keep that data intact even if it was a DBNULL Little example function savedata(DateFinish as date,Room as string...etc. savedata(cdate(DatePicke...more >>

Hello, The code listed below will insert a Microsoft Word or XLS file into my sql table when the column is defined as an "Image" type. But if I change the column to a "Text" type the provider will throw "Operand type clash: Image is incompatible with text" error. Any ideas why I can't save m...more >>

Hi, Is there someone know how to create dataset from XML format on .NET. Thanks, KPH...more >>

Hi, I've downloaded the Microsoft Visual FoxPro OLE DB Provider. I use it to connect to a FoxPro database using the Free Table method (there is no .dbc). Now I'm having some problems with the sql syntax. I'm trying to use a CASE statement inside my SELECT statement and I get the error: "Co...more >>

suppose i have a dataset populated using dataadapter. i bind the dataset to a windows datagrid. i accepts new record through textboxes not through the datagrid. how can i detect if the data entered is already existing to the dataset before the update command of the dataset is executed so that th...more >>