Developer Newsgroups: ADO.NET

TransactionScope Questions

Rick - 20 Jan 2007 7:05 PM - 2 messages

Hi! I have a couple of questions about TransactionScope... What exactly is the scope of a transaction? Is it only connections that are created in the actual code block where the TransactionScope is defined, or is it all connections created on the same thread as the TransactionScope? ...

Gridview deletion problem

Flomo Togba Kwele - 18 Jan 2007 4:59 PM - 6 messages

I created a form, a datasource (Product table from AdventureWorks) from the Data Sources tab, and dragged the Product table from the Data Source tab to the form's designer surface. This created a dataset, bindingsource, tableadapter and bindingnavigator. I placed the following code in the click event of the delete button on ...

Column <ColumnName> does not belong to table <TableName>

cori - 17 Jan 2007 3:54 PM - 12 messages

Hello all; We're using ADO.Net on a classic ASP site that's using a .Net dll for backend data manipulation. Every so often we receive an error in the pattern in the subject line, where the column name and table name change depending on ...

Problem running query in code

John - 15 Jan 2007 8:19 PM - 7 messages

Hi I am using the below code to run a sql on an underlying access table; insStr = "INSERT INTO [Web Site Action Queue] ( Action, [Client ID], [Operator], Request_Date ) " & _ "VALUES (""Modify Client"", 93, ""Administrator"", Now())" Dim insCmd As New OleDbCommand(insStr, dbConContacts) ...

DataAdapter Fill Method Query

landers - 15 Jan 2007 8:12 PM - 3 messages

Hi All, I have a SQL Server stored procedure that return the results of two select statements e.g. SELECT * FROM first_table SELECT * FROM second_table The first_table has lots and lots of rows, so I only want to return the ...

Dataset.Merge ..... Accepts changes

Evan Camilleri - 15 Jan 2007 7:32 PM - 1 message

I am trying to use Dataset.Merge BUT the new dataset has its state according to the source dataset. I would like that state in the new dataset is amended or added according to if it is amended or added in the new dataset!!! ...

Enterprise library

BrandÃ£o - 15 Jan 2007 6:20 PM - 1 message

Hi, I'm using the DLL â€œEnterprise Libraryâ€ version 2.0 for access data in my system that I am developing in C# 2.0 and SQL 2005. Although to follow the scratch an example that I caught in â€œhand-on labsâ€ when step for the code ...

Resource limitation

JimHeavey - 15 Jan 2007 4:37 PM - 2 messages

I have written a program which looping through a bunch of records and then reads a particular row on a DB2 table. When the 1326 record is processed, I get a DB2 error when I attempt to get a Data Reader Object. The error ...

DefaultValue vs. NoNullAllowedException

Bragadiru - 15 Jan 2007 2:40 PM - 1 message

Hi, I defined in my Sql Server db a table with 2 int columns that don't allow null values + their default values are set to 0. I'm using a DataAdapter to read data, but it doesn't bring the default ...

SQL Connection An existing connection was forcibly closed by the r

Martin - 15 Jan 2007 10:27 AM - 2 messages

Hi I keep seeing this exception in my logs Sql client Connection -An existing connection was forcibly closed by the remote host. What is this a bug - how do you trap this exception and get ado to open a ...

newbie really needs help with ado.net access [C# 05]

giddy - 15 Jan 2007 9:12 AM - 1 message

Hi , Im a selftaught C# programmer. I have a hotel management project to do, and i'm stuck! In One of my classes, called data! =S , from my project i initilize vars like this: public Data(string databaseURL , string xmlURL) ...

vs2003 to vs2005

John - 14 Jan 2007 8:33 PM - 3 messages

Hi I have a vb.net 2003 database winform app which uses non-bound controls and the associated plumbing is done in code. If I move it to vs 2005 would it work without any change? Thanks Regards ...

VS 2005 SP1

John - 14 Jan 2007 6:53 PM - 3 messages

Hi I am almost finished with a vs 2005 (pre sp1) project which I need to deliver in the next couple of days. I am wondering if I should deliver project with sp1. Is it safe to install sp1 at this late stage? ...

Review and contribute to my site

chrisplanters@gmail.com - 14 Jan 2007 2:01 PM - 1 message

Hi all I have set up a forum site..[link] This is in initial state and I would like you people to contribute to it. Also I would like you to give suggestions on how can I improve it ...

How to add a new row to typed datatable.

ad - 14 Jan 2007 5:32 AM - 2 messages

I am using the datatable adapter of VS2005. How can I add a new row to a typed datatable? ...