Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score DbDataReadet.GetOrdinal() - duplicate column name
David Thielen - 10 Feb 2007 11:22 PM - 14 messages
Hi; I have "select * from Company, Person where..." and both Company and Person have a Name column. So how can I call DbDataReader("Company.Name")? I tried exactly that but it failed. ...
Score DataView on two DataTables
Garik - 10 Feb 2007 5:00 PM - 11 messages
Hi, Please, help. Can I create a DataView on top of more than one DataTable. If not, how can I implement this for sorting, filtering????? ...
Score MDB or SDF?? Access or SQL Server Compact Edition???
Paul Aspinall - 9 Feb 2007 9:48 PM - 3 messages
Hi I'm looking to find a debate / discussion on the merits of coding a .NET application with either MDB or SDF files?? (ie. Access versus SQL Server Compact Edition) I guess the official line would be that SDF files should be used; but what ...
Score MDB or SDF?? Access or SQL Server Compact Edition??
Paul Aspinall - 9 Feb 2007 9:40 PM - 2 messages
Hi I'm looking to find a debate / discussion on the merits of coding a .NET application with either MDB or SDF files?? (ie. Access versus SQL Server Compact Edition) I guess the official line would be that SDF files should be used; but what ...
Score What's a best-practices way to perform an Insert/Update?
sherifffruitfly - 9 Feb 2007 8:22 PM - 4 messages
Hi all, Given key cols/data cols, I want to: IF record with that key exists, UPDATE the record with new data value, IF record with that key does NOT exist, insert the record. Oracle has a MERGE command, which may be used for this purpose, but ...
Score How to access columns having same name in a datarow More options
vish - 9 Feb 2007 2:57 PM - 4 messages
Hi all, I know this might look strange at first look, but i am looping thru a dataset created using two different tables from database.These two tables have some fields with the same names. Now i want to use those columns from datarow. How can i get exactly ...
Score How to access columns having same name in a datarow More options
vish - 9 Feb 2007 2:57 PM - 1 message
Hi all, I know this might look strange at first look, but i am looping thru a dataset created using two different tables from database.These two tables have some fields with the same names. Now i want to use those columns from datarow. How can i get exactly ...
Score Concurrency Exception and Enforce Contraints problem
Lee Clements - 9 Feb 2007 9:39 AM - 2 messages
Hi all, I am working through a example walkthrough at [link](VS.80).aspx to try and understand how to deal with concurrency issues. The only difference is that I'm using my own tables, etc. I have used the wizards to create all of the ...
Score Backup fails using SMO with big databases
sjoshi - 8 Feb 2007 10:43 PM - 1 message
Hello I'm seeing that the backup using SMO fails with big databases (>15GB). I have a 20GB database and I can see the command go thru. in Profiler but after it's about 50-70% done, I get an exception saying backup ...
Score Not Accessible in this Context
DH - 8 Feb 2007 10:38 PM - 1 message
I have the following function as part of a web service.  Where I define the dsRow and dsRowA, I am getting the error message below on the "New VcOptions.ConfigModelsRow" and the "New VCOptions.ModelAttributesRow" 'UstData.VCOptionsConfigModelsRow.Private Sub New(rb as ...
Score DataTable indexes on ADO.Net 2.0
bryan.young - 8 Feb 2007 10:14 PM - 3 messages
How can I force the creation of an index that will be used with the DataTable.Select method? I need to use the DataTable.Select because I'm doing a range select ex: select all rows where column x is between 0.001 and 0.006 ...
Score Sum inside a table
max - 8 Feb 2007 6:12 PM - 4 messages
I have a form and 5 textbox bounded to a table, called Listing; this table contains many records; every textbox bounds to a different column and show some price (price1, price2, ...price5). I add, update and display the records just using the binding navigator. ...
Score Iterate a datatable filtering on the default view.
Chris - 8 Feb 2007 5:58 PM - 5 messages
I have a data table for which I have set the default view's rowfilter. If I bind to a control everything is fine. If I go through the table with a foreach I see everything, not my filtered data. ...
Score DataSet Clear slow performance in C# 2.0
Armando Ruiz - 8 Feb 2007 12:50 PM - 11 messages
Hello group I`m testing a Vs2003 application (C#)  migrated to Vs2005 and I´ve found that when I do a DataSet.Clear(),  the C# 2.0 has a very slow performance deleting the rows, while the same process in C# 1.1 runs faster. (5 segs. ...
Score Indexing tables by name is very slow
Andrea Caldarone - 8 Feb 2007 11:10 AM - 4 messages
Hi all, look at this piece of routine, dsMAIN.Tables("ForeignKeys") is a DataTable filled with the data of all the foreignKeys in my SQL Servr 2005 database, I use this datatable to create the corresponding DataRelation object in my ...
Score Subquery in AccessDataSource Query Builder Failing
Morris Neuman - 8 Feb 2007 1:33 AM - 11 messages
I have a query with a sub query that works fine in MS Access.  However I get an error when trying the same query in .Net AccessDataSource Query Builder.  I get the error when I place open parenthesis at the start of the sub query ...
Score asp to aspx conversion problem
John - 7 Feb 2007 11:56 PM - 4 messages
Hi I have used  the wizard provided on [link] to convert an asp app to aspx. Now I am getting the Type 'xxx' is not defined error on the following; Dim rs As ADODB.Recordset ...
Score business objects vs. datasets
Penelope Dramas - 7 Feb 2007 10:17 PM - 28 messages
Hello, I'm in a front of very serious .net redesign/rewrite of an old VB6 application. I had been asked to make it .NET 2.0 and would like to ask couple of questions regarding data access as this application is heavily data-centric ...
Score Whats new in Ado.net 3.0?
Hemang - 7 Feb 2007 5:54 PM - 3 messages
Hello With the new framework .NET 3.0 out What are the main changes do ADO.NET if any? ...
Score parameters.Add("@f"...) vs parameters.Add(New SqlParameter("@f"
Rich - 7 Feb 2007 5:02 PM - 3 messages
da.InsertCommand.Parameters.Add(New SqlParameter("@f", SqlDBtype.Varchar, 10, "fld1")) da.Fill(ds, "tbl1") The statements below will insert a row into "tbl1"  just as well as the statement above da.InsertCommand.Parameters.Add("@f", SqlDBtype.Varchar, 10, "fld1") ...
Score Dataview sorting rules
Dan - 7 Feb 2007 3:04 PM - 1 message
Hi, It is possible to change the sorting rules of a Dataview ? What I want to do is a binary sort to do something like this : a-z A-Z 0-9. Also, is it possible to apply a specific culture without setting the ...
Score Exporting from a DataTable or DataView
michael - 7 Feb 2007 1:02 PM - 4 messages
Using only .NET components (rather than 3rd party components), is there a way to export data from a DataTable or DataView directly to an .xls or .csv file? ...
Score Read Records synronous (with Blocking)
Günter Prossliner - 7 Feb 2007 12:41 PM - 1 message
Hi! Is there any way to create an SqlDataReader which returns the Rows as they are added. It shall block until new Rows are added. Like: cmd.CommandText = "SELECT * FROM xyz WHERE Timestamp > LastTimestamp"; using(SqlDataReader r = cmd.ExecuteReader(???)) { ...
Score DataSet.Clear
jaro - 7 Feb 2007 12:06 PM - 6 messages
Hi I've simple scenario. I've win form with text edit bound to my dataset object. this dataset has one table with one column (datasource for my edit). Everything works fine, but when I clear my Dataset anf fill it again (from ...
Score Help - 'update is not valid updatecommand'
guzman.dan - 7 Feb 2007 1:26 AM - 4 messages
I have tried everything I can find on the internet, and I keep getting the same error message: "Update requires a valid UpdateCommand when passed DataRow collection with modified rows." Here is the simplest iteration of the code that generates the error. ...
Score Documentation on the "EnforceConstraints" property
Allen Hall - 6 Feb 2007 11:16 PM - 3 messages
Can anyone cite MS documentaion that explains that the EnforceConstraints property is set to false on a dataset when a ConstraintException is thrown. ...
Score Dynamically change connection string on a TableAdapter
twahl - 6 Feb 2007 9:04 PM - 6 messages
Hi, How can I dynamically change the connection string on a TableAdapter.  I'm looking for a way in code to easily configure this setting. Thanks for your help, Terry ...
Score Help needed using Relations on a Typed DataSet
J055 - 6 Feb 2007 7:17 PM - 9 messages
Hi I have a relation and foreign key constraint set up on two DataTables within a typed DataSet. I want to return the child rows from one of the tables, e.g. MyDataSet dataSet = primaryTbl.DataSet; (MyDataSet.MyPrimaryRow[])primaryRow.GetChildRows(dataSet.Relations[0]); ...
Score Why doesn't my project work in release mode?
Joel - 6 Feb 2007 5:03 PM - 3 messages
I have a Access backend for a vb.net 2.0 front end when i run the project in debug mode every thing goes fine, but when i run in release mode i get an error when i try to fill the items data table ...
Score Simple way to write DataSet contents to local system.
Andy - 6 Feb 2007 4:35 PM - 7 messages
I have a web service that collects data. However the service is hosted on a machine that it is difficult for me to access and administer ... As the database is small, I have added a web service method that returns the ...
Score Using transaction scope with access database
Rash VV - 6 Feb 2007 4:36 AM - 3 messages
Hi, I am working on two databases one is in SQL server 2000 and one is in MS access. My application is required to read data from the access file and update the SQL database. I want the complete operation to be done in a single transaction. For ...
Score Database Update using dataset
San - 6 Feb 2007 4:02 AM - 4 messages
Hi all, I want  to know What will happen when u try to update db using dataset and record is already deleted in database? Can any one provide info on Knocking concept in .net Thanks & Regards Santhosh ...
Score Reusing parameters
tshad - 6 Feb 2007 2:00 AM - 3 messages
I am trying to reuse my parameters to re-call my stored procedures but get the error: The SqlParameter with ParameterName '@UserID' is already contained by another SqlParameterCollection. My code is essentially: ***************************************************************    Dim parameters As SqlParameter () = { _     New SqlParameter("@UserID",SqldbType.BigInt) } ...
Score How submit values by POST method?
SushiSean - 5 Feb 2007 11:37 PM - 1 message
Hello. I have question about POST form submit and it consist from 2 parts 1. Part One: There are exist in asp.net framework2 method which allow make something like this. I have a server form (FORM1), TextBox control (textBox1) and button ...
Score Copying Database Data
Jonathan Wood - 5 Feb 2007 10:32 PM - 3 messages
I've been developing a Web site on my local computer and would like to publish it to my Web host (currently, GoDaddy.com). According to GoDaddy.com, I should be able to create a script that will recreate my database on the server. ...
Score Strange System.Data.OracleClient behavoir
LineVoltageHalogen - 5 Feb 2007 10:14 PM - 1 message
Greetings All, I have a small .NET C# app that connects to an Oracle instance and creates tables and some functions and procs.  I am sending over the DDL and using command.ExecuteNonQuery() to execute it.  The create table statements work like a charm.  However, when I ...
Score How to overwrite db records with records from dataset/table?
sherifffruitfly - 5 Feb 2007 6:41 PM - 7 messages
Hi all, I'm trying to save datasets (well, datatables in them) back to the main database. When the (key value in the) record in the dataset to be saved already exists in the main db, I get a "uniqueness constraint ...
Score DataColumn.Expression Filter on Child
flacmonster - 5 Feb 2007 5:31 PM - 2 messages
I have a field in a parent row that needs to be set to the sum of a field in its children.  That part is easy enough, as follows: Sum(Child.ColumnName) However, I need to filter out some of the children rows for the sum. ...
Score Overhead of SqlDependency
Günter Prossliner - 5 Feb 2007 4:32 PM - 1 message
Hi everyone! I am planning a Caching Implementation for an Object-Persistance Framework. Because the Framework is .Net 2.0 and SQL 2005 only, it would be possible to use the SqlDependency Class to invalidate Rows within the cache that have ...
Score Bulkcopy ignoring Primary keys exception
arnoled - 5 Feb 2007 4:00 PM - 2 messages
I want to make a bulkcopy (or insertcommand if this can't be acomplished with bulk copy) to a table. But if there are rows that are already in the table, just ignore them (don't do the insert on that ...
Score alter table with vb.net
Dew Baboeram - 5 Feb 2007 1:41 PM - 1 message
Hi, I want to alter the column property of a table I copied from another SQL Server database into my SQL Server database. In the other database the first colum was an identity colum, primary index with autoincrement. I can change ...
Score Process takes a long time to connect to SqlServer db
Sunil Menon - 5 Feb 2007 12:05 PM - 1 message
Dear All, I have a utility that I am invoking from an msi setup. This process is getting stuck for a long time while attempting to connect to SqlServer db...the following is the output of !analyze -v after taking the ...
Score temporarily allow duplicate keys?
Steven Spits - 5 Feb 2007 11:12 AM - 8 messages
Hi, We have a case where there will be temporarly duplicate keys during the update process. For example, Key "A" becomes "B" and "B" becomes "C". When "A" is set to "B", we get a duplicate key error because "B" already exists ...
Score Running a Oracle Script from VB.net
cenko2 - 5 Feb 2007 9:51 AM - 1 message
Hello, I'm now developing an installer application for an existing software package which needs to run tons of sql scripts on oracle. I know the best way to do it is to call SQLPLUS application, but then if an error happens at execution the application is unaware of that ...
Score Running a Oracle Script from VB.net
cenko2 - 5 Feb 2007 9:51 AM - 1 message
Hello, I'm now developing an installer application for an existing software package which needs to run tons of sql scripts on oracle. I know the best way to do it is to call SQLPLUS application, but then if an error happens at execution the application is unaware of that ...
Score Excel file
jessi - 5 Feb 2007 8:20 AM - 2 messages
Hello, I need to open an excel Workboot from an existing excel file, but I get the following error: Old format or invalid type library Here is my code: Dim oExcel As Excel.Application oExcel = New Excel.Application Dim oWorkbook As Excel.Workbook ...
Score merge dataset
Chris - 4 Feb 2007 9:41 PM - 3 messages
I am going to have two tables in different datasets with almost identical data except for one column. I want to overwrite the old column with the new. Will merging the datasets work and what will the performance be like. ...
Score Saving changes from DataGridView into database
karim - 4 Feb 2007 7:30 PM - 2 messages
I'm facing the following problem : I created a connection to a database table by going through the "Data Source Configuration Wizard" untill I had my tables to be shown in the Data Sources Window. Using the Data Sources Window I selected one of my tables called ...
Score Referencing Typed DataSet DataRows in .NET 2.0
gauty - 4 Feb 2007 5:18 PM - 3 messages
In .NET 1.x, you referenced a strongly typed row in a typed dataset by such VB code as:     drForum = dsForum.Forum(0)        'Get row 0 in the typed dataset ...
Score DataAdapter.FillError event does not fire
Guido Kraus - 4 Feb 2007 1:42 PM - 2 messages
I have a strongly typed dataset which I want to fill with data. If the data has errors (e.g. duplicate primary keys) I want to receive a DataAdapter.FillError event. However, this event does not fire. I both tried ...
Score vs 2003 to vs 2005 conversion problem
John - 4 Feb 2007 3:45 AM - 3 messages
Hi I have a vs2003 database app that use non-bound infragistics controls and all the plumbing is done in code. This works fine in vs2005. After importing to vs2005 via the built-in conversion wizard the application doe snot show ...
Score how does SqlDataReader work (internally)?
Sergei Shelukhin - 4 Feb 2007 12:21 AM - 2 messages
Hi. I have a couple of search queries that need to retrieve data from table Users, returning exactly N rows However, several rows of additional data from table UserSomething need to be retrieved for each User record, and there are also matching ...
Next »