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 friday april 9

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

DiffGram to Update SQL 2000 DB with WebServices Data Adapter (SOAP)
Posted by Austin at 4/9/2004 4:31:04 PM
Everything works correctly; however, the table in the SQL 2000 database does not change What is the first parameter in the SOAP [WebMethod] Update method suppose to be? Is it suppose to be the DiffGram What works I have a WebService that was generated with Visual Studio.Net as per a Microsoft C...more >>


Add expression column to a view
Posted by DCraig at 4/9/2004 4:17:56 PM
I'm having problems creating an expression column in a table inside a dataset because of multiple parent rows. I know the syntax is correct because I've done it several other times successfully. I'm thinking I need to split the table to get rid of the duplicates and am looking at two options: ...more >>

newbie question on ado.net
Posted by Danny Ni at 4/9/2004 2:58:26 PM
Hi, Is there a way to insert summary rows into a dataset or datareader without actually save them back to the SQL server? I have a resultset returned by SQL server using the following SQL statement: select gid, eid, wdate, whours from timelog order by gid, eid, wdate I like to insert a su...more >>

OracleClient.dll
Posted by Cappy at 4/9/2004 2:56:03 PM
I was hoping I could get some help with this exception that the oracle client 1.1 throws and not 1. Exception: ORA-02074: cannot ROLLBACK in a distributed transactio I am not using distributed transaction ...more >>

When does "Current" value update?
Posted by DJM at 4/9/2004 1:21:23 PM
I have a DataSet. In it, there is a DataTable. When I change the value of a column on this particular table, I want to change the values of two other fields on this table. I have an event tied to ColumnChanged (e is DataColumnChangeEventArgs). When I change the value, first I check to see if...more >>

Is there a way to make DataAdapter not call Acceptchanges after Update Method
Posted by jkang4 NO[at]SPAM hotmail.com at 4/9/2004 12:00:47 PM
Hi, Here is the problem I'm facing. I'm working on a system where I need to make DataAdapter.Update method call to update the database. After the update is complete I need to make a call to an external system. (I know it's not the prettiest picture but for now I do need to update the database...more >>

Oracle 9.2.0.4 connection pooling problem
Posted by Paul Speranza at 4/9/2004 10:22:30 AM
Hi all, I am having a problem with connection pooling. My connection string looks like this: Data Source=hipqqint;Persist Security Info=True;Pooling=true;Min Pool Size=3;Max Pool Size=50;Connection Lifetime=60 If I run an insert command - by the way I am testing this in NUnit - it...more >>

newbie question :Get return from SQL server
Posted by Danny Ni at 4/9/2004 9:57:33 AM
Hi, I used SqlCommand ExecuteNonQuery method to execute a stored procedure in SQL server, the SP returned me a value, how do I read this result in C#? ExecuteNonQuery method does not seem to return anything. TIA ...more >>



Using EXEC in Query
Posted by Steven Livingstone at 4/9/2004 9:29:36 AM
How do i call "exec" from within a select statement : e.g. something like this is what i want.... SELECT id, ChildCount = EXEC GetKids id FROM mytable Should be a no brainer, but i seem to be missing the exact syntax and can't find any examples. thanks, Steven. ...more >>

How do I programattically add a new row of data to a Typed DataSet?
Posted by Bill at 4/9/2004 7:21:47 AM
I am able to fill DataSet tables in a typed DataSet from SQL Server, but now have a situation where I need to load positionally delimited text, but am not quite sure of the syntax for this. Do I create a new datatable DataRow from the typed DataTable, populate it with data, and then add the row.....more >>

Bild in SQL Server speichern
Posted by Faschang Eduard at 4/9/2004 1:10:51 AM
möchte über ADO.NET ein Bild in einen SQL Server speichern . hätte wer ein kleines Beispiel ??? --- Posted using Wimdows.net NntpNews Component - Post Made from http://www.DotNetJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching....more >>


DevelopmentNow Blog