Hi, Using ADO.NET Table adapter in C# , am updating a record using VS2005 generated update command by passing dataset and the assocaited table...

=?Utf-8?B?cGFjaHV0cw==?=

06-21-2007 04:22 AM
Petar Repac

Hi, im using CSLA for my business objects. At my data layer tier i loop through my list of business objects, if the object is new i insert a...

=?Utf-8?B?Q2hyaXM=?=

06-21-2007 02:19 AM
RobinS

Does committing a transaction close it's underlying connection ? Or must you explicitly close the connection ? Also, is there any reason to dispose...

John Grandy

06-20-2007 07:26 PM
William \(Bill\) Vaughn

Hi, i have a class library which implements a data access tier. As i used the automated designer for the dataset it automatically added an app.config...

morleyc@gmail.com

06-20-2007 02:51 PM
morleyc@gmail.com

Is there a good primer on DataTables out there? Mainly I am looking for an article that lists the properties and methods (with examples) on the...

tshad

06-20-2007 01:06 PM
tshad

I have two sql server stored procedures that use transactions. Both stored procedures have there own begin transaction , commit and...

=?Utf-8?B?SmVycnkgSg==?=

06-20-2007 12:42 PM
Mary Chipman [MSFT]

Hi NG! I have recognized a strange behavior of the DataGrid control. If I'm editing the value of a cell in the DataGrid and press the close button...

schaf@2wire.ch

06-20-2007 10:53 AM
William \(Bill\) Vaughn

I'd like to ask for the correct way, or rather say the more advisable way to connect to a SQL Server in a Windows application written in .NET 1.1 or...

=?Utf-8?B?d3J5dGF0?=

06-20-2007 10:48 AM
William \(Bill\) Vaughn

I am opening a excel CSV file and selecting the contents. However it is selecting a trailing extra row, and this is really playing havoc with my...

Mick Walker

06-20-2007 03:29 AM
Mick Walker

i use visual studio 2003 amd c#.net to make my web application my site is about e-learning in my site i want to set some setting in "create new...

Mero

06-19-2007 08:02 PM
Scott M.

I'm a Vb.net 2005 newbie, but an Older VB6 programmer. With a ADO I work very comfortably (many years!), with ADO Is possible to work DIRECTLY with...

=?Utf-8?B?TmFuZG9fdXk=?=

06-19-2007 05:41 PM
=?Utf-8?B?TmFuZG9fdXk=?=

Hi, I created a DSN (ODBC) to connect to a database in IBM DB2. I wanted to create a dataset for 'Select' Statement by wizard. When I add a query...

frank

06-19-2007 01:11 PM
Mike Matthews

i use visual studio 2003 amd c#.net to make my web application my site is about e-learning in my site i want to set some setting in "create new...

Mero

06-19-2007 02:27 AM
Mero

I have a page which I dynamically add several usercontrols (*.ascx files) to using the following code: Public Sub Refresh() For Each section As...

Nathan Sokalski

06-19-2007 12:04 AM
Cor Ligthert [MVP]

hi to all; i use visual studio 2003 amd c#.net to make my web application my site is about e-learning in my site i want to set some setting in...

Mero

06-18-2007 07:07 PM
Mero

i all, I have a class with properties returning int, string, date... and generic Lists of other classes. private static string zipcode; private...

=?Utf-8?B?R2hpc3Rvcw==?=

06-18-2007 03:47 PM
Miha Markic

Hi We have recently moved onto SQL 2005 and our DBA wants us to use Try Catch within our stored procedures. If I have an SP such as: CREATE...

Phil Sharp

06-18-2007 10:23 AM
Simon

I apologize for any inappropriate cross-posting, but wasn't sure where whether this is a Pervasive or ADO.NET issue. I'm trying to migrate data from...

mitzoe@yahoo.com

06-18-2007 09:57 AM
mitzoe@yahoo.com

Hi all, I am workibng on an application that will interact with an Oracle database and this is the first time I am doin sthg with oracle. From what I...

ashehu@gmail.com

06-18-2007 09:18 AM
Glenn

I've got a worker thread in which I'm updating a DataTable instance. Within my main thread, I'm hosting a DataViewGrid, which is bound to a...

Jon Pope

06-18-2007 12:04 AM
Cor Ligthert [MVP]

Hi EveryBody: I made project by using Asp.Net 2.0 and the code behind is written by vb.net I want to delete the old password from the database...

=?Utf-8?B?SHVzYW0=?=

06-17-2007 11:54 PM
Cor Ligthert [MVP]

Hi, there is a Data Access Application Block for .NET Compact Framework ? I need for an Pocket PC app, I have Visual Basic .NET 2005 and SQL Server...

=?Utf-8?B?Q2hldnk=?=

06-17-2007 02:09 PM
Jim Hughes

On Jun 13, 3:01 pm, Göran Andersson <g... (AT) guffa (DOT) com> wrote: But it does subclass MarshalByValueComponent which implements IDisposable. ...

Smokey Grindle

06-17-2007 06:18 AM
AMoose

I have a SQL Server database. I am using a OleDB Provider. I am getting the following error An unhandled exception of type...

news.microsoft.com

06-16-2007 01:09 PM
William \(Bill\) Vaughn

I am using a SqlConnection on a SQL Server database. How do I use GetSchema() to return the "Primary Keys" and "Foreign Keys" in a database? Bill

news.microsoft.com

06-15-2007 11:22 PM
news.microsoft.com

I have two Table Company and Contacts I build a relationship between the two called...

Charles A. Lackman

06-15-2007 10:12 PM
Charles A. Lackman

Does any body have sample code to create a dbf from ado.net recordset in C# From...

Steve

06-15-2007 10:04 PM
Cor Ligthert [MVP]

hi, I have a 2 command objects and one connection object like following. One command object contains insert statement and other object...

yomur

06-15-2007 04:26 PM
yomur

Currently, I'm investigating various architecture designs which involve maintaining a DataTable object within a background thread. I have...

Jon Pope

06-15-2007 02:14 PM
AMDRIT

Hi, I wanted to sihgnal a named event "EventWaitHandle(...)" from within the CLR stored procedure but Sql Express doesn't allowe it and throws an...

=?Utf-8?B?THVib21pcg==?=

06-15-2007 10:52 AM
=?Utf-8?B?THVib21pcg==?=

Hi Guy, I've found that SqlDataReader.Read() (with do not read value from row) has a problem when reading image data type from Ms SqlServer 2000 if...

=?Utf-8?B?VGhhbmEgTi4=?=

06-14-2007 09:57 PM
=?Utf-8?B?VGhhbmEgTi4=?=

I have a class - I Dim a SQLconnection, then, in Sub New, I instantiate it, so that it's available to me whenever I reference the class...

Elmo Watson

06-14-2007 08:27 PM
Charles Zhang

I'm using typed dataset. The tables in the dataset have been filled from the SQL Server. The error happens when I go to work with a combo box. I...

Lee Gillie

06-14-2007 05:30 PM
Lee Gillie

I have a web application developed in asp.net v1.1; database is sql server 2005. In production envionment, we are receiving the following...

=?Utf-8?B?S2FseWFuIE5pc3RhbGE=?=

06-14-2007 01:55 PM
William \(Bill\) Vaughn

We have this SP that returns about 25,000 rows from a join of 4 tables. These 4 are all tables, and not views, and none of them have calculated...

cmay

06-14-2007 10:41 AM
Mary Chipman [MSFT]

I am recieving the following error message when I call the System.Data.OleDb.OleDbDataAdapter.Fill() method in...

Nathan Sokalski

06-14-2007 10:30 AM
Mary Chipman [MSFT]

Hi Does BindingSource have any information about column which is being edited (i.e. editing editing data in grid)? Thx Shark

shark

06-14-2007 08:00 AM
shark

Hello, I am new to Enterprise Library. I connected with my SQL database, its working fine. When I try to connect with oracle. I got some error...

raju

06-14-2007 03:23 AM
raju

I get an error on the variable @ObjectName. Can anyone suggest what is wrong? _name = _lvi.Text; _type = "T"; _sql = "INSERT INTO...

news.microsoft.com

06-14-2007 02:47 AM
Patrice

Hi SQL Gurus, I have a scenario like following: My DAL is sitting on a BOX with 4 GB RAM and calling the SQL Server BOX via Network (Internal). The...

=?Utf-8?B?U2FjaGluIENoYXZhbg==?=

06-14-2007 12:24 AM
WenYuan Wang [MSFT]

I have a DataTable with approx. 100 fields, some that don't allow nulls. I create a new row, set appropriate values, add the row to the table. So...

=?Utf-8?B?VGhvbWFzIFcuIEJyb3du?=

06-13-2007 04:17 PM
=?Utf-8?B?VGhvbWFzIFcuIEJyb3du?=

Dear all, I ma using a ComandBuilder object in order to build automatically the Update of rows when changes aoccurs in dataset. The sQL comand is a...

=?Utf-8?B?Y2FsZGVyYXJh?=

06-13-2007 02:20 PM
=?Utf-8?B?Y2FsZGVyYXJh?=

Is there any way to connect to and query Excel files that are in XML format? I've not run into these before but now I've got these files that have...

Terry Olsen

06-13-2007 12:48 PM
Terry Olsen

Dear all, I am building a multi tiers application based on .-NET 2.0 and SQL server 2005 WHast is the best way to return data access error from the...

=?Utf-8?B?Y2FsZGVyYXJh?=

06-13-2007 11:03 AM
PlatinumBay

Check it out: www.BrandonsMansion.com

baseballgolfbox@mail.com

06-12-2007 04:25 PM
Bill Yanaire

Hi Dear, Do you know that Norton antivirus is itself a virus..?? it hangs PC more than it cleans.. Try the new Spyware Doctor's Starter Edition...

anusharma99@gmail.com

06-12-2007 01:00 PM
Scott M.

In the middle tier I want to exclude some columns passed on to the client layer. I would like to exclude a specific column from a datamap...

Jonathan Orgel

06-12-2007 12:38 PM
AMDRIT

Am upgrading SQL server access app from 2003 to 2005. Old code works but I can see safer methods: My web.config (ASP.Net...

=?Utf-8?B?RWR3YXJkSA==?=

06-12-2007 09:23 AM
=?Utf-8?B?RWR3YXJkSA==?=

Hi, I am passing my simple dataset to my webservice which accepts dataset as an argument as follows. myservice.webmethod(ds); In my web service I...

=?Utf-8?B?Tmlsa2FudGggRGVzYWk=?=

06-11-2007 11:27 PM
=?Utf-8?B?TWFuaXNoIEJhZm5h?=

SELECT * FROM Actions WHERE NOT EXISTS (SELECT Actions.ActionID FROM Actions, Tracks WHERE Actions.ActionID <> Tracks.ActionID) SELECT * FROM...

BLUE

06-11-2007 09:05 PM
Robbe Morris - MVP C#