Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score Access connection string
Mike - 11 Dec 2004 8:43 PM - 3 messages
I'm developing an ASP.NET application in C#. I am storing my database connection string in the web.config file. If I set the string to connect to a SQL Server DB everything works fine, but I need to be able to connect to an ...
Score Can the RowUpdating event make the Update skip a row?
John Saunders - 11 Dec 2004 7:17 PM - 3 messages
Is it ever possible for a RowUpdating event (SqlRowUpdating, etc.) handler to cause the Update to skip the row? For instance, if e.Status is set to UpdateStatus.SkipCurrentRow, is the current row still updated? If so, it's not clear from the documentation, and I'd love to see a ...
Score Simple ADO.NEt question
Arsalan - 11 Dec 2004 4:46 PM - 5 messages
What is the equivalent of DataEnvironment1.rsCommand1("FIELD") [VB Dataenvironment] in ADO.NET? ...
Score How do I only bind certain columns with a DataGrid?
Grant - 11 Dec 2004 4:28 PM - 4 messages
I have the following code that binds a datatable to my datasource. Problem is, the table has about 25 columns and I only really want to see 5 of those columns. I know I can do it by changing my initial SQL query but that means ...
Score Need help with Stored Procedures being called from Client Code.
Manny - 11 Dec 2004 7:41 AM - 8 messages
Hi there, I created the stored procedures for Select, Insert, Update and Delete I got the Select Stored procedure to select data from the database with no problem. By the way, I'm kind of new to stored procedures. So, I want to Insert, Update or Delete records from my Windows Application ...
Score Connecting to SQL 2000 - advice
Grant - 10 Dec 2004 10:30 PM - 5 messages
Hi there, Im trying to find out how to create a front end ASP page that connects to a SQL server and retrieves a whole bunch of data. The page needs to be able to update, delete or add new records. The form itself will be showing ...
Score Sharing the transaction between different connetions in different webservices
Antonio Budano - 10 Dec 2004 10:09 PM - 2 messages
Hi there, How can I share the same transaction between two webmethods each in two different webservices? I want to be sure that when the client calls the two webmethods, there will be the data integrity, I mean if the second method will fail, also the ...
Score error-'ExecuteNonqury' on type 'SqlCommand' not found
JenHu - 10 Dec 2004 9:52 PM - 3 messages
Hi all, I have an error message: "Public member 'ExecuteNonqury' on type 'SqlCommand' not found." on objComd.ExecuteNonqury(). Can someone point me out where did I do wrong?  Thanks. The code is like this: ----------------------------------- Dim strSQL As String      strSQL = "UPDATE Epay_Transaction_Table SET EAcct_Num =' " & ...
Score Merge two DataSets to one
John Klinger - 10 Dec 2004 6:58 PM - 3 messages
I need to do the following: Create a DataSet containing one Table - no problem. Create a second DataSet containing one Table - no problem. Instantiate a new (third) DataSet - no problem. "Insert" DataSet1's Table[0] in DataSet3 as its first Table - problem. ...
Score Winforms DataGrid with a 41,000+ records.
Aaron Smith - 10 Dec 2004 6:36 PM - 6 messages
I have a DataGrid (winforms) that is bound to a table (MSDE) that has 41,000+ records in it. The form loads relatively fast and I can scroll all of the data... However, when I click in any column of any row other ...
Score Datareader design not generic
Edward Diener - 10 Dec 2004 6:12 PM - 6 messages
I would have expected an IDataReader to be able to return an IDataRecord from some interface function for the current row, to allow one to fetch the row and its values generically. But I did not find such functionality. Did I ...
Score What is the use of select statement in insert statement ?
cmhasan - 10 Dec 2004 5:53 PM - 2 messages
When I connect to any table through UI .NET add select statement in Insert statement by default .e.g. "INSERT INTO TestMessageText(msg_no, line_no, msg_text, time_stamp) VALUES (@msg_no, @line_no, @msg_text, @time_stamp); SELECT msg_no, line_no, msg_text, time_stamp FROM TestMessageText WHERE (line_no = ...
Score Connection Pooling -- who manages it?
Joel - 10 Dec 2004 5:48 PM - 2 messages
At what "level" does connection pooling get managed? For example, if I have a data access object (DAO) that uses a single connection string to access the database is there a connection pool performance advantage to putting that object in the GAC where it will be shared by all my web applications ...
Score Re: Asp.Net cannot insert record to dbf file? Help
Dakia - 10 Dec 2004 5:47 PM - 1 message
What about Guests group? Is it OK? ...
Score DateTime headache
John Dann - 10 Dec 2004 5:29 PM - 2 messages
I'm running into a major problem with DateTime formats in an ado.net-based program, probably as a result of international format differences. Situation as follows: The development environment is in Europe/UK (though hopefully the program will eventually have international uses) and uses Windows ...
Score Complex Aggregate Expression in DataColumn
Paul2004 - 10 Dec 2004 4:31 PM - 2 messages
Say I wanted to do an aggregate sum (using the Northwind examples in MSDN help) where relationships between 2 datatables exist, I would use: SUM(Child.Price) However, if I have a "IsDeleted" column in the child table, how would I ...
Score ado.net 2.0 inserting and getting blob columns
dgxhubbard - 10 Dec 2004 4:08 PM - 2 messages
Has retrieving and inserting blobs been updated in ado.net 2.0. I have read examples for 1.0 and 1.1 and understand what to do there. I have been developing Odbc applications and use the bcp api and thought it ...
Score Typed dataset, bindings and endCurrentEdit
normd@online.knorrassociates.com - 10 Dec 2004 2:01 PM - 1 message
Here is the situation, I extended the textbox windows control so that it has an additional custom string property. I have a typed dataset and my extended textbox's new property is bound to one of the columns of one of the tables in ...
Score AcceptChanges - OnColumnChanging
Madhu R - 10 Dec 2004 10:05 AM - 1 message
Hai all, This is Madhusudhanan.R from Chennai, India. I faced a problem while working with DataSet.AcceptChanges method & the DataTable.OnColumnChanging event. I have a set of textbox controls which I have bound to the columns in a ...
Score Is it me? Or don't data adapters and access work?
Daren Hawes - 10 Dec 2004 9:31 AM - 7 messages
I am having great troubles with Data Adapters, Access and Concurrency. Does everyone have to modify the SQL statements to get tit to work? I am only using a single Access DB per application, so I really do not need to worry about concurrency. ...
Score Crystal Report and password protected Access database
Jape - 10 Dec 2004 9:12 AM - 2 messages
Hi, I have a password protected access database. There's no username / password, only the database password. When I'm creating the connection to database the dialogbox ask's username (blanc) password (blanc) and also the Jet Database password. After this everyting works just fine ...
Score ForeignKeyConstraint StudentsSchYrSem requires the child key values (21000013) to exist in the paren
jaYPee - 10 Dec 2004 4:16 AM - 2 messages
I have created 3 sqldataadapter. each adapter.selectcommand has a parameter. I have added a textbox to supply a value for each parameter. My problem is when I press enter the second time to fire up the keypress event from the textbox I recieved this error in datagrid ...
Score Accessing UDF's that return tables
Kenneth - 10 Dec 2004 3:34 AM - 2 messages
Can anyone give a quick example on how to store a Table returned from an SQL Server User-Defined Function into a DataReader object? ...
Score I need help desperately with VB.Net URGENT
stargatesg1girl@yahoo.com - 10 Dec 2004 1:00 AM - 3 messages
I am taking a class and i have a project that is due on Tuesday and I need help desperately with this program I could email it to you please email me if you have any experience in VB.Net ...
Score Calling Oracle SPs w/Parameters (PLS-00306)
Scott McCormick - 10 Dec 2004 12:33 AM - 3 messages
Hello, I am trying to call several Oracle Stored Procedure using the "MS OLE DB for Oracle" driver, and have gotten the same error regardless of the SP I call. The error is:[pre] ORA-06550: line 1, column 7: ...
Score Microsoft Data Access Block and static methods
Clint - 9 Dec 2004 9:48 PM - 9 messages
Hey all - Excuse the cross-post ... I'm not sure what the appropriate newsgroup would be for this question. I have a question that I'm not quite sure how to ask. For all I know, I have the verbaige completely wrong, but here goes nothing ... ...
Score Return value from aggregate using Parent Child relationship
Mike Henry - 9 Dec 2004 9:09 PM - 1 message
Hello,   I'm trying to create a filter on a datatable in a dataset.  I have 2 tables 1) Parent - 'Patients' and 2) Child - 'Flow_Cyto' with it being a one to many relationship.  The Flow_Cyto table contains a PatientId, Date and ...
Score Icon problem
Ravi Sundari - 9 Dec 2004 8:57 PM - 2 messages
Hi We are storing Icons (.ico) files in our SQL Server Application as type Image. We have a web service call that returns these through a DataSet and we write the DataSet to disk using the WriteXML Method on the DataSet object. We ...
Score SQLConnection best way to use
bnob - 9 Dec 2004 8:07 PM - 3 messages
Im my ASP.net project I do a lot of connection to the SQL Server Database. I use a global variabe for my connection declare in a module (VB.Net code behind) All is ok but when I start a form from the default page it takes 30 ...
Score Cannot access Columns and Rows of some Strong-Typed Dataset's DataTables
Kyle - 9 Dec 2004 7:28 PM - 7 messages
I am having a major issue with strongly typed datasets.  I have been using the Server Explorer in VS.net 2003 to add tables from the database into a DataSet.  I cannot access the rows or columns of some ...
Score Like Parameter in VB.NET
Manny - 9 Dec 2004 7:04 PM - 2 messages
Hi there, I'm trying to pass a parameter to a SQL Statement with the LIKE operator but I'm not having luck on the syntax that I should use here. I want to retreive the records that match the search criteria input by the ...
Score Linking DataSets
MplsCpl - 9 Dec 2004 7:02 PM - 1 message
I'm going to try to be as succinct as possible when asking this question, so bear with me. Let's say I have two tables in a DB: 'salespeople ' and 'contacts'. 'salespeople' has a primary key field "id", which is the foreign key to ...
Score Linking DataSets
MplsCpl - 9 Dec 2004 6:40 PM - 6 messages
I'm going to try to be as succinct as possible when asking this question, so bear with me. Let's say I have two tables in a DB: 'salespeople ' and 'contacts'. 'salespeople' has a primary key field "id", which is the foreign key to ...
Score Q: Updating a table
Geoff Jones - 9 Dec 2004 6:26 PM - 4 messages
Hi I'm updating a table but trying to do it afresh every time i.e. erase any records in it and start from the start. The only problem is that the primary key doesn't re-set to its initial value i.e. it merely starts off where its ...
Score What's wrong with this find on a dataview?
Aaron Smith - 9 Dec 2004 6:13 PM - 1 message
Dim dv As DataView = New DataView(FacilitiesDS1.Facilities, "", "ID ASC", DataViewRowState.CurrentRows) Dim iPos As Integer = dv.Find(dr.Item("ID")) Me.BindingContext(FacilitiesDS1, "Facilities").Position = iPos That is the code.. dr is DataRow. If dr.Item("ID") = 3, the find will ...
Score OleDb adapter returns empty results
Anon - 9 Dec 2004 5:53 PM - 4 messages
I dont know where I am going wrong but the OleDB dataadapter returns data when it is a simple select statement like "Select * from Customers". but when i try to do a simple search query like "SELECT * FROM Customers WHERE LastName LIKE '*something*'", it does not return anything, even though ...
Score Strange query response time
Jeremy Chapman - 9 Dec 2004 5:36 PM - 4 messages
I've got a query where if I run it from query analyzer it takes about 1 second, but if I do it from an aspnet page, it takes about 54 seconds.  Can anyone suggest reasons that this might be? ...
Score Detached datarow and datarow.table
brianm - 9 Dec 2004 5:02 PM - 4 messages
Hello, I have a simple ADO.NET question for someone who knows their stuff. This has been bugging me. Here's the basic question: What is going on behind the scenes when I create a detached datarow and then call datarow.table.add? What's being ...
Score set ansi null off
Andres Felipe Arguello - 9 Dec 2004 4:52 PM - 3 messages
Hi, I need to use the ansi nulls in off to compare some register with null using '=', this is my enviroment: I call the SP from .net  1.0 object using sqlclient the SP has in the header the, ...
Score Oracle connection pooling
Lenny Shprekher - 9 Dec 2004 4:17 PM - 4 messages
Hi, I am getting issues that Oracle collecting opened sessions (connections) from my webservice using regular System.Data.OleDb.OleDbConnection object. I am guessing that this is connection pooling issue. Is there is any way to disable connection pooling for one particular .net webservice? ...
Score .NET Framework wall posters.
Tony Kirk - 9 Dec 2004 4:02 PM - 2 messages
Hey all,     Anyone know when I can get copies of the large posters that MS was having shipped with so many magazines in the past? I'm looking for any that may have been created. i.e. the standard framework library, ado.net, web ...
Score 600 field form
savsol - 9 Dec 2004 3:58 PM - 2 messages
Hi! I've a large form containing 600 fields (mix of textbox, checkbox, radiobuttons) i've broken the form in 10 parts (more or less with same number of fields) using web control, so if you press a button a ...
Score Using ADO.NET in windows service. I'm getting no events (e.g. RecordChangeComplete)
ML - 9 Dec 2004 12:41 PM - 4 messages
Hello, I have some small code that opens a connection to an oledb-provider and opens a recordset. Then creates a delegate to a RecordChangeComplete event on the recordset. When I put this code in a service (have tried both OnStart and in a separate ...
Score Q: Distinct Join???
Geoff Jones - 9 Dec 2004 11:47 AM - 3 messages
Hi I'm hoping that somebody can help me with the following: I have two tables, each of which has its own field holding integers. I would like to generate a list of the integers that the two fields have in common ...
Score SQL Question
Vincent Choy - 9 Dec 2004 10:21 AM - 3 messages
Can anybody know how to set alias after 'where'? select 1 as A, 2 as B,A-B as C from tbl where [B]=1 ...
Score Can't read Excel formatted data with OLEDB
Igor Vukomanovic - 9 Dec 2004 9:46 AM - 4 messages
Hi, I'm using ADO.NET and have troubles reading excel formatted data. leDbDataReader returns DBNull for all the values in the columns in xls workbook which aren't formatted as "Text"! I'm using this connection string: "Provider = Microsoft.Jet.OLEDB.4.0;Data Source = xlsfile;Extended ...
Score Comparing two DataSets with a Merge
Joe Sullivan - 9 Dec 2004 9:19 AM - 6 messages
I am trying to find the difference between two datasets.  I have tried merging the two datasets and then writing an xml diffgram like so:     dsA.AcceptChanges();     dsA.Merge(dsB, true);     dsA.WriteXml("D:/dev/Changes.xml", XmlWriteMode.DiffGram); ...
Score Fill select control from database
Rajani - 9 Dec 2004 8:27 AM - 2 messages
Hello, I have a table with brand_code and brand_name, 2 columns. brand_code is PK. I want to retrieve these values from the database and fill to select control. I tried using datareader. dr=cmd.exectereader() while dr.read() selBrand.attributes.add(dr("brand_code"),dr("brand_name")) ...
Score retrieve records from sqlserver w/ where clause
jaYPee - 9 Dec 2004 7:59 AM - 3 messages
I have no problem setting the selectcommand in sqldataadapter to fetch record from sqlserver w/ where clause in parent table. however, my problem is on how can i fetch the child table which is related from the parent table. I have ask this before and may be have not explained it well that's ...
Score GetOleDbSchemaTable column description
bc - 9 Dec 2004 6:03 AM - 1 message
Dim schema As DataTable = dbc.GetOleDbSchemaTable(OleDbSchemaGuid.Columns, New Object() {Nothing, Nothing, "textitem", Nothing}) schema.rows(i)("description") ' this is always dbnull, even for the columns that i set the description in SQL server enterprise manager.  i can get the ...
Score Fastest DataRow Copy?
localhost - 9 Dec 2004 5:59 AM - 4 messages
I have two DataSets and need to get DataRows from one DataTable into another.  Is this the fastest way?  I am after pure speed no matter what the "cost", in this case.    DataRow[] dataRows = oldSet.Tables["OldTable"].Select(); ...
Score ADO.NET DataAdapter Update Method (Persist DataSet to DataStore)
Ben (Melb, Vic, Aus) - 9 Dec 2004 4:15 AM - 2 messages
I hopeing that someone is able to point me to some good documentation on using the DataAdapter to Persists DataSets back to a DataStore. I having difficulty in working out how all this disconnected or (loosly-coupled) data-layer stuff works and would like some complete examples in ASP.NET (VB) ? ...
Score Dataset.Merge Concurrency violation
john.paul - 9 Dec 2004 3:23 AM - 1 message
I am using SqlClient and OleDbClient classes to copy data from an msaccess db to a sql server db. These two dbs have the same structure.I want the changes that have occured in the records in the msaccess db to be updated to the sql ...
Score My Stored procedure always returned the same value
Peter - 9 Dec 2004 2:53 AM - 2 messages
Hi, there I have created an stored procedure using the DDL below for my MS Access Database and no error occurs. Also it can create an stored procedure if I changed the parameter from "[zSampleName]" to ""@zSampleName".           OleDbcmd.CommandText = _ ...
Score Is this possible
Chris - 9 Dec 2004 12:39 AM - 10 messages
Hi, I am populating a dataset from a webservice. One one page of my app I need to get only the first 5 rows from the dataset to pupulate a datagrid and on another page I then will display all the rows from that dataset in a grid. Is ...
Score Enforcing parent-child constraints
Danny Liberty - 8 Dec 2004 11:44 PM - 2 messages
Hi, I have a simple windows forms application which resembles a parent-child table relationship. To be more specific, the form is bound to a table called "Sales" and it also contains a datagrid which is bound to a "SalesDetail" table. When I add a new record to the form and ...
Score RowFilter on a DateTime value (both Date & Time)
FinallyInSeattle - 8 Dec 2004 10:57 PM - 1 message
I have the need to be able to filter a DataTable on a column being between two datetime values.  The following works if there is no time stored : string strRowFilter = "StartDate <= " + dtStart.ToString() + " AND " + "EndDate >= " + dtEnd.ToString(); ...
Score RE: Unload XmlDataDocument
Ed Jobe - 8 Dec 2004 10:25 PM - 1 message
I found the answer in this msdn kb article: 307511. ...
Score NextResult Problem....ARGH>>>
mdjhome - 8 Dec 2004 10:09 PM - 4 messages
Greetings, I have an issue that I just can seem to get past today.  I continually get the following error: Invalid attempt to NextResult when reader is closed This is happening when calling this code, which is our standard block around ...
Score DataSet vs. DataView - How to update?
deko - 8 Dec 2004 9:51 PM - 3 messages
I have a WinForms app that builds a DataSet from an XML file.  The DataSet is wrapped in a DataView and bound to various controls through which users will make changes to the data, and when the "Save and Close" button on my ...
Score Create hierarchy from "flat" XML using DataSet/DataView?
Dave - 8 Dec 2004 8:43 PM - 4 messages
Hi, I have a "flat" XML file that I want to convert to a hierarchy as listed on the bottom. The XSLT I tried works fine in the XSelerator too but is slow when using XslTransform().  Is there a way to do this using a DataSet or DataView?  I've looked into ...
Score Sybase and OleDBDataReader problem
SRLoka - 8 Dec 2004 7:50 PM - 1 message
I am using OleDBDataReader with Sybase Anywhere 8 like SQL = "select disclaimer, about from company"; _cmd = new OleDbCommand(SQL,_cn); _dr = _cmd.ExecuteReader(System.Data.CommandBehavior.KeyInfo); The disclaimer is a varchar(1024) field. When I read back the value (I am ...
Score Locating in DataGrid
Povalyaev Sergey - 8 Dec 2004 5:12 PM - 4 messages
Hello all! I have a DataGrid bound to a DataTable. I need to select a record in the DataGrid that correspond to a DataRow with specified field "ID" value, but DataGrid should be sorted by "Name" value. As far as I see, there are no way to do this in performance sensitive way. ...
Score does Ado.Net 2.0 have bulk insert functionality?
Rich - 8 Dec 2004 4:53 PM - 7 messages
Hello, I have to read bulk data from a non RDBMS to Sql Server 2k.  I tried using Ado.Net with dataAdapter.Fill, where the app reads in 500,000 records to a dataTable in memory and then applies dAdapt.Fill to fill a table in sql Server ...
Score Object reference not set to an instance
kejeiri - 8 Dec 2004 3:09 PM - 13 messages
When I use my Dll in which I defined my dataset the following error occurs: Object reference not set to an instance or (in French "Une exception non gérée du type 'System.NullReferenceException' s'est produite dans system.data.dll, Informations supplémentaires : La ...
Score Object reference not set to an instance
kejeiri - 8 Dec 2004 3:06 PM - 1 message
When I use my Dll in which I defined my dataset the following error occurs: Object reference not set to an instance or (in French "Une exception non gérée du type 'System.NullReferenceException' s'est produite dans system.data.dll, Informations supplémentaires : La ...
Score Object reference not set to an instance
kejeiri - 8 Dec 2004 2:56 PM - 1 message
Lorsque j'uilise le Dll (dont j'ai définie ma dataSet) dans mon programme une l'erreur suivant survient : "Une exception non gérée du type 'System.NullReferenceException' s'est produite dans system.data.dll ...
Score Datasets and aggregate functions
John Dann - 8 Dec 2004 2:17 PM - 4 messages
I need to perform some aggregate stats on an ado.net dataset.datatable (which just contains numeric data), nothing too complicated, just eg: ** max and min values in a column ** row index of where the max and min occurred ** column mean ...
Score Excel values to datatable
Ibrahim Shameeque - 8 Dec 2004 1:05 PM - 2 messages
Hi I am exporting excel worksheet values into datatable. When there is a value in the excel cell which has more than 2 decimal places, for example say 123456789.123, the datatable truncates this to just two decimal places (123456789.12) losing the the third decimal place. Is there a workaround for ...
Score fetching data from excel 2000 and putting it to db using vb.net
Reny J Joseph Thuthikattu - 8 Dec 2004 12:35 PM - 2 messages
Hi, Can any one guide me to fetch data from excel sheet using vb.net Reagrds Reny --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system ([link]). Version: 6.0.807 / Virus Database: 549 - Release Date: 07/12/04 ...
Score Datagrid EndCurrentEdit problem...
Jan Nielsen - 8 Dec 2004 7:54 AM - 3 messages
Hi I have a parent detail relationship between two tables. The detail records are shown in a datagrid (GridRemarks) It is databound like this GridRemarks.Datasource = mainDatasource ' a shortcut to myDataSet.tblPersons.DefaultView GridRemarks.DataMember ="tblPersons_tblRemarks" ' The name of the parent ...
Score Connection String Dramas with JET and Directory GetCurrentDirectory
Daren Hawes - 8 Dec 2004 4:23 AM - 4 messages
Hi I am using the Visual Studio connection string.  See below ' 'OleDbConnection ' Me.OleDbConnection.ConnectionString = "Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database L" & _ "ocking Mode=1;Jet OLEDB:Database Password=;Data ...
Score retrirving @@identity using ado.net
vadim - 8 Dec 2004 3:42 AM - 4 messages
Hi, I am writing an asp.net app, where I insert some data into a table that contains an identity column ID and I need to know after the insert what was the ID value just created. In my Client server development I usually use ...
Score Help with SPROC from .asp please...
Stuart - 8 Dec 2004 2:09 AM - 3 messages
Hi there - sorry if this is a bit long winded, but I am really stuck and would appreciate any advice anyone has on this. I have the following set up in a stored procedure (below) which is called from an asp application and displays in a datagrid. The purpose is to ...
Score OLEDBCommand - locking error selecting data from dBase III
Chris Anderson - 8 Dec 2004 1:18 AM - 2 messages
Getting the following error when attempting to read in a dBase III file through ADO.net: Could not lock table 'Table#dbf'; currently in use by user '(unknown)' on machine '(unknown)'.,Microsoft JET Database Engine,   at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr) ...
Score LoadDatarow DataReader Cast Error
news.microsoft.com - 7 Dec 2004 11:11 PM - 2 messages
Im am trying to load a Data from a DataReader into a DataTable with the following code.  I am getting a cast error at the LoadDataRow statement. while(reader.Read()) {     object[] rowobjects = new object[ratestructurecompound._DataTable_RateStructureTbl.Columns.Count]; ...
Score Designing a Data Access Layer (DAL) with remoting in mind
Rupes - 7 Dec 2004 10:02 PM - 8 messages
I am trying to learn ASP.NET while writing a system in it and am feeling a bit overwhelmed. I have just read most of a book on ADO.NET. I will need to write a data access layer for this system and it is more than likely that the data ...
Score Designing a Data Access Layer (DAL) with remoting in mind
Rupes - 7 Dec 2004 9:55 PM - 1 message
I am trying to learn ASP.NET while writing a system in it and am feeling a bit overwhelmed. I have just read most of a book on ADO.NET. I will need to write a data access layer for this system and it is more than likely that the data ...
Score Designing a Data Access Layer (DAL) with remoting in mind
Rupes - 7 Dec 2004 9:55 PM - 4 messages
I am trying to learn ASP.NET while writing a system in it and am feeling a bit overwhelmed. I have just read most of a book on ADO.NET. I will need to write a data access layer for this system and it is more than likely that the data ...
Score error updating dbaseIII file with ado.net
smHaig - 7 Dec 2004 8:51 PM - 1 message
I have successfully filled a dataset in vb.net with a dbaseIII file using a select command on a dataadapter.  However, when I make my changes and go to da.update(ds,"mytable") I get the error that " the UpdateCommand is not ...
Score problem declaring SqlParameter of type Decimal
djc - 7 Dec 2004 8:49 PM - 2 messages
Problem: When peforming an update on an SQL (MSDE2000) data field of type DECIMAL my values are being rounded. For example if I enter 1.1 through 1.4 a 1.0 is entered into the table. If I enter 1.5 through 1.9 a 2.0 is entered into the ...
Score XPath problems...
cyphos - 7 Dec 2004 8:00 PM - 5 messages
Hi, I'm trying to display the data from my typed dataset on a page using the Xml web control. I have the following code: Xm1.Document = new XmlDataDocument(ds); Using the debugger, I found that the xml representation of my dataset ...
Score Re: database Query result in excel spread sheet
Duke Carey - 7 Dec 2004 7:45 PM - 1 message
Val Mazur - I sure could use the managed component you describe. my email address is dukecarey_at_hotmail.com Thanks in advance. ...
Score UDF TableData Get Problem
localhost - 7 Dec 2004 5:58 PM - 3 messages
I am trying to get table data from a MSSQL Function/UDF using the OleDb provider. The error message I get is "The request for procedure 'FuncOne' failed because 'FuncOne' is a function object." How can I get a Table-value return result from MSSQL UDF using OleDb? ...
Score Updatecommand error
vitorjol - 7 Dec 2004 5:11 PM - 3 messages
Hello In wrote this in VB code: DAComent.UpdateCommand.CommandText = "UPDATE coment SET estmensag='P' WHERE nomepess LIKE '%" & Trim(TextBox2.Text) & "%' AND emailpess LIKE '%" & Trim(TextBox3.Text) & "%' AND mensagpess LIKE '%" & Trim(TextBox5.Text) & "%'" DAComent.UpdateCommand.ExecuteNonQuery() ...
Score Reading Excel ranges
Robert Scheer - 7 Dec 2004 1:33 PM - 2 messages
Hi. I have a routine using the OleDb provider to read an Excel worksheet. The code works well, except when I need to read data from non adjacents ranges. In this case I receive all sort of errors. I need to ...
Score Retrieve XML Data
nyousfi - 7 Dec 2004 10:56 AM - 10 messages
Hi everyone, I hope you can help! I have the following query accesing an SQL Server 2000 Box SELECT     website.websiteID,         website.description,         website.URL, ...
Score How to find Number of Rows in DataReader
Perin - 7 Dec 2004 10:27 AM - 6 messages
I am using DataReader to populate my data. I want to find the number of rows in the DataReader. How to go about doing this. Is there any property or method available. I know that, it is a forward only read only cursor. But, I ...
Score Combo, dropdownlist, collection of items and databinding...
Jan Nielsen - 7 Dec 2004 9:03 AM - 1 message
My setting: I have a combo with a collection of Items as datasource: "Male", Female" I would like these selections to be exclusive so I use a DropDownStyle: DropdownList If I bind this combo to .Text property none of my selection changes are ...
Score Error while saving the data into database using shortcut key alt+S
Developer@eMantra - 7 Dec 2004 4:42 AM - 1 message
Hi, I am trying to add/update of data in a grid using the shortcut key ALT + S that is maped to the code written to save to the data base. The form is created using data wizard. But i am getting the error while updating using ALT+S ...
Score I need to run a vb.net or aspx.net file every 10 seconds.
Steve Jacobs - 7 Dec 2004 2:48 AM - 3 messages
Hi, I need to run a vb.net or aspx.net file every 10 seconds. The Task Scheduler in Windows 2003 Server can only do it every 1 minute at the minimum, but I need it every 10 seconds. Is it possible to write a small program in VB.NET ...
Score Confirm before delete
Rajani - 7 Dec 2004 1:31 AM - 4 messages
Hello,   How do i confirm before delete from the datagrid? I did like this. But getting error... "Object Reference not set to an instance of object" <asp:datagrid id="dgbrand" Runat="server" Font-Size="12px" Font-Name="arial" ...
Score ADO.Net equivalent of the ADO rs.GetRows() method
Ali M - 7 Dec 2004 12:56 AM - 3 messages
Hi,  I had a VB application that exported the values of one column - all rows - to an array by doing:     rs.movefirst     ar = rs.getrows(, , "col2") What is the equivalent to this in ADO.Net? ...
Score DataSet.Merge yielding Constraint Error
Repoleved - 6 Dec 2004 11:55 PM - 2 messages
I have dataset1, do a GetChanges to yield dataset2 dataset2 is saved The keys from dataset2 are used as search parameters to retrieve new data into dataset3.  dataset1's DataRowState (the test row) is Modified dataset3's DataRowState is Unchanged ...
Score Concurrency Issues after a Delete has occurred in Access
Daren Hawes - 6 Dec 2004 11:38 PM - 9 messages
Hi I get this error below. ------------------- An unhandled exception of type 'System.Data.DBConcurrencyException' occurred in system.data.dll Additional information: Concurrency violation: the DeleteCommand affected 0 records. -------------------- I am using Access and this only happens when I delete data from a ...
Score Concurrency Troubles using Access as Database '?' Appear in SQL
Daren Hawes - 6 Dec 2004 11:09 PM - 2 messages
Hi, I am using access as the main DB for an application. Whenever I try to update the DB by my Dataset I get Exception below. -------------- An unhandled exception of type 'System.Data.DBConcurrencyException' occurred in system.data.dll Additional information: Concurrency violation: the DeleteCommand ...
Score ---> System.Transactions and SqlTransaction <----
Sahil Malik - 6 Dec 2004 10:50 PM - 1 message
Okay, I have been trying to peice this together - and I know folks on this board have the answer. What is the common ground between System.Transactions and SqlTransaction? Would it be correct to say that - For most of my work that interacts with one single database, as far as I can ...
Score Can't Open Database from WebService
DimX - 6 Dec 2004 10:23 PM - 5 messages
I have a project consisting of a Web application and a Web service. The Web application calls the Web service to do some modifications in a database ( Microsoft Access ) When the OleDbConnection.Open function is called I receive the followin message: ...
Score ADO Connection question
DMurray - 6 Dec 2004 10:13 PM - 2 messages
I am having trouble opening an Access DB using ADO from VB.  I am part of a workgroup, the error message is: Cannot start your application.  The workgroup information file is missing or opened exclusively by another user. ...
Score add STOP button, to cancel the query process
mttc - 6 Dec 2004 8:24 PM - 2 messages
I have form that executes heavy Stored Procedure on sql 2000. I want to add STOP button, to cancel the process. I try to abort the thread. But this action not stops the process Immediately. It’s take a long time until query cancel. ...
How do I "Fake" a Bookmark?
DataSet
Throw DbConcurrencyException?
Data Type Error Reading from database
connectionstring
Re: RUSH YOUR RESUMES
Interrogating mySQL datatypes with ADO.NET
logon failed on asp.net and crystal report
How I can give to my user ability to kill or cancel transaction
Re: Keeping orphans when a parent is deleted
Get XML from typed dataset
How to excute a MS Access Stored procedure?
Please Help Me - object reference not set to an instance
Excel-like appearance in the datagrid
Same question again - tables fro 2DBs
2 DBs Ref by 1 DataAdapter?
Can't save new row to table
Large Datasets
Next »