Hi everyone-- I have a one-row DataTable that I need to manipulate. It consists of a series of three columns of related information. All the columns are strings. For example-- Col1 Col1Descrip Col1Value Col2 Col2Description Col3Value <etc> "AUTHO...more >>

Hello All! I am going to crazy and feeling myself so stupid but I don't understand such behavior. I have code: public int getNextAgentId() { Int32 agent_id = 0; IDataReader dr = dbap.DBDataReader("SELECT MAX(agent_id) FROM Agents"); if(dr.Read()) { agent_id =...more >>

Sorry , I should have made it clear, how do I do it in code. Thanks. ...more >>

And why the frick is it sooo damn hard to find information on this crap, anyway?!? Help! -Skipward ...more >>

Hi, I working on implementing a scrolling and record navigation with ADO.NET. In ado recordset having builtin caching/paging and record navigation methods. but i could find a similar conecpts in ADO.NET classes.. Am i missing something?? In dataset class i cannot set pagesize/cachesize, so ...more >>

Hi, Is there any class supports bidirectional cursor in the ADO.NEt framework? I was looking some of the samples and only talks about SqlDataReader (forward only cursor). Or is there any way i can make use of database cursors in my dotnet application to navigate the records from a table....more >>

I have an oracle storedProc that takes one input parameter and 15 output parameters. Can I get the results of the output parameters in a datareader or must I add 15 output parameters? thanks john ...more >>

I want to compare two datasets (of 2 datatables). I just need to know whether the 2 datasets are same or different. I do not want to know how it differs. (I would be nice to have though).. Is there any easy way to accompilsh this. Thanks ...more >>

Can someone help me with a very simple task I am trying to execute a stored procedure in an Oracle database using Ado.Net. The following is a code snippet conn = New OracleConnection(mOracleConnectionString) cmd = New OracleCommand cmd.Connection = conn conn.Open() cmd.CommandType = Com...more >>

I have an ODBC connection (to Perforce) using a System DSN. In a console app I can open the connection, in an ASP.Net webform I can't, and get the error... [OdbcException: ERROR [HY000] [ ERROR [HY000] [] I assume it must be permissions? I have tried a few things, firstly making ASPNET (I...more >>

How to let the user know the progress while accessing BLOB type data? The feedback such as the number of bytes readed/written to database. Regards, ZhangZQ ...more >>

Hello. If you think this post is too long to read please scroll to the bottom and read the last two sentences. Thank you :) I have a problem which I cannot find a good solution to and hopefully I can get some ideas from the readers of this group. I will first describe my environment for ...more >>

I have an excel sheet with a column of mixed data types, i.e., numeric & text. ADO.NET is scanning the first few rows and deciding on numeric so when we come across text, the data becomes blank. That being the case I set the extended properties setting to include IMEX=1 but this seems to be ...more >>

Hi everybody, we had very strange memory usage in our application when continiously updating a dataset. We were able to exactly localize the problem in the datatable.Select method. Each time we check the datatables for changes with Select, there is an internal index build. These indexes ar...more >>

Hi, i am trying to make a window application that create graphs (plot data as in excel) for a given set of points, how can i do this? thanx -- Message posted via http://www.dotnetmonster.com...more >>

Not really sure if I have a problem or not...but, I want to try and understand what is going on. With that said, I haven't ruled out that it's a code problem, but I want to post to see if anyone has seen similar behavior. Basically, throughout the day, we may see "large" jump in the number of...more >>

Hi, I thought I had my problem with the dataview and InsertAt fixed, but nope. It looks like it works at first, but then the dataview starts going nuts. And I experience the issue from my other recent post about the dataview containing datarowviews that don't point to an actual row. In fac...more >>

How do i find out what version of ADO.NET is being used in my .NET application. Iam building vc++ application in visual studio.net 2003 (7.1 version) and ..NET framework version 1.1. I would like use the new feature of ADO.NET 2.0 and need to know i have the correct ado dll's on my system.?...more >>

Hi, For some reasons, these lines of code sometimes differ in results: myDataView.Item(1).row("MyColumn") myDataView.Item(1)("MyColumn") Sometimes the second version throws a NullReferenceException in the System.Data.DataView.IsOriginalVersion(Int32 index) method. So the DataRowView ob...more >>

I'm trying to set the RowFilter = "MyDateTimeColumn in ('2005-02-21')" but it returns 0 rows. I know the row is there. If change the RowFilter to RowFilter = "MyDateTimeColumn not in (all the other dates but 2005-02-21) it returns the rows. Any suggestions? ...more >>

Hi, Let's say I have an existing view on a table which has 4 rows. If I add a row to the table at position 2, the view treats it as position 5, instead of it's physical location. Note: there is no sort on the view. So, the order in the datatable, should be exactly the same as the order ...more >>

Hi, I am trying to export info about a SQL server database in vb.net. I need to retrieve the following info about the fields in the tables: names, data type, length and default values. I have used the following code to retrieve the first three properies: Dim strSQL As String = "SELECT * F...more >>

We have a database that is accessed by the web to display the data. We also have programs that insert or update to that database. What I want to be able to do is insert data using a transaction but I don't want the web page to display any new rows being inserted until the transaction is commi...more >>

Hi. I have an XSD which describes a set of objects which one is both contained in a parent, as well as referencing itself again (recursively). XSD.exe doesn't like it very much and complains about: "The same table cannot be the child table in two nested relations." I have read all over th...more >>

Ive read about similar problems here. Im using a SQL 2000 db. Im trying to use the VS .NET designer to drag 'n' drop tables from Server explorer to my component and receive this error message. My table is uniquely identified by a primary key, so I dont understand the problem. Do you have an...more >>

I've created a strongly typed DataSet, with a 2 related tables. a couple of the columns in the parent are computed with expressions. One of which is a Sum of a Child.column (Sum(Child.UnitCost). Eitherway, since adding these expressions, I'm getting a InvalidOperationException when I execute t...more >>

...more >>

In VS 2003 we used Data access layers intensively. Is the same pattern valid for VS 2005? Or new data source features ceases its existence... ...more >>

Hi, I would like to concrete my understanding about my custom object using an ADO.NET connection object and the behavior of garbage collector. I have a simple .NET object public class DBACCESS { public void OpenConnection() { SqlConnection cn = new ...more >>

these two parameter field are varchar type in DB. when I pass an empty string in one of the paramters the result set is empty. but if I one parameter is something other than empty string, and the other is existing value in the db, the result is correct. Any idea ? string SQL = "Select * from...more >>

unable to load oramts.dll when i am trying to open the connection it is show the above problem. get me the solution. From http://www.developmentnow.com/g/7_2004_6_0_11_0/dotnet-framework-adonet.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com...more >>

I created a dropdown list and a datagrid in a webform. When a customer's name is selected in the dropdown list, a "SelectedIndexChanged" event is raised and the orders for that customer would be displayed in the datagrid. The following code was written but the orders were not displayed after ...more >>

Does SqlDataAdaptor do an explicit table lock when calling Update? We have an importer that connect to SQL Server 2000 and anytime imports are being written to a table and a query is ran against that table at the same time we get a timeout exception. Not locking the table is fine for us becaus...more >>

Hi all, I'm trying to catch errors and when running in VS.net 2003 my try catch doesn't seam to catch the error? this error comes up: why does this not catch it? Catch ex As System.Data.SqlClient.SqlException "A first chance exception of type 'System.Data.SqlClient.SqlExce...more >>

Hi I know that to perform a DataView.RowFilter based on a child relation, an aggregation must be performed. But I have a datagrid bound to a DataView (filtered by various columns) of my parent table on which Insert/Update/Delete operations are performed. The parent table has a relationsh...more >>

Whenever I try to read an excel sheet using ado.net, I keep getting this error "Could not find installable ISAM. " I tried what microsoft had to say on this link http://support.microsoft.com/?scid=kb;EN-US;209805 but the problem still persists. Does anyone have any idea why?...more >>

I am using a dataset containing Parent/Child tables. When I attempt to delete more than a single row, I get the DeletedRowInaccessibleException error on the second row to be deleted. I cannot figure out why. I have looked at the data just before the failed call (identified by ==>). I have ve...more >>

Hello: I have a Progress Bar in my program and I also wrote some code that will show the Percent completed. I know that the percent complete is actually being calculated but when i run the program it does not show up. Instead when the process is complete it just shows the 100%. Is there a...more >>

I'm using Microsoft OracleDataAdapter 1.0.5 with Oracle client 9.2 and Oracle DB 8.1.7 with NLS_LANGUAGE=AMERICAN and NLS_CHARACTERSET, NLS_NCHAR_CHARACTERSET=IW8ISO8859P8 Sometimes, when the result exceeds several hundred rows, I'm receiving gibberish in the lower part of the result. Any s...more >>

Hi! I have a windows forms application and , what I basically do is: 1.- Instanciate a DataSet. 2.- Instanciate a XMlDataDocument attaching the DataSet to it. 3.- Load XmlDataDocument with a local XML document (C:\mydoc.xml) 2.- Bind it to a Datagrid. That is all! My app doesn't nee...more >>

I had large database about 2GB size and consist of 1 million+ records. I use ADO.Net 1.1 in ASP.Net 1.1 for connection pooling this database and it always prompt "Stack Memory Error". The information request is about 2MB if I running at SQL Query Analyzer. Please advise. Many thanks. ...more >>

Hi, we had strange memory usage / memory leak of our web application which we could strip down to a (at least for us) unexpected behaviour of a dataset. Scenario: With application start we open a dataset keeping a reference of some datatables as long as the app runs. During this time we do...more >>

I am accessing an Access db. I generated the adapter and ds thru the wizard. I have a datetime field in the database (simply called Time) that I am posting to from a textbox. I had to convert it to dattime format, which seems to go fine, but when I execute the update, it strips the time p...more >>

hi all, i have storedprocedure who takes one input/output parameter the sp also return 2 tables. i m using sqldataadapter. and read the contents of sp in dataset in dataset 2 tables are automatically added by the sp which it returns but how can i get the value of output parameter. please he...more >>

Hello All In my DataTable the following data is returned Object_IDX Object_FullName 48984232 |MS_Net|EUR|Server02 48986409 |MS_Net|EUR|Server21 48990195 |MS_Net|EUR|WKS23 48995964 |MS_Net|EUR|WKS2 48996647 |MS_Net|EUR|Test01 I want to parse out the Object_FullName ...more >>

Hi there, I have an ArrayList containing approximately 20,000 database INSERT command objects. Each of these commands needs to be executed. The commands do not need to be executed in any particular order, nor do they need to be part of a transaction. I'm currently accomplishing t...more >>

Im using OleDb How do I send a parameter to an In clause ? My SQL is like this. Select name from contact where accountid in (?) accountids are char fields of length 15. Since the number of arguments inside the in clause could vary I cannot go on putting ? for each item in it. I tried cr...more >>

My program grabs a single datatable (dt) from an Excel file, loads it into a dataset (ds) and displays it in a datagrid (dg). The datatable has a couple of "calculated" columns that start out blank. After loading the datattable, the program fills in these blank columns using the values in othe...more >>

I am currently getting a General Network Error were I was not getting one before. The batty thing is the error happens about every other connection to the database. I have looked at the SQLException that gets generated and the error number is 20....more >>

I'm new to .NET.. I have multiple related tables that I need to insert data into. Lets say for example: Customers and Orders. Orders has a foreign key Customer_Number column in it. I want to use the dataadapter update method to do the inserts for me. Ideally I'd use a stored procedure th...more >>