Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score remote server
koredump - 10 Dec 2005 11:09 PM - 5 messages
Hi All, I'm working on an distributable application that will have to connect to a remote sql server over the internet and would like to find out what will be the best way to implement this type of a connection. ...
Score Problem creating a Bitmap from an IO.FileStream
Nathan Sokalski - 10 Dec 2005 8:29 PM - 8 messages
I am having a problem saving an image with the same name it originally had. I have two similar versions of my code, one in which I close the FileStream used to open the original image before saving, the other in which I close the FileStream afterwards, although both return the same error. Here are the two versions of the code and the errors they each return (NOTE: I rebooted immediately before running each of these versions so that I knew they were run under exactly the same conditions, I think the FileStream gets left open because the error occurs before I can close it): ...
Score Querying Access Databases
Andruil - 10 Dec 2005 6:33 PM - 4 messages
Hi I am having some trouble using ado.net and was hoping someone could help me understand what i've messed up.  I am currently using ado.net from inside a C# asp.net project but i've also tried to do the same ...
Score With 30 minutes "work" millionaire?!?
With 30 minutes "work" millionaire?!? - 10 Dec 2005 4:51 PM - 1 message
With 30 minutes "work" millionaire?!? store / copy this text or site, before the administrator could remove this letter. You start this program quickly and simply NO RISK!! 100% SERIOUSLY and LEGAL!! Your dreams can be true!! Very honored friend, You have now just the probably best chance of your life to earn really ...
Score With 30 minutes "work" millionaire?!?
With 30 minutes "work" millionaire?!? - 10 Dec 2005 4:51 PM - 1 message
With 30 minutes "work" millionaire?!? store / copy this text or site, before the administrator could remove this letter. You start this program quickly and simply NO RISK!! 100% SERIOUSLY and LEGAL!! Your dreams can be true!! Very honored friend, You have now just the probably best chance of your life to earn really ...
Score Full text search command parameter from C#
zb - 10 Dec 2005 9:47 AM - 1 message
I have an application where I am required to run a full text query. My database is MySQL and code in C#. The way all queries are SELECT * FROM table WHERE firstname = ? and using command parameter the value of ? is ...
Score class designer
chris81 - 10 Dec 2005 8:36 AM - 2 messages
hello, when i create a diagram of class, ya you it a means of launching an automatic creation of a base of data being pressed on this diagram?? thank you ...
Score ADO.NET 2.0 Merge/Load XML question
css - 10 Dec 2005 3:51 AM - 3 messages
I have a DataTable with three columns "UniqueID", "A" and "B". Rather than pass updates like: <DataTable UniqueID=1 A="data.." B="data.."/> The application gets XML from a 3rd party and they want to economically send data packets over the network like so: ...
Score Using Connection Class VS Connection Module in Asp.net Application
Dave Johnson - 9 Dec 2005 11:18 PM - 5 messages
Working on Asp.net with access database backend,a serious Question in the Class design phase, for accessing the database; Which is Better to make a Connection Class that handles all the ADO Connections for all the other Objects, OR ...
Score Datatable Column ByteArray Problem
Phil C. - 9 Dec 2005 6:22 PM - 4 messages
I've been having trouble getting a byte array back as a datatable column with this code: Public Class RegisteredCustomerVerify     ''' -----------------------------------------------------------------------------     ''' <summary>     ''' Friend Function ValidEmail     ''' Pass plaintext email address to stored proc that must use ...
Score Dataset Name
Vayse - 9 Dec 2005 4:29 PM - 4 messages
From the help Dim dataSet As DataSet = New DataSet("Suppliers") Why name the dataset? Why not just use Dim dataSet As DataSet = New DataSet() Thanks Vayse ...
Score ODBC query to modify DBF table structure
Andrzej Kaczmarczyk - 9 Dec 2005 4:27 PM - 5 messages
Hi, I have a DBF table that I can access using from VisualStudio 2005 via ODBC OdbcConnection conn; string connectionString = @"Dsn=Pliki programu dBase;defaultdir=c:\DBFFiles;driverid=533;maxbuffersize=2048;pagetimeout=5"; conn = new OdbcConnection(connectionString); conn.Open(); I can then for example query it with select or import a schema ...
Score When does the Dataset load?
Vayse - 9 Dec 2005 4:02 PM - 4 messages
Lets say I create a databound Form with the datasource config wizard. It has a Dataset  -> TestDataSet, and two table adapters. When the form loads, I have code like so   Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As ...
Score Self-referencing elements in XMLREAD
Doug Gault - 9 Dec 2005 3:40 PM - 1 message
I've been very pleased to find that you can load an XML file into a DATASET using the XMLREAD method, but I'm having a problem when trying to load a file that contains self-referencing elements. Here is an excerpt from the .XSD file ... ...
Score Migration SQL2000 to SQL2005
Lorenzo Soncini - 9 Dec 2005 2:44 PM - 3 messages
For some customer we plan a Sql Server Migration but in our test  all the application build with .NET 1.1 don't access the new SQL Server 2005. We have tested the creation in a VS2003 a new connection to the SQL server ...
Score Excel Data messed up after insert or update
Malky Wullur - 9 Dec 2005 1:05 PM - 1 message
hi guys, I have problem with inserting & updating row in excel... for example I have 5 columns in first row and 100 rows , using HDR=yes will have data table which column name appears as expected. the problem arise when you have empty value cell in one of the row, ...
Score Sql Server doesnot exist or access denied
Gomathi - 9 Dec 2005 7:02 AM - 4 messages
I am getting a 'SQL Server does not exist or access denied. ' error when trying to access a SQL Server Database from my local machine. I have the code on the web server and it is working fine. My connection string is fine and I am able to log into SQL Server via ...
Score dataGridView + dataSet in ADO.NET 2.0
Friedhelm Drecktrah - 9 Dec 2005 5:45 AM - 3 messages
Hi, I have a dataGridView databinded to a dataSet. The Rows are in a specific order and I want to swap the selected row with the row below it. I have a RowNum (int) Field in the database. How can I do this? ...
Score DbProviderFactories.GetFactory(row) exception
David Thielen - 9 Dec 2005 3:39 AM - 7 messages
Hi; I have the following code: DataTable table = DbProviderFactories.GetFactoryClasses(); foreach (DataRow row in DbProviderFactories.GetFactoryClasses().Rows) DbProviderFactory providerFactory = DbProviderFactories.GetFactory(row); The DbProviderFactories.GetFactory(row) throws an exception when the row has the values: "SQL Server CE Data Provider", ".NET Framework Data Provider for ...
Score Advanced Button Missing
darindaniel - 9 Dec 2005 1:59 AM - 1 message
On the TableAdapter wizard the 'Advanced' Button is not there. Version Issue? Bug ? ...
Score Wildcars with DataAdapter
JohnT - 9 Dec 2005 12:18 AM - 9 messages
I fell like a Dufuss... Going from VB6 to VB.net and it's like walking all over again... I think I'm at the crawl point (: I'm using VB.net and opening a MS Access db.  Then displaying the info into a ...
Score ADO.NET 2.0 and VS 2003
jones6 - 8 Dec 2005 11:25 PM - 5 messages
We would like ADO.NET 2.0 but don't want to upgrade to VS2005 yet.  We would like this for automatic failover in the connection string in ADO.NET 2.0 for database mirroring.  Does anyone know if we can upgrade to ADO.NET 2.0 ...
Score ASP.NET: dollar sign ($) on the page changed to not displayable character
Norman Yuan - 8 Dec 2005 11:11 PM - 5 messages
System: ASP.NET app, .NET 1.1, developed on VS.NET2003. Windows Server 2003 Std. with SP1, IIS6.0 Problem: The app is a invoicing system, a lot of numbers are displayed as currency, like $200.00. These numbers are formated in the code using either {0:C}, or ...
Score TableAdapter.Update = No Updates
Jay Pondy - 8 Dec 2005 8:29 PM - 2 messages
Need some troubleshooting guidance on this one as I am stumped as to where or what to look at next. I have a VS2005 strongly typed dataset with a TableAdapter using SQL2000 stored procedures for select, insert, update and delete. ...
Score Data Inserts using DataAdapter
sameer - 8 Dec 2005 8:26 PM - 2 messages
hi, this is something very basic that i am trying to get done here. i want to update and insert record to the database using a dataadapter which would use Update and insert stored procs. this is easy and i can handle that, ...
Score Re: Updatable views
Rick Elbers - 8 Dec 2005 7:10 PM - 2 messages
Hello Paul, To make it less abstract lets take 1 simple example. Lets say we have Orders, Products, Customers, ProductPrices and OrderDetails and we find some way to edit or select all those in 1 gui( thats a challenge on itself but a different one). Think about a grid with ...
Score Using ODP.NET 10 to connect to oracle 9 database
Andy Fish - 8 Dec 2005 4:34 PM - 5 messages
Hi, As a workaround to my problem with the microsoft oracle provider (see my recent post in this same group) I am considering switching to Oracle's own ODP.NET. When I go to download it, I can download either version 9i or 10g. Should I ...
Score NullReferenceException calling OracleConnection.Open()
Andy Fish - 8 Dec 2005 3:49 PM - 2 messages
Hi, I have an asp.net application which intermittently throws the following exception trying to open an oracle connection System.NullReferenceException: Object reference not set to an instance of an object. System.Data.OracleClient    at System.Data.OracleClient.DBObjectPool.GetObject(Object owningObject, ...
Score How can I make DataGridView retrieve the table structure from DAL or BLL for design?
abc my vclass - 8 Dec 2005 3:46 PM - 1 message
How can I make DataGridView retrieve the table structure from DAL or BLL for design? ...
Score Sorting a DataTable without binding it to a data control
Mark Rae - 8 Dec 2005 11:22 AM - 3 messages
Hi, Sorry about this, but I'm having a brainstorm here. I'm returning a DataSet from a SQL Server database via a stored procedure, and need to sort the data by a dynamically chosen set of fields. The DataSet is then used for various ...
Score Need filling four combo with same DataView
Chakravarti Mukesh - 8 Dec 2005 11:20 AM - 2 messages
Hi, I have a form with four Combo whose DataSource and DisplayMember is the same.  The problem is that when I select a value from a combo all other combo start displaying same value.  I have not used any ...
Score Multiple Filter Application ADO 2.0
Giovanni - 8 Dec 2005 5:55 AM - 2 messages
Hi All,      Does anyone know, besides building a concatenated string, how to apply multiple filters on a datatable?  For example, if I have 4 comboboxes with prefilled values, depending whether a combobox has a chosen value or not, ...
Score ADO .NET Data Validation 2.0
Giovanni - 8 Dec 2005 5:52 AM - 3 messages
Hi All,      I am using VS 2005 and ADO.NET 2.0 to build a Windows Forms.  I am binding my data source to a datagridview and would like to know the following:      Where is the best place to perform data validation ...
Score Commits or rollbacks issued following each select
Jim - 8 Dec 2005 2:38 AM - 6 messages
I have an application that uses the direct provider for Oracle to connect to an Oracle database server. While looking at Oracle trace files, I discovered something that bothers me. The following pseudo-code describes the problem. string statement = "Select fielda, fieldb from tablea where fieldc = ...
Score I want to instantiate an OleDbException
PIEBALD - 7 Dec 2005 9:16 PM - 3 messages
I want to do something like: catch ( System.Data.OleDb.OleDbException err ) {     throw ( new System.Data.OleDb.OleDbException ( "something application-specific" , err ) ) ; } But the constructoris not public (it seems). Is there a work-around other than using System.Exception (which isn't ...
Score Pessimistic Locking
Ferdinand Zaubzer - 7 Dec 2005 7:09 PM - 5 messages
I would like to use pissimistic locking for changing data on a database. (Yes, I know what I'm doing, it will scale poorly!) I tried it using a transaction with Isolationlevel "serializable". I set the select, insert, update and delete command of the DataAdapter ...
Score Get all servers, databases, etc
David Thielen - 7 Dec 2005 6:56 PM - 5 messages
Hi; With the new ADO .NET 2.0, is there a way to have it enumerate all: servers (of a given type such as Sql Server, Oracle, MySql, etc.)? databases on a server? tables, views, and stored procedures in a database? ...
Score Opinion on my Data Access Class - VB.NET - 2nd Draft
kirby.matt - 7 Dec 2005 5:23 PM - 1 message
Thanks for the feedback on my last post. Can I get some thoughts on my 2nd try. This time I created 2 classes, the DBObject and a Parameters class. Any feedback would be appreciated. Imports System Imports System.Data Imports System.Data.SqlClient ...
Score insert a null value into a datetime field
Esperanza - 7 Dec 2005 3:56 PM - 2 messages
Hello dotnet experts ! I need to insert a null value, into a datetime field if the user dosen't enter one. I crash everytme I tried. What can I do ?? Thanks in advance !! Esperanza if (this.txtDatePrescrip.Text.Equals("")){ this.appAjustement.Parameters["@DatePrescrip"].Value = null; ...
Score DataView.FindRows between two values?
michael.hodgson - 7 Dec 2005 3:54 PM - 1 message
I am trying to quickly extract subsets of data from a dataset. For example perhaps a date range, or where a string value lies between A and M I know that I can use A DataView.RowFilter for this, but having the ...
Score BindingSource.Add raises error
Simon - 7 Dec 2005 2:26 PM - 10 messages
I have a combobox on a form bound to a bindingSource. DataSource is derived from BindingList as follows: public class RendererList : BindingList<RendererListItem> { public RendererList() {     Add(new RendererListItem("Active Server Pages")); } } In my form I am calling the Add method to set the source ...
Score Dual Database Maser Detail Form
KevinM - 7 Dec 2005 2:21 PM - 3 messages
Hello, I am trying to create a windows form in VB.NEt that is based on a maser detail layout (dropdown with a data grid). My problem is that I am using two differnt SQL Server databases for either part of the form, and VS does not ...
Score Transaction cannot enlist in the specified transacion coordinator
Benny - 7 Dec 2005 11:16 AM - 1 message
When trying to run my application from client on server I get this error. I know about the firewall problem when client is Windows XP SP2 - and this didn't help. Then I tried the tool dtcPing. On the server (Windows 2003 SP1) this reports ...
Score auto session check with override
rony_16 - 7 Dec 2005 10:50 AM - 1 message
hi , i want to override the object session in class page , because i want to check the Session["UserName"] automaticly in WebForm , without writing "if" in evry page . i know that i need to make a new class Lib and inharite from "page" . ...
Score connection pooling
Clipboard J. Spaghetti - 7 Dec 2005 10:04 AM - 4 messages
Hello everyone, Could you please tell me if it is appropriate to use code such as this to generate a valid SqlConnection object for use with objects that use it?   private SqlConnection GetConnection()   {     try     { ...
Score Get transaction object from a connection
quylevinh - 7 Dec 2005 9:18 AM - 4 messages
After I begin a transaction: e.g: IDbTransaction aTran = aConn.BeginTransction(); I see in the debug window a lot of member of the connection such as: _transaction, HasTransaction, Transaction,.. But I can not get the values of them in my code, I guess they are private ...
Score How to Load SpreadSheet in AxSpreadSheet object in VB.NET or C#.NET
Lucky - 7 Dec 2005 7:20 AM - 1 message
hi guys,     i've just started woth Excel component in .NET. i manged to import the Excel Component on windows Forms but i'm not able to load Excel file in that. if anyone has any idea how can this be done please do let ...
Score Disconnected dataset -- can't delete row???
Rob Perkins - 6 Dec 2005 8:38 PM - 14 messages
The following code snipped is intended to delete a row from a typed dataset. The name of the dataset instance is "dbMats", which contains a table called "CastingAlloys". Instead of deleting the row it is actually   moving the row to be the first item in the dataset's "CastingAlloys" ...
Score sql dependency through webservice ?
Rick Elbers - 6 Dec 2005 6:36 PM - 2 messages
Dear all, Is something like sql depency with a webservice dataset or table  possible ? If not say that we want direct mutual communication how difficult would it be to use remoting in 2.0 ? Had some traumas with remoting's security ...
Score Data validation on row of DataGrid
lisa.biagioni - 6 Dec 2005 3:48 PM - 3 messages
Hi, I have a DataGrid bound to a DataTable in a Windows Forms application. I'm using the DataTable.RowChanging event to trigger the validation of a row when the user has modified a row and clicks off of it.  The ...
Score DataTable select method behaviour
Abhishek - 6 Dec 2005 3:41 PM - 5 messages
Hello,            I was using Datagrid (Windows Forms) the datasource of which was a DataTable. If I try to modify or delete some rows from the Datagrid using the underlying DataTable then ...
Score CLR Trigger Rollback
David R - 6 Dec 2005 3:15 PM - 2 messages
How can I setup a CLR  trigger to rollback the transaction that fired the trigger if an exception occurs. Here is waht I'm trying to do SQL: INSERT INTO myTable(column1, column2) Values(1, 2) C# Trigger: .... try ...
Score Customizing MSDataSetGenerator output in VS2005
Stig - 6 Dec 2005 12:53 PM - 2 messages
Hi, I am using a strongly typed dataset in .Net 2.0, and would like all tables to inherit from a cusomt datatable class instead of DataTable. The reason for this is that I want some common code excuted on the row ...
Score Handling Special Characters when reading Excel file
Rohit - 6 Dec 2005 12:48 PM - 1 message
Hello, When trying to read an excel file, one of the Column names contains special Characters such as "Vehicle ' " [ (  & % $ # @ ! ~ ` ^ * Name". When i read this excel file using OLEDB in VB.NET, I get an error message. How can i load the excel file with this column header? ...
Score ADO.NET connection string for Excel
Mori - 6 Dec 2005 12:45 PM - 4 messages
Need a good working example of reading Excel using ADO.NET.  Here is what I have but it does not work.  The problem seems to be how to escape the quotes in the Extended properties.  Any suggestions appreciated. ...
Score Selecting rows from table according the rows from another table
Zoltan Hubai - 6 Dec 2005 11:29 AM - 3 messages
Hi I would like to select rows from one table according the rows from another table in .net with C#. Both tables are loaded into memory. For example a simple structure CustomerGroup                      Customer ...
Score Merge dataset into identical table?
Chris Ashley - 6 Dec 2005 10:46 AM - 3 messages
Hi there, If i have a dataset which has a datatable which has fields matching an existing SQL Server DB Table exactly, is there an easy way to merge all the records from the datatable into my SQL table without having to ...
Score Merge dataset into identical table?
Chris Ashley - 6 Dec 2005 10:46 AM - 1 message
Hi there, If i have a dataset which has a datatable which has fields matching an existing SQL Server DB Table exactly, is there an easy way to merge all the records from the datatable into my SQL table without having to ...
Score DataSet in ArrayList
murali.trichy - 6 Dec 2005 8:11 AM - 4 messages
Is it possible to store my Dataset in ArrayList ? if yes then How ? bye murali ...
Score @@ERROR per connection?
Jeff User - 6 Dec 2005 4:34 AM - 2 messages
Hi Hoping someone may know this. I am connecting to sql server 2K via OleDbConnection from C#, .net1.1 Is the instance of @@ERROR that is set in db per connection? What I was going to do was, after connecting and opening a data reader on one ...
Score Opinion on my Data Access Class - VB.NET
kirby.matt - 6 Dec 2005 12:14 AM - 4 messages
Hi, I was wondering if some other experienced .NET developers could give me opinions, feedback, or critisizms on the data access class I developed for an application I am starting.  I just want to make sure I am not overlooking anything. I also want to know if I am following ...
Score Opening a SQLExpress database (Desktop) from PocketPC
Paul Aspinall - 5 Dec 2005 10:40 PM - 2 messages
Hi Can anyone point me in the right direction.... I'm trying to open a SQL Express 2005 DB, from my PocketPC, so that I can write some code to synchronize the data. Does anyone have any code to show this being done?? ...
Score Closing a connection confusion
tshad - 5 Dec 2005 9:28 PM - 6 messages
Question on Closing connections. I just got an error: Message: Timeout expired.  The timeout period elapsed prior to obtaining a connection from the pool.  This may have occurred because all pooled connections were in use and max pool size was reached. ...
Score Parameterized Query issue
Steve Enzer - 5 Dec 2005 8:11 PM - 4 messages
Hi, Using a data adapter, I've created a query containing four parameters.  The query looks something like this: SELECT * FROM Materials WHERE (Type=@Type) AND (Material=@Material) (I've simplified the statement to include only two parameters here.) ...
Score SqlDataSource optional parameter problem
JSmith - 5 Dec 2005 7:00 PM - 2 messages
Hi, I'm having some issues with the SqlDataSource. I want to use it to populate a GridView, but using an optional parameter to filter the results. This is what I have right now (hopefully haven't made any typos - can't ...
Score OdbDataReader.GetSchemaTable and SQL Server 2005 XML Data Type
Howard Hoffman - 5 Dec 2005 4:44 PM - 5 messages
Does the System.Data.Common.OdbDataReader type shipping with VS.NET 2005 support the XML column type on SQL Server 2005? I've a stored procedure that has an input parameter of the XML data type. If I create an OdbcDataReader via OdbcCommand.ExecuteReader( .. ) and try to ...
Score Deadlocks during SqlDataReader.Read method
jason - 5 Dec 2005 3:32 PM - 5 messages
I have found one other thread on this topic, but the responses only described "bad" ways to fix the problem. I'd like to know if there are any "good" ways to fix the problem :) I have a class with a private, instance-level SqlDataReader reference ...
Score Filter data when populatinga dataset
Roby Eisenbraun Martins - 5 Dec 2005 10:38 AM - 7 messages
Hi,     I want to fill a dataset with only some records. How can I add a filter in the dataadapter? ...
Score ADOX Problem
Mr. B - 5 Dec 2005 8:57 AM - 3 messages
VB.net 2003 and MS Access db File.  Framework 1.1 installed. This afternoon, I spent some time here on a new project.  During that time I added the ADOX 2.8 reference to my application and proceeded with code to ...
Score Retrieving Excel Sheet Names/Column Names
Rohit - 5 Dec 2005 6:39 AM - 7 messages
I am using GetOleDbSchemaTable to get the sheet names and the column names from the Excel file. It is working fine with all workbook/worksheets except one that when I try to load the worksheet name "04cars", it gives me an ...
Score Sync SQL Server Express 2005 and SQL Server Mobile 2005.
Paul Aspinall - 4 Dec 2005 9:50 PM - 3 messages
Hi I have an application which runs on a desktop. I want to synchronise the DB with a PDA app, which also uses SQL Server 2005 (mobile and express). How can I connect to the Desktop DB, from the PDA, in order to check if I ...
Score Detecting a change in a file or directory
Nathan Sokalski - 4 Dec 2005 7:35 PM - 4 messages
I have several pieces of data that I use the HttpApplicationState for, because they rarely change and are used by everyone. When these pieces of data are created, they are created either from several files that rarely change or are a list of the files in a directory that I rarely add or remove ...
Score dataTable.Compute("Count(GuidCol)", "") generates Exception
GilesT - 4 Dec 2005 7:19 PM - 5 messages
Hi, I have a datatable that has three columns each of data type Guid. (which I have just changed from previously being Integers) In the past I have used : dataTable.Compute("Count(Col1)", "Col1=5")  - which worked fine Now having changed the data types to Guids I get an exception when I use: ...
Score Oracle Cursor Function - Embedded Cursors
JMB - 4 Dec 2005 5:15 PM - 1 message
Platform Background: ..NET 1.1 Framework System.Data.OracleClient Oracle 9.2.0.6 Consider the following: CREATE OR REPLACE PACKAGE EMPLOYEE_PKG AS    TYPE T_CURSOR IS REF CURSOR;    PROCEDURE GetDepartments (dept_cur OUT T_CURSOR); END EMPLOYEE_PKG ; CREATE OR REPLACE PACKAGE BODY EMPLOYEE_PKG AS ...
Next »