hi all, i am working on a MS.access project, in this i need to generate a report from multiple tables. I have used stored queries for operation...

sai

07-12-2006 12:10 PM
William \(Bill\) Vaughn

Hello: I am using 2 datagrid in a master-detail, now if I want delete a record in master, I should delete all child record of this master record...

wesbird

07-12-2006 11:38 AM
AlBruAn

Hi! Scenario: A User deletes a row in a DataTable; a MessageBox comes up and asks if he/she really wants to delete the row; in case the answer is...

AxelHecker

07-12-2006 09:52 AM
AxelHecker

Dear All, What is the relevant way of migration of ASP to ASP.net

Nau

07-12-2006 07:10 AM
Nau

Seems to me that a lot of people have had this problem. I went...

Philippe

07-12-2006 04:22 AM
Philippe

How can I change the ConnectionString in QueriesTableAdapter? I have some queiries which returns scalar values in QueriesTableAdapter in DataSet, but...

Jan

07-12-2006 04:16 AM
Sacher dos

I am using a non-pooled OLE DB connection to add records to an access database. The database is an empty template database that is copied to the...

AT

07-11-2006 07:52 PM
Scott M.

I have a table that has some data that is being read is a column with XML data. It is typed 'text' and the server is running 2000 so I don't have...

Kevin Burton

07-11-2006 07:15 PM
Kevin Burton

Hello, I developed an export to Excel that runs in an ASP.NET 1.1 page (code-behind). Sometimes, when calling the Open() method of the...

Mike

07-11-2006 06:22 PM
Mike

I am having difficulty sending an update of 20,000 rows to an SQL server. When I use sqlCommandBuiilder to create the update command the update...

Chris

07-11-2006 04:17 PM
Chris

Name have been changed to protect the innocent. This is the only class that is causing me this issue and I can't figure out why. Everything before...

ECathell

07-11-2006 03:20 PM
ECathell

I have a calendar control that I am using to have a person select a date. Then I connect to a database and I want to display anything that is equal...

MasterChief

07-11-2006 02:56 PM
MasterChief

Many Thanks Carl, It worked PR "Carl Prothman" wrote:

PR

07-11-2006 02:17 PM
PR

I'm trying to code a routine that will test the connection to a server and I would like to specific how long (aka timeout) the .Open() should wait...

Rob R. Ainscough

07-11-2006 12:40 PM
William \(Bill\) Vaughn

I have a typed DataSet with a DataTable in it. The structure of the DataTable is from a table in a database. Now I have make the DataTble with about...

ad

07-11-2006 11:15 AM
Miha Markic [MVP C#]

Hello everyone, I am desperate to solve this problem. I have built my website using Visual Web Developer. The website works perfectly fine when I...

AT

07-11-2006 09:04 AM
Nuki

Hello, I have the following problem. I have my own component descendand for TextBox, Where I have property "DataField", that indicate into column...

Qubeczek

07-11-2006 08:10 AM
Qubeczek

I'm getting an error when I try send a dataset from a .NET2.0 proces to a .NET1.1 proces: Type is not resolved for System.Data.Serializationformat,...

henk gijsbert

07-11-2006 03:01 AM
henk gijsbert

Attention ADO.NET provider writers! Microsoft is inviting third party ADO.NET provider writers to take part in our ADO.NET Provider Writer...

AT

07-10-2006 08:38 PM
AT

Hello, Just recently installed 10g Express and the latest release of ODP.net and found an issue or more of a nuisance. Everything works fine except...

Brian Pruitt

07-10-2006 07:34 PM
Brian Pruitt

All, I have set a transaction lock on an Sql Server 2005 database as below: transaction =...

Scott

07-10-2006 06:48 PM
Scott

How can one fill a DataSet or DataTable from inside a transaction? I'm receiving an exception when the following Fill method is executed. DataTable...

Mike King

07-10-2006 04:00 PM
Mike King

My understanding of ADO.NET connection pooling as it relates to Sql Server is that once a connection is created and opened, behind the scenes...

John A Grandy

07-10-2006 02:54 PM
Sahil Malik [MVP C#]

SqlClient maps to SQL Server functionality, so as long as SQL Server continues to support multiple commands, SqlClient will :-) --Mary On Sun, 09...

Mary Chipman [MSFT]

07-10-2006 09:32 AM
Mary Chipman [MSFT]

In SqlClient - probably yes. (I say probably because I'm not an MSFT employee, but I haven't heard anything contrarian). - Sahil...

Sahil Malik [MVP C#]

07-09-2006 11:00 PM
Sahil Malik [MVP C#]

Hi guy, How can we make sure the date format that we pass in MS Access are constantly the format that we wish. I ask this is because My select...

Goh

07-09-2006 10:41 PM
AT

I have a table with a DateTime column and both the date and time portions of the field are used in the entries. But I want to write a query that'll...

Alex Maghen

07-09-2006 09:50 PM
AT

Hey folks, I have a quiz in my mind... When u have a query that u have 3 ou 4 tables involved (tables), I figure there r 2 solutions: 1) You write...

Bruce One

07-09-2006 05:09 PM
Cowboy \(Gregory A. Beamer\)

I would like to know how joins (2 or more tables involved) are treated by LLBGen, either how to write client code or how LLBGen deals with...

Bruce One

07-09-2006 07:47 AM
Bruce One

Why do we serialize business objects?

kunaly

07-09-2006 12:33 AM
David Williams

I have just opened DAAB code and saw that, incredibly alll functions return only Sql objects. That means this App Block does not deal with Oracle or...

Bruce One

07-08-2006 08:51 PM
Matt Noonan

I need to have several different applications on a multi-tiered system access a common data infrastructure. I'm trying to store a strongly typed...

Abhorrenator

07-08-2006 07:11 PM
Abhorrenator

Hi, what is really worthwhile to use of Ent Library framework (e.g. Data Access Application Block) ? Who has used in practice ? Thanks a lot !

Bruce One

07-08-2006 12:34 PM
ECathell

I have a Table with a SmallDateTime field name OrderDate. I want to insert a record into this table, I use the SQL below: sSqlLogIns = "Insert Into...

ad

07-08-2006 11:34 AM
Cowboy \(Gregory A. Beamer\)

I have a very long stored procedure "runMRP". approx 1000 lines and can runs for 30 minutes at Query Analyser. It runs sucessfully at query analyser...

Locus

07-08-2006 11:30 AM
Cowboy \(Gregory A. Beamer\)

Hello All, I'm having this problem which deals with 2 tables in a database. Both tables have a primary key set as an autonumber but also both tables...

samyk

07-08-2006 10:35 AM
Cowboy \(Gregory A. Beamer\)

I am trying to add a new item to a table based on another item in the same table. To do this I have the user click on the + button on the navigator....

ECathell

07-08-2006 08:46 AM
ECathell

I have Visual Studio 2003 VB .net application that currently access MS Access database. Does anybody know that if it is possible for these...

dotnet user

07-07-2006 05:04 PM
William \(Bill\) Vaughn

I'm sure this is a basic question, but I'm just not getting it. I'm using a Try / Catch block to surround my database access code. ...

Bryan

07-07-2006 04:47 PM
Bryan

Running VB.Net I pass a datatable from a form.list to a form.item and use a dataview to show a selected row in text boxes. The row to show usesthe...

Tom_B

07-07-2006 01:53 PM
Tom_B

I am a new user of Visual Basic Express / SQL Server 2005 Express editions. I am trying to write sql statements in an application database that...

jwilson

07-07-2006 01:52 PM
jwilson

In VB.NET 2005, the ADO.NET provide TableAdapter for Developer eaily code the query and parameter query by "Query Builder". I can build a single...

ken

07-07-2006 12:10 PM
W.G. Ryan eMVP

Hola Tengo un problema con una pantallita que estoy realizando, lo que quiero es cargar un combobox con informacion de una biblioteca del AS400 pero...

Kary

07-07-2006 12:05 PM
Kary

Hi I'm trying to read RTF and Word files from blob columns in SQL Server, but the files can't be opened in Word when i retreive them. They seem to...

excession

07-07-2006 11:26 AM
Paul Clement

greetings! I am new to this, so if I am in the wrong discussion group, I apologize. I would like to 1)use a treeview component (in Web Developer 05...

julie

07-07-2006 11:21 AM
julie

Hi, I'll try to make it short, thing is - I'm trying to implement a query notification (Sql Server 2005) in a C# Windows Application. I've been...

דוד

07-07-2006 06:08 AM
David

Hi All, I hope someone can help me with this. I am working with real time data.Where on one end there is a desktop application & on the other hand a...

Ritesh Sharma

07-07-2006 02:57 AM
Raj

I apologize if I am posting this to the wrong area. Here is my problem. I am running a .NET 2003 Windows service against Oracle 9i. This service is...

MPutt

07-06-2006 12:45 PM
MPutt

Hello, I am working with an Access database file and want to create a new file with the same table structure. Creating the new file was no problem,...

Sensei76

07-06-2006 11:52 AM
Sensei76

Avendo visto il servizio di Raccomandata on line mi sono chiesto se sia possibile inviare in modo automatico una raccomandata direttamente dal...

flavio

07-06-2006 09:56 AM
Miha Markic [MVP C#]