Are OleDb libraries installed with runtime .NET or do you have to install ADO.NET separately? -- Thanks ------------------- czupet@wsinc.com ...more >>

Can anyone tell me why some tools are shut off in the Compact Framework area of the Visual studios 2003. The XML tools are very usefull in the Windows Application Area, but are UNAVAILABLE in the Smart Device Area of the Editor. Is there a Fix for this ?? Thanks for your time. Dave ...more >>

In Data Adapter Preview window, you can preview the size of the dataset. But how to get this value progammtaically? i tried to find proper property in dataset and data adapter but cannot find. any idea? Here is the screenshot: http://www.ezballet.com/scrdump/datasetsize.gi ...more >>

Is it possible to run 2 commands within a try-catch statment with a datareader i. Tr Cn.Open( Dim reader1 As SqlDataReade Dim reader2 As SqlDataReade reader1 = cmd1.ExecuteReader( reader2 = cmd2.Execut...more >>

Hi, I have a Dataset with 2 tables : TBL_CUSTOMER ---------------- Cust_ID CustName CustAddress CustPhoneNo Type_ID TBL_CUSTOMER_TYPE ------------------- Type_ID TypeName I also have a data relation parent/child linking the 2 tables. I want to display the following infor...more >>

Can anyone tell me why my datarelations are not showing up at run time when I instantiate a Typed dataset that I created in the Visual Studio 2003 visual designer? I have dragged two table on to the designere and created a relation between the two tables and generated a typed dataset. At run t...more >>

Hi, I can't find how to transfer a datatable in one time to an empty access table... Is this possible? Thanks for your help! Wim ...more >>

I am trying to Add and Update data to Access database, the update part works just fine, but when I try to add data I get the following error, what am I doing wrong? --------------------------- --------------------------- System.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC Microsoft...more >>

Are Nested Transactions possible with ADO.NET? Ive read where Ole DB supports nested transactions, but when I try to implement them I receive the following error: OleDbConnection does not support parallel transactions Here is an example of the code: public class DAC { public DAC() ...more >>

When using a strongly-typed dataset, it seems to me that a logical extension would be to associate the dataset with a logical system and treat the associated strongly-typed tables and rows as system-wide collections and objects respectively. In this sense, the strongly-typed dataset and its asso...more >>

Hi We have a sbs2000 server with xp & win2k clients. Question is, how can such a set-up be remotely supported at individual machine basis? I presume I can use remote desktop for xp? What can I do about win2k pcs? Thanks Regards ...more >>

Hi I am trying to run a query that will return a date. I wanted to pass the contents of an arraylist as a parameter to the query. The query will need to be run many times for each value in the arraylist so i have placed the code in a loop. What i am confused on is how i actullay use the values of ...more >>

If you have a datatable connected to a dataview. And In that dataview you have a "Sort" property set to a value; And You try to modify the "Sort" column in row in such a fashion that it gets moved in the DataView IT CAN Corrupt your database. A quick fix is to set the "Sort" propert...more >>

Hi, I created a new command object passing the connection and the transaction of the existing transaction. Then I call ExecuteNonQuery. Instead of using the same connection it opens up a new connection causing a deadlock as both are trying to use the same resource. Is this a correct behaviour...more >>

I don't see how the following code snippet from page 100 in ADO.NET core reference creates the primary key out of the ID field CREATE TABLE NewTable (NewTableID int NOT NUL CONSTRAINT PK_NewTable PRIMARY KEY OtherField varchar(32) Its not clear to ...more >>

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 >>

Hi Could any one tell me what is the latest version of System.Data.OracleClient? Currently I'm using version 1.0.1012.0 in my project which is giving problem of not closing connection eventough I'm issuing connection Close() statement.I am trying to connect Oracle 8i from ASP.NET framwork 1.1 in m...more >>

I dont have a problem with the required 2 clicks to change a checkbox value, however, on the second click, the value change is not immediately visible. I can see the change only after I select a different cell. Please advise why this visibility problem is happening. thanks ...more >>

[If someone has already addressed this issue, please let me know in detail as I have actually searched all of microsft.public.dotnet.* for an answer and couldnt find it anywhere] Hello again... I have the following problem: Lets say I have a Parent DataTable (ID, col1) and a child DataT...more >>

A chain letter is a "get rich quick" scheme that promises that your mail box will soon be stuffed full of cash if you decide to participate. You're told you can make thousands of dollars every month if you follow the detailed instructions in the letter. A typical chain letter includes names an...more >>

It seems kind of inefficient to have to pass the connection string in each time you use one of the SqlHelper methods. Does it make more sense to have it stored at the SqlHelper class or at least have that class get it from somewhere else as opposed to having to continually pass it from everypla...more >>

I'm not sure where the most effcient place to put my main SqlConnection object should be. The app's a typical windows form based client/server app. Do I put the SqlConnection in my main application's class? Do I put one on each form? The forms are modal but at somepoint that might change wh...more >>

Hi, Is there any way by which null values of a dataset's table can be represented in its XML. Regards. ...more >>