Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score Error using money datatype parameter and DBNull.
Jeff Mason - 3 Mar 2007 6:52 PM - 1 message
Hi, Hi, I am getting an error executing a SQL Server stored procedure with parameters of type money. The following code fails:    With cmd       ...       If mActualCost = Decimal.MinValue Then ...
Score Column does not allow nulls when saving
John - 3 Mar 2007 6:05 PM - 6 messages
Hi I have a vb.net winform data app with sql server 2005 backend. The ID field in the tblClients table is an 'int' identity column that does not allow nulls. The problem is that when I try to save the record using the below ...
Score GetOrdinal problem
Dandle - 2 Mar 2007 4:49 PM - 3 messages
Hi, Sorry for the cross post first of all.  I posted to the ADO forum the first time by accident. I wrote a windows service in c# .net 2.0.  There is a timer that fires every second or so and when it does I start two threads (unless they are ...
Score Getting out of memory when DataSet.GetXml()
OverTheTop - 2 Mar 2007 3:08 PM - 10 messages
When the dataset is too large it thows OutOfMemory Exception although that there is enough momory on the web server, is this a bug in .net or something must be configured?! The Dataset contains near 50 000 rows. How can I escape this. Please help? ...
Score Weird problem inserting image in DB...
Pablo Alvarez Doval - 2 Mar 2007 2:26 PM - 4 messages
Hi all,     I'm experiencing quite a weird problem inserting an image in a database. I've designed a small form with some fields and a picturebox. I can fill all of them and clcik the 'create item' button, and the task is performed ...
Score Using TransactionScope and connection pool
deja - 2 Mar 2007 2:07 PM - 5 messages
hi, I am trying to use TransactionScope and multiple async calls but get Transaction aborted - transaction in doubt errors. My program goes like this using (TransactionScope ts = new TransactionScope()) {    do an insert on Table1 (Connection1 = new SqlConnection)     foreach table to read from aList ...
Score Reload dataset in DataError event handler
koen.roos - 2 Mar 2007 2:00 PM - 1 message
Hi, I have a bound DataGridView, and I handle the DataError event like this: ShowMessageBox(); mhdsHospitalDataSet.MhdsHospital.RejectChanges(); mhdsHospitalTableAdapter.Fill(mhdsHospitalDataSet.MhdsHospital); In other words: I show a message box, then I reject the changes made on the DataSet, and then i refill the dataset. ...
Score Typed Dataset. Filtering/Selecting
Allan Bredahl - 2 Mar 2007 8:02 AM - 2 messages
Hi all I'm in the process of making a system to integrate a webshop with an erp system. All exports from the erp are XML based, and when I needed a test application the obvious choice for me was to use XSD generated from the XML ...
Score c# and data navigator
Chris - 2 Mar 2007 2:17 AM - 5 messages
I have an access database dataset which a draggedonto a form which also put the data navigator on the form. The problem is that when I ADD a new record witht he add button, it gives me a primarykey that has already been used and ...
Score Master/Child Binding not working
Flomo Togba Kwele - 2 Mar 2007 2:06 AM - 5 messages
I have created a dataset containing master/detail tables and used it as a datasource for a master BindingSource. I created another BindingSource for the detail table - its datasource is the master BindingSource and its DataMember is the relationship between the 2 tables. ...
Score 'The transaction has aborted.'
Paraclete - 1 Mar 2007 7:13 PM - 1 message
Hi All, I have some code that is using ADO.NET 2.0 and TableAdapters. The code is pretty simple and I occassionally get an exception i.e. 'The transaction has aborted.'. The number of tables are actually 4 and 2 of wchich are being updated and ...
Score DB2 Connection Issue
JimHeavey - 1 Mar 2007 2:56 PM - 3 messages
I can connect to one db2 database through my application just fine.  But when I attempt to connect to another database in another application, I am getting errors.  When I create the connection object, I see the following on the ...
Score Need Help regarding Authentication Violation.
Mani - 1 Mar 2007 12:48 PM - 3 messages
Hi Using ado.net i am trying to connect Sybase[SqlAnywhere-9]. The problem is i am able to retreive data from the tables , but while inserting i am getting exception as "Authentication Violation".The database is local and i am using ...
Score Mater/Detail Form
IDM - 1 Mar 2007 9:42 AM - 1 message
Hi, I wants to create a Mater/Detail Form in VB.NET 2005. Can any one direct me to a good tutorial I went through [link] but it is not straight forward ...
Score Mater/Detail Form
IDM - 1 Mar 2007 9:42 AM - 2 messages
Hi, I wants to create a Mater/Detail Form in VB.NET 2005. Can any one direct me to a good tutorial I went through [link] but it is not straight forward ...
Score Help Requried on Connection Pooling [Urgent]
Mani - 1 Mar 2007 6:24 AM - 6 messages
Hi , i have a requriment where i need to perform connection pooling through c#.net code .My database is Sybase. Can any one forward me link or suggest me on how to start to write code for this. Regards Mani. ...
Score Async Connection timed out
apiringmvp - 1 Mar 2007 4:00 AM - 1 message
After reading Jeff Prosise article Scalable Apps with Asynchronous Programming in ASP.NET ([link] WickedCode/default.aspx) in MSDN Magazine I was inspired to upgrade my website to use async database calls.  Everything is working from the ...
Score Async Connection timed out
apiringmvp - 1 Mar 2007 3:34 AM - 1 message
After reading Jeff Prosise article <a href="[link] msdnmag/issues/07/03/WickedCode/default.aspx">Scalable Apps with Asynchronous Programming in ASP.NET</a> in MSDN Magazine I was inspired to upgrade my website to use async database calls. ...
Score Europe Tests Established Chemicals on Millions of Animals
TONY-GAL - 1 Mar 2007 1:37 AM - 1 message
Tony Nottingham England 28 February 2007 TO: All People Who Care A   new   European   Chemical   Testing    Policy    called REACH  has  now   been   finalised   by    the   European ...
Score How to get the unchanged row of a changed row - ado.net 2.0
Rolf Welskes - 28 Feb 2007 3:42 PM - 5 messages
Hello, I have the following problem: I have a table and in this I have rows say: Name, PreName, street. as fields. Now a have a row for example: Smith, John, new street 5 . Now I make a change to this row to: ...
Score Synclock in IIS Hosted Remoting - Single Threading Function Call?
Spam Catcher - 28 Feb 2007 4:03 AM - 2 messages
Hi all, I'm hosting a remoting service in IIS. I have a function which I only want one concurrent access at a time. Will this prevent multiple users from accessing the function at a paritcular time? 'Empty object used for sync locking purposes ...
Score SqlCommand.Cancel and Transactions
draggin dragon - 28 Feb 2007 2:50 AM - 6 messages
I have a Data Access Layer that clients use to interact with the database.  The layer takes in a SqlConnection and optionally a SqlTransaction.  Clients are responsible for the upkeep of the connection/transaction. The layer allows clients to limit the # of records (maxsize) ...
Score Oracle database demands SELECT "column1" FROM "table" syntax
Torgeir - 27 Feb 2007 11:32 PM - 2 messages
Hi I have a problem with the syntax of the SQL commands I use with the Oracle 10g Express database (from an asp.net 2.0 application using system.data.oracleclient). The database wants the queries formulated as in this example: ...
Score How do I ignore time zone differences?
Harry Keck - 27 Feb 2007 9:07 PM - 3 messages
I call a web service that returns a dataset with date infomation.  I then store that information in a local database.  The web server and the machine I am calling it from are on different time zones.  All of the times that I save ...
Score Reference for Columns returned by GetSchema for Sql Server
pmayer995 - 27 Feb 2007 8:23 PM - 4 messages
Hello, The problem with GetSchema is that the columns vary by provider. In fact, I can't even find a spec for the columns returned for Sql Server! I don't know why Microsoft didn't even see fit to provide such ...
Score C# - Binding Navigator
Chris - 27 Feb 2007 6:24 PM - 2 messages
1. Where would I find the code where the delete action takes place?  C# automatically placed this binding navigator on my form and I see no code for where it deletes a record. I want to add a messagebox to confirm before allowign the delete. ...
Score Data adapter.Update with fields that are part of the update condit
Roger Tranchez - 27 Feb 2007 6:13 PM - 4 messages
Hello, I'm trying to update some records of a database table called "PETICIONS_TRESORERIA" with this structure: codi                   int data_peticio        datetime ...
Score Joining tables from two databases
T McDonald - 27 Feb 2007 3:26 PM - 6 messages
I am having trouble figuring out how I might do the following, if I can do it at all. I have two databases, each with their own separate authentication details. I have a select statement that gets the data from one table based on ...
Score Need Expert Help and Advice. Thank You.
shapper - 27 Feb 2007 1:36 PM - 5 messages
Hello, Consider I have a String: Dim MyString As String = "Hello" or an Integer: Dim MyInteger As Integer = 100 or a class which its properties: Dim MyClass As New MyCustomClass MyClass.Property1 = "Hello" MyClass.Property2 = Unit.Pixel(100) MyClass.Property3 = 100 ...
Score How to add date in access database
Tony - 27 Feb 2007 1:30 PM - 5 messages
I am trying this: SQL = "INSERT INTO GradeList (Date) Values(#01-01-2007#)" I get message "Syntax error in Insert statement". How to add date field in access database? ...
Score query question
musosdev - 27 Feb 2007 11:09 AM - 9 messages
Hi all, Is there a simpler/faster way of performing the following query with AccessDataSource against an .MDB file? SELECT StoryID, StoryTitle FROM Stories WHERE ((SoryTitle LIKE '0%') OR (SoryTitle LIKE '1%') OR (SoryTitle LIKE '2%') OR(SoryTitle LIKE '3%') OR (SoryTitle LIKE '4%') OR (SoryTitle LIKE ...
Score autocomplete textbox like google
nil - 27 Feb 2007 9:33 AM - 4 messages
Hello all, It's urgent... i want to add autocomplete textbox facility in my application like google. as you type it suggests option to the user..i want the same kind of facility...i know i can do only with ajax(xml and javascript) ...
Score Using UpdateDataSet from Enterprise Library January 2006
H - 26 Feb 2007 10:16 PM - 3 messages
I call a function with a CustomerID and it returns a dataset of two tables (Customers, Orders). If the ID does not exist in Customers, it returns empty tables. I also set a relationship on CustomerID between the tables, as well as ...
Score Timeout with SQLExpress
Earl - 26 Feb 2007 3:53 PM - 3 messages
After I run the debugger awhile on the same app (change, run, change, run, etc. ad nauseaum), I start getting timeout errors on connection. I'm speculating that the connection pool is being used up at some point. I am ...
Score Oracle Error Invalid character
Oldman - 26 Feb 2007 2:45 PM - 4 messages
I am setting the command object text of an OracleCommand to "Select FNGETDBVER() FROM DUAL;" I am attempting to retrieve the result of this function.  However, when I call ExecuteScalar on this I get an invalid character error: "ORA-00911: ...
Score quetion about identity, dataadapter
Felix González - 26 Feb 2007 9:55 AM - 2 messages
Hi I´ve 2 tables (order and order details), In my application I´ve 2 Datatable with 2 dataadapter. The primary key of table orders it´s and Identity the table details has foreign key with the identity of orders. How can insert in ...
Score Why aren't data types in SqlParameters validated?
Jerad Rose - 26 Feb 2007 7:17 AM - 5 messages
I believe this question is simple enough -- why aren't data types in SqlParameters validated in ADO.NET? For example, why is an exception *not* thrown on this line: cmd.Parameters.Add(New SqlParameter("@Id", Data.SqlDbType.Int)).Value = "not ...
Score VS2003 versus VS2005 data adapters: Auto-generated update commands generate parameter errors?
DDon - 26 Feb 2007 5:30 AM - 8 messages
Gents, Been using 2003 for 4 years, and have several large Windows Forms based project that I need to continue to develop with VS2005.  I have imported one of these projects, fixed some newly detected errors, and it appears to work ...
Score Re: Finalizing edits in DataSet when using Bound controls
Digital Slug - 25 Feb 2007 11:11 PM - 1 message
Agreed. This thread is very helpful. ...
Score Strange concurrency error
John - 25 Feb 2007 8:44 PM - 2 messages
Hi I have a perfectly working vs 2003 winform data app. All the data access code has been generated using the data adapter wizard and then pasted into the app. I had to add a new field in the backend access db which I did. I then ...
Score DataRelations and grids
Claws - 25 Feb 2007 10:47 AM - 3 messages
Hi everyone. I have a very simple problem, that I seem to not being able to solve! Assume I have two simple tables Car, and Store, looking like this: Car ------- car_id make Store ------- car_id numberofcars and I want to show, and update the data in the Store table. I can ...
Score DataRelations and grids
Claws - 25 Feb 2007 10:47 AM - 1 message
Hi everyone. I have a very simple problem, that I seem to not being able to solve! Assume I have two simple tables Car, and Store, looking like this: Car ------- car_id make Store ------- car_id numberofcars and I want to show, and update the data in the Store table. I can ...
Score How to cancel deleting a row in an event
Hamed - 25 Feb 2007 8:22 AM - 8 messages
Hello I need an event to be able to cancel a delete request to a DataRow object in some conditions. It seems DataRowDeleting should be able to do the job but setting e.Action is impossible (it is read-only) ...
Score VS 2003, false data concurrency error
John - 25 Feb 2007 1:55 AM - 4 messages
Hi I have a vs 2003 winform data app. All the data access code has been generated using the data adapter wizard and then pasted into the app. The problem I have is that I am getting a data concurrency error on ...
Next »