Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score Using Typed Dataset with Winform vs ASP.NET
David R - 18 Feb 2006 11:09 PM - 9 messages
Something doesn't make sense here. I create a class library containing a typed dataset containing a single simple SQLServer table.  When I build it, and reference this in a new ASP.NET project, I can use the ObjectDataSource to find the right object, link to my ...
Score SQL 2K5 AND VS.NET 2K3
Chris - 18 Feb 2006 8:39 PM - 3 messages
Is it possible to use VS.NET 2k3 to access SQL Server 2k5?  Do you need any special data access provider or will the built in provider work? Thanks ...
Score Read only copy of DataSet
Praveen - 18 Feb 2006 2:27 PM - 5 messages
Hi All, I wanted to get readonly copy of a Dataset instance. Dataset has a Copy Function which can give me a give me a copy of the dataset but I did not find a way to make it readonly. ...
Score Timeout expired - on a simple SqlDataReader:Read() call
CuriousGeorge - 18 Feb 2006 1:15 AM - 10 messages
I have a very simple .Net 1.1 app that I'm writing to upgrade our applications database for a new version.  This app has a pretty tight loop where I'm using a SqlDataReader to walk through all records in a fairly ...
Score Persist a dataset
Paul Ilacqua - 17 Feb 2006 9:21 PM - 4 messages
How do I persist a dataset to another procedure in a form IE 'Code Public ds as Dataset 'Fill and use Dataset in LoadProjects but I want to use this dataset from another sub in the same form class. Private Sub LoadProjects() ...
Score DreamWeaver ·f°tVisual Studio ¦³¤°»ò¦n³B
ad - 17 Feb 2006 9:15 PM - 1 message
±q[link] DreamWearver¥i¥H·f°tVisualStuio ¨Ó¶}µoWeb Application ½Ð°ÝDreamWeaver ·f°tVisual Studio ¦³¤°»ò¦n³B? ...
Score DAAB Slowness issues in production
kevin.c - 17 Feb 2006 7:17 PM - 4 messages
This is somewhat of an odd situation...but to make a long story short: I built a test web application which inserts X number of records into a table.  It does this via a stored proc, shown here: CREATE  PROCEDURE dbo.spInsertTestData ...
Score 2.0 : DataColumn.DataType
John A Grandy - 17 Feb 2006 7:13 PM - 2 messages
I took this code right out of the VS05 docs , placed it in a method in a separate class , from the page instantiate that class and call the method ..... error thrown: using System.Data; DataColumn dc = new DataColumn("Int32Col"); dc.DataType = System.Type.GetType("System.Int32 "); ...
Score Parent <-> Child Updates
Radi Radichev - 17 Feb 2006 5:29 PM - 2 messages
Hi! I'm having trouble updating a dataset. So this ist my situation: I insert a new data source in my application and it is a table from Access mdb database. This table is related to another table in the database that i do ...
Score column names in a strongly typed dataset
Sergey Zuyev - 17 Feb 2006 5:10 PM - 1 message
Is there a way to get the column  names in a strongly typed dataset. If I have a dataset and want to set RowError to the name of the column without hardcoding it. I want a compile time error if the name of the column does not ...
Score Strongly typed Datasets and DataView
Vayse - 17 Feb 2006 4:27 PM - 2 messages
I have two questions on this. I'll show my code first '********************************************************** Dim taEvents As New AssetsDataSetTableAdapters.HTEventsTableAdapter Dim dtEvents As New AssetsDataSet.HTEventsDataTable taEvents.Fill(dtEvents) Dim viewEvents As New DataView(dtEvents) viewEvents.RowFilter = "EventDay Like 'D*'" viewEvents.Sort = "EventDay ASC" ...
Score ImportRow() doesn't save changes to database table
mikus - 17 Feb 2006 3:42 PM - 3 messages
Can anybody help me please. I'm new to VB.NET and I'm trying to import some data from SQL Server to MS Access but cannot make it to work (note: I don't want to use DTS) .....goes like this... ...
Score Discover parameters using DAAB
Ravi Ambros Wallau - 17 Feb 2006 1:21 PM - 3 messages
Hi,     I am using Enterprise Library (June 2005) and, in the older version, we could discover a stored procedure parameters set without calling it. It seems to me that it's not possible to discover a stored procedure parameters ...
Score ExecuteNonQuery
Lorenz Ingold - 17 Feb 2006 12:41 PM - 3 messages
In .NET 2.0 I have the instruction mySqlCommand.ExecuteNonQuery() This throws an error, not the first time since object creation, but only from the second time on. The error is (first in German, as our system is German): "-2146232060 .Net SqlClient Data Provider  Die vorbereitete Anweisung mit ...
Score Initialize user aded row in a DataGridView
scorredoira - 17 Feb 2006 12:12 PM - 1 message
Hi, which is the standard way to initialize a typed dataset row with Guid and DateTime columns when the user adds a new row in a bound datagridView by clicking in the last row? I can not set default values for some columns in the typed dataTable ...
Score DAAB ExecuteReader method causes Exception
Alec MacLean - 17 Feb 2006 11:54 AM - 8 messages
Hi all, I'm trying to deploy an ASP.NET (1.1) app to our production webserver, but having problems with the DAAB (from Ent Lib June 2005). As you might guess, it works just fine and dandy on my dev PC (VS2003). ...
Score Creating menu in asp.net
Alok yadav - 17 Feb 2006 9:31 AM - 3 messages
Hi, How can i create drop down menu in asp.net. please help me is there any component freely available for it ...
Score Can't use DbProviderFactory in compact framework?
enantiomer - 17 Feb 2006 8:08 AM - 2 messages
I am using the DbProviderFactory in my services project (a class library) to do all of my database interactions.  I use this because people may want to use a variety of different databases.  I have been using this for my windows forms project and it seems to be working ...
Score Not able to configure Enterprise Library - January 2006
Deepson Thomas - 17 Feb 2006 7:00 AM - 2 messages
Hi,    Let me describe my environment. I am using Visual Web Developer 2005 Express with SQL-Server 2005 Express. OS is windows 2000 professional. IIS which iam using is the inbuild one of "Visual Web Developer 2005 Express". ...
Score save a file in database
RbanBph - 17 Feb 2006 6:06 AM - 3 messages
Hello, I want to save a file in database. How can I do this in vb.net? Which datatype for the table I should specify for storing the whole file in it. Thanks , RbanBPH ...
Score Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign
googler - 17 Feb 2006 12:08 AM - 2 messages
Hi, I get the message "Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints." All the keys are intact and this problem pops up when there is a dataset.merge(dataset). ...
Score ANN: ObjectMagix Persistency Framework
Roman Bobik - 16 Feb 2006 8:19 PM - 1 message
ObjectMagix Framework Beta has been released. ObjectMagix provides persistency services (including an O/R mapper) for your business objects. It's based on .NET 2.0 and targets .NET 2.0 applications. Check out the official website at [link] ...
Score Join tables in DataSet
rh.krish - 16 Feb 2006 8:13 PM - 2 messages
Hi,     I have to join two table in a DataSet. I cannot do the join in stored procedure as the data for the tables come from different database servers. Data for table 1 comes from Sql Server, while data ...
Score What is the quickest/most efficient way to insert 100,000 Rows
Fiddelm3742 - 16 Feb 2006 6:50 PM - 7 messages
Well here is what I want to do.  I'm writting an aplication that will run through a data file, and either insert the records if they do not exist in the database, or update them if they do exist.  I'm inserting/updating over ...
Score Filling Dataset With a predefined XSD
Praveen - 16 Feb 2006 5:51 PM - 4 messages
Hello All, I wanted to query database and make an XML using WriteXML function in the dataset. When I use WriteXML function the XML structure is according to some default schema. I wanted the schema to be defined by me (given below). ...
Score sqlEx = {"Error converting data type numeric to numeric."}
rajmgopal - 16 Feb 2006 3:53 PM - 1 message
Hello Everyone I am getting the following error when i try to insert a record into Sql Server 2005 from my VB 2005 application. sqlEx = {"Error converting data type numeric to numeric."} I checked for possible overflow exception, but did not encounter any. ...
Score Using Ent Lib DAAB (1.1) with an SSL site
Alec MacLean - 16 Feb 2006 3:47 PM - 4 messages
Hi all, Can anyone tell me if there are any extra configuration steps to using the Ent Lib DAAB in an asp.net app that's being run through an SSL connection? (Framework 1.1, EntLib June 2005, VS2003) Thanks. ...
Score what's the secure way to post the jobs on the etranet?
asdf - 16 Feb 2006 2:38 PM - 1 message
Hi, I have the scenario where I have one database and need to post jobs on the intranet and then the same jobs on the extranet. I wonder what is the most feasible and secure way of doing it without buying ...
Score SqlDataSource: how to access internal data via code
Glenn Maples - 16 Feb 2006 2:10 PM - 3 messages
Guys- I hope this is a quck question but I've been playing with this for several hours and getting no love.  Thanks!!! Assume I have a SqlDataSource after databind -- that is populated with data. Is there any accessor to the internal state? ...
Score Advatages of Stored Procedures?
Sean - 16 Feb 2006 1:28 PM - 9 messages
Currently we are building SQL statements using strings and string variables depending on users selections and then passing the SQL statement into the command or connection object. I have been taught to use stored procedures however I am unclear as to the specific advantages of using stored procedures ...
Score Autogenerated dataset from a mdb access database
Alvaro Enriquez de Luna - 16 Feb 2006 12:05 PM - 2 messages
Hello everybody. I have included an Access mdb database in my c# project. Visual Studio 2005 has autogenerated a xsd dataset (cs, xsc and xss files). My problem is that, after making modifications in the mdb file directly from access, the dataset doesn´t refresh in my program (in this case, ...
Score Help! Serviced componets SQL-server 2005
Jo ARild - 16 Feb 2006 10:26 AM - 1 message
After upgrading to SQL-server 2005 the following error message occures on a random basis.  The SQL-server does not have any deadlock. It worked perfect before the upgrade and no database changes were made after the upgrade. The serviced components are called from asp.net 2.0. ...
Score Sql Server SCOPE_IDENTITY()
Carlo Razzeto - 16 Feb 2006 1:35 AM - 12 messages
Hello, I'm currenly in the process of writing a Database abstraction class that will support MySql, MS-SQL and OLEDB. In the abstract base class, I have a public read only property LastAutoID UInt64 deffined. The field behind this property is updated every time the end program calls the ...
Score Design query - inherited data structures
Toby Groves - 15 Feb 2006 11:11 PM - 2 messages
Hi, after a bit of advice here if possible. I have an application which needs to store several different types of "document".  Each of these documents have many properties in common but in addition will have some properties peculiar to themselves.  In normal ...
Score "Business Objects" and the DAL
Steve - 15 Feb 2006 10:42 PM - 7 messages
I *still* can't get my head around this. In designing a basic n-tier application, what exactly is the relationship between the "Business Objects" and the "Data Access Layer"? In the past when I have attempted to make an n-tier application, business ...
Score DataAdapter: Maximum length SQL statement?
DjMark - 15 Feb 2006 8:47 PM - 2 messages
Hi, I am trying to configure a dataAdapter in Visual Studio 2003, using the wizard. I tried using the SQL statement, "SELECT * FROM table" When i preview the output in de Query builder everything seems to work fine. But when i finish the wizard, i get an error: "There were errors generating ...
Score SQL syntax question
VB Programmer - 15 Feb 2006 8:32 PM - 6 messages
In SQL how do you combine several fields AS 'xxxxx'. This type of syntax doesn't work SELECT MyPhone & "-" & MyCity AS 'MyInfo' FROM XXXXX WHERE.... ...
Score An event was unable to invoke any of the subscribers
ss - 15 Feb 2006 8:20 PM - 2 messages
I am working with distributed transactions. When I open and close the database multiple times within one single distributed transaction, then the 11th time fails when the database is closed. I receive "An event was unable to invoke any of the subscribers".   Any help is greatly appreciated. ...
Score Dynamically Adding Controls
micah - 15 Feb 2006 5:50 PM - 2 messages
I am somewhat new to the .net framework, and I am completely stumped on something that I feel should be relatively simple. 1. I need to dynamically create controls on a web page This is not a problem. 2. In order to format these dynamic controls how I want them, I first ...
Score Moving data from one dataset to another
SH - 15 Feb 2006 4:01 PM - 2 messages
What is the easiest way to move data from one dataset to another? I have a web service that returns a dataset from a datasource. I then want to move all the data in one datatable in that dataset to another ...
Score Mapping date information from C# variable to a DataRow object
Peter - 15 Feb 2006 3:49 PM - 1 message
I have a mapping question as below: MyDataRow[name] = "Mary";          //OK, name defined as varchar, in Sql table MyDataRow[age]    = 25;                //OK, age defined as int, in Sql table ...
Score Conversion failed when converting from a character string to uniqueidentifier.
Allen Moss - 15 Feb 2006 2:31 PM - 1 message
I keep getting a conversion failed when converting from a character string to uniqueidentifier when running the sql below in SQL server 2005.  You can run it in the the management sql server studio.  BranchID is a uniqueidentifier.  If you substitute ...
Score ADO \ ADO.Net
DylanM - 15 Feb 2006 1:51 PM - 2 messages
Hi, We have an old web service that's written in VB6. It expects an XML document that it can load into an ADODB recordset as follows... set objADORst = Server.CreateObject("ADODB.Recordset.2.7") set objXML = Server.CreateObject("Msxml2.DOMDocument.3.0") ...
Score What is the secure way to share data between Intranet and Extranet?
asdf - 15 Feb 2006 12:29 PM - 2 messages
Hi, I have the scenario where I have one database and need to allow to see the information accessible from Intranet and (future)Extranet. I wonder what is the most feasible and secure way of doing it without buying second license ...
Score Refreshing sqldatareader after read method [vb.Net]
Hardik Shah - 15 Feb 2006 11:36 AM - 2 messages
Hi, I want to refresh (get first record) again after calling .read method once. I give following command but second loop doesn't give any output. While myreader.read    ' myreader is a sqldatareader     console (myreader.item("field_nm") ...
Score Multiple selection in a control with databinding
ricbenasco - 15 Feb 2006 10:00 AM - 1 message
I'm developing an application where I need to let users to select from a table (Table2) multiple values wich are relationed n to n with a another table (Table1) Table1<------>Table2 IdTable1  n-n   IdTable2 ...
Score Opening MDF files with ADO.NET 2.0
rasx - 15 Feb 2006 12:30 AM - 4 messages
An article in SQL Server magazine mentioned in passing that we can open MDF files directly with ADO.NET 2.0. Is this true? Are there any examples/tutorials of this? Does this mean that ADO.NET 2.0 is kind of like a ...
Score <target>.PrimaryKey Merge Error
Tom_B - 14 Feb 2006 8:41 PM - 3 messages
Running a VB.Net console application that uses data from a VB.Net webservice. Both the data sent and received are accessed with strongly-typed datasets. With dsMapping           ds = WS.WorkOrdersForReprint(StoreId) ...
Score GridView - Update using stored procedure
drakuu - 14 Feb 2006 8:36 PM - 1 message
So I'm updating the records using Edit-Update Command fields in Gridview using stored procedure. The stored procedure updates two tables. I have there two ID columns - ProviderID and AddressID which I need for my update statement. If I make the columns invisible or read ...
Score Updating access through VB
karthik.charan@gmail.com - 14 Feb 2006 7:48 PM - 4 messages
Hi I am a new to VB.net, I am using access as my database I am trying to show some tables in Vb using Datagrids, I am able to add rows to the table and update those changes to the access file, but when ...
Score Cascading delete performance
Rolf - 14 Feb 2006 6:36 PM - 4 messages
Hi I need to implement cascading delete between related tables. I can do this in sql server (2005) or in the dataset in my application. But what is the best solution when perfermance is important ? Thanks Rolf ...
Score CLR problems with security under ADO.NET and SQL Server 2005
Brian Henry - 14 Feb 2006 6:27 PM - 3 messages
Ok I'm confused on this... in T-SQL Say I have TableA and it has no select permissions on it for the user... but the user has a stored procedure with execute permission on it and contents of it is SELECT * from TableA... well ...
Score How to make database changes visible to your application?
Dino Buljubasic - 14 Feb 2006 4:23 PM - 5 messages
Hi, I am using VS2005 (C#) and SQL Server 2000. How can I make sure that: 1. Client A queries info from database and displays it in a list view or other controls on a form.  If Client B changes some of this info ...
Score Syntax error?
Joneleth - 14 Feb 2006 4:00 PM - 4 messages
Hi, I'm developing an ASP.NET web application  with MySql 5. I have a little problem: if i create a stored procedure like this one: CREATE PROCEDURE `spProva` (out retval int, in idemployee int) BEGIN   UPDATE employee e SET e.Room = 'Milan 41' WHERE e.IdEmployee = ...
Score transaction has already been implicitly or explicitly committed er
Ben Lam - 14 Feb 2006 3:26 PM - 1 message
We are using MSDTC to handle our transactions and some clients seem to be getting these errors more and more when we went to framework 2.0.  Any ideas what could be causing this? Before in framework 1.1 we would ask our clients to re-register their ...
Score ExecuteReader closed connection
Gregor - 14 Feb 2006 3:01 PM - 2 messages
Hi, I am using the SQL data reader to access SQL2000. I am opening the connection and executing the reader then closing reader and connection. There is an example code:     SqlDataReader sqlReader = null;     tring storedprocName = "procName"; ...
Score ExecuteReader closed connection
Gregor - 14 Feb 2006 3:01 PM - 1 message
Hi, I am using the SQL data reader to access SQL2000. I am opening the connection and executing the reader then closing reader and connection. There is an example code:     SqlDataReader sqlReader = null;     tring storedprocName = "procName"; ...
Score A severe error occurred on the current command. sp_AddMergePublication
david.brunning - 14 Feb 2006 11:12 AM - 7 messages
I have a C# application in which I am allowing users that are members of sysadmins on SQL Server to create publications.  The first thing that happens is the application sets up a loal distributor on the SQL server if one doesn't exist and then tries to set up a merge ...
Score How to determine if a value has changed as a result of data binding
Nik - 14 Feb 2006 9:03 AM - 1 message
Hello, if I bind a property of a control to a field in a data source, is there a way to know that its value has changed as a result of data binding. For example, if I bind Text property of a TextBox, I need to know that ...
Score How to prevent concuurent users from adding data to cache
Jeenu - 14 Feb 2006 7:35 AM - 2 messages
I am using asp.net  to build a scalable application. I am using data caching and I want to know whether the following situation can arise If concurrent users check the cache and finds that data is not there ...
Score How to know length (data width) of column from VB.Net
Hardik Shah - 14 Feb 2006 5:48 AM - 2 messages
Hi, I have a table in SQL Server 2000 and accessing it in ADO.Net , I want to know fields width and I gave following VB.Net commands but I am fail to know it, it returns -1 for all columns. ...
Score DataAdapter Commands
Charles - 14 Feb 2006 5:35 AM - 3 messages
I would appreciate some help, or direction, in understanding two things about using the DataAdapter's update method.  The first issue I have is the DataAdapter and Table need to be declared in the same procedure as the three commands.  Usally, this is done at the begining of a Web Form ...
Score The Ellipsis (.) Character Is Not Showing Up When Read From A Text File
Nathan Sokalski - 14 Feb 2006 4:37 AM - 2 messages
I have a page which reads the the first line of every *.txt file in a certain directory of mine to use as the Text property of a HyperLink Control. However, in one of my recently added text files in the directory it ...
Score Why does INSERT statement delete previous records?
the_grove_man@yahoo.com - 13 Feb 2006 10:20 PM - 5 messages
I am writing an application that populates a database from text files. I have an insert command which works fine,  however, it overwrites anything that was in the database before. Looking for a little help: (the database starts off empty) ...
Score "Out of Memory Exception" with Push Method for crystal reports
Debi - 13 Feb 2006 8:36 PM - 3 messages
Hi,     I'm using a dataset close to 11 MB as the datasource for my reports. I've 15 subreports in my report, of which two uses this dataset as the datasource and the rest uses the same dataset, but have Selection Formula ...
Score Started getting "InvalidOperationException was unhandled" since upgrading to .Net 2.0
Ben Fidge - 13 Feb 2006 8:31 PM - 4 messages
Since upgrading my project to .Net 2.0 i've been getting the following error on occassion: "InvalidOperationException was unhandled" followed by "Internal .Net Framework Data Provider error 1." The error happens when I call SqlConnection.Close(), but not all the time. ...
Score Generate PDF and/or RTF file from the DataSet
Just D. - 13 Feb 2006 8:07 PM - 6 messages
All, Do we have some service/app/control to generate in our WebApplication the downloadable RTF/PDF file. The original data can be provided in the DataSet or DataView, plus some text like header, footer... Thanks, Just D. ...
Score .NET Framework Data Provider for Oracle does not support batched SQL statements
AK_TIREDOFSPAM - 13 Feb 2006 7:14 PM - 2 messages
It is clearly stated in MSDN that "The .NET Framework Data Provider for Oracle does not support batched SQL statements". Are batch updates going to be supported anytime soon? Is anybody successfully using ODP.Net to execute batched updates against Oracle? ...
Score Updating Client on Database Changes
Dino Buljubasic - 13 Feb 2006 6:59 PM - 4 messages
Hi, How can I update my client imediatelly if database info has changed? Example 1. Clinet A (win forms app in C#) has displayed on its form data retrieved from database (SQL Server). Client B adds new info or edits existing info of data displayed on ...
Score LoadDataRow to DataTable built by fill schema
Fiddelm3742 - 13 Feb 2006 4:36 PM - 2 messages
So what I'm trying to do is Create the table tblToLoad which i have done, then use fill schema to create the proper columns based on strLoadTable (which is a table name that is passed in via command line )  Then later in my ...
Score I can do this in ASP, but no clue for ASP.NET
Scott at Cedar Creek - 13 Feb 2006 2:43 PM - 2 messages
From within a FormView control, by looking at a particular column in my FormView, I can determine the "service type" of any particular record.  Another table in my database will tell me how many "categories" that "service type has" (it's dynamic...different service types have a different numbers of ...
Score DataGrid & Checkbox Template Columns
JP - 13 Feb 2006 2:16 PM - 1 message
Hi, I've got a simple datagrid (ASP.NET C#) that is populated by an adapter from SQL.  I have two template columns - one with a checkbox and one with a textbox. I am allowing users to indicate which rows to remove from the grid by ...
Score DataGrid update issues
BStrick - 13 Feb 2006 5:54 AM - 5 messages
I've looked around and haven't found a usuable solution to this issue. I hope that you can provide me with some assistance. I have a application that calls for the user to select a database/table to view ...
Score ODP .Net Connection Pool Problem on Web Application
mingki - 13 Feb 2006 4:09 AM - 10 messages
Hi Developers, I am a .Net developer of a Large Online Retailling Company. I would like to have your help on a Connection Pool issue. Recently we have developed a Web Application on ODP .Net to work with Oracle Database 10g. To gain the performance, connection pool enable is ...
Score Is this a bug?
Ant - 13 Feb 2006 2:31 AM - 2 messages
Hi, I'n using VS2003 I.m using two typed datasets. One of them has stopped supplying intellisense methods: e.g. dsLocation.Locations.Clear();  // ok, intellisense from Locations tbl provided dsDepartment.Departments    // Doesn't provide intellisense from the ...
Score Need to close DataReader?
ad - 13 Feb 2006 1:21 AM - 2 messages
If it need to close DataReader after read? I am study the Data Access Application Block for .Net Framework2.0 form [link] I found the the DataReaders in the examples are not close explicitly in ...
Score Usual Databinding Question - UNusual Requirements
Neo Geshel - 12 Feb 2006 10:21 PM - 3 messages
Greetings! I have a rather unusual request about a rather basic need. I need to be able to bind data to a page, but WITHOUT using a Repeater, DataGrid or DataList. Why? Well, I have some formatting and JavaScript issues that require each and ...
Score [simplified] Reusability of objects in MySQL Connector/NET
Mochuelo - 12 Feb 2006 9:01 PM - 2 messages
Hi, My previous post may be too confusing. This is the idea of my doubt: To do one single SELECT-type query, or one single INSERT-type query, I have no problems. To do multiple queries in a row, which objects can I reuse? Do I need ...
Score DataAdapter and foreignkey constraints
Joerg Fischer - 12 Feb 2006 8:43 PM - 4 messages
Hi, Using dataadapters, I got the follwing question: Given a DataSet with two tables (lets call them HEAD and ROW). As you can imaging, there is a foreign key constraint indicating that every ROW entry must have a corresponding HEAD entry. ...
Score Reusability of objects in MySQL Connector/NET
Mochuelo - 12 Feb 2006 4:17 PM - 1 message
Hi, I'm using: - Visual Studio 2005. - MySQL Server v4.1.9. - MySQL Connector/NET v1.0.7 (and I have referenced the dll for .NET 2.0). I wrote a class "C_MySQL" that attempts to encapsulate the low level ...
Score Best Way of Deleting All Rows in a DataView
michael - 12 Feb 2006 3:24 PM - 5 messages
If I create a DataView(i.e. dv) with a particular RowFilter and Sort, I realize that I can't use a For Each to delete those rows because each deletion changes the current view. So that this won't work: ...
Next »