Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score Update Access DB from a Data Grid
Stephen Plotnick - 30 Sep 2006 2:16 PM - 1 message
I have a data grid with three columns Text1, Text2, Bool3. I would like to have the user check/uncheck in Bool3 column and automatically update the Access DB. One other thing I have Text1 and Text2 and readonly and the user can only ...
Score Async Ado.Net Operations (Begin/End OpenConnection)
Chris Mullins - 29 Sep 2006 8:29 PM - 2 messages
We're building high performance database applications, and are trying to use all the new Async ADO.Net 2.0 features. The problem we're having is that we can't find a SqlConnection.BeginOpen/EndOpen method. We can execute everything using the ...
Score ADO.NET 2.0 Asynchronous Command Execution: Independant of Web Session?
amy.yerks - 29 Sep 2006 5:34 PM - 6 messages
I have a small ASP.NET 2.0 application that needs to be able to kick off a long stored procedure (for importing and processing tables ) and then allow the user to continue with the session, perform other tasks, and log out without having to wait for the SP to complete. I read the ...
Score Getting Oracle Error
sjoshi - 29 Sep 2006 4:19 PM - 2 messages
Hi I'm trying to run a queries on a schema, and I keep getting ORA-00911: invalid character error. If I copy/paste it in SQL/Plus it runs fine. This is what I'm doing in code: //Set session here to ZGK037_MDB ...
Score TableAdapter vs DataAdapter
s.bussing - 29 Sep 2006 3:45 PM - 5 messages
Hi, I was wondering when to use TableAdapters (TA) and when to use DataAdapters (DA). If I've got a typed dataset containing multiple related tables, I would say use a DA to fill the dataset. Why should I use TA instead? I can ...
Score Casting - IDataParameter
Doug - 29 Sep 2006 2:29 PM - 4 messages
Is there some way to cast a IDataParameter to a SQLParameter?  It's not working and I'm not sure why. ...
Score xmltype oracleclient
Sal - 29 Sep 2006 2:17 PM - 3 messages
Hi - Does anyone know if the xmltype oracle column data type is supported in system.data.oracleclient? ---------------- Sal ..NET 2003 Oracle 9i ...
Score Connection pooling parameters not working for Oracle connection
yoram.ayalon@structuredweb.com - 29 Sep 2006 1:34 PM - 2 messages
I am using OracleConnection to connect to Oracle 9i Database from a VB.NET project  the connection string has the parameters "User ID", "password", and "Data Source". my project import System.Data.OracleClient I tried to add connection pooling parameters like "Connection Timeout", ...
Score Export Table to dBase 3 (.dbf)
Stephan Zaubzer - 29 Sep 2006 12:25 PM - 6 messages
Hi! Does anybody know the best way how to export a DataTable to a dBase 3 file? Regards Stephan ...
Score InvalidOperationException when changing value in XmlDataDocument
Bjørn Terje Svennes - 29 Sep 2006 8:37 AM - 1 message
I'm using a XmlDataDocument to interface a DataSet. When trying to change the value of a node (I'm actually using InnerXML) I get an InvalidOperationException saying "Please set DataSet.EnforceConstraints == false before trying to edit XmlDataDocument using XML operations.". Is it not ...
Score Remove association between DataSet and XmlDataDocument
Bjørn Terje Svennes - 29 Sep 2006 8:16 AM - 1 message
I have a DataSet that is not cleared untill the application is closed. But I want to associate a XmlDataDocument to the DataSet several times. If I try this I get an ArgumentException saying that a XmlDataDocument cannot be associated with a DataSet that already has an association. How do I remove ...
Score What happened to SqlConnection.BeginOpen?
Chris Mullins - 29 Sep 2006 1:42 AM - 9 messages
We're building some very high performance database applications, and are trying to use all of the new Async ADO.Net 2.0 features. The problem we're having is that we can't find a SqlConnection.BeginOpen/EndOpen method. We can execute everything using the ...
Score Oracle connection error when called from web service
chandra82_tech - 29 Sep 2006 12:17 AM - 1 message
Hi, I'm having a web service which connects to a Oracle database and gets the results. When running the web service individually the database gets connected and the results are downloaded. I'm calling the same web service from another web service, the Oracle connection is not made, it ...
Score Executing an sql script on a remote database from Visual Studio .NET 2005
Nathan Sokalski - 28 Sep 2006 9:09 PM - 5 messages
I am connecting to a remote SQL Server database from Visual Studio .NET 2005. I have an sql script located on my machine containing the sql code I want to use to create several tables, and want to execute it. How can I do ...
Score Query works in Query Analizer but not as part of a table adapter
Tom - 28 Sep 2006 8:42 PM - 4 messages
I'm trying to run a query to return all of the customers who have not placed an order.  This query runs fine in Query Analizer but when I try to run it as part of a table adapter it returns all rows (customers with orders AND ...
Score DataBindings : wrong data displayed
Guillaume JAY - 28 Sep 2006 10:08 AM - 3 messages
Hello, I'm using databindings to display data from a datatable. When I first fill my datatable, it works perfectly, and displays the current data. If I remove the datatable, and recreate it with new data, it's not working anymore : the displayed data are from the first fill of the ...
Score Creating dataset.xsd file programmatically as dragging table from Server explorer fails
Chukkalove - 28 Sep 2006 9:55 AM - 2 messages
Visual studio 2003, MySQL database, MySQL odbc 3.51 driver Is it possible to create the file dataset.xsd programmatically? I'm trying to create my dataset1.xsd file for using with crystal reports. The database is mySQL and the data connection is sat in my server exporer ...
Score ado & Active directory
km - 27 Sep 2006 10:01 PM - 5 messages
I am using ado to connect to active directory in a web application. I create the command:     objConnection = new adodb.connection     objCommand = New adodb.Command     objConnection.Provider = ADSDOObject     objCommand.Properties("Page Size").Value = 1000 ...
Score DTSWizard
Joe - 27 Sep 2006 9:58 PM - 8 messages
Are there any tools around similar to MSSQLs DTSWizard for importing data into a DataTable? The DTSWizard has many nice features which I would hate to recreate if it's already been done. Thanks, Joe ...
Score How do I connect to SQL database using applicaiton roles and ado.net?
Ken Varn - 27 Sep 2006 9:48 PM - 4 messages
My MSDE database uses Application Roles.  When I run my asp.net application I cannot open the database, I get a Logon Failed exception.  I need to be able to open the DB to run the sp_setapprole stored procedure for my role ...
Score Trapping for Connection and Command Timeout
RMB - 27 Sep 2006 9:04 PM - 4 messages
FW: 1.1 What is the best method for trapping timeout exceptions?  There does not seem to be specific exceptions thrown for connection or command timeout.  Should I check the message for "Timeout", or is there some other propery in ...
Score SQL Question
Paul - 27 Sep 2006 3:23 PM - 4 messages
Hello: I have a SQL question. If this is the improper board to post this question on, please let me know where you would suggest I post it. I have a SALES table with the following schema and structure. ID      Status     Date ...
Score pStartInfo in C#.Net
cu.4m.srinivas@gmail.com - 27 Sep 2006 2:01 PM - 2 messages
Hi all, I want to do the foll. I want to get the process running in the name system, with name "abc", and in turn get their arguments, so that i do some processing later Foll. is my code: Process proc = new Process(); ...
Score Using crystal reports with MySQL ADO connector
Chukkalove - 27 Sep 2006 1:44 PM - 5 messages
I am a developer with limited database and zero crystal report experience. I am very confused. We wanted the ability to switch database providers easily, so I selected to use ADO components with our application. The database we're developing with is MySQL. I downloaded their MySQL ...
Score How to keep ALTER SESSION settings
sjoshi - 27 Sep 2006 1:30 PM - 1 message
Hello All I'm trying to execute queries on a specific schema using ALTER SESSION as string sqlSession = string.Format("ALTER SESSION SET CURRENT_SCHEMA={0}", oDB.DatabaseName); MiscDataUtils.ExecuteNonQuery(sqlSession, oDB.Connection); //Change Session Here //However this one fails since this is another connection ...
Score Non English Characters
saygin - 27 Sep 2006 12:53 PM - 5 messages
Hi, We are developing a small web interface to a local ERP software, which uses SQL Server 2000 as database. The database uses SQL_Latin1_CP1 collation, and the fields are varchar (not nvarchar), however, the main program inserts and reads non-English (Turkish) characters into these ...
Score Corrupted TableAdapter
Pershing - 27 Sep 2006 12:13 PM - 4 messages
I have this a Data Set. In that data set I have three table adapters, each has there own queries. For some unknown reason, after I added two new fields to the database and mofified the store procedure to retrieve the new fields, in addition too the ...
Score db2 commands on .net
esamanli - 27 Sep 2006 11:31 AM - 2 messages
hi, i'm using db2 v8.2 and .net 2005. i'm trying to execute db2 commands but i can't . forexample, i can't get list of aliases or i can't create a new database. how can i solve this problem? ...
Score Problem with proc.kill()
cu.4m.srinivas@gmail.com - 27 Sep 2006 9:14 AM - 2 messages
Hi, My case is, i am trying to kill a process (SQLPLUS process) in my Win. Service, when either the Service is stopped or when my app exe is killed from the Task Manager. The problem is, when i kill the SQL process, its not getting killed, ...
Score CommandBuilder and Identity Field
Daniele Pinai - 27 Sep 2006 8:27 AM - 2 messages
Hi, I used a commandbuilder for my DataAdapter. i have a dataadapter "Pather" and a dataadapter "Sons" in "Pather"  table i have and identity field  that i use in "Sons" table to join them. How can i know with identity number i have for my new "Pather" row ? ...
Score using access as database
moshi - 27 Sep 2006 7:44 AM - 2 messages
Hey everyone, I want an advice. I want to build a site as an internet application using database etc. Since I need to use database , I'm interested in something not expensive for my own needs. I thought about using sqlServer, but I know that it is very expensive. ...
Score haii...adding bunch of records
anil - 27 Sep 2006 5:56 AM - 1 message
haii...     i neeed to know how to add a bunch of records to a database table from c#.net coding.. please sugest me .... ...
Score Connection String of SQL 2005
Jason Chan - 27 Sep 2006 2:58 AM - 2 messages
We upgrade our database from 2000 to 2005. So I use the new connection string in our newly developed web app. "Provider=SQLNCLI;Server=server_ip;Database=db_name;UID=username;PWD=password;" I got this error: The 'SQLNCLI' provider is not registered on the local machine ...
Score ConnectionString manual and secure in C# 2.0
Duong Nguyen - 27 Sep 2006 2:17 AM - 3 messages
Hello, I am a newbie in C#2.0, as I have read, the application automatically generates a configuration files to store the connectionstring in (.XML file). So after compiling, everyone can see this sensitive infomation (username, password). Pls tell me how to make it "hidden" from user and how ...
Score CommandBuilder ConflictOption usage
Darren - 26 Sep 2006 11:23 PM - 4 messages
I'd like to use the command builder to create update queries but my database schema uses datetime columns for the last time modified instead of a timestamp.  Unfortunately ConflictOption.CompareRowVersion seems to only work if a timestamp exists. ...
Score Possible to Select * Into #temp From tblx and read #temp with ado.
Rich - 26 Sep 2006 10:15 PM - 3 messages
Hello, I have a complex query on sqlsrv2000 that runs better if I use an intermediate #temp table.   I have tried using a dataAdapter, Command Object to da.SelectCommand.CommandText = "Select * Into #temp From tblx" da.SelectCommand.ExecuteNonQuery ...
Score Calling Oracle proc from C# - must I pass in a cursor?
Burt - 26 Sep 2006 8:20 PM - 5 messages
I want to create a simple procedure in Oracle that returns a resultset (a select query). In all the examples I've seen, you have to pass in a "ref cursor" OUT param into the proc from C#. Is there a simpler way to do this? IWO can I not pass anything in, and ...
Score getting data from exchange server
Gerhard - 26 Sep 2006 7:49 PM - 2 messages
How can I get email data by email address from Exchange Server into a vb.net web application?  The exchange server is on the same network as the web server.  I basically need to be able to display what emails were sent ...
Score OleDbConnection + MySQL hanging.
Rasmus Kromann-Larsen - 26 Sep 2006 5:16 PM - 1 message
Hi, I'm trying to use a web service on my webhotel that has support for ASP.NET 2.0 and MySQL 4.0.18-nt. However, whenever I try to use OleDbConnection, my SOAP call just hangs for a while, then returns with "WebException unhandled - Operation ...
Score MS ACCESS and ADO.NET 2.0
Niyazi via DotNetMonster.com - 26 Sep 2006 4:15 PM - 1 message
Hi, I try to use new DataSource wizard to create a connection to MS Access 2003 with VB.NET 2003. Unfortunetly after I created the solution when I try to use getdata button I get and error that MS Access DB not found. I cretaed folder in under my ...
Score DataTable Add Row is slow (especially with empty table)
diesel - 26 Sep 2006 3:12 PM - 1 message
After several frustrating hours, I found a solution to a problem that I've been having with DataTable.Add running very slow when trying to add a bunch of records.  I found similar questions posted but no good answers, so I thought I'd post this in hopes of helping someone else. ...
Score combining fields
Ant - 26 Sep 2006 3:06 PM - 1 message
VS2003 C# Hi, I have a bound text box in which I would like to display a first name/last name concatination. These reside in different fields in the database. Rather than do this from the underlying database, or doing it in code, which ...
Score Passing parameter for Stored Procedure to Data Adapter/Data Set
Rotciv - 26 Sep 2006 3:01 PM - 11 messages
Hey all,    I'm trying to pass a parameter into my Stored procedure to be accessed by my data adapter into a dataset             db2.AddParameter("@intClientID", cmbClientList.SelectedValue.ToString()); ...
Score Compare datasets with hash values or possibly another method?
Nicolle - 26 Sep 2006 2:24 PM - 1 message
I have two datasets with the same exact structure that I would like to compare.   I would like to know if there is any difference in the data between them.  I don't need to know what the differences are, only that there is a difference. ...
Score 2.0 Auto Id in typed datasets
s.bussing - 26 Sep 2006 12:35 PM - 4 messages
Hi, I'm still strugling with the following situation. I've got two table which are related by a foreign key contraint. These table reside in a typed dataset. I working on a webbased app, so a disconnected environment. Now, when I add a row to the parent table and ...
Score objectdatasource questions
tparks69 - 25 Sep 2006 10:04 PM - 1 message
Can anyone tell me is there an easy way to get a value into an objectdatasource select parameter from Application Variables?  Obviously its easy from cookies, session etc... but what about Application?  Or is there an easy way to get a value into an objectdatasource parameter from the ...
Score TableAdapter specifing 'IN' in the where clause for list of id's
twahl - 25 Sep 2006 9:32 PM - 10 messages
Hi, I have a table that contains an interger primary key.  I want to query the table for rows that have values equal to a list of ID's that I specify.  The sql that I would use would be something like the following: ...
Score DataGridView or something else
JohnK - 25 Sep 2006 5:58 PM - 2 messages
from what I read & tried, DataGridView was meant for Window Forms, not for ASP/Web pages... correct? While I can use it to display data, I can't seem to figure out how to edit the cells... I'm not looking to put edit buttons on each row... I'll go back ...
Score how useful DbCommon namespace?
ZenRhapsody - 25 Sep 2006 3:37 PM - 4 messages
I am working on an application where the end user will select the type of datastorage to use (SQL, Oracle, Access, even Excel for some readonly data, and maybe more providers ) The application reads/writes data and even must be able to create tables in ...
Score locking recoreds
Pure Heart - 25 Sep 2006 6:51 AM - 2 messages
hi i know in the VS 2005 when we use data access and binding there is no locking for data as before cuz its disconected but i wonder is this the standard now ? i mean when i make a query i will always be sure that maybe some recoreds ...
Score multidimensional array and data table help
Steve Arndt - 25 Sep 2006 4:25 AM - 4 messages
In vb6, I used getrows to load data into a multi-dimensional array.   Since ADO.NET doesn't have getrows, I've succesfully loaded the same data into a datatable. How do I reference the data in the data table as a multi-dimensional array ...
Score SQL Server 2005 Express connection error?
jnikle - 25 Sep 2006 3:27 AM - 9 messages
When I run the code below in Visual Web Developer 2005 Express, I'm getting an "Unable to find the requested .Net Framework Data Provider. It may not be installed." error.  I've been researching a fix for the ...
Score ASP
UB - 25 Sep 2006 1:48 AM - 2 messages
I have a database ASP program that works off a centralized server. Now the client wants me to put it on laptops using  SQL Server 2005 Express. I can do this but do not know of any way to protect my AP code from being viewed and ...
Score How to Remove SPAN tag from the Web Custom controls
Flavio - 24 Sep 2006 5:22 PM - 5 messages
i'm creating a WebUserControl that overrides the RenderContents method, on that i generate the HTML to the writer. here the problem is that on the html code of the page i've one more tag that i doesn't whant <span>! ...
Next »