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