Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score Noob Question, please help
rocha1573 - 14 Oct 2006 2:12 AM - 2 messages
I want to create a form with basically 2 boxes and 4 navigation buttons, First, Last, Next and Previous.  Now, I am trying to do it like this: For the Previous Button for example, on click event: If bindingcontext(dataset,"tablename").position > 0 then ...
Score Printing PPage Breaks in an aspx page
RML - 13 Oct 2006 9:04 PM - 1 message
Hi, I have benn attempting to print page breaks in my aspx page with no success.  My page has 2 tables, and I have tried inserting the following HTML between them: <div style="PAGE-BREAK-AFTER: always"></div> ...
Score DataTable ConstraintException problem/debugging VB - VS 2005
Brice Cave - 13 Oct 2006 6:15 PM - 2 messages
I am loading a Typed Dataset using another dataset via each table's Load() Method and getting a ConstraintException on one of the tables. Disabling the constraints before the load and Enabling constraints after the load produces the same error. ...
Score Getting Currency Manager takes a long time
Joe - 13 Oct 2006 4:53 PM - 9 messages
Why does BindingContext[dataSource, dataMemeber] as CurrencyManager take 40 seconds to return? The dataSource which is a DataTable has 500k rows. I'm using .NET 2.0 and have 2gigs of ram and dual 3.GHz Xeons Thanks for any help, ...
Score Quickest way to update a DataColumns values?
Joe - 13 Oct 2006 4:12 PM - 5 messages
I have to update 500k rows in a DataTable for a single column. Is there any quicker way to do this other than looping through the rows and doing row[col] = val; ? -Joe ...
Score ado.net to .csv format
TBoon - 13 Oct 2006 2:08 PM - 2 messages
Hi there, What's the best way to convert ADO.Net recordset/dataset to .csv file? regards, Boon ...
Score SQL connection error in ASP.NET only (WinForms ok)
pearcz - 13 Oct 2006 10:01 AM - 1 message
Hallo, I have this perplexing problem. On my development machine, sql connections in ASP.NET pages debugged in both Visual Studio 2003 (ASP.NET 1.1.) and Visual Studio 2005 (ASP.NET 2.0.) stopped working. I suspect the cause is one ...
Score AcceptChanges() is very slow
weishng - 13 Oct 2006 4:07 AM - 12 messages
Dear helpers, I have a ADO.NET table which has about 4 columns and less than 5000 rows. table.Fill(...) // modify table DataTable changedTable = table.GetChanges(); // if there are any changes, update the database if (changedTable != null) {      rowsAffected = adapter.Update(changedTable); ...
Score Connection String Problem
Randy - 12 Oct 2006 7:49 PM - 7 messages
Hi, I am trying to connect to a MS SQL Sever 2005 via an IP address and I am having problems.  I have setup MS SQL Server to accept remote connections. Here is the connection string: "Data Source=198.118.0.149,1433;Network Library=DBMSSOCN;Initial ...
Score SqlClient vs. OleDb MissingSchemaAction performance
erpo kekkuli - 12 Oct 2006 7:00 PM - 1 message
Hi! I'm using DataAdapter to fill datasets, and querying database views with MissingSchemaAction.AddWithKey option, it's about 50 times slower with SqlClient than with OleDb! I know it's propably not wise to fetch the schema for views, but in this case i must do so. ...
Score New Sceppa ADO.Net 2.0 book
Earl - 12 Oct 2006 5:27 PM - 4 messages
I have this new book and have learned much from it but just realized that the page numbering is wacky (goes from page 1 up to 106 then starts over at 75, counts back up to 106 then jumps to 139). Does anyone else have this ...
Score VB.Net 'Caught Exception' error re-occuring
anthony - 12 Oct 2006 4:48 PM - 3 messages
New to vb.net! What's the best way to handle this scenario: I have a vb.net app (SQL Server DB). When 2 or more users are running the app simultaneously, I recently keep getting: 'Caught Exception': The statement has been terminated'. Violation of Primary Key ...
Score Generating SqlServer db out of DataSet
Edgile - 12 Oct 2006 11:30 AM - 2 messages
Hi, I have a XSD schema from which I generate a DataSet and then I need a db as well to persist the content. As the schema is still not finished, I do not want to synch the db and the schema all the time manually, so I wonder if ...
Score LoadDataRow + OutOfMemoryException
hangar18 - 12 Oct 2006 3:00 AM - 2 messages
Hi, I'm looping through some folders and files and adding them to a datatable. This gives me the following OutOfMemoryException at times. Error Exception of type 'System.OutOfMemoryException' was thrown. ----------- Error    at System.Data.RBTree`1.TreePage..ctor(Int32 size) ...
Score DataBindings and Custom Control
TigerMan - 12 Oct 2006 1:57 AM - 1 message
Hi, I have a custom control based on a TextBox and have my own property called 'ValidateText' I can add DataBindings easily to it at runtime but is there a way to do it at design time when I drag a table from a Typed DataSet so it ...
Score Duplicate a record in a typed data set
Michael D. Reed - 12 Oct 2006 12:20 AM - 3 messages
I have a typed data set, with two tables.  This is an in memory data set, that is there is no underlying database.  I would like to duplicate a record in one of the tables and append this record back to the same table.  The idea ...
Score Duplicate a record an in memor typed data set
Michael D. Reed - 12 Oct 2006 12:19 AM - 1 message
I have a typed data set, with two tables.  This is an in memory data set, that is there is no underlying database.  I would like to duplicate a record in one of the tables and append this record back to the same table.  The idea ...
Score Data-Based User Controls
Jonathan Wood - 11 Oct 2006 6:41 PM - 2 messages
I'm new to C# and ASP.NET, and wondered if anyone could give me some pointers on this. I want a serious of boxes on the left side of my master page. Each box will display a graphic image followed by any number of links. Each box needs to ...
Score Error: Cannot have more than one SimpleContent columns in a DataTable.
dlgarrett_98 - 11 Oct 2006 4:49 PM - 1 message
Error: Cannot have more than one SimpleContent columns in a DataTable. I have a small XML document which I want to convert to a Net20 DataSet. I use the .Net xsd tool to do this, and it works fine.  I can load the ...
Score get @RETURN_VALUE after calling MyTableAdapter.Update(...)
google@easiesttoremember.com - 11 Oct 2006 2:39 PM - 2 messages
The subject pretty much says it all.  I've got a TableAdapter that calles a stored procedure for its InsertCommand and the stored procedure returns an integer into @RETURN_VALUE.  I can't figure out either of the following: ...
Score Enterprise Library DeriveParams with Multiple Owner Schemas SQL 2k
Wangkhar - 11 Oct 2006 11:25 AM - 1 message
Hi I am having some issues with the above. Apologies if this is the wrong forum, perhaps someone will point me to the correct one. Basically the issue is this: (using SQL Server 2k sp4, EnterpriseLibrary). Create procedure dbo.TestProc @param1 int, @param2 int ...
Score OraClient and .NET Managed PRovider usage from within Service
Joerg Fischer - 11 Oct 2006 10:50 AM - 3 messages
Hi there, Currently, I am facing the following issue: We are using the Oracle Client from within our software, which runs under a service account. Now, everything works fine as long as the service account has local administrator privileges which is not fearsible. When I remove ...
Score udate 1 row by 1 row using dataset or datatable - is it possible
Senthilkumar - 11 Oct 2006 8:13 AM - 1 message
Hi to All, I have a question : I have a dataset which is holding binary data in the rows. i copy the dataset to another dataset and then try to update the dataadapter, but it fails because of the binary fields( only few rows are ...
Score Merging untyped datasets
Earl - 10 Oct 2006 8:38 PM - 2 messages
I'm using a data access layer that creates untyped datasets and then merging those with the frontend typed datasets. Sometimes I get no rows when I know there should be a value. I have the option of changing the untyped datasets ...
Score Pooling Counters in Perfmon
CGW - 10 Oct 2006 3:33 PM - 2 messages
Our web app is throwing errors that appear to be associated with connection pooling. I found the tab in the ODBC manager to turn on perfom counters and I added the counters on both the web and SQL servers. However, they aren't incrementing... absolutely nothing is ...
Score RE: Intermittent IndexOutOfRangeException - SqlDataReader
Jodin - 10 Oct 2006 2:56 PM - 1 message
I have the same problem with an application running in a dual server requesting to the same DB, I do not know if it is part of the problem, but when we debug the application on our workstations, it works just fine, but when we put it in production, we get those errors at random, I can't seem to find a pattern to reproduce it. ...
Score Visual studio 2003, crystal reports, ADO from project. Losing datasets/field view
Chukkalove - 10 Oct 2006 1:16 PM - 1 message
My crystal report is being generated from an ADO DataSet file that I create before I create the report itself. The dataset is added to the same project as the crystal report. When i start to design the report, I have access to the Field View explorer ...
Score Dataset updates fewer rows for Binary(blob) fields
Senthilkumar - 10 Oct 2006 11:12 AM - 1 message
Hi, An application uses Mimer database. There are a few tables which uses Binary data. Due to the use of binary fields, the database size grows very large quickly. I am trying to write an application where in we can sort of archive ...
Score "Invalid cast from 'Int32' to 'DateTime'."
Sharat Koya - 10 Oct 2006 9:51 AM - 2 messages
Hi I have a Visual Studio .NET Generated DataSet from SQL servers using the wizard. I have a particular table with the column that stores when the row in the table was last updated. I then have the following code... ...
Score Change Connection String at runtime.
david.leedom - 10 Oct 2006 4:38 AM - 7 messages
I am at my witts end, which is not saying very much.... I am building a commerical VB.NET applicaiton.  The assumptions are: *The Server IP number is different for every deployment. *Possibly the database engine is different for every deployment (SQL ...
Score Connectiing to SQL 2005 from ASP Pages
Fred Chateau - 10 Oct 2006 3:34 AM - 6 messages
I am having difficulty connecting to SQL 2005 Express from ASP Pages. My Web site is a mix of data driven ASP.NET 2.0 pages and some complicated ASP pages which I have not had time to migrate. I recently copied all the my ...
Score Is this a bug in the data adapter wizard?
Alan Pretre - 9 Oct 2006 9:28 PM - 6 messages
In VS 2003 when I use the Configure Data Adapter option in VS 2003 I get the size parameter to the SqlParameter set to the correct size for a varchar, for example, .... new System.Data.SqlClient.SqlParameter("@SWA_SO_TYPE", System.Data.SqlDbType.VarChar, 256, "SWA_SO_TYPE"), ...
Score BindingSource positioning
Earl - 9 Oct 2006 5:23 PM - 4 messages
I've probably asked the wrong question down below, as the issue is with the datasource rather than the datagridview. What I'd like to do is position the binding source to where no row is selected. Even setting BindingSource.Position = -1 does not leave me with no rows selected. What ...
Score on”_statement
Tyron Millwee - 9 Oct 2006 4:47 PM - 3 messages
SQL is timing out on a “BeginTransaction” statement.  This error is only happening every few days in a distributed application. Here is the code: Dim connection As SqlClient.SqlConnection = SqlHelper.GetConnection(ConnectionString) Try    Dim trans As SqlClient.SqlTransaction = connection.BeginTransaction ...
Score Problem with SQL Server authentication
Vayse - 9 Oct 2006 2:56 PM - 2 messages
Hi I added a new user to SQL Server, called Reporting1. I set it up to use SQL Server authentication. In VB2005, I want to Add a Data Source, and use the Reporting1 user. I tick to Use SQL Server Authentication, but it doesn't work. The error I ...
Score does dataadater updates 2 tables.
trialproduct2004 - 9 Oct 2006 11:35 AM - 4 messages
Hi all, i am having code as following:- SqlCommandBuilder cmd; da = new SqlDataAdapter("select status,id,mode  from test1,test2 where test1.id = test2.id;", mConn); cmd = new SqlCommandBuilder(da); DataSet ds; ds=new DataSet(); da.Fill(ds); da.UpdateCommand = new SqlCommand("update test1 set status = @status ...
Score CLR Trigger Rollback
honzas - 9 Oct 2006 9:09 AM - 7 messages
A disccussion on this topic (how to perform rollback from CLR trigger) went here last year. ([link]) ...
Score Clearing row selected from DataGridView
Earl - 9 Oct 2006 6:59 AM - 8 messages
I've got a datagridview with a bindingsource bound to a datatable. I've also got a bunch of textboxes (on the same form) with their databindings set to the datagridview (I'm not allowing edits in the datagridview). When I go to ...
Score uncleared code
vijaiyanb - 8 Oct 2006 1:07 PM - 4 messages
please explain the following code         Dim rt As String = "{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fswiss\fcharset0 Arial;}}\viewkind4\uc1\pard\qr\f0\fs20 " ...
Score Provider independant Data Access
Philipp Brune - 8 Oct 2006 8:07 AM - 20 messages
Hello Newsgroup, what I want to achieve is to build my own set of DbCommand/DbConnection/DbDataAdapter/etc. classes that wrap a given .NET Data Provider like MySql, Firebird, SqlClient, OleDbClient, etc and provide the following functionalities on top  : ...
Score Access Autonumber problem
dcali001 - 8 Oct 2006 1:08 AM - 6 messages
Hello, I am working on a C# application that uses an Access 2003 database.  The database is also the back end for a much larger (and much older) VB6 project. The primary key to each table is an ID field that is built from two fields, ...
Score Error: Cannot change DataType of a column once it has data
Matt Fielder - 8 Oct 2006 12:57 AM - 5 messages
I'm running into a problem when filling a DataTable with data from an Excel file.  The DataTable is filled with datatypes that the fill method has "guessed" are correct -- the problem is I need them to be treated as ...
Next »