| Groups | Blog | Home |
|
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 |
Filter by week: 1 2 3 4 5 Get extern changes back into dataset without completely refill Posted by rfw68 at 5/14/2007 11:57:01 PM Hello,
I have a (typed) dataset for some tables in a sql-server express.
Well, loading the datas with Fill and sending changes to the sql server with
Update works fine.
What I like to do is, sending the changes in the sql server (done by an
other instance of my application on a different ...more >>
object-relational mapping Posted by Deanna at 5/14/2007 10:54:11 AM Hi,
We're looking for recommendations for an object-relational mapping
product that will work with Microsoft's Data Access Layer and is
either free or very reasonable. We have a very complex database and
would need a robust product able to map complex objects. We are
currently using a cu...more >>
partial merge? Posted by eran at 5/12/2007 12:19:00 PM Hi,
I'm using DataTable.Merge() to merge values from a source DT into a
destination DT which are in seperate Datasets.
The source DT has columns A,B,C and the destination DT has columns A,B,D.
column A is primary key for both of them. So, basically, my target is to
copy all the values from co...more >>
OleDb and x64 Posted by Mark Rae at 5/11/2007 11:50:22 PM Hi,
Since there *appears* to be no 64-bit support for any data source other than
SQL Server (and I wouldn't use OleDb to interface with SQL Server anyway as
there's a native .NET data provider for that), what is the "accepted wisdom"
for porting 32-bit apps to 64-bit when they require OleDb...more >>
Query in memory dataset c# 2 Posted by deciacco at 5/11/2007 2:46:17 PM Is there a way to query an in-memory dataset with sql or can you only
work with the individual table through DataTable.Select()?
How can you go about getting the identity of a new record if you use an
autoincrement primary key on the datatable?
Thanks...more >>
How to populate an empty table in DB? Posted by Lubomir at 5/11/2007 10:14:00 AM Hi,
I am wondering how I could populate the ampty table in the database from the
DataSet or DataTable.
So far I am using SqlBulkCopy. Is there any other way, or is it I should be
using? I could make Insert row by row, but it is slow, I guess.
Thanks,
Lubomir...more >>
Help, Connection to Access Database Posted by Randy at 5/11/2007 12:00:00 AM Hi,all
I met one problem of connecting Access database in asp.net web program.
I use ODBC link to Access, the connection string like
"PWD=12345;DSN=QADLinkMDB;DriverId=25;MaxBufferSize=2048;FIL=MS
Access;PageTimeout=5;UID=apiprogram"
while runing program, system prompt error: the ...more >>
TableAdapter not updating table if the table is empty when loaded? Posted by Brooke at 5/10/2007 5:08:51 PM I am having problems with the table adapter not updating (inserting a new
record) the sql server table if I open the form with out any records already
in the sql server table.
If I add on record in sql server management studio, the the table adapter
will work correctly, but there has to be ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Ole DB Jet 4.0 Provider corrupts recipient Excel database predicta Posted by Jim Walsh at 5/10/2007 1:45:00 PM VS2005 C# 2.0
I'm using ADO.NET and the Jet 4.0 OLE DB provider to append a row to an
Excel spreadsheet.
I have a data table of type System.Data.DataTable, and a table adapter of
type System.Data.OleDb.OleDbDataAdapter to fill the data table. These are
generated by the VS2005 dataset des...more >>
How do I make lots of changes to a database table using a dataset Posted by HONOREDANCESTOR NO[at]SPAM YAHOO.COM at 5/10/2007 8:13:33 AM Hi,
I'd like to take a table in a database and modify some rows and delete
some others. So I created a dataset, and tried to make modifications
to one of its tables, and then I tried to send it back to the
database. But I got an error message: "update requires a valid
UpdateCommand when passe...more >>
Merge Replication SQL 2000 and SQL Server Compact Posted by JB at 5/10/2007 5:40:19 AM I have a desktop application using SQL Server Compact Edition and I
want to use merge replication with an SQL Server 2000 database (SP4).
I have installed all the necessary things (sqlcesa30.dll is available
via IIS and displays the message: "Microsoft SQL Server Compact
Edition Server Agent" ...more >>
Concurrency control in updating Access records? Posted by pedestrian at 5/9/2007 10:06:47 PM I'm using OleDbDataAdapter to update records to the Access database.
Refer to the "Introduction to Data Concurrency in ADO.NET" topic in MSDN:
"The Saving-All-Values Approach" section
ms-help://MS.MSDNQTR.v80.en/MS.MSDN.v80/MS.VisualStudio.v80.
en/dv_raddata/html/d5293098-4a88-4110-abd2-34d9e...more >>
SQL Server Stored Procedure Try Catch and ADO.Net exception handli Posted by Phil Sharp at 5/9/2007 2:29:01 AM Hi
We have recently moved onto SQL 2005 and our DBA wants us to use Try Catch
within our stored procedures.
If I have an SP such as:
CREATE PROCEDURE NoTry
AS
BEGIN
INSERT INTO MyTable(Id, Description)
VALUES (3, 'Toodles');
END
and I have a primary key on the Id field and re...more >>
ReadXML Dataset - Original Rows, RowState = Added (not Unchanged) Posted by kkam99504 at 5/8/2007 8:29:02 PM I realize the original quesiton was dealt with but this appeared to be the
most appropriate thread to post my question under. Here is my senario:
1) Connect to DB
2) Fill DataSet with tables, set Relationships, Constraints
3) Save DataSet to file
4) Send DataSet (a...more >>
How to get Column Description from SQL Server Posted by Aamir Mahmood at 5/8/2007 3:04:32 PM Hi,
Can I get the column's description in my code, for each columns in the
table.
'Column description' is set at the table design time.
Thanks.
-
Aamir
...more >>
Calling code behind without losing values Posted by Doug at 5/8/2007 9:30:28 AM Hi,
I'm trying to set up a refresh of some of the data on a page and am
using this:
<meta http-equiv="refresh" content="120">
This works great with one exception. I only want to refresh one grid
on the page, not the entire page. I have the values I don't want to
refresh in the "is not pa...more >>
Supporting Transactions A La System.Transactions in a custom system Posted by aldousd666 at 5/8/2007 8:29:02 AM First of all I apologize that this is a dupe of a post tot he
Framework.* mailing list, but this seemed like a more appropriate
place for it.
I'd like to write an ADO.NET provider for a non-relational data
store. I'd like to make it support transactions, but since it's a
third party tool I'm...more >>
TransactionScope - Unable to get error message (6106) Posted by BigLuzer at 5/8/2007 7:46:32 AM hi
using the new TransactionScope class in .NET 2.0, we occasionally get
an "Unable to get error message (6106) message" returned from .net,
after (it seems) 60 seconds.
we are connecting to Oracle 9.2.0.5 database, with the same version
client.
it happens approx 10% of the time.
has ...more >>
populating a varchar2 field with .net Posted by Damian at 5/8/2007 3:39:14 AM I am trying to populate a varchar2(1) field in an oracle database by
createing a varcharparam in .net - but the field is never getting
updated.
The values I am sending in through the parameter are either "Y" or "N"
- however the field value is always "1"
My question is - Is it possible to u...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |