Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score Add Record to MS Access Database
thomasp - 25 Jun 2005 4:14 PM - 12 messages
Is there anyone that knows how to add a record to a MS Access database with VB.NET.  I have search for 3 days for some code that works.  I have gathered bits and pieces of code and put it together, but I have not found a solution ...
Score Oracle transaction rollback problem
dnhelp - 25 Jun 2005 12:49 PM - 2 messages
I have problem with transaction. When I try to rollback transaction commit happend and record is updated. Can anybody tell me, where I made a mistake. Thanx, S. Imports Oracle.DataAccess.Client Imports Oracle.DataAccess.Types private sub mWriteOnOra() Dim inFile As System.IO.FileStream ...
Score Query Result Paging with different Ordering
J Rieggle - 25 Jun 2005 12:15 PM - 2 messages
Hi, I have posted to multiple groups - I hope this is ok. For the past week or so I have been trying to find out how to perform a search against SQL Server, and have the results sorted on a choice made by ...
Score problem in uploading and downloading files from DB in ASP.Net
Himanshu - 25 Jun 2005 9:52 AM - 2 messages
hi, Can anybody tell me that thru asp.net using c#, how can we upload and download physical files in any table of SQL Server Database. the uploading part is running successfully but the problem arises in the retriving part of the code. ...
Score Using UPDATE I con't write the dataset back to datasource
B.J. - 25 Jun 2005 3:52 AM - 5 messages
It works fine with the datagrid but with the sqlAdapter. Here is the code I was using. if State is always undefined. so it skips the logic, but the Textboxes hold the changed information. I am learning, please advise. Thanks ...
Score ODBC Data Sources
Landley - 24 Jun 2005 10:24 PM - 6 messages
Hi All, Is there a method that I can call to return a list of available database drivers? If so, is there then a way to get the list of fields that are required for those the database drivers? L. ...
Score Connection Won't Die
Beck - 24 Jun 2005 8:44 PM - 2 messages
Application - give Oracle DB connection status on an ongoing basis Technique--thread is fired off by a timer every minute.  It attempts to open a connection.   It catches an open error as a failure, and otherwise indicates ...
Score Convert _Recordset to DataSet/DataTable
B. Salmon - 24 Jun 2005 7:31 PM - 4 messages
I have a Visual C++ .NET function that is calling an unmanaged function that returns an ADO _Recordset* object.  I want to be able to convert that into an ADO.NET DataSet (or DataTable).  I tried to use the OleDbDataAdapter.Fill ...
Score How DataRelation object is updated
DHuang - 24 Jun 2005 3:20 PM - 5 messages
After the VS 2003 creates a strongly typed DataSet object that contains a couple of tables and serveral many-to-may data relations among all the tables, and the data got populated, I am wonder how the DataRelation object of the DataSet object is updated when some new rows are added to some of the ...
Score ADO or String.Format bug ? ......
Nicola Cisternino - 24 Jun 2005 2:27 PM - 5 messages
Hi It seems that String.Format method, when use a ***ZERO VALUE*** object coming from a SqlDataAdapter Fill method works fine, while if the same query is runned using an SqlDataReader ExecuteReader method, the formatted result is wrong .... For my tests i've used the Sql Server 2000 Northwind database and i've ...
Score connection question
Mike - 24 Jun 2005 12:30 AM - 7 messages
I'm getting an error while running an aspx page on a production server. The error is that either the server can not be found or the access is denied. The following code fails at line 36. Line 34:        str = "Driver={SQL ...
Score MSDE, ASP.NET, Visual Studio .NET, and connectionstrings
Nathan Sokalski - 23 Jun 2005 10:45 PM - 18 messages
I have Visual Studio .NET and SQL Server Desktop Engine on my computer. I have created an empty database using Visual Studio .NET's Server Explorer. However, I am having trouble connecting to the database using ASP.NET. I think the problem is somewhere in my connection string, but because I do not ...
Score ODP.NET Publisher Policy?
llevity - 23 Jun 2005 9:32 PM - 5 messages
We recently started running into a problem.  We had a .NET winform application built with ODP.NET 9.2.0.4.  We rolled out a new OS image that had only the 10.1.200 Oracle client and ODP.NET. ...
Score datatable.select("Distinct") or such to string?
DEWright_CA@online.nospam - 23 Jun 2005 8:46 PM - 10 messages
I am hitting a bit of a wall - I am building a table - public DataTable theTownships = new DataTable("AdjacentTownships"); public DataTable buildTownshipTable() { DataColumn tscolumn;    //Townships-Range Field tscolumn = new DataColumn(); tscolumn.DataType = System.Type.GetType("System.String"); ...
Score Using System.GUID in a RowFilter
michael - 23 Jun 2005 8:34 PM - 4 messages
I have a table in SQL server that has a column of type UniqueIdentifier. I use a DataAdapter to fill a typed DataSet with rows from the table. (Interestingly, when I look at the typed dataset, the datatype of this column ...
Score Dataset Relationship
Justin Lazanowski - 23 Jun 2005 8:27 PM - 2 messages
I have a grid that is bound to a typed dataset. Three fields make up the key in the parent table and those same three fields are also in the child tables with a 1 to many relationship. When I bind this dataset to a grid it displays it hierchalily (which is what ...
Score SQL queries and datasets etc
John Dann - 23 Jun 2005 12:41 PM - 5 messages
As only an occasional ado.net user I'm realising that there's something important and basic that I don't understand: I can obviously perform SQL queries on a database, but sometimes the data I need to access is in a bare datatable. So the question is ...
Score Error saving data from dataset with expression column
JMBC - 23 Jun 2005 12:12 PM - 5 messages
Hi, I have a dataset created by dragging table from database explorer. Then I have added a column in dataset with expression cant * price in order to get calculation from two columns. This work fine. But when I try to save data into database using datadapter.update method i ...
Score Loss of datetime precision when attaching parameters to an ADO.NET command
Chris Lacey - 23 Jun 2005 10:46 AM - 3 messages
Hi, I am encountering some strange losses of datetime precision when calling a stored procedure through ADO.NET.  I'm using ExecuteNonQuery in the Microsoft Data Access Application Block for .NET, which simply creates an ADO.NET command, and attaches each of the parameters, before calling ...
Score Dataset ambiguous error
tshad - 23 Jun 2005 5:07 AM - 3 messages
I am getting an error from defining my Dataset. The error is: BC30561: 'DataSet' is ambiguous, imported from the namespaces or types 'System.Data, DreamweaverCtrls'. I am using Dreamweaver, but am doing all the database functions by  hand. My function is: ...
Score DA Update Error
Steve B. - 23 Jun 2005 12:34 AM - 2 messages
I realize this is a broad ADO .Net question but i thought I'd give it a shot because i can't solve it When my DG opens and I select a row for deletion everything works fine.  If ...
Score FYI - Alternative DB engine for .net
David - 22 Jun 2005 9:13 PM - 2 messages
I found a alternative DB engine for .net suited stand alone apps that may not wish to use Jet or MSDE.  I have not used it so can not comments on stability. Comes with source code and a license to allow use in commercial ...
Score Help - MSDE or Jet for Stand-alone App,
David - 22 Jun 2005 7:32 PM - 4 messages
I am converting a older VB app to  .net.  The app currently strores info. Into a JET database.  As this is an end user app, I can not convert to SQL server, etc. so I need to use either the older Jet ...
Score SQL Server SPIDs
Jim - 22 Jun 2005 6:33 PM - 2 messages
Hello, I don't know much about SQL Server processes/SPIDs but everytime our web app creates a ADO.NET connection and closes it, the SPID is still hanging around in "sleeping status" well after it's closed in the ADO.NET code. ...
Score Database query performance
KDV - 22 Jun 2005 5:05 PM - 15 messages
I have a database table. The table has number of fields. Out of those fields one is Company and another is DateTime. The table has thousands of records. I want to get the most recent record for each company. In order to do that I am using the following query ...
Score ERROR [42724] - .NET to DB2 via Managed Provider
Frank Buchan - 22 Jun 2005 5:04 PM - 5 messages
The complete error is at the end of this cry for help. I've been tasked with hooking an interface in ASP.NET and a handheld (via web services) to an existing DB2 data store. The requirement for real-time ...
Score Huge data needs to be transfer from Fixed width Text File to SQL S
Permood - 22 Jun 2005 4:38 PM - 6 messages
Hi Experts, I have huge fixed width text files around 9GB or 60 TO 75 millions records. I need to transfer 300GB data from these Text files to SQL Server 2000 monthly bases. I am trying to develop VB.NET application. One problem is I ...
Score retrieve id when adding a new record in SQL
geodev - 22 Jun 2005 4:03 PM - 3 messages
Hello, I’m adding a record to a SQL database. One of the columns in the database generates a uniquely identifying integer when a record is added. I would like to retrieve this number when I add a new record to the table. By the way I do ...
Score Pivoting DataSet
Patrick - 22 Jun 2005 4:01 PM - 8 messages
I currently have from SQL a stored procedure that is vaguely doing something like: SELECT     FormName,     frmDueDate,     DepartmentName,     Country                 frmStatus ...
Score DataGrid control scrolling
KDV - 22 Jun 2005 2:38 PM - 3 messages
Can I programmatically control the scrolling of DataGrid control in Windows Forms. I have DataGrid control which shows hundred of rows. I want a way of scrolling the data grid to last row KDV ...
Score wizard-generated stored procedure for Null-Guid-Column
Gunnar Mohr - 22 Jun 2005 2:12 PM - 3 messages
Hi, - occurs with .Net 2.0 Beta 2 - I have a typed-DataSet and some DataAdapters to provide the tables for the DataSet. When I create the stored-procedures with the DataAdaper-Wizard for a table with a Guid column, which can be NULL, the Wizard generates a wrong ...
Score Poor DAB performance
DaveK - 22 Jun 2005 12:01 PM - 4 messages
I recently came across the Microsoft Data Access Application Block so I decided to try it out in a Windows forms application. Without using the DAAB, the following code, which creates a data reader which is then used to populate a combo box, takes 3 seconds to run: ...
Score Exception on SqlTransaction.Rollback(), BUT it doesn't
Thana N. - 22 Jun 2005 10:41 AM - 3 messages
Hi, My program injects message at the same time as SQLServer is backing up (full).  I write injecting module using Try...Catch block with SqlTransaction and using SP. Within Exception block I call Rollback() (it cautch timeout exception). I've ...
Score SQL CLR: which assembly to reference for microsoft.sqlserver.serv
Yushan - 22 Jun 2005 10:02 AM - 2 messages
I am trying to use objects (such as sqlcontext) defined in the microsoft.sqlserver.server name space, but couldn't find the right assembly to reference.   Does anyone know which assembly implements the classes defined in this name space? ...
Score Trying to find ClientID of web form - Solution Found
Neo Geshel - 22 Jun 2005 5:00 AM - 3 messages
After pouring over about a dozen sites that clearly dealt with ClientID all by itself, I came to the realization that about 2/3+ of them were doing it wrong. It is indeed impossible to grab the Client ID of a form ...
Score minumn and maximum
AAA - 22 Jun 2005 3:06 AM - 6 messages
what is the mininum and maximum value in SQL statement select * from table1 where field1 between "minumum" and "maximum" then it will show up all the value in table1 thank regards ...
Score Datasets and identities in ADO.NET 2.0
Massimo - 22 Jun 2005 12:26 AM - 5 messages
Hi to all, I'm developing a test application with Visual Studio 2005 Beta 2 and the 2.0 framework (along as SQL Server 2005 June CTP), and I'd like to know if they introduce some improvements in order to solve an old problem: ...
Score DataTable.Select method bug in .Net Framework 1.1 SP1
lynch - 21 Jun 2005 6:38 PM - 19 messages
Since Microsoft removed the original thread from this newsgroup... here it is again. Just to add some comments: we are MSDN Universal Subscribers and didn't get support from Microsoft. We are being ignored for almost 5 months. We have ...
Score TRANSFORM statements in ADO (Excel)
Rob Wills - 21 Jun 2005 6:21 PM - 3 messages
I require a report (in Excel) using data stored in Excel whcih uses the PIVOT/TRANSFORM SQL function.  I've attempted this in ADO as unfortunately the Pivot Table function in Excel doesn't appear to be able to support my ...
Score Delete DataView rows from DataTable (should be simple)
MattB - 21 Jun 2005 6:12 PM - 2 messages
I'm using vb.net, but if you only have a c# answer, feel free to offer it!. Anyway, I have a DataTable and a DataView which is a subset I have ID'd to be deleted from that DataTable. I tried looping through the DataView ...
Score ado.net unable to connect from Windows 2000 after SQL server Resta
Baz - 21 Jun 2005 4:34 PM - 4 messages
After restarting my SQl Server instance my ASP.net applicaions running on Windows 2000 are unable to connect to the SQL Server. My asp appplications are still able to connect The connection string I am using is user id=sa;pwd=????;data source=????;persist security info=False;initial ...
Score Is this a good application Design?
Jay Balapa - 21 Jun 2005 3:00 PM - 51 messages
Hello, Currently  my application has three tiers- 1. Presentation Layer (Asp.Net  / Win Forms/ Pocket PC UI.) This predominantly contains User Controls, Custom Controls and  Win/Web Forms. I have one base form and I inherit from that form. ...
Score Oracle and .NET stored procedures returning dataset...
Ricardo Magalhaes - 21 Jun 2005 2:57 PM - 5 messages
Hi, How can I return a DataSet from oracle stored procedure(that returns for example, the customers from Brasil) to my ASP.NET application In Sql server is easy.. and seens like this: ------------ into sql Procedure SP_cursos (@categoriaID Int) As ...
Score Problem with varcharData
Alessandro - 21 Jun 2005 2:10 PM - 2 messages
Hi ! I have problem to extract data from a DB when there is a filed "Varchar" with more or equal to 1000chars ! I don't understand why ! I add parameters like:                     prmOleDb = New OleDbParameter() ...
Score view vs sproc
Niño - 21 Jun 2005 11:24 AM - 5 messages
i have a query containing inner joins....i use it to populate my truegrid. which better way of executing my query? make a view of it or make a stored procedure of it? im using a dataset and dataadapter to populate a datatable to be bind as the ...
Score sql group problem
steve - 21 Jun 2005 10:04 AM - 2 messages
Hi All Using VB.net 2003 and ADO.Net with MS Access 2003 database I want to retrieve records grouped by time, but grouped within 1/2 hour increments The program is for a gym membership and I display graphs of the number of ...
Score CancelCurrentEdit doesn't
TLWood - 21 Jun 2005 8:38 AM - 6 messages
Hi Using Windows.Forms in ADO.NET in VB.NET 2003. I have 3 dataviews of the same datatable in a dataset, each a subset of the datatable by means of rowfilter. for example: Me.dv1 = New DataView(myDataTable) Me.cm1 = Me.BindingContext(Me.dv1) ...
Score OleDb: Get Properties
Armin Zingler - 21 Jun 2005 8:36 AM - 6 messages
Hi, how can I get properties in ADO.Net? I read about it in the OleDB documentation (Chapter 14: properties) but I can not find out how to get them in .Net using an OleDBConnection. Any ideas? I searched "everywhere" ...
Score Cloning Datasets but also filtering
Daren Hawes - 21 Jun 2005 3:39 AM - 4 messages
Hi, I have 2 Datasets with 20 tables. Ones called Surveys and the other SingleSurveys. Surveys contains ALL survey data (IE SurveyID = 1,2,3,4,5......).  All tables have related ID field (IE SurveyID on each table) I need to copy over to SingleSurveys only one survey data (IE SurveyID = 12) ...
Score dataset merge with itself
Robin - 21 Jun 2005 1:30 AM - 2 messages
I am trying to create a dataset with multiple records that hold identical data by merging a dataset with itself. I don't think this will work and I am looking for other solutions. For example, a dataset has a parent table called CATEGORY and a child table ...
Score Operator '=' on System.DateTime and System.Double
googlegroups - 20 Jun 2005 11:08 PM - 17 messages
I'm developeing a small app based on the Visual Studio Beta 2 and the DataGridView. I'm trying to add a new row to a datatable programmatically and I keep getting a strange error about not being able to use the '=' operator ...
Score from mm/dd/yyyy to yyyy/mm/dd
Asif Qureshi - 20 Jun 2005 1:18 PM - 7 messages
The date in my application is in mm/dd/yyyy format which i use in query to access data from a mini system on network having data in yyyy/mm/dd format.How can i change my date into yyyy/mm/dd format in query to get ...
Score sqltransaction
Niño - 20 Jun 2005 7:08 AM - 10 messages
im updating a header and detail table with an update constraint. sqlcmd1 is used to update header, sqlcmd2 is for detail. both cmd runs in one sqltransaction. my problem is my second sqlcmd catches a constraint error when updating the ...
Score Question regarding DataRowView.RowFilter
Stuart - 20 Jun 2005 6:53 AM - 3 messages
Hi There I am having trouble with the DataRowView.RowFilter I am giving subscribers to an asp.NET application the ability to search through a large group of historical records based on a "Subject" field. They have a textbox (txtSubjectCriteria) within which they enter search ...
Score Return values from SQL compute commands
John Dann - 19 Jun 2005 2:26 PM - 3 messages
I have a vb.net program that runs summary commands on columns of a data table. So eg I have a couple of lines of code: MyValue= DataTable.compute(computestring, Nothing) where eg computestring="MAX(" & columnname & ")" Occasionally it happens that the column is full of DBNull.Value ...
Score System.InvalidOperationException: ExecuteReader
Negri - 19 Jun 2005 1:29 PM - 24 messages
Hi, I have a little application coded with .net 1.1, my problem is that this application worked fine in W2000. But the client change to XP, and from that get this error. This problem show when try to read from a table of Access XP. ...
Next » 2 3 4 5 6 7 8 9 10