Groups | Blog | Home


Archived Months
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
December 2007
January 2008
February 2008
March 2008
April 2008
all groups > dotnet ado.net > april 2004 > threads for wednesday april 14

Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

Online, Offline, Disconnected applications.
Posted by Aaron A. Anderson at 4/14/2004 8:46:05 PM
I'm in the initial stages of architecting an application for use in both an online and offline modes. I've looked at both the TaskVision application and the Offline Application Block for for guidance. The TaskVision application is much simpler in design than the Offline Application Block, but...more >>


whats the best way to do this?
Posted by suzy at 4/14/2004 8:42:54 PM
hi, i am 3 xml files containing train timetables, the columns in each xml file are "departuretime" and "destination". the difference between the 3 files are they contain train times for 3 different train companies. i want to display 3 columns (1 for each company), and display (in HTML) the ...more >>

InvalidOperationException - Cannot create file mapping error
Posted by Ben Fidge at 4/14/2004 6:02:32 PM
When connecting to one of my Sql Server 2000 databases running locally using SqlConnection, I get the following error: InvalidOperationException - Cannot create file mapping This is thrown during a call to SqlConnection.Open(); After this exception occurs, I can continue to use the con...more >>

ADO.NET Secret of eternal youth
Posted by Haim at 4/14/2004 5:34:25 PM
I have a web service which is syncronizing two Access (mdb) databases. The web service accepts a dataset. Adds the data to a table on the server and then returns the dataset with the server's id fields to the client, and the client is updated. Pseudo code as follows: Webservice Public f...more >>

ColumnChanged
Posted by WineNCheese at 4/14/2004 4:10:21 PM
How is it possible to recieve a column changed event, and have HasChanges() on the dataset return false? ...more >>

Auto Ajust the Column width in a datagrid
Posted by Gerry Viator at 4/14/2004 4:08:27 PM
Hi again I'm trying to ajust the width of columns in Datagrid based on the size of the Column Names and eventually the Values as well? The Code between the * is where I'm having the problem. This is not working, I'm getting a Error ShownDataTable.Columns.Clear() Dim i As I...more >>

OracleParameter Output using straight SQL not a stored procedure
Posted by kevin.schneider NO[at]SPAM level3.com at 4/14/2004 3:38:59 PM
I am trying to insert a new row into a table in Oracle. The table generates the ID during the insert through the use of a trigger. How can I pull back the generated ID when I do the insert with the following InsertCommand? OracleInsertCommand1.CommandText = "INSERT INTO WIDGETS(WIDGETID,...more >>

DataSet construction question
Posted by Mika M at 4/14/2004 3:36:09 PM
Hello! I have created DataSet with three tables, Master table, Child table, and Child table's Child table - and relations between them. Anyway I don't figure out how to handle primary and foreign keys when updating (inserting) these tables back into database tables. Is there any easy to learn ...more >>



SqlDataAdapter does not read input parameter to a stored procedure
Posted by rocio.katsanis NO[at]SPAM softwareservices.net at 4/14/2004 2:33:33 PM
I have this piece of code and keep getting error: System.Data.SqlClient.SqlException: Procedure 'web_GetTransaction' expects parameter '@PaymentStatus', which was not supplied. it crashes right after objDA.Fill(objDS) below, any ideas why? The only new thing is that, I'm running this from ...more >>

SaveToFile within Exchange Store Event
Posted by gerry at 4/14/2004 2:20:35 PM
I have an async OnStore event written in c# and registered in exchange 2003. Everything seems to be working fine other than the SaveToFile(). If there is an error in the iMessage.DataSource.Open ( ie. the message has moved ) the expected exception is raised and caught. However when the strm.Save...more >>

Access database in app directory
Posted by Dinko Deranja at 4/14/2004 2:00:07 PM
My question is simple, but I haven't found an answer: How to connect to Access database that will always be in the application root directory (in VS IDE)? I am making a windows forms application, and I dragged the OleDbConnection to the form. If I change the conn string (in "WinForm designer g...more >>

Access Table Access
Posted by Jim Heavey at 4/14/2004 12:20:36 PM
Hello, When I am using Asp.Net to read an Access table (from within VS.Net) and I "quit" (close out of IE, but still in VS.Net) the application and I attempt to open the access file in Access, I get a message which indicates that I can only have read access as something else has a "Lock" on th...more >>

VB: EndEdit won't save, PositionChanged does
Posted by Brian Link at 4/14/2004 11:21:30 AM
I whipped up a form using the dataform wizard. I have three records. If I make changes to a record and run my Save routine, I'll call the EndEdit method on the dataset, then Update. In this case, the record does not save successfully. If I navigate to another record using the wizard-generated...more >>

Microsoft Data Access Block for .NET under COM+ 1.5 ?
Posted by Kevin Jackson at 4/14/2004 10:26:25 AM
Can you use the Microsoft Data Access Block for .NET under COM+. In other words will it auto-enlist into COM+ transactions and all that jazz. My assumption is it will and you should not use any of the overrides that have the SqlTransaction parameter if you are using COM+ delcarative transac...more >>

Dataviews and joining to tables
Posted by Brian Henry at 4/14/2004 10:10:43 AM
I have a strange problem... I have a junction table that i need to filter based on a id, then take the filtered data and join it to a description table then show the data that was filtered in a listbox with the description instead of the id... here's an example Junction table ===========...more >>

Adjust Picture Quality in MyTV
Posted by George Economos at 4/14/2004 10:08:11 AM
Okay to start I am one of those suckers that managed to get his AIW 9800 working with MCE :) I split my cable sending one signal to my STB and the other to my AIW 9800. Both are hooked up to my Yamaha A/V receiver using a composite RCA connection. That being said the picture quality while ...more >>

Import Row... HELP!!!
Posted by m_gorgone NO[at]SPAM hotmail.com at 4/14/2004 9:51:43 AM
Hi All, Quite the Quandry here... I've got two list boxes with datasets bound to them. Items from the listboxes can be moved from one listbox to another and vice versa. The problem is that when a listbox is empty the first time I load it the load takes about 2 seconds and after that it's nice...more >>

releasing memory ...
Posted by paruchurip NO[at]SPAM hotmail-dot-com.no-spam.invalid at 4/14/2004 9:06:08 AM
I wrote a ado.net application that uses dataadapter,connection and command objects. I have a procedure to populate dataset.I call dispose on all objects after dataset is populate and close the connection. I see that the application still uses connection on sqlserver(I verified this by executin...more >>

memory..
Posted by pvp at 4/14/2004 6:21:04 AM
I wrote a ado.net application that uses dataadapter,connection and command objects I have a procedure to populate dataset.I call dispose on all objects after dataset is populate and close the connection I see that the application still uses connection on sqlserver(I verified this by executing sp_...more >>

Oracle Connection
Posted by Jim Heavey at 4/14/2004 5:10:26 AM
If I am wanting to see my Oracle databases in the "Server Explorer" am I suppose to right click on "Server" and add a server? I want to see all my tables and table definitions in the server explorer, how do I get this for Oracle database? Thanks in advance for your assistance!...more >>

Load Picture From SQL Database Table
Posted by Geoff Murley at 4/14/2004 3:31:06 AM
I have a Table containing an Image datatype Column. On a Windows Form I have a listbox containing the titles of image files e.g. sample.jpg, populated from the same table When the user clicks on a list item I want the related image to be displayed in a PictureBox contol. I have tried ExecuteScala...more >>

DataLink Properties in Win2k3 server ?
Posted by WJ at 4/14/2004 12:08:09 AM
ADO.Net Experts, I have a WinForm database app developed in my XP box, works great. When deployed to Win2k3 server (standard), it gave an AV on invoking the "ADO" Data Link Propertie dialog. My Win2k box has MDAC 2.8, everything on this box is lattest & greatest. I deployed the following fi...more >>


DevelopmentNow Blog