Internal .Net Framework Data Provider error 6
(2 messages)
Date: Tue, 7 Aug 2007 08:35:40 -0400
We have started experiencing "System.InvalidOperationException: Internal
..Net Framework Data Provider error 6" exceptions from our Visual Studio 2005
applications since implementing Mirroring with SQL Server 2005. If we ...
|
Specify DB Location for Auto-generated Dataset
(3 messages)
Date: Tue, 07 Aug 2007 02:38:10 GMT
I auto-generated a dataset for CRUD DB usage. I did this to save the time in
generating this myself by hand. Bad idea or not I'd still like to use the
code, but I also want to dynamically specify the location of the database ...
|
Detecting database column data type of smalldatetime vs. datetime?
(4 messages)
Date: Mon, 6 Aug 2007 21:54:54 -0400
Is there a way for C# ADO.NET code to determine whether a SQL Server column
data type is smalldatetime vs. datetime? It looks like DataColumn.DataType
makes no distinction, both return DateTime.
...
|
DataReader and DataAdapter
(8 messages)
Date: Mon, 6 Aug 2007 13:16:02 -0700
I want to get a better understanding in using DataReader and DataAdapter to
retrieve data from MS SQL Server 2005. I'm using visual basic 2005 and .net
3.0.
Is there any difference in retrieving data in MS SQL Server ...
|
Pass Null parameter from VB.NET to Access Query
(2 messages)
Date: Mon, 06 Aug 2007 05:14:06 -0700
I have created a access query where if I give parameter value Dept
Code like 41 then the details of this department is shown. But If I
give null then It will show All the detartments details one after
another. But my problem ...
|
newbie question
(7 messages)
Date: Mon, 6 Aug 2007 12:56:25 +0100
Hello,
I did some database programming in the past and I always used database
controls which were offered by VB to connect to a database (Access
database). One facility that offered by these controls and I like it ...
|
Checking for open db
(1 messages)
Date: Mon, 6 Aug 2007 03:13:58 +0100
Hi
In my app I am opening a db connection then running a set of queries and at
the end closing the db connection. Once in a while a query fails to run
saying database connection is closed. How can I ensure that db connection ...
|
Converting a winform app into service
(1 messages)
Date: Mon, 6 Aug 2007 03:01:10 +0100
Hi
I have a winform app that uses a timer to periodically run a number of
queries on an access db and write the results in a rich text control on the
form. I have two questions;
1. If I am to convert this app into ...
|
Assigning null to OleDb.OleDbConnection
(1 messages)
Date: Mon, 6 Aug 2007 02:55:29 +0100
Hi
How can I assign a null value to a variable of type OleDb.OleDbConnection?
Thanks
Regards
...
|
Is it possible to get the leftmost tab name of a Excel file?
(1 messages)
Date: Sun, 5 Aug 2007 12:10:03 -0700
Is it possible to get the leftmost tab name of a Excel file using ado.net?
Thanks, ...
|
|
Problem about showing ErrorIcon and Error tooltip text in the dgv.
(1 messages)
Date: Sun, 05 Aug 2007 17:38:33 -0000
Hey all,
I tried to show both error Icon and error tooltrip text when the error
is raised.
The cell ErrorText is set in the CellValidating event handler function
in my dgv like followings,
if (Convert.ToInt64(e.FormattedValue ...
|
Undo, redo functions in dgv.
(1 messages)
Date: Sun, 05 Aug 2007 17:21:42 -0000
Dear all,
I met two problems.
1. "Undo" only worked when the XML file was loaded. However, it didn't
work when the new row is added in the dataTable ["a"] in dvg.
There are dgv, dataset and target xml file in my application ...
|
Problem about moving the rows in the dgv + XML + dataSet.
(1 messages)
Date: Sun, 05 Aug 2007 17:15:24 -0000
Hey,
In my application, I have to manipulate the XML file in the dgv, which
is bounded by DataSet. E.g. move the selected row in the dataTable "p"
which is in the DataGridView dgv "up" and "down", then save it to the
DataSet ...
|
Fighting with typed data set and child relation
(3 messages)
Date: Sun, 05 Aug 2007 04:54:01 -0700
Hi,
the problem I have, is that the GetChildRows() method does not work. I
get error:
Unable to cast object of type 'DEBTORRow[]' to type 'DEBTOR_NACERow[]'
>From the database (oracle10gR2 using Oracle .NET provider ...
|
Updating and Merging with Order Details
(4 messages)
Date: Sat, 04 Aug 2007 12:26:37 +0100
My question is do merges always take place using the original values of primary key fields ?
For example using the Northwind Order Details table:
1. The primary key is OrderID and ProductID.
2. The user can change the ...
|
SqlDataReader and null fields
(2 messages)
Date: Fri, 3 Aug 2007 23:20:05 -0400
I am returning data using a SqlDataReader. Here is a snippet of code where
I am having a problem. What is the best way to handle nulls?
private void TGenerateJobSiteList2FromReader<T>(SqlDataReader returnData,
ref List<JobSite> ...
|
ADO.NET driver for MySQL?
(2 messages)
Date: Fri, 03 Aug 2007 15:37:09 +0200
Hello,
I have dowloaded two drivers for MySQL:
- mysql-connector-net-1.0.9.zip
- ByteFX.MySqlClient.76.NI.zip
Which one do you recommend?
Please help
Thank you!
RAM ...
|
ObjectDataSource
(3 messages)
Date: Thu, 2 Aug 2007 22:22:43 -0400
I am using an ObjectDataSource to populate a GridView. The ObjectDataSource
accesses the data in the table by means of a Stored Procedure using a
SQLCommand.ExecuteReader. Does this mean that I can't easily do sorting ...
|
Linq group
(2 messages)
Date: Thu, 2 Aug 2007 20:11:02 -0400
Is this gonna be the place for Linq questions (not the windows forum)?
--
William Stacey [C# MVP]
PowerLocker, PowerPad
www.powerlocker.com
...
|
DataGrids with Multiple tables
(3 messages)
Date: Thu, 02 Aug 2007 21:46:53 -0000
Hi, I want to have a DataGrid with two columns - 1 from one table and
one from another. The tables are linked by a key from the 2nd to the
first. I am using a DataSet in .Net and the tables are in the DataSet
and there is ...
|
