Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score SELECT query
Lubomir - 30 Mar 2007 11:08 PM - 2 messages
Hi, I have a table: column: A | B ---------------- row:     a | 1             a | 2             c | 2 ...
Score Could not understand the problem while reading excel in dataset
dinoo - 30 Mar 2007 10:56 PM - 1 message
I need some one to help me out here to understand the problem. I am trying to read an excel sheet and I am using the following connection string- "Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties='Excel 8.0;HDR=YES;IMEX=1';Data Source=FILENAME" ...
Score Transactions + multiple table adapters
Mark Baldwin - 30 Mar 2007 9:57 PM - 4 messages
I am using SQL2000 and .NET 2.0 I have a dataset, with two DataTables each having a TableAdapter. I need to use the insert command on the first TableAdapter and then execute a stored procedure on the second table adapter - all within a transaction. ...
Score NHibernate + Custom List: Unable to cast...
Pieter - 30 Mar 2007 8:57 AM - 1 message
Hi, I'm using NHibernate 1.2 (CR1), and I'm using a custom list (inherited from BindingList(Of T) ) for all my lists. The NHibernate documentation told me that I had to implement IUserCollectionType to my custom list, which I did. But I still get an error ...
Score MySQL Remote data access : Access Denied for user
vighnesh - 30 Mar 2007 6:22 AM - 1 message
Hi Folks I am able to connect to my local MySQL DB from VB.NET application, but when it comes to remote data acess I have  been facing the "ACCESS DENIED ERROR". The connection string I used is as below. ...
Score My ADO.NET 2.0 Provider doesn't work in SSIS Import Export Wizard?
Simon - 30 Mar 2007 4:58 AM - 2 messages
Hi, I've written an ADO.NET 2.0 provider for our company's database and a Visual Studio DDEX design time support proivder. Everything works well and the documentation supplied on MSDN and samples were excellent. However I can not figure out how to get the SQL Server Integration Services ...
Score DataGridView and edit
Chris - 30 Mar 2007 12:52 AM - 1 message
I am trying to figuere out how, programtically, I can put a specific cell into the EDIT mode. Then after inserting a string value, I want to EndEdit mode.  Once I accomplish this my code in DataGridView_EndEdit(etc) should ...
Score Concurrency Violation
pooba53 - 29 Mar 2007 10:45 PM - 3 messages
My VB .NET 2003 application communicates with an Access database. So far everything has been working just swell. I have a menu selection in my main form that when clicked launches a "customer data" form that folks fill personal information into and the ...
Score Variable WHERE part of SELECT command
Lubomir - 29 Mar 2007 4:36 PM - 14 messages
Hi, I need to get data from a table from a database. The data will be queried according ID column. In a fixed time interval my application will receive the list of IDs. Than all records with this IDs should be retrieved from database. ...
Score PLSQL Associative Array error
Zencat - 29 Mar 2007 4:01 PM - 1 message
I was hoping someone could help me.  I am attempting to consume an Oracle SP that uses Associative Arrays via ODP.NET and I get a error that I can't see my way around and it's really getting annoying! :-( ...
Score Adding identity column to an existing DataTable
SoftLion - 29 Mar 2007 1:25 PM - 2 messages
Hi all, I'm trying to add an identity like column into an existing table of a DataSet: DataSet ds = ... .... DataColumn identity = new DataColumn( "ROWINDEX", typeof(int) ); identity.AutoIncrement = true; identity.AutoIncrementSeed = 0; identity.AutoIncrementStep = 1; ds.Tables[0].Columns.Add( identity ); ...
Score Shameful design
Amir Tohidi - 29 Mar 2007 9:44 AM - 5 messages
Hi In all the years I have been using the internet, this is first time that I am venting my anger publicly! So as you can imagine, I am not a happy bunny! We have just come across a new issue in our application which we have traced ...
Score UpdateBatchSize Method not supported
Tony - 28 Mar 2007 9:37 PM - 1 message
Everytime I try to call UpdateBatchSize, I get an exception "Specified method not supported"  I'm using a strongly typed data set, and so far I have not been able to find anything on this error.  If I leave out the ...
Score Tabledefs and VB.net
Vanny - 28 Mar 2007 8:40 PM - 6 messages
I'm really new to vb.net.  What I like to know is what would be the code to read the definition of table or view. Here is the piece of code in VB6 that try to find a column name called "year" in a view. How to write this in ...
Score Loading ado.net table from datatableReader - wont update table on
Rich - 28 Mar 2007 7:04 PM - 3 messages
Hello, I have to read data from an external file into a ado.net table ds.tblExternal.ReadXml(...) and I want to load this data into a table that resides in a sql server (2000) DB.  I can do this if I loop through ds.tblExternal and add new rows ...
Score How do you programmatically create a file in the App_Data folder?
Tony Girgenti - 28 Mar 2007 4:59 PM - 7 messages
Hello. Developing a web site in VS2005, SP1, VB, .NET 2.0, ASP.NET 2.0 on XP Pro, SP2. I'm trying to write a file to the App_Data folder in my project using:         Dim docPath As String = "~\App_Data\Trips.xml" ...
Score Can not update text with Polish characters.
Eurofirms. - 28 Mar 2007 12:02 PM - 4 messages
I have a table where there are translations of various strings into different languages. I need to load this strings and allow some users to modify and update the strings back into the table. When I load a text written in polish, the application loads the data ...
Score Deployable SQL Server authentication for ASP.NET
warder - 28 Mar 2007 2:00 AM - 4 messages
Hi, We have an ASP.NET application that connects to a SQL Server database.  Historically we have used a trusted connection, and during our database creation, created granted database access to the system account <SQLSERVERNAME>\ASPNET. This appears to work great on XP in that IIS appears to connect to the SQL ...
Score Violation of PRIMARY KEY constaint...
Ken Abe - 28 Mar 2007 1:58 AM - 6 messages
Dear Community, I'm using ADO.net to update a SQL Server 2005 table. The table has a an aggregate primary key made of two integers. I use the typcial SqlDataSet/SqlDataAdapter tools to perform updates and inserts, after an ...
Score Problem with Data Readers and connections
Somesh - 28 Mar 2007 1:12 AM - 2 messages
Hi, I am doing maintenance work for a ASP .net application which uses ADO .net to access the data from database (SQL Server 2000).The functionality is something like that it uses SQL Data Reader to fetch the data and always open ...
Score Oracel User numbers
David++ - 28 Mar 2007 12:17 AM - 1 message
Hi, I've been connecting to an Oracle database using the System.Data.OracleClient provider. A web service connects to the Oracle database, runs a select statement, and then closes the connection. After each call I Dispose() of the OracleConnection, OracleCommand and OracleDataAdapter ...
Score dataset.update datetime skew from 00:00:00 to 01:00:00
Mars13 - 28 Mar 2007 12:03 AM - 1 message
hi, the dataset.update now(in daylight saving time +02) skews 00:00 to 01:00 when saving to sql2005 if i switch off the checkbox (daylight saving) in Date&Time applet, everything is ok. does anybody knows why this happens? is this by design? ...
Score How to handle Numeric Null Data in Excel?
Nilesh Gambhava - 27 Mar 2007 11:56 PM - 1 message
I am creating Excel Sheet using Microsoft.Jet.OLEDB.4.0 Create Table Query. It works well and I can transfer my data to Excel Sheet. The problem is whenever I have some numeric or date data and it is null then ...
Score VS 2005 MS SQL server express query problem
Yogi - 27 Mar 2007 9:43 PM - 4 messages
I wrote simple application (C#) that use a database (MS SQL serwer) and I had very strage problem I want to have pramized query, so my code is... SELECT     name FROM         person ...
Score Loading a stored procedure based on index?
mjpdatadev - 27 Mar 2007 2:48 PM - 6 messages
I have a few sprocs and I want to create a generic handler for them. Basically, I want to call any sproc and leave it up to the developer to know the parameters.  To keep it simple, I would like to do it so ...
Score DataTable merge using paging
jditsolutions - 27 Mar 2007 10:33 AM - 1 message
Hi,     I have an application which uses 4+ datagridviews, as time progresses the amount of data displayed is growing so I need to page the data in the datagridviews. Before my merges worked fine here's the ...
Score System.Collections.Generic.List
Kuldeep - 27 Mar 2007 7:44 AM - 2 messages
Framework: Visual Studio 2005, ASP.NET Programing Language: C#.NET I am using a Generic List Collection to fetch a particular master data from the database. Once collected, I use this Collection to bind it to a DataGrid. Now that I am using a Generic List Collection to populate the DataGrid, say ...
Score SqlClient/OleDbClient vs Remoting speed
Mark - 26 Mar 2007 1:32 PM - 2 messages
Hi I have prototyped a WinForms application that uses the Enterprise Microsoft Data Access block to load data into a strongly typed dataset. This works very well and is pretty fast. My problem is that our customers will probably complain about having ...
Score Unable to sort Dataview
Amritha.Datta - 26 Mar 2007 1:31 PM - 12 messages
Hi, I was trying to sort dataview using the below process. It is throwing exception. Please help.                 Dim DSExcel1 As DataSet                 DSExcel1 = New DataSet ...
Score BE VERY CAREFUL, AS YOU MIGHT BE A VICTIM OF SCAM/FRAUD RIGHT NOW!!
SIS - 26 Mar 2007 10:27 AM - 1 message
<HTML> <HEAD> <META NAME="GENERATOR" Content="Microsoft DHTML Editing Control"> <TITLE></TITLE> </HEAD> <BODY><FONT size=2> <P><FONT face="Arial Narrow"><STRONG><IMG ...
Score BE-CAREFUL, YOU COULD BE A VICTIM OF SCAM OR FRAUD!!!
SIS - 26 Mar 2007 3:08 AM - 2 messages
Attention! With several on-going cases of fraudulent practices being carried out by criminals on the internet, you are advised to carefully read this circular, so as to completely secure yourself from every fraudulent and scam attacks by criminals on the internet which is very rampant in our current world. ...
Score Help hasmorepages datagridview print
Scotty - 25 Mar 2007 9:17 AM - 1 message
Hi, Hope someone can help me I have a datagridview sith data Code below works fine if I print the data if there is only 1 page (without using '!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! If intRowPos <= 10 Then e.HasMorePages = False Else e.HasMorePages = True ...
Next »