I am using a Visual Basic parametized query to locate a record in a SQL Server per the following...

Joe

07-09-2003 06:58 PM
AT

no. the return values (in the tds data stream) are passed back after all other result sets, so you must read to the end of each of these result...

bruce barker

07-09-2003 05:05 PM
bruce barker

Hi, In VB6 when using DAO e.t.c, it was often required to call the function DBEngine.Idle, otherwise MS Access took ages to release record locks...

Merlin

07-09-2003 04:44 PM
bruce barker

Hi, How would you get an XML file out of a DataSet? Inside of the XML file you only want to see updated records from a particular...

Andrew Bolonniy

07-09-2003 01:41 PM
Andrew Bolonniy

What you will want to be aware of is your connection string when connecting to the database. If you can make sure that this connection string is...

Silvia Brunet Jones

07-09-2003 01:22 PM
Jeff Woodie

My pleasure. Glad you got it working. -- Peter Wright Author of ADO.NET Novice To Pro, from Apress Inc. _____________________________ "copyco"...

copyco

07-09-2003 12:05 PM
Pete Wright

Well, using a SQL join (as I showed in the previous reply) the solution is to write the DataAdapter's Update, Insert and Delete commands yourself,...

Pete Wright

07-09-2003 12:04 PM
Pete Wright

I have a typed dataset with three tables. The names are "SaleCustTable", "SaleInvTable", and "CompanyDetail". when the dataset is filled ie:...

Roy Forkner

07-09-2003 11:47 AM
Giri

Where did you get the number 50? The connection pool has a default size. You can change it if needed. The advantage is that the physical connection...

Joe Fallon

07-09-2003 11:43 AM
Joe Fallon

hi! i have install petshop 3.0 sucessfully but when i run it ,the follow error message...

James

07-09-2003 11:42 AM
James

Is it possible to have the scroll bar appear beneath the headers, so they stay in view while scrolling down a large list of data in the...

Nimbus Dorkus

07-09-2003 10:17 AM
Nimbus Dorkus

Lots of people ask this question. Let me tell you what I know. You might divide the data-access mechanisms into two categories - managed...

Thomas Graef

07-09-2003 10:08 AM
Dino Chiesa [MSFT]

Thank you. It works. It turns out trickier than I expected, because it looks like Microsoft C# UI can not be updated from thread different from...

AT

07-09-2003 09:11 AM
AT

Then how about a starting value of -1 and an increment of -1? "Ced" <zechu_REMOVETHIS_ (AT) hotmail (DOT) com> wrote

Ced

07-09-2003 09:02 AM
Ced

I was gettting the timeout error too when trying to run a large bulk insert statement within ADO.NET. I tried increasing all of the timeouts in...

AT

07-09-2003 08:48 AM
AT

Hi, has MicroSoft developed any native ado.net data provider for PostGreSql. TIA regards

poonas

07-09-2003 07:49 AM
Teemu Keiski

Is there any way to find out whether the ADO.Net library installed on the Deployment PC is working fine. I am developing a workflow application...

Devesh Aggarwal

07-09-2003 07:07 AM
Devesh Aggarwal

I'm working on an ASP.NET website and a strange problem occurs. I execute a stored procedure that gets data out of 2 SQL Server databases. When the...

Domien Holthof

07-09-2003 06:28 AM
Domien Holthof

Hi, Good Day! I wonder why i can't debug my ASP.Net program. I do checked the "ASP.Net debugging" under configuration properties but there's an...

Phoebe.

07-09-2003 06:00 AM
Phoebe.

try to untick the "Network Transaction" option in security settings of MSDTC tab in the properties of component service which SQL Server installed,...

nx liu

07-09-2003 04:39 AM
nx liu

Please refer to the following link: Overview of Windows Server 2003, Web...

AT

07-09-2003 03:51 AM
AT

Hi. We get an intermittent exception as in the example below. Any suggestions on how to approach this problem would be appreciated. We cannot find...

Chris Kriel

07-09-2003 03:34 AM
Chris Kriel

Hi, Good Day! I need to know how can i delete my ASP.Net program? I tried to delete from Windows Explorer and from IIS's Default Web Site, both...

Phoebe.

07-09-2003 03:24 AM
Phoebe.

does anyone know why the syntax for SQL Inserts and Updates is so different? the Insert syntax can cause so many problems it would be nice to use...

me

07-09-2003 03:05 AM
me

I've written a generic code generator that generates classes with properties based on table names and fields. I'm just now testing it with the...

Michael Lang

07-09-2003 02:30 AM
srinivas moorthy

Ah! I knew there had to be another solution. I think I saw an example of this somewhere, but didn't think it applied to my situation. ...

copyco

07-09-2003 12:26 AM
copyco

How do i display the constraints that a table has..i'm using oracle 9i....I wish to display all the constraints that a table has...

Raj

07-09-2003 12:10 AM
Raj

How about using MAPPath "Pete Wright" <pete (AT) codemonkey (DOT) demon.co.uk> wrote

Raja Balaji R

07-08-2003 10:56 PM
Jerry

thanks Cowboy... I understand plenty about views, stored procedures and all in SQL Server. My issues were with filtering a dataset, but I have since...

SStory

07-08-2003 05:01 PM
SStory

Hi everybody I have DotNet framework installed and it is working fine. I need to make an assembly. I tried to run a *.bat file with the following...

Rajesh Madhra

07-08-2003 04:39 PM
Rajesh Madhra

Hi, I am doing some crytpo stuff, and I want to store my key, IV and encrypted values (These are all generated as byte arrays) in a database table...

James Bender

07-08-2003 04:04 PM
James Bender

Is this an issue with Oracle 8.x accessed using a 9.x client? swatturkar (AT) yahoo (DOT) com (Suhas) wrote in message...

AT

07-08-2003 04:03 PM
AT

Is it possible to databind the text property of both a treenode and listview item (windows forms)? I can't seem to find the appropriate solution for...

Marty Cruise

07-08-2003 03:40 PM
Marty Cruise

Hi. I have a weird problem when I update my database. I am using SQL Server 2000. In my VB.NET application I used Web Services for insert, update,...

Jean-Yves

07-08-2003 03:02 PM
Jean-Yves

Hi, Does anybody know how to add some foreign keys to a table by using VS.NET Server Explorer? Is it possible run some sql query command by using...

Chi Tang

07-08-2003 02:53 PM
Chi Tang

Hi, I recently upgrade my VS.NET to 2003 version (with 1.1 framework). But I've encountered some problems when I compile my old application! My...

Paulo Henrique Castro

07-08-2003 02:36 PM
Paulo Henrique Castro

You got it ;) -- Peter Wright Author of ADO.NET Novice To Pro, from Apress Inc. _____________________________ "trinitypete" <support (AT) trinity...

trinitypete

07-08-2003 01:51 PM
Pete Wright

First up, I don't know any reason at all why VS2003 would break classic ADO or ADO related controls. My immedate, highly supersititious not based...

Pete Wright

07-08-2003 01:46 PM
Pete Wright

dataset,as it will keep a copy of the data in memory.so that u can rebind the datagrid with changes without going to database. Rajesh *** Sent via...

Rajesh Tiwari

07-08-2003 01:43 PM
Pete Wright

John, In your property procedure you set the value mAddress but you do not display it. You need to add a line after mAddress = vAddress to display...

Ken Tucker

07-08-2003 12:43 PM
John Bonds

Deadlocks occur when one connection locks records that another connection needs. If this is the same stored procedure, you may need to change...

vineet batta

07-08-2003 12:38 PM
William \(Bill\) Vaughn

Hi all, i've a problem trying to update a DataTable with a calculated column added at runtime. The error i receive is: Cannot change readonly...

Luca Giusti

07-08-2003 11:56 AM
Luca Giusti

"David Boaz" <dboaz (AT) bgumail (DOT) bgu.ac.il> wrote Look at DataTable.Merge David

David Browne

07-08-2003 11:30 AM
David Browne

Hey Nick.... Will you please specify, exactly how you do what you describ? Creating what role where and how! I would be very pleased if you would...

ecoder

07-08-2003 11:18 AM
ecoder

I don't think that 5 seconds is unusual for a connection to Oracle; bear in mind that the framework's managed Oracle provider must load the...

AT

07-08-2003 10:59 AM
Bernie Yaeger

When I try to insert/update a null value in a field datetime with an SQL command, it´s generate an exception using .net oledb. I had try this SQL...

Diovani

07-08-2003 10:54 AM
IbrahimMalluf

With connections, I would use conn.Dispose(); to aid disposal. Of course, your example is a bit overblown, as opening 100 connections is not a...

Cowboy \(Gregory A. Beamer\)

07-08-2003 10:26 AM
Cowboy \(Gregory A. Beamer\)

Hi all, in my project I want to connect my visual basic .NET application to a Access 2000 database. Especially when trying to use a DataAdapter, I...

Luc Delcoigne

07-08-2003 10:23 AM
Paul Clement

this was working Dim szMsgNumber = db_grid.SelectedItem.Cells(0).Text until i changed the first column (at index 0) to a ASP:ButtonColumn from...

Daniel Bass

07-08-2003 10:18 AM
Daniel Bass

Thanks Srinivas, But the code works fine for the values under 31000 and throws an exception for bigger values. "srinivas moorthy" <srinivas_moorthy...

Devrim Baris Acar

07-08-2003 09:19 AM
Devrim Baris Acar