Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score DataGrid Edit/Update problem
thebison - 22 Apr 2006 8:07 PM - 6 messages
Hi all, I hope someone can help with this relatively simple problem. I am building a timesheet application using ASP.NET C# with Visual Studio 2003.As it is only a protoype application, my database has been made in MSDE. ...
Score Query multiple TableAdapters with open connection
JohnMSyrasoft - 22 Apr 2006 6:39 PM - 1 message
We can open a connection and pass it to multiple dataAdapters before closing the connection. How is this handled with TableAdapters when we call queries from multiple tableAdapters? Let's say I want to populate specific queries on a number of datatables.  ...
Score How to use information from udl file to connect to ODBC Datasource
JzP - 22 Apr 2006 5:51 PM - 1 message
Hi, I have a vb.net program which accesses a sql database and produces PowerPoint charts. There are several sqlConnections in the code which have to be changed if the target database server changes. Ideally I would like to be able to pass the defined name of an ODBC ...
Score What is best way to copy data from a .dbf to MS Access .mdb file?
RajSB - 22 Apr 2006 4:51 PM - 2 messages
Iam writing an appln in VB.NET using VStudio.NET Express. 1. I have an MS Access mdb with a table called "tbl_one" 2. I have another database in foxpro format .dbf called "tbl_two" 3. I need to do few comparisons between tbl_one and tbl_two. ...
Score how to pass variables from asp.net to asp ?
jpm - 22 Apr 2006 4:26 PM - 2 messages
hi, how can i send variables on asp.net to asp on another site ? i want to open 2 sites web with the same  username and password. one site is in ASPNET the other is in ASP.i have a link with a url to open access to 2 ...
Score two disimilar tables - Report
jjmraz - 22 Apr 2006 12:48 PM - 7 messages
Hi All, I have two dissimilar tables, what I mean by this is there is no data in either table that has anything to do with the other from a relationship standpoint. Now my problem is I need to create a report ...
Score How to pass TableAdapater as parameter
ad - 22 Apr 2006 8:25 AM - 3 messages
I want to create a function which take a TablAdapter as parameter and return a typed DataTable. Like: DataTable GetDataTable(TableAdapter adp) {        ..... } But I find there is no parent class for specific TableAdapter. How can I finish this function? ...
Score How to link TableAdapter in WinForm
ad - 22 Apr 2006 7:43 AM - 1 message
I can use ObjectDatasource to link a TableAdapter in WebForm. I want to link a TableAdapter in WinForm too. Which contol should I use to link TableAdapter in WinForm? ...
Score webservices - always work local?
Jeff Jarrell - 22 Apr 2006 2:35 AM - 2 messages
I am coming from a shop that is historically is winforms and we work in our own workareas on network drives. Primarily so  the daily work gets backed up but also so it is easy to look at each other's work in progress. we aren't all in the same location.  The version control and build tools are oriented around this configuration. ...
Score DataSet, Finding Unique Values in Table
Bernie Hunt - 22 Apr 2006 2:26 AM - 3 messages
I have problem I don't know how to solve in a Dataset. My Dataset has one table. That table contains medical services for patients. Each row is one service for a patient, patients may have multiple service records. I need to make a list of the patients in this table. I'd ...
Score FileSystemWatcher does not seem to be working
Nathan Sokalski - 21 Apr 2006 11:15 PM - 5 messages
I have a directory on my site that I keep a bunch of text files in (this directory is "/poetry/poems/"). The Application keeps the first line of each of these files in an HttpApplicationState variable as a SortedList. When I ...
Score is this a bad idea?
matt.delvecchio - 21 Apr 2006 10:44 PM - 3 messages
hello, i have a question.. in my data-access-layer, my app is submitting a bunch of optional paramters to a stored proc for insertion. however, if my user did not select a value for an optional paramter, i decided i ...
Score Passing variable to a SQL statement does not work?
glenn - 21 Apr 2006 7:05 PM - 4 messages
Hi folks, The problem I have is that a query string works if hard-coded but if I pass a variable to it, it does not work as shown here. Dim queryString, q1, q2 As String This works:    querystring="SELECT * FROM USERS WHERE CNAME = Microsoft" ...
Score Passing a variable to a SQL statement does not work ?
glenn - 21 Apr 2006 6:21 PM - 6 messages
Hi folks, The problem I have is that a query string works if hard-coded but if I pass a variable to it, it does not work as shown here. Dim queryString, q1, q2 As String This works:    querystring="SELECT * FROM USERS WHERE CNAME = 'MICROSOFT'" ...
Score DataAdapter Update gives "INSERT" error
Paul - 21 Apr 2006 5:21 PM - 4 messages
When I try to update my data source using DA_InstalledItems.Update(DS_InstalledItems) I get this error: Violation of PRIMARY KEY constraint 'PK_VehicleItems'. Cannot insert duplicate key in object 'dbo.VehicleItems'.  The statement has been terminated."    DA_InstalledItems.UpdateCommand.CommandText is: ...
Score TableAdapters and true N-Tier
CMM - 21 Apr 2006 3:38 PM - 11 messages
Unless someone has come up with a way, I still don't understand how you can use TableAdapters in a true n-tier infrastructure.... where the DataAccessLayer is in one Dll and *only* the Datasets themselves can be shared across layers. ...
Score data adapter
Fanor - 21 Apr 2006 2:10 PM - 3 messages
Hi guys, I'm new in VS 2005. I noticed that in the toolbox there is no dataadapter!! In a previous version there was a data adapter icon in toolbox  and is was easy to drag to a form, is it posible to add the data adapter icon to the ...
Score Distributed Transactions: Intermittent problem reading data
Anderw Miller - 21 Apr 2006 1:36 PM - 1 message
(this message is cross-posted to microsoft.public.mts.programming and microsoft.public.platformsdk.complus_mts) Summary of Problem:  Intermittently, a single threaded application reads data immediately after it has been written in a COM+ transaction and the updated data is not seen.  ...
Score security for row level but not based on Database user's login
Friends - 21 Apr 2006 10:36 AM - 2 messages
Hi I need to set security for row level but not based on Database user's login. It should be based on the user table login. For the particular user I need to allow only the particular records to access insert, ...
Score Error accessing MS Access database with Linked Tables on fileshare
PÃ¥l Eilertsen - 21 Apr 2006 8:42 AM - 8 messages
Hi, I have a ASP.Net application that uses a MS Access database. The site works fine when all databases resides locally but on my public server I need to use a different database where the main databasefile resides locally but also has ...
Score Running Two Instances of same Windows Service?
Prodip K Saha - 21 Apr 2006 5:08 AM - 1 message
Running Two Instances of same Windows Service? Recently I was given a project to cut down the queue processing time by 50 percent. Queue processing application is a Single Threaded Windows Service written in C#.Net to batch update data in Sybase database. Depending on the ...
Score A problem with the datagrid
Pearl.Elevation - 21 Apr 2006 3:39 AM - 5 messages
Hi, I am just beginning to learn to use the .Net framework and recently I confront a problem with the datagrid. I create an .asp file. There are two buttons, one datagrid on the screen. The first button is "Show" button. When I click this button, it will ...
Score Open Connection for long time
MountainKid - 21 Apr 2006 2:45 AM - 3 messages
I use ADO.NET to develop my project. (use SqlClient.SqlDataConnection object to conection SQL 2000) It is stranger that Connection.Open() method spect 12 seconds to execute in one of our servers, but it is faster in another server, not more than 1 ...
Score data bound combobox does not leave focus
nicolasr - 21 Apr 2006 12:32 AM - 4 messages
Hi, I'm quite new to database development and am trying Visual Studio with ADO.NET for the first time (Borland user before). So please apologize my lack of experience with the tool. (More precise, I'm using MS Visual C# 2005 Express) ...
Score How to highlight an entire row in a DataGridView?
Hexman - 20 Apr 2006 9:14 PM - 3 messages
I have a DataGridView with RowHeadersVisible = False.  When a user clicks on a cell how do I highlight the entire row.  And secondly how to (syntax) get the value of cells into variables.  I've looked at ...
Score How to rename columnnames in a table in .NET
Jayashri Yadav - 20 Apr 2006 7:29 PM - 3 messages
Hi, I would like to know if there is any way to rename a column in a table in access database using .Net programmatically. Thank you ...
Score deriving enterpriselibrary.data.database
RMB - 20 Apr 2006 7:17 PM - 1 message
I have a class that I want to derive from enterpriselibrary.data.database.  I want to open the database connection on the base class, but I have hit a road block as to how I can retrieve the connectionstring from dataConfiguration, ...
Score c# string: escape chars passed to VB problems
Shawn B. - 20 Apr 2006 5:28 PM - 1 message
Greetings, We've created a wrapper component around ADO.NET (written in VB.NET).  When we build a string in C# that contains escape characters "\r\n" or "\t", etc., and pass them to the data access wrapper, VB.NET actually sees the ...
Score c# string: escape chars passed to VB problems
Shawn B. - 20 Apr 2006 5:28 PM - 1 message
Greetings, We've created a wrapper component around ADO.NET (written in VB.NET).  When we build a string in C# that contains escape characters "\r\n" or "\t", etc., and pass them to the data access wrapper, VB.NET actually sees the ...
Score Streaming SQL Data
ewellnitz - 20 Apr 2006 4:19 PM - 3 messages
I have a large SQL result set that I am returning to a client from a WCF Service.  The client and the service both are configured to use TransferMode.Streamed, and the operation signiture is: System.IO.Stream GetData(); ...
Score Spltting large datasets for parallel processing
Andy Furnival - 20 Apr 2006 3:38 PM - 4 messages
Hi people, I have a problem, where I'm trying to find a fast effective means of continually polling a database for messages to process which are grouped based on content and then processing these groups in multiple threads and ...
Score Deleting duplicate values in a DataSet
glenn - 20 Apr 2006 3:04 PM - 3 messages
Hi folks, I have a DataSet that returns values from a single column in a database where I query a table named USERS for companies that are working on a given project. The SQL statement is as follows: SELECT COMPANYNAMES FROM USERS WHERE PROJECT = @PROJECT ...
Score Updating two table through data adapter.
trialproduct2004 - 20 Apr 2006 12:22 PM - 2 messages
Hi all, I am having one confusion regarding working of data adapter. What i am doing is i am having one stored procedure which is returing me data from two different table. Then i am collecting data from this sp into dataset using dataadapter. ...
Score Getting All Parent Records For Known Child (Double Primary Key)
Aziz - 20 Apr 2006 12:05 PM - 1 message
I need a way to populate a DataTable withparent rows when the child row is known in a double primary key situation. This is my XML Schema, currently dealing in the two tables below, second one has two primary keys: ...
Score Most efficient proptocol to access a SQL2k on the same server?
mortb - 20 Apr 2006 9:10 AM - 4 messages
Hi Our clients website is hosted by the same machine that runs their DBMS. We have no network protcol (tcp | named pipes | etc..) defined in the connection string. Which method will be used accessing the database? Would it be more efficient ...
Score inconsistency in ConstraintsCollection
Dan - 20 Apr 2006 8:14 AM - 5 messages
Hi, I discovered a bug in ConstraintsCollection: Suppose you have two constraints, with the same columns but different names; one already in the collection, one you try to add it to collection. if you want to add the Constraint to the collection and check whether it ...
Score AppSettings file="user.config" for connectionstring in .NET2.0
mortb - 20 Apr 2006 6:39 AM - 3 messages
Hi! To ensure that my development connectionstring wasn't the one used for our live website I have used a development configuration file that overrides the appsettings section. Syntax as follows: <appSettings file="..\user.config">     <add key="ConnStr" value=" .. "/> ...
Score FTP code using Windows API
aparnasinha26 - 20 Apr 2006 6:29 AM - 2 messages
Hi ALl, Please cud any one guide me as to upload and download files by FTP using Windows API  in VB.Net Or  is there any better way to do it in VB dot net...I dont want to use  third party components.. ...
Score Default Provider
Baren - 20 Apr 2006 6:26 AM - 5 messages
Hi!, Which is the default provider for ADO.NET?? Regards, Baren ...
Score FS: 11 Books for $50 CHEAP - Microsoft VB.NET, Windows Programming Books
MiniMe - 20 Apr 2006 2:48 AM - 1 message
I am selling these books in a lot.  I am not selling them individually. Total Number of books: 11 Total List Price Value: $476.98 Total Asking price: $50 Location: Houston, TX USA, but willing to ship via Media Mail. ...
Score Intermittent exceptions raised by SqlClient
David R - 20 Apr 2006 1:00 AM - 1 message
I've been recording these exceptions intermittently occuring (I got the stacktraces by getting the program to email them to me). These two exceptions occur at fairly random intervals: Index was out of range. Must be non-negative and less than the size of the ...
Score Re: Connection problem with Oracle client and pooled connections
Som - 20 Apr 2006 12:10 AM - 1 message
Hi, We are running our web site on Win2k3 machine with  .NET Framework 1.1 SP1 version 1.1.4322.573. The actual file on server that is specified in the article is System.data.oracleclient.dll   version  1.1.4322.2300    ...
Score Datarelation HELP needed - Constraints, M-2-M
Hexman - 20 Apr 2006 12:06 AM - 4 messages
Hello all, Back again with more questions.  I have a task at hand and I'm trying to use a datarelation between two datatables.  Table1 = Trans fields= date, product, dept, assignto, ..... 04/01/06 Clamp       54    <blank> ...
Score How to select on datatable to exclude objects
Sreppohcdoow - 19 Apr 2006 6:42 PM - 3 messages
I.e., I want to select all rows in a datatable that don't match a condition... Explicitly: myDatatable.Select("myStringColumn length > 0") Of course, I could select them all, then check the condition afterward.. is there a cleaner way? ...
Score DataRelations
Aziz - 19 Apr 2006 4:22 PM - 1 message
Take this XML Schema [link] In this system an AlloyCode is made from several BaseMetalCodes (but not the same combination of BaseMetalCodes for every AlloyCode) BaseMetalStocks (Parent) BaseMetalAlloy (Child) If I wanted to get all related rows from the parent table when the ...
Score Create my own db connection wizard
Carlo Stonebanks - 19 Apr 2006 4:10 PM - 13 messages
I would like my app to have its own run-time data connection wizard so that users can connect to a data source of their choice. I'm new to ADO.NET, previously programing for RDO/ODBC. With that, I could actually invoke the ...
Score ADO.NET Transaction Locking
scott - 19 Apr 2006 3:44 PM - 5 messages
I have a transaction that is Updating or inserting multiple tables(12 or more)  This transaction takes about a 2 seconds to perform.  During that two seconds.  We are getting timeouts expired errors from other clients requesting records from the same 12 or so tables.  What setting is there to ...
Score useless UniqueConstraint constructors...
Dan - 19 Apr 2006 1:23 PM - 2 messages
Hi, Why there are UniqueConstraint constructors that accept a bool that sets the constraint as primary key if the flag is not used?? this is the code inside IsPrimaryKey property... public bool IsPrimaryKey {       get       { ...
Score ObjectDataSource and DataSets
Chris Fulstow - 19 Apr 2006 1:22 PM - 3 messages
Hi all, I'm investigating the best approach for building an n-tier web application with ASP.NET 2.0.  I want to separate my data access layer, so an ObjectDataSource seems the natural choice, but I can't decide ...
Score Timeout
Lou Civitella - 19 Apr 2006 1:11 PM - 4 messages
I am setting the source of a crystal report and sometimes get a Timeout error. How can I increase the timeout? It seems to timeout after 30 seconds. Here is a snippet of the code that I use. Using VB 2005 ...
Score OCIEnvCreate returned -1.
Nicolae Braduceanu - 19 Apr 2006 1:00 PM - 1 message
I try to connect my asp.net application to oracle 9i database I get this error message: Could not create an environment: OCIEnvCreate returned -1. I already changed the machine.config file of framework 1.1 by setting UserName="SYSTEM" in tag ProcessModel. ...
Score How to prevent "Input string was not in a correct format" in DataGridView
Pieter Coucke - 19 Apr 2006 9:29 AM - 6 messages
Hi, When a user types a non numeric-value in a numeric column in a DataGridView, and he tries to leave the cell, he gets this "Input string was not in a correct format."-exception. Is there a (nice) way to get rid of this exception? And just put a "0" in ...
Score automatically converting collection to datatable and vice versa
Miraj Haq - 19 Apr 2006 7:29 AM - 2 messages
Hi, Is there anything in .NET framework with help of which I can automatically conert a collection to datatable and vice versa? Thanks M ...
Score FS: 11 Books for $50 CHEAP - Microsoft VB.NET, Windows Programming Books
MiniMe - 19 Apr 2006 5:50 AM - 1 message
I am selling these books in a lot.  I am not selling them individually. Total Number of books: 11 Total List Price Value: $476.98 Total Asking price: $50 Location: Houston, TX USA, but willing to ship via Media Mail. ...
Score Query Question
KeithM - 19 Apr 2006 1:18 AM - 3 messages
I am trying to create a view that returns data from three tables and can't seem to get it to return the data that I want. I am no SQL expert, so hopefully someone can give me some insight into what I need to do. ...
Score Checking for DBNull
Sreppohcdoow - 19 Apr 2006 12:18 AM - 3 messages
Since Operator '==' cannot be applied to operands of type 'string' and 'System.DBNull' What is the best way to accomplish: if(myString == DBNull.Value)   myString="" Thx, MS ...
Score How to filter a dataset using relationships like a sqlcommand
Alvaro E. Gonzalez - 19 Apr 2006 12:17 AM - 7 messages
Hi, I have a dataset with many ralated datatables, i need execute filter that gives back datarows to me that gives back to me if outside the following SQL command. SELECT  distinct   GE_SERVICE_TYPE.SERVICE_TYPE_ID, GE_SERVICE_TYPE.DESCRIPTION    FROM  PS_PACKAGE_TYPE, ...
Score Exclusive Connection to Access Database
Debi - 18 Apr 2006 10:24 PM - 8 messages
Hi, How do I set the connectionstring to get Exclusive connection to MS Access database. I want to let the user reset the database password. Thanks, Debi ...
Score Programatically figuring out if sql server 2000 or 2005
Jaffa - 18 Apr 2006 7:40 PM - 4 messages
Hi, Is there a way to programatically tell whether I am connecting to a sql server 2000 or sql server 2005 database. I have a connection string that works for both versions, but when I connect to the database is there some way ...
Score Databind TabControl as Detail to Master Records
Cheryl - 18 Apr 2006 7:16 PM - 3 messages
Using VB.NET 2003. I have two tables. One is the master and the other is the detail. I am successfully binding them both and can successfully bind the detail to a datagrid and pull in all related detail records to the master. (not really ...
Score Using insertcommand with AccessDataSource in asp.net 2.0
jb50c - 18 Apr 2006 6:17 PM - 1 message
Hello, Im new to .net 2.0.  I've worked with 1.x for a couple of years now with a working (not advanced) knowledge of asp.net.  I am building a simple knowledgebase with an interface for people answering questions ...
Score Creating the DataTable objects within a Dataset from the DB itself
Ed Minrights - 18 Apr 2006 4:27 PM - 5 messages
I have a feeling I'm thinking about this the wrong way... I need to insert lots of rows into lots of different tables and then submit the whole lot into the database. I'm not concerned about what rows will already be present in the database, these will all be ...
Score any performance comparisons between retrieving large result set with DataSet/Fill verses Generic Lis
Peter Kellner - 18 Apr 2006 3:52 PM - 3 messages
I'm looking for a comparison of using Strongly typed datasets and using a generic list. Specifically, I'm wondering if when I use vs2005 and create a dataset, tie it to an ObjectDataSource, plug that into a gridivew, if the ...
Score Recovery of the DataRows that has ChildrenRows
Alvaro E. Gonzalez - 18 Apr 2006 2:51 PM - 2 messages
Very Good Day to All; Somebody knows a way fast to filter the DataRows of DataTable "A" to that they have rows in a DataTable B. Which is the best way to obtain this? Thanks beforehand for the collaboration. Greetings. ...
Score Typed Datasets and DataAdapters
Max André Bündchen - 18 Apr 2006 1:26 PM - 1 message
Is possible work with Typed Datasets and using custom DataAdapters (based on DB-Agnostic System.Data.Common)? In this case, how generate the Typed Dataset ignoring the inherited DataAdapter generated by the VS 2005 wizard? ...
Score Working with DataRelations
Aziz - 18 Apr 2006 1:00 PM - 1 message
Now that I can finally write to and read from my application without any errors, it's time to get down to the nitty-gritty. Take this XML Schema: [link] If I wanted to get all the associated rows in BASEMETALALLOY and/or ...
Score DAL
Max André Bündchen - 18 Apr 2006 11:55 AM - 5 messages
I'm new in .Net world and I have a multi database system to develop in my hands. This system should work with SQL Server, Oracle and Firebird. In the .Net world I could make a DAL with typed datasets (one set for each DB) and all works with no problems. However, I couldn't ...
Score DataAdapter.Fill order
Aziz - 18 Apr 2006 11:16 AM - 5 messages
I'm using VB .NET 2003 and Access 2000 I have a several DataTables in my XML Schema that are linked using DataRelations (My original Access databse still has the same relations). However when I fill the DataAdapters (I assume in the ...
Score asp.net sql connection problem
param - 18 Apr 2006 7:48 AM - 17 messages
Hi all, I have a production environment where I have a 2-node SQL 2005 Cluster running on boxes which are part of a domain "MyCompany". I have setup a domain user account called "netasp" and then given it permissions to the ...
Score SqlConnection - Timeout Property is read-only?
Mark - 18 Apr 2006 4:21 AM - 9 messages
I'd like to change the SqlConnection timeout propery from the default 15 seconds down to 4 or less.  How can I change it?  I have been unable to find an example of a connection string that would allow me to override this. ...
Score Fields in a Access table
Who - 17 Apr 2006 10:35 PM - 3 messages
What is the easiest way to get the names of the fields in an Access database table using VB.net 2005 and ADO.net? MBS ...
Score Mob-ocracy and the Fall of the Republic
The Right Perspective - 17 Apr 2006 10:17 PM - 1 message
Are we fools? Or are we slaves? As in the film Gladiator, are we as a nation going from free men to slaves? Would we restore the Republic? Are we even still living in a Republic? Or a mob-ocracy? And where is our representation in ...
Score Insert quits when exception is thrown
Fiddelm3742 - 17 Apr 2006 8:55 PM - 4 messages
I am trying to update a large set of data (VS2005 & SQL2000).  I have a temp_table setup to hold my data taht i read in from my datafile.  I BCP all of the data to that table and I'm then running insert/update statement(s) on ...
Score Operation must use an updateable query... while trying to write to Excel file
jef - 17 Apr 2006 6:20 PM - 10 messages
I'm attempting to use OLEDB to write an Excel file.  I start with an existing file that has a single worksheet with one row (the column headers).  Everything seems to be working except when I try to save the ...
Score SqlDataReader .NET 2.0 GetSchemaTable not returning AutoIncrementS
Jaffa - 17 Apr 2006 4:58 PM - 5 messages
Hi, So I have this: SqlDataReader rdr = ExecuteDataReader(connection, Command.Text, "Select * from myTableName"); DataTable table = rdr.GetSchemaTable(); This is working great and telling me all the defined columns within the myTableName, except if the column is an identity and autoincremented it is ...
Score Insert Pattern
Max André Bündchen - 17 Apr 2006 2:20 PM - 4 messages
I'm developing a bigger application that will run under three DB (SQL Server, Oracle and Firebird). I would like to use a helper class (like the Professional ADO.NET 2 example). My problem is 'simple'. In a insert I would like to ...
Score DBNull vs null in .Net 2.0
Joe L. F. - 17 Apr 2006 1:23 PM - 2 messages
With .Net 2.0 the concept of nullable types appear. DBNull seems to be useless today. Null references could be used everywhere DBNull were used. Why does DBNull still exists? ...
Score VS2005 Compile Error: Could not find schema information
Bojan Kuhar - 17 Apr 2006 10:37 AM - 1 message
I have created typed datasets in VS2002 originally. I have converted the project to VS 2005. Now I get Information type error messages when I build my application: Could not find schema information for the attribute 'urn:schemas-microsoft-com:xml-msprop:nullValue'. ...
Score Performance of sqlDataReader.Close() is very bad?
Santosh - 17 Apr 2006 10:04 AM - 13 messages
I have a piece of code which goes like this. Datareader dr = Datareader on (Select ItemName, ItemValue, LotValid from Items where ItemName = something) while dr.read { read and assign values if LotValid = false; break; } dr.close(); The issue arises when the number of records fetched by the query is high and ...
Score OracleConnection.BeginTransaction() calls OracleCommand.ExecuteNonQuery() internally?
Sanjay - 17 Apr 2006 5:04 AM - 4 messages
Hi I'm trying to use OracleConnection.BeginTransaction() to create an OracleTransaction object to assign to the transaction property of my OracleCommand object. I get this exception ... "Execute requires the Command object to have a Transaction object when the Connection object assigned to the Command is in a pending local ...
Score Successfully executing queries
John - 17 Apr 2006 2:30 AM - 3 messages
Hi I need to run separate insert & update queries. I suppose I can use execute.nonquery to execute the queries. How can I tell if the queries were successful? Thanks Regards ...
Score Using @@Identity with access
Dana King - 16 Apr 2006 6:52 PM - 7 messages
I primarily work with SQL (thank god) so I have an Access question. Thanks in advance for some insight. I am trying to insert a new record and have the identity returned. I have been using the code below but no luck. It always returns 0 ...
Score Data in table through dataset or bindingsource
Eric Algera - 16 Apr 2006 6:00 PM - 9 messages
I have a gui build from a dataset. The gui consists of an ID field (identy and key field in the database) and a name field. I have a textfile with only the names in it. I want to fill the database ...
Score SqlDependency - Options and Timeout
Gidion - 16 Apr 2006 5:43 PM - 2 messages
Hi, I'm using SqlDependency quite a lot and really love it, but there are two things I just can't seem to find anywhere on MSDN or elsewhere. 1. One of the SqlDependency constructors, allows you to pass a "string ...
Score for sale: internetDotComs.com
internetDotComs.com - 16 Apr 2006 1:31 PM - 1 message
domain for sale:  internetdotcoms.com   [link] ...
Score Incorrect ID returned
drops - 16 Apr 2006 9:18 AM - 8 messages
I have a problem with an incorrect ID thats returned from the second insert. 1) There is a table in SQL Server 2005 with an ID colum that is marked primary key and identity to autoincrement. 2) I fill a dataset with a dataadapter from this table ...
Score Crystal Reports Dataset!
Brashen - 16 Apr 2006 8:53 AM - 2 messages
I have a dataset, report, and report viewer on a form. I want the form to get the data from the dataset NOT the database and then tie the report to the viewer. I don't seem to be having much luck in figuring it out, Any ideas? ...
Score how to set listview's backgound image?
±è¿ë°Ç - 16 Apr 2006 7:27 AM - 1 message
i tried to set listview's background image (using managed C++) first try, i maked bitmap and set back ground image like below code but, it had no effect LiveView * listViewJobTable .... HBITMAP hBitmap = LoadBitmap(g_hInstance,MAKEINTRESOURCE(IDB_BITMAPJOBLIST)); listViewJobTable->BackgroundImage = Image::FromHbitmap(hBitmap); ...
Next »