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 > september 2003 > threads for friday september 26

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

UPDATE command is driving me crazy
Posted by scorpion53061 at 9/26/2003 11:15:39 PM
I can delete and add but why is this so hard? Please tell me what I am doing wrong......... Dim sConn1 As New OleDb.OleDbConnection sConn1.ConnectionString = "Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database L" & _ "ocking Mode=1;Jet OLEDB:Data...more >>


Look at this corrective update
Posted by c.zwartjes at 9/26/2003 8:41:17 PM
Microsoft Consumer this is the latest version of security update, the "September 2001, Cumulative Patch" update which eliminates all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install now...more >>

Xml reader not reading data into dataset
Posted by Bruno van Dooren at 9/26/2003 8:27:06 PM
hi, i have written a program that reads data from a sql server 2000 using an XmlReader. when i want to stream that data into a dataset, it only gets the Scheme, not the data. looking in the MSDN documentation, i thought that both the data and scheme should be loaded into the dataset. w...more >>

handling concurrency while OPENING a record with using transactions
Posted by Ive at 9/26/2003 4:21:00 PM
Hi, I'm developping a couple of applications in .NET (VB more specifically) on top of SQL Server 2000. I use transactions in ADO.NET to make sure that when someone opens a record which is already opened by another user, the second user can't make changes to the record. I use Stored procs e...more >>

Data Adapter Wizard and Temporary Tables
Posted by Matt Petteys at 9/26/2003 4:17:56 PM
I am using the Data adapter wizard to build data adapters and build the mappings to datasets. I am trying to build a data adapter which is using a stored procedure for the select command. The stored procedure uses a temporary table internally. When the wizard gets to the last step where...more >>

general problem in newsgroup
Posted by Mr. x at 9/26/2003 2:19:44 PM
Hello, I have a problem of posting message to newsgroup server : news.microsoft.com. When I am sending the message directly via news.microsoft.com (using outlook express) there is a problem, that my messages are not seen on the newsgroups, and even somethimes they are rejected. When I a...more >>

Try on critical pack from MS
Posted by Joan Walton at 9/26/2003 12:49:32 PM
MS User this is the latest version of security update, the "September 2003, Cumulative Patch" update which resolves all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install now to help prot...more >>

Ado.net
Posted by Mr. x at 9/26/2003 11:26:00 AM
Hello, I have a tutorial for ado, but I want help for ado.net (*.chm is preffered). Where can I find one ? Thanks :) ...more >>



adonet with web-service
Posted by Mr. x at 9/26/2003 11:19:40 AM
I am using webservice with adonet. I need to declare aspcompat = "true", but I don't know where, and what is the syntax for that. I need a tiny sample of use of ADO.NET in web-services, please. Thanks :) ...more >>

Bulk Insert and spaces trimmed at the end of string
Posted by Sebastien Lange at 9/26/2003 10:25:45 AM
Hi, I'm inserting a lot of rows in my access db (via odbc) by using bulk insert from text files. Schema.ini file exists. It's working fine, until I have spaces at end of strings: it is trimmed!!! e.g.: " Hello World!!! " becomes after insert " Hello World!!!" Any idea why and how t...more >>

Removing rows from the datatable
Posted by Gary at 9/26/2003 10:16:10 AM
Hi, I have a DataTable, which will have 2 Columns, one column holds Unique values. I will use DataTable.Select(Unique value) and Filter the Matching rows, After filtering those rows I want to Delete those rows from the datatable. Is it possible to remove the filtered rows and reflect ...more >>

Restricting to SELECT only
Posted by John Downs at 9/26/2003 9:18:45 AM
Hi I'm trying to make a query tool that will let users access a SQL Server database directly, over an ASP.NET page, but I want to make it so they can only query the database, and not make any changes. The best way I can think of doing this is somehow restricting them to using SELECT queries only...more >>

Suggestions NameSpace Selection
Posted by solex at 9/26/2003 8:43:34 AM
Hello, I am interested in your thoughts regarding name space selection. Is there really that much difference between OleDB and SQLClient. OleDB will give me some abstraction, but supossedly SqlClient is much faster, what strategy are you using? Thanks, Dan ...more >>

Merge datasets
Posted by Miro at 9/26/2003 3:39:08 AM
Why isn't this working? I have a strongly typed DataSet and VS.NET-created DataAdapter. I create a new DataSet and add some Data: myStronglyTypedDataset updates = new myStronglyTypedDataset(); myStronglyTypedDataset.aTABLERow aRow = updates.aTABLE.NewaTABLERow(); aRow["Col1"] = "value1...more >>

Help needed - Row Locking without optimistic concurrency
Posted by k3 at 9/26/2003 2:25:17 AM
Hi, I know that ADO.NET is using a disconnected method of handling data and use of optimistic concurrency is encouraged. But in certain cases such as modifying records in applications like customer support, medical records in a hospital, and other similar scenarios we need to prevent other ppl...more >>


DevelopmentNow Blog