To start, I'm using VB 2005 and SQL Server Express 2005. This almost appears to be a bug, but I've yet to find an actual bug and generally narrow my...

Lucas Bussey

08-02-2007 05:35 PM
Jim Rand

I'm using the OLEDB provider against an Access Database. I need to update just one record. Is there any way to do something like this? UPDATE TOP 1 ...

Terry Olsen

08-02-2007 04:57 PM
Terry Olsen

I'm considering using MS .net provider for oracle to connect to an oracle 10g R1 DB. I was reading thru some documents and it seems that an oracle...

maz

08-02-2007 11:59 AM
Jesse Houwing

I have encountered a wiered problem. I am using visual studio 2005, Oracle 8.1 and OracleClient. ADO.NET works fine even for batch statement, but...

=?Utf-8?B?TiBT?=

08-02-2007 09:08 AM
=?Utf-8?B?TiBT?=

Hi, I've noticed that if I change my connectionstring in the app.config file, this isn't enough, a second change in the Global.System.Configuration...

=?Utf-8?B?THVj?=

08-02-2007 07:40 AM
Saulo J. S. Machado

Hi, I'm very impress with .net 2.0 which Dataset already combine with Adapter, so I can do like "Dataset.DataTable.GetData()" in order to get and...

=?Utf-8?B?TWFydGluIEFkaGll?=

08-02-2007 03:30 AM
=?Utf-8?B?TWFydGluIEFkaGll?=

I have the following tag in one of my DataList's ItemTemplates: <asp:ImageButton ID="btnViewQuestion" runat="server"...

Nathan Sokalski

08-01-2007 12:44 PM
Teemu Keiski

When I use a DataAdapter and call its Fill method to populate data into a DataTable, most of the DataTable's schema information is missing: all...

\(O\)enone

08-01-2007 06:49 AM
\(O\)enone

Hi, I'm creating a typed dataset based off of a SQL Server 2005 DB. There are 2 fields from one table that I'd like to bind to on an ASP.NET...

=?Utf-8?B?YmVuamk=?=

07-31-2007 04:02 PM
Sheng Jiang[MVP]

Hi, We have bunch of DataObejcts/BusinessObjects those used against database. Now we fetch some data from database into a dataset. How can we...

jzdeng@gmail.com

07-31-2007 02:40 PM
Morten Wennevik [C# MVP]

I'm working with the new Beta 2 of VS2008 and LINQ is really great but i'm searching for an opposite construct of the SubmitChanges() method to...

=?Utf-8?B?UmFsZiBFaGxlcnQ=?=

07-31-2007 01:58 PM
=?Utf-8?B?UmFsZiBFaGxlcnQ=?=

Is there any way to select a record and update a field in that record in the same statement? I have a table that several threads will be querying....

Terry Olsen

07-31-2007 09:48 AM
Petar Atanasov

Hi; One of our testers is getting this now - and he is not running under a debugger. The error is: Exception(s):DataSourceException: executeQuery...

=?Utf-8?B?RGF2aWQgVGhpZWxlbg==?=

07-31-2007 09:46 AM
=?Utf-8?B?RGF2aWQgVGhpZWxlbg==?=

I have a query that looks up the highest value for column a and then returns column a and column b. It uses a nested select in the from clause. I...

cptkirkh

07-31-2007 04:43 AM
glennanthonyb

SQLServer2005, VS2005, C#. I have a stored procedure that returns a SCOPE_IDENTITY after doing an insert. Here's the pertinent part of the...

RobinS

07-30-2007 07:09 PM
Mary Chipman [MSFT]

Hello, When writing a text to a SQL database nvarchar(6) field, I get following error when the size of the input is larger than the available...

Michel Vanderbeke

07-30-2007 04:47 PM
Michel Vanderbeke

Hi There, What's the better way to follow when we use sql string sql = "Inset into table(f1,f2) values (@f1, @f2)"; then add and passing parameters...

Ganesh

07-30-2007 11:05 AM
William Vaughn

Hi; The class OracleConnection is part of .NET and so is always available. However, it does not work if the Oracle client software is not installed...

David Thielen

07-30-2007 06:52 AM
=?Utf-8?B?TWFuaXNoIEJhZm5h?=

I have a DataRow in a DataTable. I want to know if there is a value. I do this if ( this.Rows == null ) { throw new Exception ( "no" ); } However...

lucius

07-30-2007 06:17 AM
WenYuan Wang [MSFT]

I have a DataTable with one row and I did a Merge() from another DataTable and now I have two rows. How can I get the rows to be a single row...

lucius

07-30-2007 06:10 AM
WenYuan Wang [MSFT]

Hi, MS have exposed the functionality to use custom data providers in Visual Studio 2005, I've used this and it works fine. I would like to know if...

bryars@hotmail.com

07-30-2007 05:45 AM
bryars@hotmail.com

If I delete rows in a DataTable and then do a DataSet.AcceptChanges, and then pass that DataSet to the client, will the client have any idea of...

Ronald S. Cook

07-28-2007 03:06 AM
Miha Markic

Is there a way I can compare two DataSets to see if they are identical? Thanks, Ron

Ronald S. Cook

07-28-2007 03:02 AM
Miha Markic

On Fri, 27 Jul 2007 19:00:56 +0200, Heinrich Moser <usenet (AT) heinzi (DOT) at> wrote: I see, the obvious solution to your problem is specifying...

Morten Wennevik [C# MVP]

07-27-2007 12:32 PM
Morten Wennevik [C# MVP]

When I have a timeout on invoking a stored procedure against SQL Server, I have an exception returned that looks like the...

n.phelge

07-27-2007 10:40 AM
Aaron Bertrand [SQL Server MVP]

Hi, How to search the user (or users) associate to computer by ldap. thanks -- Jean-Yves BURLOT SI - EVEN Lait

Jyb

07-27-2007 09:50 AM
Jyb

I am having an issue with getting my ds to update my db. I am pulling info from the NW db on my Default.aspx page. I then click the edit btn and...

=?Utf-8?B?U3R1cGlkMQ==?=

07-27-2007 07:44 AM
=?Utf-8?B?U3R1cGlkMQ==?=

I have a GridView which is bound to a table. The user has the ability to change some defaults and then run a process from this. This all worked...

=?Utf-8?B?R2VyaGFyZA==?=

07-27-2007 06:06 AM
WenYuan Wang [MSFT]

Hi, In Strongly typed datasets, when we preview a table adapter query, we cannot preview a stored procedure query that has GUID parameter. The...

Max2006

07-27-2007 03:14 AM
WenYuan Wang [MSFT]

With a .Net 2's WinForms which contain 1) a DataGrid which is assigned to a DataSet's DataTable (some columns are "hidden" on screen) 2) a few...

=?Utf-8?B?UGF0cmljaw==?=

07-27-2007 02:49 AM
Morten Wennevik [C# MVP]

Hi, Does TransactionScope need DTC in situations that the transaction is not distributed? I have a set of non-distributed transactions and I am not...

Max2006

07-27-2007 02:02 AM
WenYuan Wang [MSFT]

Our project is using the System.Transactions.TransactionScope class to provide an ambient transaction which our DAL classes can leverage. I'm...

=?Utf-8?B?Y2xydWRvbHBoaQ==?=

07-26-2007 10:32 AM
Mary Chipman [MSFT]

Maybe a stupid one,...... is it still usefull to make indexes on the SQL server since in ADO.NET we work with complete datasets which contain...

=?Utf-8?B?THVj?=

07-26-2007 09:46 AM
Miha Markic

Hi I'm not sure whether I've given this post the correct title, but I'm a bit unsure of where to put it. I have a database that holds information...

steve.a.bennett@gmail.com

07-26-2007 05:15 AM
steve.a.bennett@gmail.com

I use .Net 2.0 and connect to a database access, on the connection.open() I've this message "The type initializer...

Wavounet

07-26-2007 02:39 AM
atharvainfo@gmail.com

Hi, I am populating a dataset from a stored procedure, which returns multiple resultsets. One of the resultset is formed with a join condition from...

Manohar

07-25-2007 12:56 PM
Manohar

Hello, is there a possibility to get the ID of the last created or modified dataset of a table via ADO.NET? Is there a database independent way? In...

thalion77@graffiti.net

07-25-2007 10:34 AM
=?Utf-8?B?S2VycnkgTW9vcm1hbg==?=

Hi I have an excel workbook with 4 worksheets. When I connect to this workbook using an Oledb connection, I use GetOleDbTableSchema to retrieve the...

=?Utf-8?B?R3Jpbm5pbmcgQ3Jvdw==?=

07-25-2007 07:14 AM
=?Utf-8?B?R3Jpbm5pbmcgQ3Jvdw==?=

Hello there, I want to write a function returning the primary key name of a certain table. The following function successfully returns the names of...

thalion77@graffiti.net

07-25-2007 04:30 AM
thalion77@graffiti.net

I'm new to .net. It seems that those application blocks in Enterprise Library are very useful especially when one tries to build a new...

=?Utf-8?B?UGV0ZXI=?=

07-25-2007 03:06 AM
Jun Junrex

Hello, In order to avoid errors, I have all my DataReader-fields converted with a ..ToString. This in case some record could have Null-fields and an...

Michel Vanderbeke

07-24-2007 10:51 AM
William Vaughn

Hi guys, could you please help me on my problem. Table1: Tbl_Employee Field1: Emp_name Field2: Position Field3: Contact# Field4: Address

mroks via DotNetMonster.com

07-24-2007 01:28 AM
shatrughna

I'm working heavily with query notifications in SQL Server 2005 and I'm now getting the following...

=?Utf-8?B?U2VlbiAiVGhlIEJlYW4i?=

07-23-2007 06:50 PM
=?Utf-8?B?U2VlbiAiVGhlIEJlYW4i?=

I'm working heavily with query notifications in SQL Server 2005 and I get the following exception: System.Collections.Generic.KeyNotFoundException:...

Seen The Bean

07-23-2007 06:41 PM
Seen The Bean

Hello, How can I use an ExecuteNonQuery within the loop of a datareader? My code is as follows: Dim cmdToProcess As New SqlClient.SqlCommand Dim...

=?Utf-8?B?TWljaGVs?=

07-23-2007 04:56 PM
Brandon Gano

Hello, When I have closed my appliciation in VB.NET, and I try to detach my database from SQL SERVER, I often get a message that the database cannot...

=?Utf-8?B?TWljaGVs?=

07-23-2007 01:08 PM
Patrice

When I run the following code everything works fine (which proves the stored procedure and the parameter: Dim cmdSQL As New...

DesCF

07-23-2007 08:05 AM
Miha Markic

Hi All, I have been failing to delete a row from dataGridView. I use typed dataset. Here is my code, please advice what wrong is here? private void...

alexl

07-23-2007 08:02 AM
alexl

Hello there, what is the best way to add an dataset and, then, to read out the ID value of the created dataset? ExecuteNonQuery() does not retrieve...

thalion77@graffiti.net

07-23-2007 04:19 AM
thalion77@graffiti.net

i am looking for code sampe in aso.net 2 for encrypt/decrypt of paswr d withought using any external DLL (judt to use existing net2 tools) thnaks i...

=?Utf-8?B?cGVsZWdrMQ==?=

07-21-2007 12:54 PM
=?Utf-8?B?QnJhdWxpbyBEaWV6?=