Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score What is the max number of tables advised to use with typed datasets?
Brooke - 5 May 2007 2:28 PM - 3 messages
I am helping develop a SQL Server 2005 application with a C# front-end. Originally I was using untyped datasets and stored procedures and it worked fine.  Now I have been told to used typed datasets and table adapters.  Is ...
Score Best way to get the identity for new records?
Brooke - 5 May 2007 2:23 PM - 2 messages
I am helping develop a SQL Server 2005 application with a C# front-end. Originally I was using untyped datasets and stored procedures and it worked fine.  Now I have been told to used typed datasets and table adapters.  How ...
Score vb.net take array data and put in combobox
lopez510 - 5 May 2007 3:15 AM - 3 messages
I am new to vb.net.  I have a multidimensional array that I want to reference and replace current data in a combobox with each line of data from the array in the combox on an click event.  I am having issues getting the data to be ...
Score Fun with products and Expression columns
Earl - 4 May 2007 5:52 PM - 10 messages
I have somewhat of an interesting scenario: The form allows the user to select a service, which populates a a grid of product information related to that service ("service grid"). The user can then select from the products in the first grid and those choices populate ...
Score Does sorting a dataview cause its datatable to change
Jerry J - 4 May 2007 1:17 PM - 2 messages
If I sort a dataview using dataview.sort = "sort string", can the dataview.table change? ...
Score Need help in Calling Oracle Function from EntLib Data Access App Block(from c#)
rh.krish - 4 May 2007 5:13 AM - 1 message
I have the following oracle function: FUNCTION GetLoanStatus(LOAN_ID IN VARCHAR2) RETURN VARCHAR2 AS status VARCHAR2; BEGIN SELECT CURRSTATUS INTO status FROM LOAN WHERE AP# = LOANID; RETURN status; END; I have the following c# code: Database db = DatabaseFactory.CreateDatabase(); using (DbCommand cmd = db.GetStoredProcCommand("Test.GetLoanStatus")) ...
Score DataTable.Select - Group By
Doug - 4 May 2007 12:36 AM - 2 messages
Is it possible to do a Group By in the Select method of the DataTable object? ...
Score What is the best approach to export a table or subtable(resultset) to a separate .sdf file?
Nick - 3 May 2007 10:16 PM - 1 message
hi, guys How to move one table or a ResultSet to a separate database .sdf file in compact edition? For example, I have handheld installed the compact edition to do some order works. After the job done, I want move the new table Orders to ...
Score Checking db connection open status
John - 3 May 2007 4:01 PM - 7 messages
Hi I am creating a db connection using the below code. Is there a way to check if the connection is open? Thanks Regards = Code Below ==================== Dim LocalConn As OleDb.OleDbConnection Dim St As String = My.Settings.LocalDBConnectionString LocalConn = New OleDb.OleDbConnection(St) ...
Score Database closing problem
John - 3 May 2007 3:55 PM - 5 messages
Hi I have a vb.net app that opens an access database runs several sql action queries on the tables and closes the db. This is done every few minutes. The problem is that sometimes I get an error 'ExecuteNonQuery requires an open ...
Score Load multiple datasets to crystal report.
Li Weng - 3 May 2007 3:14 PM - 4 messages
Hi, I like to use .SetDataSource() to load several data tables from different datasets to a crystal report. I was thinking to create a new dataset to have all these tables. But is there a way to load them directly? ...
Score Optimistic Concurrency - how? - net 2.0
Rolf Welskes - 2 May 2007 11:01 PM - 6 messages
Hello, I have the situation that many users on the same db , table have access and make changes. Ok for this there is optimistic concurrency. So I am able to check for cocurrency and get (in the moment) a messagebox, ...
Score Still trying to read descriptions for tables, columns, etc from me
DavidThi808 - 2 May 2007 10:57 PM - 7 messages
the sp_help command doesn't return descriptions as far as I can tell. Any other ideas? ...
Score OLEDB Jet writing to Excel clobbers all text cells and other sheet
Jim Walsh - 2 May 2007 9:47 PM - 2 messages
I'm developing a Provider Independent Data Access program using ADO.NET and Ole DB Providers in VS2005. I am using OLE DB Provider for Visual FoxPro for the VFP data source, and the Jet 4.0 OLE DB Provider fot the Excel source. ...
Score DataTable.Merge()
mj2736 - 2 May 2007 7:46 PM - 2 messages
I'm a little confused about DataTable.Merge(). I have two DataTable objects with the same structure - dtOrig and dtCurrent. The end result I'm trying to achieve is to get all the rows in dtCurrent that are in some way different from the corresponding rows in dtOrig so those new/ ...
Score Get FK:PK relationships from a schema and from a result set
David Thielen - 2 May 2007 7:34 PM - 5 messages
Hi; Please, please, please tell me there is a way to do this. For a foreign key, say Orders.CustomerId I need to know that it maps to Customers.CustomerId. I need to be able to get this metadata both from when I ...
Score Creating a tped DataSet for dbase files - Parameters question
Mircea Ion - 2 May 2007 6:38 PM - 2 messages
I have an ODBC connection to a folder where a few dbf files reside. In Visual Studio I'm trying to create a DataSet for this table ZIPS with the following fields: ZIP char PROV char CITY char The default Fill and GetData using a SELECT zip, prov, city FROM zips are ...
Score data type synchronization
Alex - 2 May 2007 5:30 PM - 8 messages
Hi, I have three different data types coming out of my SQL tables that I need to align with my VB code and the data set properties.  I'm getting an error message that reads "SQL exception unhandled.  The ...
Score DOWNLOAD CRACKED SOFTWARE: AUTOCAD,XSTEEL,ARCHICAD,SOLIDWORKS,DELCAM,WILCOM,CHIEF ARCHITECT,UGS!
William Eistenach - 2 May 2007 5:11 PM - 1 message
Our team provide different types of services such as: - proffessional cracking of any kind of software (CAD,CAM,CAE,EDA,GIS,PCB,FEA,FEM,CNC,CFD,PDS,3D,Optics etc.) designed for any kind of operating systems(Windows 95/98/ME/2000/XP, Linux, ...
Score transaction problems
Smokey Grindle - 2 May 2007 3:43 PM - 3 messages
I am having wierd transaction problems where the transaction holds a lock in SQL Server 2005 even after i perform the transaction.commit... anyone know why ADO.NET would be doing this? this is a sqltransaction object that i am ...
Score Oracle and Data Source Configuration Wizard
cartoper - 2 May 2007 2:32 PM - 1 message
I am brand new to Oracle.  I would like to do with Oracle what I do with MS SQL, that is add the data connection to the Data Source view via the Data Source Configuration Wizard.  I am selecting the ".NET ...
Score multiple updates in one round trip?
jeff.ranney - 2 May 2007 6:50 AM - 5 messages
Hi all. Is there any way using ADO.net that I can send an entire datatable (with multiple rows) through the adapter and in one round trip accomplish multiple updates/inserts (using stored procedures)? If not, is there any other way to accomplish that?  I have seen people ...
Score get DB results from inner join update
Rick - 2 May 2007 12:37 AM - 3 messages
VS 2005 & Firebird DB 1.5 I have a query for Customer orders that has several inner joins to show things like Terms name (from termsnum) and Sales Rep name (from repnum) etc. I have written the custom SQL insert statement and this works with no ...
Score Deploying Windows Application with ODP .NET
Tas - 1 May 2007 11:13 PM - 2 messages
I hope this is the right place for this, if not please move it. I have developed a windows application which uses an Oracle database for storage. In order to communicate with the DB, I am using the ODP .NET ...
Score Column data type
Lubomir - 1 May 2007 10:31 PM - 3 messages
Hi, To send the result table from the stored procedure back to a client, I have to create SqlDataRecord and send the rows one-by-one. The constructor fro SqlDataRecord needs an instance of the SqlMetaData. To create this instance I need the type definition for a particular column. ...
Score Best way to update indexed field in 4 million rows?
Bryan Nehl - 1 May 2007 6:43 PM - 2 messages
Scenario: SQL Server 2005 w/table that has 4 million rows. There is a column that we need to run through, format it and update the row with the new string. Using VS2005 we have an application that will do this. ...
Score Best way to update indexed field in 4 million rows?
Bryan Nehl - 1 May 2007 6:37 PM - 1 message
Scenario: SQL Server 2005 w/table that has 4 million rows. There is a column that we need to run through, format it and update the row with the new string. Using VS2005 we have an application that will do this. ...
Score SqlContext.Pipe and SqlDataReader
Lubomir - 1 May 2007 6:04 PM - 1 message
Hi, I am wondering, when I use SqlContext.Pipe.Send(MyDataReader), will be the connection open till the client is working with the reader ? Thanks, Lubomir ...
Score Validation error does not block the gui - .net 2.0
Rolf Welskes - 1 May 2007 3:58 PM - 5 messages
Hello, I have the following: a form, a datasource, in the form I have tabs, menus, listboxes, a datagridView and textboxes. All is bound to the datasource and works fine. Now I have (beside other) with the textBox-events Valdiating and Validated ...
Score Separating out common data tables in datasets?
Clive Dixon - 1 May 2007 3:06 PM - 3 messages
If I create two datasets using the visual designer which both contain the same table, the generated datasets will each have their own nested copy of the same table class. Ideally I would like to be able to have datasets use a ...
Score Looking for SQL2K Stored Procedure utility
Brian Simmons - 1 May 2007 1:30 PM - 4 messages
Hi All, Many moons ago, I remember the ASP.NET Pro magazine publishing an article about a Winform utility that generated stored procedure .net calling code. i.e. if you have stored proc had 5 params it would generate some text you ...
Score SP Parameters - default values and parameter order
Just D - 1 May 2007 9:01 AM - 5 messages
I know that when we write a Stored Procedure we can add a default value to the parameter so that if it's not set when we call this SP the default value should be used. It gives me some additional flexibility and a simple way to ...
Score Stored Proc problems in SQL2K5 SP1
b_asp.net - 30 Apr 2007 9:02 PM - 1 message
My stored procedure runs intermittently in SQL2K5 SP1. It will sometimes run and complete from SQL Management Studio, and when it completes, it usually makes about 5K reads, and it takes about .3 seconds. It will never run if called from my asp.net 2.0 data layer (via sqlclient ...
Score Data rows not commiting to database.
skl - 30 Apr 2007 4:24 PM - 2 messages
I am currently using VS.NET 2005 to read in a text file into a sql server database table.  The code cycles through the file and using a .add with a dataset seems to add all the rows just fine. ...
Score Typed datasets with multiple datatables?
Dave - 30 Apr 2007 3:12 PM - 2 messages
Using the typed dataset designer, I dragged an existing stored procedure onto it which has several select statements in it For simplicity, something like: select * from table1 select * from table2 select * from table3 It seems the designer generates on datatable based on the first select ...
Score Can I create tables in an existing database or manage a dynamic dataset?
gobis - 30 Apr 2007 5:53 AM - 3 messages
Hello all, I am working on a csharp database application that should give its end users the ability to create new tables related to existing ones or even create the database structure completely on their own. I know how to do that by creating a DataSet object and adding tables ...
Score COM problem
Martinez - 30 Apr 2007 4:39 AM - 1 message
Hello I try declare Dim db as New BtDatabase() and execute metod db.open(par1,par2,par3) but i get error : System.NullReferenceException was unhandled   Message="Object reference not set to an instance of an object."   Source="Microsoft.VisualBasic" ...
Score Error dataset deletion
Flomo Togba Kwele - 29 Apr 2007 4:30 AM - 7 messages
I got the following error: Concurrency violation: the DeleteCommand affected 0 of the expected 1 records. I have two tables in a strongly typed dataset, parent and child. I have defined the delete rule of the relationship to cascade in both the dataset and in the ...
Next »