I'm glad we agree. :) - Sahil Malik ADO.NET 2.0 book...

johnb41

01-04-2006 12:39 PM
Sahil Malik [MVP C#]

in the 'Access Cookbook' by Getz, Litwin and Baron, it shows how to get a qryAlternativeAlbums query as an OleDbDataReader: 'Construct an...

jonefer

01-04-2006 09:51 AM
Paul Clement

The example would be like this: <<<query analizer>>> sp1 param1,param2 --shows col1 col2 col3 col4 ---- ---- ---- ---- 1 1 2 ...

Buho

01-04-2006 09:32 AM
Buho

Usually, when I create a typed DataSet using the Visual Studio designer, IsColumnNameNull methods are automatically generated for each column in...

Harry Keck

01-04-2006 09:31 AM
Miha Markic [MVP C#]

Dear All We are currently write a program to "Transfer" Data from old system. How can i connect to a set of DBF files by What is the connection...

EricLun

01-04-2006 08:44 AM
Paul Clement

Hi, I'm building an application, to edit data on a SQL Server database. Database has a table Jobs with primary key (JobID) with identity seed =...

Rob Smeets

01-04-2006 08:10 AM
Miha Markic [MVP C#]

I want to toy with an embeded database for shareware application. I would like to know better SqlServer as well. However, correct me if I'm wrong,...

Lloyd Dupont

01-04-2006 07:38 AM
Lloyd Dupont

I have an ASP.NET app that searches for members using 5 parameters. I finally wrote a nifty Stored procedure to account for all or anything...

jonefer

01-04-2006 03:30 AM
jonefer

All, What is the simplest way to send an email message through the MS SQL Server? There was a method to send email messages using a standard C# way...

Just D.

01-03-2006 11:19 PM
Ansil MCAD

Hello, I am facing a weird problem using the DataReader. This is what my code looks like. --------------- Dim dbCommand As OleDbCommand Dim...

Cyril Gupta

01-03-2006 08:55 PM
Cyril Gupta

Why when using Dataset.WriteXml("C:\somefile.xml") is there a xml declaration added to the top of the xml document created. However, when...

CVillalba

01-03-2006 03:11 PM
CVillalba

How can i delete a row in dataset based on the column value, i have four columns in a row and i want to delete the row based on the column1 value.

dotnetlover

01-03-2006 02:16 PM
Miha Markic [MVP C#]

Hi, In our project we are using sqlClient to communicate with the database server(SQL Server 2005). It's running great. Our project is doing lots of...

millner,kim

01-03-2006 01:51 PM
William \(Bill\) Vaughn

I have a DataGridView which is bound to a dataset. When I delete rows from the DataGridView, should it delete the same rows from the dataset also? I...

Michael Wong

01-03-2006 01:11 PM
Michael Wong

I don't know if I am outdated or is my grouse still valid. I am trying to connect two concurrent DataReader objects to the same connection, but the...

Cyril Gupta

01-03-2006 12:20 PM
Paul Clement

i have a website that i use to file all my clients information, the go online and they type the information. i'm using an microsoft access database....

Gerlop

01-03-2006 11:47 AM
Paul Clement

Using c# and Visual Studio 2003, I've begun to wonder whether I'm adding rows to Oracle tables correctly. The tables often have "row ID" columns...

Joe Reggae

01-03-2006 10:16 AM
brian_harris

Hi, We have one application that return the exception below, when retrieve any date fields: "Specified argument was out of the range of valid...

Luis Augusto M. Barbosa

01-03-2006 08:20 AM
Cowboy (Gregory A. Beamer) - MVP

Our application, currently in .NET 1.1, uses strongly-typed DataSets as business objects. These have been created using a third-party generator (from...

Mark Rendle

01-03-2006 07:24 AM
Mark Rendle

Hi, "Thomas Ströehm" <thomas (AT) stroehm (DOT) com> wrote If you're talking about a master-lookup scenario with ComboBox then you don't need any...

Cor Ligthert [MVP]

01-03-2006 06:43 AM
Bart Mermuys

Does anyone know when the data access block for ADO.NET 2.0 will be released? (or has it - and i cant find it?) guy

guy

01-03-2006 05:27 AM
guy

Hi, my server has a database table. I read this table on the server into a dataset and my client retrieves it through a webservice. No changes on...

Anthony Malt

01-03-2006 05:02 AM
Cor Ligthert [MVP]

Is a DataSet.Clear required before new data is brought into the dataset? I.E. daMyDataset.Fill(dsMyDataset) Can I simply refill the dataset with...

Rick Lederman

01-03-2006 03:46 AM
Cor Ligthert [MVP]

I have a datatable with a field in it that tells me where the data belongs (let's say the values are 'A' and 'B'). I want to split the table into...

UJ

01-03-2006 03:41 AM
Cor Ligthert [MVP]

I'd like to programatically move through a table (call it a recordset in ADO ) and disply fields in a textbox. I've gotten as far as the code...

barret bonden

01-02-2006 05:12 PM
barret bonden

I have a paramaterized command for a data adapter SELECT MRN, Name, Sex, DOB, SSN FROM dbo.Membership WHERE (MRN = @MRN or @MRN is null) AND (Name...

jonefer

01-02-2006 04:01 PM
Otis Mukinfus

I just discovered the SqlCeResultSet in the compact framework. It is more like ADO or DAO than anything else that I have seen as far as coding in a...

Rick Lederman

01-02-2006 02:51 PM
Rick Lederman

LOL Thats funny :) -- - Sahil Malik ADO.NET 2.0 book...

SwatSoftwareDev

01-02-2006 02:35 PM
William \(Bill\) Vaughn

In ADO.Net, can I create "create table ( ... )", "alter table ..." stuff, and execute it to create my schema for MS-SQL2000? Jack

Jack

01-02-2006 10:35 AM
Jack

Okay try this - On the 4 tables, call "BeginLoadData" before you start filling, and "EndLoadData" after the data has been filled. See if that...

Sahil Malik [MVP C#]

01-02-2006 08:44 AM
Sahil Malik [MVP C#]

The code below loads an Access table with one row. It then adds a row and displays all this in a datagridview. So far so good. But when I use the...

William LaMartin

01-01-2006 10:48 PM
William LaMartin

Hello, I have several strongly typed DataSet classes that encapsulate the same table. My challenge is that I can't reuse the wrapper code for this...

Vagif Abilov

01-01-2006 04:09 PM
Vagif Abilov

it seem that data table and Expression field have a lot of Laks, it is true? the DataTable is powerfull of Memory relation data that bind...

AT

12-31-2005 03:41 PM
Adrian Moore

I'm use diffgarm xml (for update) which is sent with a schema with sqlxmlcommand whith sqlxml version 3 sp3. This mechanizem used ALL the parameters...

Shtirlits

12-31-2005 02:50 PM
Shtirlits

A concept I've waffled on from time-to-time with ADO.Net: how often to submit updates back to the database. For example, I have some CF apps...

Earl

12-31-2005 04:21 AM
Sahil Malik [MVP C#]

(VB Exoress 20005) I get an exception on this line : ra = myCommand.ExecuteNonQuery() {"ExecuteNonQuery requires an open and available Connection....

barret bonden

12-31-2005 03:09 AM
Cor Ligthert [MVP]

Hi, Where does the datareader store it's data in this scenario: Create sqlconnection, Create sqlCommand - query specified here could return 1000...

Vadim

12-31-2005 02:14 AM
Cor Ligthert [MVP]

How do most people support multiple database types such as SQLServer, Oracle, Access, etc.? Mainly I am wanting to just support MS (SQLServer...

Me

12-30-2005 06:38 PM
john smith

I'm trying to create a SqlServer express database file on the fly in a web application.. (mhh.... maybe I should try to get something running in a...

Lloyd Dupont

12-30-2005 06:15 PM
Lloyd Dupont

Is there a trick to keeping a Typed DataSet in sync with the underlying database other than either manually making the changes or deleting and adding...

Dotnet Gruven

12-30-2005 03:44 PM
bianderson

Hi everyone(happy new year!!), Well, here we go... I have a problem with datsets, ado.net as i understand ..I have a sp that in query analizer...

Buho

12-30-2005 02:26 PM
Buho

I would have to see what you are attempting to do to better understand. One of my former coworkers did some tests with the TableAdapter that...

Cowboy (Gregory A. Beamer) - MVP

12-30-2005 02:00 PM
Cowboy (Gregory A. Beamer) - MVP

As the existing application is running very slow when start application, How to use backgroupworker to load dataset?

abc

12-30-2005 10:15 AM
abc

Can anyone point me to step by step walk-throughs of ADO.NET code - I'd like to get to the point of being able to programmatically work...

barret bonden

12-30-2005 10:04 AM
Jerry H.

Hi How to pass the content of one data table to another data table.I simply tried using assignment operator...Example:...

Ravindra

12-30-2005 07:20 AM
Miha Markic [MVP C#]

Hi, I have an sql server on seperate system and my application runs on another dedicated server - both the machines works on Windows 2003 server OS....

Suhas Vengilat

12-30-2005 05:22 AM
Suhas Vengilat

I seem to recall, back in the early promise days of Whidbey, that there was talk (and even an early version) of a set of classes for mapping...

Martin Robins

12-30-2005 03:46 AM
Miha Markic [MVP C#]

I have an application that connects to sql server. Two installs of the application are frequently experiencing the following...

Scott S.

12-30-2005 01:46 AM
Cor Ligthert [MVP]

Using VS2003 and SQL2k. I've noticed that if I have an expression column (or relation column) added to the main table, I cannot do an Update without...

Earl

12-29-2005 04:14 PM
Earl

Hi, I am using VisualStudio 2005 (C#) and have to write a code to access Oracle Database. I know that in .NET Framework 1.1, I could...

Dino Buljubasic

12-29-2005 03:57 PM
Dino Buljubasic