Archived Months
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
December 2007
January 2008
February 2008
March 2008
April 2008
all groups > dotnet ado.net > october 2003 > threads for friday october 24

Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

where are the wrong codes??? I can't find.
Posted by Tao Lei at 10/24/2003 9:32:33 PM
Please: I wrote these lines of codes of ASP.Net. But it goes wrong. Why??? Who can help me? Thank you very much!!! <% @Page Language="C#"%> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.Odbc" %> <html> <head> <Script runat="server"> void page_Load(Object So...more >>


Cannot Add Row To Access 2000 DB using insert into command
Posted by Tom Ashcroft at 10/24/2003 5:53:29 PM
All I have the following function public void AddItem(string cartID, int productID, int quantity) { string SQL = "INSERT INTO ShoppingCart ( [CartID], [Quantity], [ProductID] ) VALUES('" + cartID + "', " + quantity.ToString() + ", " + productID.ToString() + ")"; try {...more >>

DataView.Sort not sorting
Posted by anonymous NO[at]SPAM discussions.microsoft.com at 10/24/2003 5:31:23 PM
Hello, Can anyone tell me what is wrong with the following? I am trying to sort a table, then return it as the dataset. The dataset ds1 is returned, but is the same as the orignal, meaning that the sort did not take place. Thanks, David (existing dataset ds passed in to method) ...more >>

how to speedup ado.net in 98?
Posted by Jin-Yu at 10/24/2003 4:42:58 PM
Hi all, I write a c/s program, client receive data by web server from server, but is very slowly in 98 client, how to speedup? thanks. yujin 2003.10.24 ...more >>

DataSet
Posted by itsme at 10/24/2003 2:37:34 PM
Hello All, How can one convert an XmlDocument object into a DataSet? Thanks ...more >>

access to sql -- synch process with ado.net
Posted by JM at 10/24/2003 2:28:43 PM
i have an Access app with about 15k rows that will slowly grow (this is about a two years of data so far) indefnitely. The table structure is horrible in the access design (can not be changed, its a third party app) so on the sql side the table structure is totally different. What i need to do...more >>

is it possible to get ...
Posted by haiwen at 10/24/2003 1:42:58 PM
Hello, everyone: I have three tables like below: class {classID,int; cbtHour, int; ojtHour, int; } schedule { scheduleID, int; classID, int; } date { scheduleID,int; startTime, DateTime; endTime, DateTime; } the requirement is I need to set up schedule's date so that their tota...more >>

Failed to enable constraints error...
Posted by Robb Sadler at 10/24/2003 11:24:33 AM
I have created a dataset which contains a parent child relationship based on a date, machine and batch number. After creating the batch (parent) record, pseudo: new dataset new parentdataadapter new childdataadapter select stmt for parent for one record I am able to successfully ...more >>



Best practice for data insert
Posted by Greif at 10/24/2003 11:21:24 AM
I am creating some methods for disconected data maniuplations. I have came up with the following method to insert a single row into the DB: public virtual int singleInsert(string tableName, params IDbDataParameter[] values) { if(ConnectionString == "" || ConnectionString.Length == 0) ...more >>

Creating an exchange account. How to create mailbox?
Posted by Jeremy Chapman at 10/24/2003 11:21:05 AM
I'm trying to create an exchange account and mailbox using LDAP. So far I've created the exchange account, and it looks good when viewing it in Exchange administrator (Exchange 5.5). How do I associate it to an active directory? How do I create the mailbox for the account? (I tried to add the ...more >>

problem with multiple table datset updates
Posted by shiv at 10/24/2003 10:02:19 AM
Hi all, my code looks something like this connection = createconnection() // creates connection SqlDataAdapter ad=new sqlAdatpter("select * from EMP",connection); SqlDataAdapter ad1=new sqlAdatpter("select * from DEPT",connection); DataSet ds=new Dataset(); ad.fill(ds...more >>

connection Pool
Posted by VBM at 10/24/2003 10:00:35 AM
I am using ASP.NET, SQL Server and ADO.NET, when I debug my web application I get connection pool error...connections exceeded....But when I run it as a released version I dont get the connetion pool errors....I am explicitely closing the connections by calling My own Dispose method and not waiti...more >>

"GetOleDBSchema"
Posted by chak at 10/24/2003 9:59:31 AM
When i use "GetOleDbSchemaTable" to get the schema information of an Oracle table, it gets us numbers, in place of data types, when we connect to an Oracle 8 database, using the OleDB data provider from Microsoft. Any ideas on why it is in numbers ? Besides the numbers are not consistent with the...more >>

DataBinding could not find a row in the list ... ?
Posted by ghanchi NO[at]SPAM bigfoot.com at 10/24/2003 7:32:53 AM
I get the following exception message when I try to reopn a form window after closing it down (while the main MDI window is still running) "An unhandled exception of type 'System.Exception' occurred in system.windows.forms.dll Additional information: DataBinding could not find a row in the ...more >>

error about ReturnPooledConnection
Posted by Marc Jannes at 10/24/2003 12:15:18 AM
Hello, from time to time I get this error: System.NullReferenceException: Object reference not set to an instance of an object. at System.Data.SqlClient.SqlConnectionPoolManager.ReturnPooled Connection(SqlInt ernalConnection pooledConnection) at System.Data.SqlClient.SqlConnection.Op...more >>


DevelopmentNow Blog