Hello, I trying to produce a querry that will accomplish the following and am not sure how to write the statement. I am currently using Jet 4.0 but...

Charles A. Lackman

12-29-2005 04:38 PM
Charles A. Lackman

Hi, I am trying to merge two datasets into one, each dataset has one table when I merge the two datasets I get a dataset with two tables? I need the...

Chris

12-29-2005 07:51 AM
Chris

Hi, when you load a child row when the parent row doesn't exist in a relational dataset an execption is thrown. Is there an event to capture this...

Bart

12-29-2005 03:54 AM
Cor Ligthert [MVP]

So far the dataset just shows Type, Benefit, Change I want it to show Type, Benefit, Change, Description This should be a pretty elementary...

jonefer

12-29-2005 03:37 AM
Cor Ligthert [MVP]

Hello, I just purchased Visual Studios 2005. I noticed that when I drag a control from the DataSources toolbar, or set the datasource property of...

AaronMoore

12-29-2005 03:29 AM
Cor Ligthert [MVP]

hello all, Created procedure in sqlserver accepting id as parameter to delet record. initialized statements Dim DeleteCommand As New...

karunam

12-29-2005 02:21 AM
Miha Markic [MVP C#]

Hi I am busy with a C# Windows application. I load data from a MS Access database into a DataSet. In my database the primary key is an...

Kobus

12-29-2005 12:32 AM
Kobus

Hi I have a sub method that has been passed a dataset as parameter. I need to insert this dataset into a table. What is the code that I need to do...

John

12-28-2005 04:34 PM
John

Hi all, I need a quick way to create a new datarow based on an existing one change a few values and update them to the database (the...

AT

12-28-2005 02:28 PM
AT

Hi everyone. I have a small problem that I can not seem to resolve. I am executing a stored procedure using the ExecuteReader method. However it...

WXMCDBA

12-28-2005 02:15 PM
WXMCDBA

New feature come in VS 2005, ability to ADD local database files (.mdf) into project. When i install my EXE on client PC, I need install SQL server?

AT

12-28-2005 01:57 PM
Paul Clement

This is why I am against using the wizards generate all this garbage for you. Then you have to go back every time you make a database change...

Marina

12-28-2005 01:17 PM
Marina

Any clue to why this newRow call sets "programSelected" to null no matter what I have tried? Further explanation, this function resides in a form2...

Rock

12-28-2005 12:46 PM
Rock

This is a union query from an Access Database But I will also be using SQL server For the meantime in Access, I want parameters MRN, and SGR For...

jonefer

12-28-2005 12:22 PM
jonefer

VS 2003 question I know that this question has been asked alot but I have seen no direct answer to it as yet. From control panel it is possible to...

MDFS

12-28-2005 11:59 AM
Matthew McHugh

Hi, I am trying to review by ADO.NET skills so what will be the best online site to review the topics in ADO.NET and if possible that should be a...

review

12-28-2005 11:13 AM
review

If I only have ASP.Net 1.1 installed on a server what would I replace this with? <dataProvider...

Kim\(Kman\)

12-28-2005 09:54 AM
Cowboy (Gregory A. Beamer) - MVP

I am using a DataGrid with a dataset and the OracleDataAdapter.Fill(dataset,"Tablename") method. All is fine: a table is created and mapped to the...

mspzzz

12-28-2005 08:56 AM
Paul Clement

It used to be that you could add references to the same Com object used by VS2003 by: Add ref to adodb Add ref to Microsoft OLE DB Service...

_DG

12-28-2005 07:49 AM
_DG

Hi How can I insert a dataset into an sql table? Thanks Regards

John

12-27-2005 06:32 PM
John

I've often used the datagrid CurrentCellChanged event to trigger my Update code. However, I've noticed with checkbox columns, this event is...

Earl

12-27-2005 03:22 PM
Earl

I'm using the SqlCommandBuilder to help construct the update commands to a SQL Server 2000 database. I have the SqlCommandBuilder generate the...

PaulJB PHD

12-27-2005 02:38 PM
PaulJB PHD

How to generate a dataset from stored procedure which have many resultsets? I try Dataset designer from VS2005, it only generate first table from...

abc my vclass

12-27-2005 11:20 AM
Elton W

Hi, Is there an equivelant to the old ado recordset which you could use the movenext/moveprevious methdods with? If not, what do you use to do this...

Ant

12-27-2005 11:18 AM
Paul Clement

Hi all, Merry Christmas! I have an application that reads records off an Excel spreadsheet and imports them into an Oracle database. What I have...

JL

12-27-2005 09:29 AM
JL

If I have three DataTables, let's call them "MyParentTable", "MyChildTable" & "MySubChildTable", with a relation between "MyParentTable" and...

Ted

12-27-2005 01:59 AM
Ted

Hello I use the data source window to connect to a database. Because the location of the database might vary, I want to change the connectionstring...

Dirk Schelfaut

12-26-2005 09:05 AM
W.G. Ryan eMVP

Hello: The Jet provider is not part of the recent MDACs. You would have to download a recent version of the provider which is not part of the...

Wiktor Zychla [C# MVP]

12-26-2005 07:38 AM
Skanda Subramanian

Hi all, i am using Sql Connection with SqlHelper class; it is working fine with windows xp and MSDE; when i developed the application and tried it...

Anupam

12-26-2005 07:34 AM
Skanda Subramanian

Hi All, I want to update the values into database.And i get these values from a xml file.I have done the coding for that but its not...

AT

12-25-2005 04:37 PM
W.G. Ryan eMVP

hey guys, any idea(s) why this code would only export the first page? it works perfectly - just if the report has multiple pages, it only exports...

rbutch

12-25-2005 12:26 AM
Sahil Malik [MVP C#]

I created an application that makes use of a typed DataSet for holding its data. This DataSet is saved out with simple XML serialization. Now,...

Arian T. Kulp

12-25-2005 12:23 AM
Sahil Malik [MVP C#]

Hi, Is there any effect of Enlist attribute in the connection string if there is not DTS environment, No COm+ or MTS. I am facing a problem where...

Bhupesh

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

Is there anyway new in SQL Server 2005 to enumerate all the servers on the network without sqldmo? I'm working in .NET and want to get the list,...

Brian Henry

12-25-2005 12:15 AM
Sahil Malik [MVP C#]

What is the easiest way to map table names when filling a dataset? I am filling a dataset from two tables. My command text looks like this: "Select...

David Veeneman

12-25-2005 12:14 AM
Sahil Malik [MVP C#]

I saw a lot of people were having a problem with this and I found an elegent solution to this problem so I decided to post it. Use the following...

Jonathan Seidner

12-24-2005 03:27 PM
Jonathan Seidner

I have to create an SQL statement at run time based on the items the user selects on a report menu. The SQL statement gets quite complex if you...

Steve B.

12-24-2005 02:01 PM
Triax

I have a combo box that inherits from DataGridTextBoxColumn. Everything works fine with the control except a CancelEdit(). The underlying rows' value...

Joe

12-23-2005 11:09 PM
AT

I notice that after converting a vs.net 2003 ASP application to vs.net 2005 that my DataAdapters are gone from the design view along with the ability...

Gary Blakely

12-23-2005 10:20 PM
AT

Background: Using ADO.NET 2.0 with VS2005 RTM. I have a data column with the following set for its expression...

Oldman

12-23-2005 02:10 PM
Oldman

Hi, Jet engine is a separate download (starting from MDAC 2.6 if I remember properly) thus you have to install it (just search ms website for...

Miha Markic [MVP C#]

12-23-2005 03:38 AM
Miha Markic [MVP C#]

Hi, I Want to update My Database , i using sqlDataAdapter and i have all the command (Insert/select/delete/update). I dont want to use update method...

Yossi And Inbar

12-23-2005 03:37 AM
Miha Markic [MVP C#]

I was having a problem using a DataTable targeted against a table with columns that have default values and do not allow nulls. When you added a new...

William F. Kinsley

12-22-2005 11:54 PM
AT

When binding a control to a BindingSource and executing .AddNew on the binding source, then setting default values on the row, the bound controls...

JohnT

12-22-2005 09:30 PM
JohnT

Hi everybody, I like to asked anyone who is very good at sql to help me display this data in a table format that duplicate headings, subheadings or...

den 2005

12-22-2005 07:09 PM
den 2005

Hi, I have an asp.net application which intermittently throws the following exception trying to open an oracle...

Andy Fish

12-22-2005 03:12 PM
Sreedhar

I am using GetOleDbSchemaTable to read the data from the Excel file. It is working fine with all workbook/worksheets except the one that has...

Rohit

12-22-2005 10:42 AM
Paul Clement

Hi, I originally posted this on public.data.ado, and someone nicely informed me that this group is probably better suited to my question, so here...

AT

12-22-2005 09:51 AM
AT

In Microsoft Access, it is possible to create a query and then refer to it inside another query... how would I do this in ADO.NET? I'd like to...

jonefer

12-22-2005 04:26 AM
Earl

hi.. i'm trying to connect to oracle 8.1.7 in asp.net using integrated security but i'm always getting a ora 01017 invalid username/password. logon...

saleryan

12-22-2005 02:57 AM
saleryan