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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|