Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score Problem with Restore (SMO) PercentCompleteNotification
Scott - 17 Mar 2007 11:48 PM - 3 messages
All, I am using SQL Server Manager Objects (SMO) Restore to restore an SQL Database. All works well however when I set the PercentCompleteNotification = 1 I would of expected the PercentCompleteEventHandler to trigger every one percent, instead it triggers a total 23 times not 100. ...
Score Simple problem: Why does this cause a massive memory leak?
Simon - 17 Mar 2007 10:37 PM - 23 messages
Hi all, I have a huge memory leak problem in what is really very simple data insert code. In my app I'm trying to use a typed dataset to insert into a database. It adds quite a few rows (say hundreds). Unfortunately it has a big ass ...
Score Where is the decimal point?
Tony Girgenti - 17 Mar 2007 12:21 AM - 6 messages
Hello. Working on a VS2005 SP1 Windows form program in .NET 2.0, on XP Pro, SP2. I must be pretty stupid.  I can't figure out how use decimal data in a table where there is no decimal point.  I populated the table with data from a ...
Score How do you clear a datatable?
Tony Girgenti - 16 Mar 2007 8:59 PM - 11 messages
Hello. Working on a VS2005 SP1 Windows form program in .NET 2.0, on XP Pro, SP2. I have a datatable with no keys and just three columns. How do you clear a datatable to no rows ? I tried : itemsDataTable.Clear() ...
Score dataset designer - building data access layer - how to close connect on exception
Microsoft - 16 Mar 2007 6:56 PM - 7 messages
I have been going through some tutorials on using the new dataset designer in Visual Studio 2005 to build dataadapters which include inserts, updates, and deletes...so I don't have to code it all by hand. This tutorial is ...
Score SqlCeDataAdapter not running Insert Command...
iKiLL - 16 Mar 2007 4:44 PM - 4 messages
Hi all I am having problems getting my SqlCeDataAdapter to Update the SQL Mobile Data base. i am using C# CF2. I have tried this a number of different ways. Starting with the command builder but eventually i wrote out the entire command my self, and still ...
Score Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign
nadeem_far - 16 Mar 2007 4:05 AM - 5 messages
Hello Everyone, We have a .net application (1.1 Framework)  that uses a strongly typed dataset. The application is in production for over 2 years. One of the users recently reported that when he tried starting the app. in the morning it failed and the logs showed the following error ...
Score Invalidate disconected recodset
Lubomir - 16 Mar 2007 12:10 AM - 8 messages
Hi, We would like to use MS SQL Server Express database for out data. The data can be updated by many clients. There will be an application that will show these data. This application can work with the disconnected recordest. ...
Score SqlServer ntext truncated
Peter Morris - 15 Mar 2007 7:22 PM - 3 messages
Hi all I am inserting data into an ntext column in SqlServer 2000 but it is being truncated.  In every StackTrace and Steps column (the only 2 ntext columns) I am seeing the text truncated to about 255 chars.  Can anyone tell me why ...
Score compiler error during scripting Oracle stored procedure
Andy - 15 Mar 2007 6:01 PM - 2 messages
How to find out or catch compiler error during scripting stored procedure via OracleCommand class? E.g. OracleCommand _oracleCommand = new OracleCommand(); .......       StringBuilder sb = new StringBuilder();       sb.AppendLine("create or replace procedure test_proc(var_number in ...
Score Small problem with storing connection strings
Simon Harvey - 15 Mar 2007 11:49 AM - 2 messages
Hi all, I have a data access library project within which I have created a number of datasets. In one of the datasets I've added a number of strongly typed datatable/tableadapters and configured them to use a connection string ...
Score Data Addaptor Not updating database?? Can some on tell me what i am missing please.
iKiLL - 15 Mar 2007 9:42 AM - 4 messages
Hi all The Code is below but i will give you a brief over view first. I am using C#, SQL Mobile and the CF2.0 with Merge Replication. My Primary Keys are all "uniqueidentifier" types with default value of ...
Score Linefeed in Datacolumn.Expression
Frank - 15 Mar 2007 8:55 AM - 3 messages
Hello ng I edit the field expression with '\n' or '\r\n' in the property-designer of the dataset/datacolumn. At runtime in the datagrid I miss the linebreak. The charaters '\n' or '\r\n' were shown in the datagrid. ...
Score Refresh not working on TableAdapter
fuzz_ball - 15 Mar 2007 7:43 AM - 10 messages
Okay, so I've read various articles on setting up a TableAdapter to retrieve a newly generated identity column value back into the dataset after an insert.  However, I'm having issues with the dataset actually getting updated. I swear this was working Monday, but once I thought ...
Score How to create own DataColumn Aggregate function
whiteboy - 15 Mar 2007 5:34 AM - 2 messages
I want to create my own Aggregate function to be used in the DataColumn.Expression property. So for example, DataColumn col = new DataColumn("foo", typeof(String)); col.Expression = "my_custom(Child.Test)"; Anyone done this before? Any suggestions on where to start? ...
Score Is it possible to use flat files as datasource
Tony Girgenti - 14 Mar 2007 11:52 PM - 3 messages
Hello. Developing a VS2005, VB, .NET 2.0, Windows form program. Is it possible to use flat files with fixed length fields as a datasoure.  I would use one for input and another to update. Any help would be gratefully appreciated. ...
Score "Scroll" cursor in Oracle?
c4p - 14 Mar 2007 8:00 AM - 1 message
I'm going to use server-side cursors from ADO.NET, like in this article. Creating and Managing Server-Side Cursors with ADO.NET: [link] Do Oracle has such kind of cursor ("scroll cursors")? ...
Score Get PK back on an insert into Oracle
David Thielen - 14 Mar 2007 2:27 AM - 4 messages
I am trying to get returned the autogenerated primary key value from Oracle when I insert a row. I am using the Microsoft OracleConnection class. My code is: // cmd is an OracleCommand object.     cmd.CommandText += "; returning " + column_name + " into :r1"; ...
Score DataGridView and Combobox columns
Chris - 14 Mar 2007 1:03 AM - 3 messages
I am trying to populate a DataGridView Combobox column with a different data binding source (dataset) depending upon a selection made in a previous column. I can handle the previous column but how do I assign the following properties dynamically in code? ...
Score I need an approach to storing/editing data amongs forms
Todd Beaulieu - 13 Mar 2007 8:14 PM - 2 messages
I'm working on a small, single user .net 2005 windows application in c# connecting to SQL Express. I'm trying to learn Typed DataSets, DataTables, DataAdapters, etc. What I need to figure out is a reasonable approach (doesn't have to be totally academic) to dealing with data. In other words, ...
Score Password protect .mdb file
musosdev - 13 Mar 2007 8:04 PM - 8 messages
Hi I'm using AccessDataSources to access my .mdb file, like so... <asp:AccessDataSource ID="adsStory" runat="server" DataFile="~/App_Data/MyDB.mdb"         SelectCommand="SELECT * FROM Table WHERE ColumID = ?">         <SelectParameters> ...
Score A search module in c#
Hemang - 13 Mar 2007 7:16 PM - 5 messages
Hello I need to create a search form which allows the user to search for records using multiple criteria, and then they can select that record and when clicked ok, that particular record to be displayed in the main form. ...
Score TableAdapter Configuration Wizard
frank - 13 Mar 2007 4:22 PM - 1 message
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 variable @strGeoID in 'where' statement - where  (PRODDTA.F1755.ZAURRF = @strGeoID), I got the error message: ...
Score connecting SQL server using OleDb - Reg
yasodhai - 13 Mar 2007 1:10 PM - 3 messages
While trying to connect to SQL server using OleDb I am getting the following error. The connection string used is Provider=SQLOLEDB.1;server=ctsinprnslse;database=Sample;user id=140869; password=140869 The Error I received is A first chance exception of type 'System.Data.OleDb.OleDbException' ...
Score connecting SQL server using OleDb - Reg
yasodhai - 13 Mar 2007 12:34 PM - 1 message
While trying to connect to SQL server using OleDb I am getting the following error. The connection string used is Provider=SQLOLEDB.1;server=ctsinprnslse;database=Sample;user id=140869; password=140869 The Error I received is A first chance exception of type 'System.Data.OleDb.OleDbException' ...
Score How can I use connected mode instead of disconnected?
Brooke - 13 Mar 2007 6:13 AM - 6 messages
I would like to bind some datagrids to datasource and have them update the database when a row is changed.  I don't like the disconnected mode.  I am developing a Windows Form app, not an ASP.net app. ...
Score Inherit from typed dataset
rusguy - 13 Mar 2007 4:57 AM - 4 messages
Hi Group. Is it at all possible to inherit from typed dataset in .net 2.0? I have a dataset defined in main project that will be distributed as dll. But I want to give others a possibility to inherit from this ...
Score Inherit a typed dataset
rusguy - 13 Mar 2007 3:17 AM - 2 messages
Hi Group. Is it at all possible to inherit from typed dataset in .net 2.0? I have a dataset defined in main project that will be distributed as dll. But I want to give others a possibility to inherit from this ...
Score Inherit form typed Dataset
rusguy - 13 Mar 2007 2:48 AM - 2 messages
Hi Group. Is it at all possible to inherit from typed dataset in .net 2.0? I have a dataset defined in main project that will be distributed as dll. But I want to give others a possibility to inherit from this ...
Score Import text file with DATE column into MS Access Database with VB.NET or C#
efiguero2000 - 12 Mar 2007 11:39 PM - 4 messages
Hello, I followed the thread "Import large text file to MS Access Database" trying to solve a similar problem, but with no help. I have a CSV file called "orders.csv" which I want to export to a MS Access table. ...
Score typed datasets populated by generic lists?
MarkAurit - 12 Mar 2007 7:03 PM - 2 messages
We have an application that makes use of a strongly typed dataset. However, some issues have come up with the database and tools. We would like to continue using it, but would prefer to populate it from a Genric List ...
Score how to get row number from DataTable.Compute method
AboutJAV - 12 Mar 2007 6:35 PM - 1 message
how do you get the row number from the DataTable Compute() method? Thanks ...
Score An existing connection was forcibly closed by the remote host.
salonen - 12 Mar 2007 4:09 PM - 1 message
I've seen this message a lot in the groups but I haven't found a solution for it yet. Our setup is SQL Server 2000 on a Windows Server 2003 cluster.  I don't believe this issue happened as often when the OS was Server 2000 ...
Score Is it possible to fill a DataSet.DataTable with values from more than one database table?
nvx - 12 Mar 2007 9:18 AM - 4 messages
Hello, is there a way to fill a DataSet.DataTable with values from more than one table from a single database file? The thing I'd like to achieve is to get something similar to a result of the JOIN keyword in SQL. ...
Score Urgent Memory Leak Problem Using Type Dataset. Please help! :-(
Simon - 12 Mar 2007 4:43 AM - 13 messages
Hi all, I'm having a baffling problem with a windows service that I'm working on. Basically, I am using a typed dataset to insert a large number of rows into an SQL Server 2005 database. But there's a memory leak that seems ...
Score Stopping a Query
Bill Gower - 12 Mar 2007 1:33 AM - 2 messages
I have a program which allows the user to graphically create SQL statements without having to know SQL.  They just drag and drop fields to view, select criteria and sort order.  When the user indicates that they want to execute ...
Next »