Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score Image upload FREE
Picica - 5 Nov 2005 12:03 PM - 1 message
Upload your image free! send blank message to sa***@lpi-hk.com to get access. ...
Score Image upload FREE
Picica - 5 Nov 2005 12:03 PM - 1 message
Upload your image free! send blank message to sa***@lpi-hk.com to get access. ...
Score free world sms
Fesstica - 5 Nov 2005 10:48 AM - 1 message
Free SMS send all over world send blank message to sa***@lpi-hk.com to get access. ...
Score free world sms
Fesstica - 5 Nov 2005 10:48 AM - 1 message
Free SMS send all over world send blank message to sa***@lpi-hk.com to get access. ...
Score How to attach mdf in a relative directory
ad - 5 Nov 2005 10:46 AM - 2 messages
I use asp.net 2.0 and SqlServer 2005 Express to develop my Web application The database file of my applicaiton is "db.mdf", I put it in  "myDB" directory under the application folder. I want to attach the mdf file when application start. How can I do that? ...
Score Datarows without datatables ?????
Al Christoph - 5 Nov 2005 8:37 AM - 5 messages
have the need for a data structure to have the clone / copy / independent hunk of memory with the original values (take your choice) of a row in a datatable. I don't see a data.datarow.clone or data.datarow.copy NOR a way of ...
Score DbDataReader.Read() result
David Thielen - 5 Nov 2005 2:18 AM - 3 messages
Hi; The docs for this say "true if there are more rows; otherwise false." The way that is written says that there is a row after the row it is now on. But the way it appears to work is when it returns false, you are now past ...
Score DbDataReader numRows?
David Thielen - 4 Nov 2005 9:16 PM - 7 messages
Hi; Is there a way to get the number of rows a DbDataReader has? ...
Score Loading Data
Giovanni - 4 Nov 2005 8:23 PM - 1 message
Hi All,      Need help with the following (VS 2005 Beta 2, .NET 2.0):      I am using the new Data Sources window to drag and drop fields from a parameterized stored procedure (Proc1) onto a Windows form.  For some ...
Score Store Value from Data Repeater
Christine Y. - 4 Nov 2005 8:13 PM - 2 messages
I'm using a data repeater to get ID values from a simple table in my database and display them on my .aspx page (this is working): <ItemTemplate> <tr> .... <td><%# DataBinder.Eval(Container, "DataItem.MyID") %></td> ...
Score get table structure
Jaime Lucci - 4 Nov 2005 7:47 PM - 4 messages
Hi everyone! I need to get a table structure from a SQL Server. I mean the full design of the table with all tis properties and its fileds properties too. For example, an integer field, its max lenght, if it is an identity, etc. I ...
Score OdbcConnection - Querying MySql tables using date parameters
Ben Fidge - 4 Nov 2005 7:11 PM - 6 messages
Hi I'm trying to query a MySql database using OdbcConnection. My query looks like so: select Count(*) from Table1 where BookingDate = @Date I'm using an OdbcParameter set up as such: OdbcParamter oParam = oCmd.Parameters.Add("@Date", OdbcType.Date); ...
Score Cor L. Testing Cross-Post (again)
Mark - 4 Nov 2005 7:08 PM - 3 messages
Guessing at what the "USENET designation" is: microsoft.public.dotnet.languages.vb Let's see if that works. ...
Score Cor L. - Testing Cross-Post
Mark - 4 Nov 2005 6:57 PM - 5 messages
Just testing the Cross-Post option Thanks, Mark ...
Score wow, this is a good one :(
Steve - 4 Nov 2005 5:11 PM - 4 messages
Single call to ExecuteNonQuery() with "EXECUTE MyAccessQuery" creates 86 new, identical records. Here is the code from the Access Query <AccessQueryCode>     INSERT INTO Tbl_ProtocolSegments ( ProtocolID, FreqBStart, FreqBEnd, DurationSec, [Count], AmplitudeRampID, OpCode )     SELECT [_protocolID] AS Expr1, [_freqBStart] AS Expr2, [_freqBEnd] AS ...
Score Deleting XML Record from Dataset removing table?
John - 4 Nov 2005 5:07 PM - 2 messages
Hi All, When I delete the last record from my dataset and then WriteXML() to the file; the Table itself, in the xml file, is removed.  I need to prevent the table structure from being deleted if there are no more records to be ...
Score Query: Timeout depending on number of rows retrieved
alex.vezeau - 4 Nov 2005 4:48 PM - 2 messages
I have a query: select * from projet where prcleunik between 70 and 110 Runs fine from all workstations and/or servers. If I change the between statement to: select * from projet where prcleunik between 30 and 110 It runs fine from all workstations and/or servers EXCEPT from our web ...
Score Question about new SqlDataSource class
Benton - 4 Nov 2005 4:25 PM - 3 messages
Hi there, I'm learning about ASP.NET 2.0 databinding and see that this class is heavily used for this purpose. I don't use MS SQL Server, so my question is if a derived/compatible class should be included on the .NET provider for the database I use, or if I as ...
Score DataTable Compute Method
Andreiwid - 4 Nov 2005 4:18 PM - 2 messages
Hi! There are 3 DaTables in my DataSet, which 1 is the Master and 2 are Children. I've set the relations and everything is working fine. But when I try to use the Compute method I receive a strange error and I can't find the ...
Score MDAC 2.8
Mark - 4 Nov 2005 3:19 PM - 2 messages
We have a production server that hosts numerous ASP.NET 1.1 web applications, as well as several ASP applications.  It currently has MDAC 2.6 installed.  A new product we are installing requires MDAC 2.7 or higher. ...
Score Sharing connection between threads
koltti - 4 Nov 2005 1:38 PM - 7 messages
Hello, Is it possibility to share connections between threads using ado.net pooling system? I'm using remoting and I want that clients can share connection by using ado.net pooling system. It seem that thread will not release connection to pool when connection is closed(Close() method called) or ...
Score SQL Server Connection pool limit?
Valerie Hough - 4 Nov 2005 12:36 PM - 5 messages
If I'm using connection pooling in my application, is there some way I can tell if there are no more connections available? Can I control the number? Are there performance implications ? Thanks in advance. Valerie Hough ...
Score SqlDataAdapter: Connection closed on exception?
Pieter - 4 Nov 2005 12:05 PM - 3 messages
Hi, An SqlDataAdapter always opens its Conection and closes it automaticly. But does it Close the connection also when an exception occured? I tried to test it, and the connection was everytime closes, but I don't knwo if this would happen with every type of exception... I googled around ...
Score OleDbDataAdapter Update command updates unmodified rows also
Sek - 4 Nov 2005 11:37 AM - 3 messages
Hi Folks, I am using OleDb in ADO.NET to update a mdb file. I open the db, read the table into a dataset. Map the dataset to a dbgrid. Make changes in dbgrid and try to save the changes to the same mdb ...
Score Timeout on commit during backup sqlserver
rafaelgaucho@gmail.com - 4 Nov 2005 11:26 AM - 3 messages
Hello, During sqlserver2000 backup, I try to insert a record with transcation, but on .commit() are throw timeout expired exception. Anybody help me? ...
Score Quick Question - Updating Bound Dataset
uAsking - 4 Nov 2005 11:11 AM - 1 message
Hi I'm building a distributed application using remoting in a small company. The client side has a dataset (a local cache) which is bound to a third party grid control. The server fires events to each of its clients with updates for ...
Score How to change rowstate of DataRow
ad - 4 Nov 2005 6:17 AM - 2 messages
When we create a DataSet by Select command like: //--------------------------------------------------------------------   SqlCommand myCommand = new SqlCommand("SELECT * FROM Suppliers",       myConnection);       myCommand.CommandType = CommandType.Text;       myAdapter.SelectCommand = myCommand; ...
Score Iterating through selects - what is the best approach?
David Thielen - 4 Nov 2005 4:51 AM - 10 messages
Hi; I am porting some code (from java) and I need to do the following on SQL databases: I am passed the DbConnection object so I only have the one connection. Call a select to return a list of rows. ...
Score Multiple active readers on one connection?
David Thielen - 4 Nov 2005 4:39 AM - 5 messages
Hi; For a single DbConnection, can I call DbCommand.ExecuteReader() for several selects and then for each reader call Read() and iterate through the rows. I have a situation where for my outer reader, for each row I need to call a ...
Score DbDataReader.previous()
David Thielen - 4 Nov 2005 4:27 AM - 4 messages
Hi; In .net 2.0 I need the ability to not only get the next row in a result set, but also the previous. Is there a way to do this in .net? (Similiar to the JDBC ResultSet.previous?) ...
Score Error Trying to add table to dataset
Mark - 4 Nov 2005 3:50 AM - 5 messages
I'm trying to add a table to a dataset but get the error:      "A DataTable named 'BordDates0040' already belongs to this DataSet." Code:             Dim dtBordDates As DataTable ...
Score Database Connections
nbohana - 4 Nov 2005 2:33 AM - 4 messages
I have MSDE running on one of my computers, along with my windows application. this.cnKennel.ConnectionString = "Data Source=(local)\\NetSDK;packet size=4096;integrated security=SSPI;"persist security info=False;initial catalog=kennel";. If I point the data source at the computer it works. Is there a way to use ...
Score Bypassing update of a field
howard39@nospam.nospam - 3 Nov 2005 11:47 PM - 4 messages
My data access layer fills a table in a DataSet using an SqlDataAdapter. Then it makes changes in some of the fields. Then it creates an SqlCommandBuilder to get the UpdateCommand and calls SqlDataAdapter.Update() to update the changes to the SQL database. ...
Score multithreaded grid-binding problems
Daniel Serra - 3 Nov 2005 11:24 PM - 7 messages
Hi there (sorry for the cross-post), I have a problem that I am not sure quite how to resolve. I have a series of datasets, with grids being bound to any one of the datasets. These datasets can get updated quite frequently (upwards of 10-20x per second, sometimes ...
Score Problems with Session variable
vvenk - 3 Nov 2005 9:35 PM - 3 messages
Hello: I just wrote my first ASP.Net application, tested it on my development environment and deployed it on a production server. That's when I encountered a problem. In my Global.ASCX, I have coded the Session_Start event 1. I read Request.ServerVariables("Auth_User") ...
Score Newbie:Storing .NET datatypes in disconnected ADO.NET tables
Navin Mishra - 3 Nov 2005 8:25 PM - 4 messages
Hi,   I am storing .NET datatypes like Hashtable, ArrayList and other .NET custom classes in disconnected ADO.NET tables. Some questions: 1) Do I need to still synchronize access to the stored ArrayList, Hashtable, etc. ? Are they stored by value in table colums or still reference to ...
Score Determine if connection is from pool or newly opened
stephen_barrett - 3 Nov 2005 6:49 PM - 1 message
We are using Oracle for our backend database.  We now have a need that whenever a new connection is made to the Oracle database from our app, we have to call a package function that is basically setting a ...
Score Determine if connection is from pool or newly opened
stephen_barrett - 3 Nov 2005 6:48 PM - 1 message
We are using Oracle for our backend database.  We now have a need that whenever a new connection is made to the Oracle database from our app, we have to call a package function that is basically setting a ...
Score filling dataset with Sybase stored procedure
VMI - 3 Nov 2005 5:12 PM - 5 messages
Hi, How can I fill my dataset with a call to an SP created in sybase 11.5? The SP queries several tables and dumps the resultset in a #temp_table.  What would I need to do in my SP to transfer that data to ado.net? ...
Score Dataset Comparison, Connection to Excel and SQL Sever
rpoole - 3 Nov 2005 3:26 PM - 1 message
Dataset Comparison, Connection to Excel and SQL Sever Problem, mind is a blank to the best way. Overview: Importing Excel data into VB .Net Application using JET and Dataset. Compare Excel Dataset with SQL connection dataset to select invalid orders before updating the SQL connection with the Excel Dataset. ...
Score Getting sheet names from excel without named ranges.
Joe - 3 Nov 2005 3:24 PM - 2 messages
Is there a way to specify only table (sheet) names without getting the named ranges? oleDbConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] {null, null, null, "TABLE"} ); I haven't been able to find anyway to distinguish between the two. Thanks, Joe ...
Score How to Insert a whole dataset into database
ad - 3 Nov 2005 2:55 PM - 14 messages
I use WebService upload a dataset to server. There is only one DataTable in the DataSet. I want to insert all rows of that DataSet into SQL Server 2005. Is it necessay to insert rows one by one into database? ...
Score Access database Memo data types
Sanjib Biswas - 3 Nov 2005 2:37 PM - 3 messages
Hi,     I am trying to add record (INSERT INTO...) into a Memo field in the access database. But the ExecuteNonQuery() throws an exception. "Syntax error (missing operator) in query expression "<field value>"". Also note that <field value> is a string and has apostrophes in two places. For text ...
Score Connection string information
Francois Malgreve - 3 Nov 2005 12:09 PM - 10 messages
Hi, I would like to know how I can do to retrieve the user and password from a connection object. All i see from SQLConnection is that i can access the connectionString but I need to be able to access the specific user and password for that ...
Score updating database from collection
vinutha - 3 Nov 2005 11:51 AM - 2 messages
hi,         I am using access as database ,and filling hashtable with records  from a table.          On editing this collection i want to update the records in datable . ...
Score ASP.NET 2 Features for Users and Passwords and Tree Controls
Siegfried Heintze - 3 Nov 2005 12:51 AM - 2 messages
I recall there is a new feature in ASP.NET 2 that makes the implementation of forms based authorization and authentication a lot easier. What is the name of this feature? Is it a feature of VS2005 or the framwork? ...
Score Access Query OleDbParameter problem
Steve - 2 Nov 2005 9:27 PM - 3 messages
I have an update routine that fills a OleDbCommand.Parameters collection with 16 values.  The last one is the criteria for the update.  This worked fine until I added the 14th and 15th parameters and now I get an exception: ...
Score Intermittent SQL Server does not exist or access
roxy636 - 2 Nov 2005 8:04 PM - 5 messages
ASP.NET application with intermittent returns of 503 errors with the following message: System.Data.SqlClient.SqlException: SQL Server does not exist or access denied. SQL Server does not exist or access denied. An unhandled exception was generated during the execution of the ...
Score Databinding and editing data on another form
Matt A. - 2 Nov 2005 7:05 PM - 1 message
I'm having some difficulty wrapping my hands around a problem I am having.... Here is the situation, I'll use the classic "Customers / Invoices" example to explain it.  I'm displaying a list of customers on a form ...
Score Memory usage increases with ADO.NET v2.0 RTM
Stuart Carnie - 2 Nov 2005 6:10 PM - 9 messages
Firstly, the index performance improvement is awesome, I've seen a 75x improvement in test cases. Using the RTM version of Whidbey and the code from November 2005 MSDN article ([link]), I ...
Score specified cast is not valid, again!
Patrick Sullivan - 2 Nov 2005 5:39 PM - 3 messages
Hi, I get a "specified cast is not valid" when the "cboContactName_SelectedIndexChanged" tries to put a new value into the txtCompany textbox. I am using relations in this and have not used them much before. I was getting an error before this one that complained about no ...
Score IIS, WS2003, ADO.net and network drives
jem777 - 2 Nov 2005 3:04 PM - 3 messages
Weird! I am opening an MS Access database using an OleDbConnection. The system: 1) Windows Server 2003 (with latest patches) 2) .NET framework 1.1 3) R: is a mapped network drive. From a web page I try to open the connection to the Access db using this ...
Score How to change a value inside a data column???
Jon S via DotNetMonster.com - 2 Nov 2005 10:28 AM - 3 messages
Hi all, If the dcSource.ColumnName == 'Text' then I would like to change the contents of drSource[dcSource.ColumnName].  How would I do this?  I know I could use the ToString() method on the drSource[dcSource.ColumnName] to return a value ...
Score Not associated with a trusted SQL connection???
Andrew - 2 Nov 2005 4:55 AM - 9 messages
Hi, friends, When I used ADO.Net to connect to our SQL Server, I got the error saying: Login failed for user 'mscn'. Reason: Not associated with a trusted SQL Server connection. What did this mean? I created this user for msc database already! And the ...
Score SQL Server End User Problem
Lyners - 1 Nov 2005 10:17 PM - 4 messages
I have an ASP.NET Site. My Web Server is a Windows 2003 Server, My SQL Server 2000 runs on another Windows 2003 server. I setup the website so that the connection statement would be in the web.config file (with a generic userid ...
Score Make DataTable from Clipboard.GetObject, possible?
DapperDanH@nospam.nospam - 1 Nov 2005 9:47 PM - 3 messages
Is there a way to make a DataTable from the Clipboard?  Anyone have sample code or project? Thanks Dan H. ...
Score How To Clear "Open Existing Projects" Listing?
Mr. B - 1 Nov 2005 8:40 PM - 6 messages
I have VB.net 2003 and I am wondering How (if possible) can I clear out the current listing of my OPEN AND EXISTING PROJECT list when I first start up VB.net? I currentl show 10 such projects.  I've tried to only show 1 then change back ...
Score Asynchronous dataset reading
Valerie Hough - 1 Nov 2005 8:13 PM - 4 messages
Hi, I am debugging an application which uses C# with .NET v1.1. It attempts to implement asynchronous dataset retrieval by using separate threads and synchronizing them with the UI form. Recently the application is having some problems whereby it is crashing with a "General Network Error" and a call ...
Score Unable to connect to Visual Foxpro DBC from .Net
HaySeed - 1 Nov 2005 6:58 PM - 4 messages
I am unable to establish a conection to a Visual Foxpro 9.0 DBC from inside of .Net 2005. I have downloaded and installed the latest VFPOleDB driver. Is there somnething missing in my code? string connectionString = @"Provider=VFPOLEDB;Data ...
Score Problem opening excel spreadsheet using oledb
Bill Youngman - 1 Nov 2005 5:42 PM - 1 message
I am writing a web application as a administrative front end to a document management system. One of the functions that I am developing is the ability to import new users into the system via an Excel spreadsheet. The specific ...
Score OLEDB ODBC connection string component, does it exist?
DapperDanH@nospam.nospam - 1 Nov 2005 5:10 PM - 2 messages
We have internal software that knows how to do some work on a ADO.NET Dataset.   We are looking for a component that can visually walk the user through setting up either an OLEDB or ODBC connection string.  Ideally, but ...
Score create datatable from array of objects?
hazz - 1 Nov 2005 4:34 PM - 5 messages
How can I do that? Thank you. -hazz ...
Score Trapping error in DataAdapter.Fill(ds)
Rick - 1 Nov 2005 3:23 PM - 5 messages
I use a DataAdapter (.Net 1.1) to fill a dataset of about 30 tables using a stored procedure.  One of the tables is throwing a constraint error, and I'd like to figure out which one.  Can't debug through the ...
Score Sum 3 column values in a DataTable
Codex Twin - 1 Nov 2005 3:22 PM - 2 messages
I have a DataTable, of which the data looks like the section below: Month Year Fish  DataValue ---------------------------------------------------------------- 1    2005    Salmon    578.00 2    2005    Salmon    764.00 ...
Score SQLDatareader field length
banana boy - 1 Nov 2005 1:56 PM - 2 messages
Could someone tell me if it is possible to get the length of a field retrieved with the sqldatareader ...
Score large dataset!
Francois Malgreve - 1 Nov 2005 11:19 AM - 4 messages
Hi, I am using .NET 1.1. I have a windows application that imports large excel file (can be up to 60.000 rows) into a dataset, transforms the dataset and  need to save that dataset into an SQL Server 2000 DB. ...
Score How to explicit trap a Time Out exception?
Mario - 31 Oct 2005 10:26 PM - 2 messages
It seems to me that a "time out" exception is a fairly routine exception that can occur either when I'm reading from or updating to a database.  That said, it's a bit curious that there is no built-in ...
Score DataSet to Access Database
Sanjib Biswas - 31 Oct 2005 7:49 PM - 8 messages
Hi,    I am new to VB.Net and was wondering is there any easiest way to create and update an Access Database (.mdb) with the DataSet that I have populated from ReadXml(). Basically, I don't want to manually create each table from ...
Score Datarelation handling
Rob W via DotNetMonster.com - 31 Oct 2005 6:02 PM - 6 messages
Hi I've created a datarelation between two tables in a dataset which works fine. What I need to be able to handle is if there are entries in the child table that don't match those in the parent then ignore them (the children). ...
Score Conversion from type 'SqlInt32' to type 'Integer' is not valid
Greg Burns - 31 Oct 2005 5:55 PM - 3 messages
I have a lot of autogenerated code (created from LLBL Gen, [link])  that looks similiar to this: Dim _errorCode As SqlInt32 .... _errorCode = New SqlInt32(CType(cmdToExecute.Parameters.Item("@iErrorCode").Value, Integer)) I am upgrading my project to VS 2005.  Now, when this code executes I am ...
Score newbie - get value of field from datatable syntax
Steve - 31 Oct 2005 3:38 PM - 3 messages
I have a datatable containing 1 row and a few columns. I simply want to retrieve the value of the 'nameid' column and store it as an integer in a variable. Dim data As Data.DataTable data = MyObject.MyMethod(parameter) 'Returns 1 row with several columns ...
Score SqlDependency minimum permissions
Michael Vanhoutte - 31 Oct 2005 3:01 PM - 1 message
The blog entry posted by Sushil Chordia at [link] describes the minimum requirements a Sql user should have for SqlDependency to work. I have tried to apply them, but I still have some problems. ...
Score Master/Detail DataSet and DataBindigs - applying RowFilter
Andreiwid - 31 Oct 2005 1:08 PM - 3 messages
Hi friends! I've a DataSet with 2 tables inside. The relation and mappings between both are set and ok. I need to create a Master/Detail datagrid based on DataBindings. 'DataGrid1 shows the Master view and TextBox1 shows one field's content, as ...
Score Concurrency exception when calling a teradata storedproc
Ali - 31 Oct 2005 12:10 PM - 3 messages
Hi I have a C# app that uses a dataadapter to update a table in a teradata datawarhouse. It performs an update using a teradata stored procedure. In teradata, stored procs dont actually return the number of rows updated but ...
Score Checking the database has a password???
Jon S via DotNetMonster.com - 31 Oct 2005 10:25 AM - 5 messages
Hi all, I'm producing a database connection string but I need a way to establish if the database has a password or not.  There are two versions of the database I'm opening, the first doesn't have a password and the second does.  So if ...
Score How to export DataTable to SQL Server when the SQL table doesn't exist
gradx7 - 31 Oct 2005 3:45 AM - 1 message
I've seen a few posts about this and I had to write a function to do it so I thought I'd share.  (It uses ODBC cause that was the requirement I had for a small job): public class TableExport ...
Score How to obtain the list of all tables?
Georges Bessis - 31 Oct 2005 12:42 AM - 5 messages
Easy in DAO but can't find a way with ADO.Net : How to obtain the list of all tables (names) of an Access Database in VB.Net? Thanks in advance. GB ...
Score ADO.net and VC++.net 2005
Maileen - 30 Oct 2005 6:33 PM - 2 messages
Hi, I'm writing a VC++.net 2005 application and i would like to use the ODBC connector. I would like to allow user to choose the DB he wants to have (MS SQL, PostgreSQl, MySQL, Oracle,...) by choosing the write ODBC driver. ...
Score Get the 100 XXX first and after whait on background for other record?
mtcc - 30 Oct 2005 1:57 PM - 2 messages
in MSAccess run a query return very first record, and after continue whaiting for other record on background. have easy way to get it on ADO.NET 2 + SQL2005 ? ...
Score Writing ADO custom providers
Mark - 30 Oct 2005 11:56 AM - 10 messages
Hi, We have a DOS based ISAM style database format and need to access this data via ADO. Can anyone point me toward information that will help me write an ADO data provider so that we can access this information using ADO.NET? ...
Score Transactions and Referential Integrity
Roger Rabbit - 30 Oct 2005 1:46 AM - 2 messages
Hello, I have a simple problem that involves an Order and OrderDetail table.OrderDetail requires an Order Id to be present in Order i.e. ref integrity prior to record insertion. Using transactions to ensure that i dont end up with only order stubs and no ...
Next »