Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score Context Connection & Using
Scott M. - 24 Nov 2007 8:35 PM - 4 messages
When working with the SQL CLR, should I be using "using" when referring to the "context connection"? ...
Score Provider factory for Mobile / Compact Framework
Larry - 24 Nov 2007 5:56 AM - 3 messages
Hello, I am about to write an app for Pocket PC 2003 / Windows CE / Mobile 5 (don't know which yet) from which I need to query both SQL Server Express 2005 and SQLCe.  I would like to be able to use a provider factory to not have to ...
Score Datatable.Select on custom type column
Stephan Steiner - 23 Nov 2007 2:37 PM - 1 message
Hi Is there a way to do a select where the selection criteria is on a column of a custom data type. E.g. if the table column is defined DataColun column = new DataColumn("Task", System.Type.GetType("Task")); And the select would be something like ...
Score Problem with BindingSource and saving ...
Yen - 23 Nov 2007 9:40 AM - 2 messages
I created simple forms with wizard. From a DataSources I dragged table to form. VB GDI created DataSet, BindingSource and BindingNavigator controls. I code, I have for Save Button: Me.Validate() Me.DicInvSymBindingSource.EndEdit() Me.DicInvSymTableAdapter.Update(Me.AfbDbDataSet.DicInvSym) ...
Score Inserting data using a derived table in SQL Server Mobile
VooDoo - 23 Nov 2007 9:22 AM - 1 message
I need to put data from one table to another. In online book i found example but when run the script: insert into faktura1(ident_fakt, kod_odb) select(ident_fakt,  kod_odb) from faktura1_t a get an error 80040E14. When a insert only one field(column) every thing is ...
Score SQLException and mulitple threads
Henk Kelder - 22 Nov 2007 4:46 PM - 1 message
We run a service using multiple thread, all of them doing database access. Whenever the database stops or another another error occurs a SqlException is thrown. We log these exception using the exception building blocks and our logs show that ...
Score Named DataSets with Grids, How to enable a SqlServer Application role
Harry Leboeuf - 22 Nov 2007 11:11 AM - 3 messages
Hello, I'm a novice in .Net development (switched after 10 years Delphi). I've created a small test app with a Dataset in it. The Dataset contains a TableAdapter. In my Form i'm using a grid that uses that named dataset to display an ...
Score DataSet.ReadXml question
stefano_mi74 - 22 Nov 2007 9:37 AM - 1 message
Hi all, I've created my xml file  and I try to read it with : DataSet ds = new DataSet(); ds.ReadXml("Myfile.xml", XmlReadMode.InferSchema); Now in the my DataSet there are 4 table but I believe that it should ...
Score Linq To Sql-Beginners Q: can't Add new record (Add() method missin
Sky - 22 Nov 2007 2:11 AM - 2 messages
Hello: Downloaded VS2008 trial from MS 24 hours ago in order to investigate Linq To Sql. But I'm hitting a strange roadblock, where I am unable to find an Add() method on the dataContext's tables... And without, I can't add a new record. ...
Score SqlTransaction.BeginTransaction() within TransactionScope bad?
haroldsphsu - 22 Nov 2007 12:57 AM - 5 messages
Hi all, I have some existing code that updates the database by creating a SqlCommand and SqlTransaction: public class GroupMapper {     public static void Update(Group g)     {         // Gets SqlConnection, creates SqlCommand and calls ...
Score How to tell sql server the maximum size my temp table will grow so that it does at most 1 memory all
DR - 21 Nov 2007 9:43 PM - 1 message
How to tell sql server the maximum size my temp table will grow so that it does at most 1 memory allocation? ...
Score using a DataAdapter to insert with identity column
Andy Fish - 21 Nov 2007 4:31 PM - 2 messages
hi, i am using a DataAdapter and DataSet to insert rows into a table which has an identity column I would expect that once I have executed the update, the field in the corresponding DataRow would have been updated to reflect the newly allocated ...
Score Table Field Set To Not Allow Nulls
JimHeavey - 21 Nov 2007 4:12 PM - 2 messages
I have a table with 2 keys, which are of course identified as not being allowed to be null.  I have created a screen in which has a number of fields identified for selection criteria, and the user has the freedom to identify ...
Score Is this a Bug?
JimHeavey - 21 Nov 2007 3:44 PM - 1 message
Using the UI to create a dataset and then the associated queries...one of the queries I created the following SQL statement.... SELECT  ACCT_NUM, EMPLOYEE_ID, NAME, ADDR_LINE1, ADDR_LINE2, CITY, STATE, ZIP,               BUS_PHONE, HOME_PHONE, OLD_ACCT_NUM, GE_RATING, CST_CTR, ...
Score Accessing other Web Services from a Web Service
Masood - 21 Nov 2007 2:14 PM - 1 message
Greetings All, I have two web services, say webserviceA and webserviceB. Now I am supposed to make a call to the webserviceA (from client application) which will in turn call ( delegate call) to webserviceB. And the response will propogate back from webserviceB to webserviceA ...
Score DataAdapter W/Parameters
JimHeavey - 21 Nov 2007 5:27 AM - 2 messages
I used VS2005 to Created a Dataset and TableAdapter  and a number of queries for my Oracle Table.  I created a "BLL" class to handle my Business Logic Layer.  One of the "Select" query has selection criteria for a number of ...
Score michael lalonde wanderr tax solutions
mike lalonde - 21 Nov 2007 4:08 AM - 1 message
zippity michael lalonde married jennifer heinz and opened wanderer tax solutions together. they now employ 12 part time and 3 full time staff michael lalonde michael lalonde michael lalonde michael lalonde michael lalonde michael lalonde sudbury michael lalondemichael lalonde michael lalonde ...
Score DataList - How to programmatically add a separator row
Tony_VBACoder - 20 Nov 2007 10:56 PM - 1 message
With ASP.NET 2.0 VB.NET, how do I: I have a multi-column (4 columns) DataList control on my WebForm that displays sports teams for our league.  The data is grouped by Division Names where there are 4 teams per Division.  When the data is displayed on the Web ...
Score TransactionScope returns "Error HRESULT E_FAIL has been returned from a call to a COM component"
tbannon - 20 Nov 2007 10:45 PM - 1 message
I am using  ENTLIB2.0; VS2005; and SQLServer Express on a standalone machine.  Additionally we are using TransactionScope and are receiving an exception. We have enabled DTC and have also added MSTDC to the Firewall exceptions.  The database is resident on the local machine. ...
Score asp:SqlDataSource error handling
Arne Garvander - 20 Nov 2007 3:04 PM - 1 message
asp:SqlDataSource does not seem to have any error handling. Do you know a solution to that problem? ...
Score I have a CLR function thet returns IEnumberable (a table) and it has a FillRow function. I am return
DR - 20 Nov 2007 3:41 AM - 4 messages
I have a CLR function thet returns IEnumberable (a table) and it has a FillRow function. I am returning 10,000 integers from this function. Is there any way that I can preallocate the resulting table or give SQL server ...
Score RE: KB928365 and 'Internal .Net Framework Data Provider error 6' issue
Mark - 19 Nov 2007 4:34 PM - 2 messages
Looks like MS issued a hot fix for this on the 9th. [link] ...
Score Inserting taking to long time System.Data.OracleClient
vviktorsson - 19 Nov 2007 4:21 PM - 4 messages
Hi I hope I'm in the right group.  I'm accessing a lot of data from a WebService that returns me a DataSet.  I need to insert the Data set into an Oracle Database version 9.  It's taking about an hour to loop ...
Score SqlDataAdapter.Update questions
JJ - 19 Nov 2007 2:49 PM - 3 messages
I'd like to know exactly how an UpdateCommand determines that there are concurency issues, specifically if I have supplied I created my own update command, instead of using the SqlCommandBuilder. The issue I am facing is I have setup a column in my DataTable to map to an ...
Score reading data from an excel spreadsheet - is it supposed to be easy?
Andy Fish - 19 Nov 2007 11:00 AM - 4 messages
ok, so after a few dead ends I have got this far: 1. using visual studio 2005, create a new blank windows forms project and add a data source 2. create a new connection, select data source as "other" then select ".net ...
Score Re: DOWNLOAD CRACKED 2007's SOFTWARE: ARCHICAD 11,UNIG ...
Skyhighnemo - 18 Nov 2007 7:06 AM - 1 message
Hi, Saw your link while looking for 3Dflux software.  How do I obtain a copy from you and can it be FTP downloaded..  Graham ...
Next »