| 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 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 31 Bestway to submit updated row in ds via webservice Posted by moondaddy at 10/15/2003 11:34:08 PM I have a WinForms application that uses webservices for its data access.
Rather than having the user insert/update/delete multiple rows and then send
the dataset back to the server as a batch, I want to submit the changes back
to the server as each row is saved. what would be the best way to sen...more >>
access to informix Posted by carlos medina at 10/15/2003 6:18:47 PM hi all,
I am accessing to a informix database with oledb.net ( .net 1.0 sp 2 ), =
the last week all works very well !!! but this week, when my application =
try to connect to informix the application shows me this error:
"Invalid accesss to memory location"
this is the code to connect:
...more >>
Newbie: DataAdapter and DataSet Use? Posted by Shanon Swafford at 10/15/2003 6:00:08 PM
I am building an application to be used to maintain 5 different tables in a
"Customer Database" using VB.NET and Access 2002.
Database tables are:
Customers
Customer Locations
Orders
Suppliers
Shippers
Employees
I plan to have a tab on the form for each of the tables...more >>
Suppressing SQLExceptions... Posted by Peter at 10/15/2003 5:07:41 PM Hi, we're using STored Procedures with MS-SQL and VS.net.
When the SP code attempts to insert a record and there is
a primary key violation, the check for for @@error inside
the SP would catch it. In our case, this is a business
issue, the SP would subsequently do some other processing
a...more >>
Getting only Updated Column of Updated Row from dataset Posted by sandeep garg at 10/15/2003 3:50:31 PM I have filled up datagrid with rows from dataset. I have updated only
two columns of a row having 14 columns.I can Easily get that updated row
from dataset. Is there any way to get only Two columns that i have
updated from updated row.
Thanks in advance
*** Sent via Developersdex http...more >>
Parent Child Relationship Posted by Sue at 10/15/2003 1:12:03 PM Hi
I am having two tables Parent and Child, I have created a
relation Rel between them. When I bind two datagrids, 1 to
Parent and other to Parent.rel using setdatabindings.
The child Datagrid does displays only 1 row with the key
field and all other columns as null value.
If I bind the chi...more >>
Automatically Create Constraints in DataRelation Posted by michael at 10/15/2003 12:51:18 PM The following constructor creates a new DataRelation.
With respect to the 4th parameter, I really can't see a
difference whether I put "True" in this position or use
the constructor that has only 3 parameters (no boolean).
What's the purpose of indicating whether or not you want
the constr...more >>
Removing Dataset Column when DS has schema. Posted by Mark Myers at 10/15/2003 11:53:45 AM Question: If I populate a dataset using an xsd and an xml file, can I
then remove a column and still reference the data? I get an error when I
try it.
Note1: if I don't use the xsd it's OK. What gives?
Note2: calling Update on an SQL data adapter gives the same error.
Note3: calling AcceptCha...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Whether to use dataset or array of objects Posted by Raghav at 10/15/2003 11:44:30 AM Hi,
I've a Windows based .Net distributed application. One of the scenarios is
getting multiple records from the database at the presentation layer and
showing that in a DataGrid control. The user should be able to add / modify
/ delete records. All this updation will be passed to the business...more >>
read information of datagrid Posted by Tarajan at 10/15/2003 10:39:40 AM Hi,
i have a aspx-page with products and informations in a datagrid.
I bound an additional column with textboxes to the datagrid, so the users
can enter a number of orders for the product.
What is the best way to send all the informations in the datagrid or only
the information with filled in...more >>
Table Update Notifications Posted by James Lennon at 10/15/2003 10:33:02 AM
I am creating an application that basically reports the
contents of a SQL server table to the user. Is there an
event handling mechanism in ADO.NET that would notify my
application when the tables contents have been modified?...more >>
cmd.ExecuteNonQuery() completing? Posted by DaveS at 10/15/2003 9:12:28 AM Hi!
I am exeuting an INSERT query from within a public
function. Is there any way to know if the entire INSERT
query completed updating in the database? It appears that
code continues to execute even before the query has
finished. However, when I check cmd.State.ToString, it
says "Op...more >>
Renamed tbl not viewed in Immed. Window. Posted by Nat at 10/15/2003 8:01:16 AM Old table name : tblTimeOption
New table name: tblDefinitionTimes
Keep getting this error for the following
code: "System.Data.SqlClient.SqlException: Invalid object
name 'tblTimeOption'.
However code says this:
Dim sSqlCommand1 As String _
= "Insert Into tblDefinitionTimes...more >>
Data column expression Posted by KPH at 10/15/2003 6:17:25 AM Hi,
Consider the following code statement:
dstest.Tables("test").Select("intfield = " + CStr(intval))
Suppose table test has the column name "intfield" with
int32 datatype. Let's dataset test contain the following
rows
Test:
Col 1, Col 2, Col 3 ..., "intfield", ... ,Col 1[0-9]
* ...more >>
IBM.Data.DB2 Connection string Posted by Josh at 10/15/2003 3:36:33 AM Hello All,
We have an issue with the IBM DB2 Managed Data Provider (IBM.Data..DB2). We
manged to establish the connection and fetch data using Select queries.
However we are uable to save any changes to the database as Update, Delete
and Insert commands fail with a message "inconsistent data...more >>
dataset column expression Posted by Gary at 10/15/2003 1:15:17 AM Hi,
I have a typed data set defined thus:
Title
Forename
Surname
FullName
FullName is a derived column with the expression:
Title + ' ' + Forename + ' ' + Surname
I have set the dataset so that Title, Forename and Surname
allow Nulls.
In some cases the Title is null, so the data...more >>
Outer Join in SqldataAdapter Posted by Scott at 10/15/2003 12:42:08 AM I need to use an OUTER JOIN in the SELECT statement of a
SqlDataAdapter to fill a DataSet. Currently the SELECT is
on a VIEW which contains the OUTER JOIN. This works well,
but I am having difficulty knowing how to update the data
source (SQL Server) when it comes time to commit the data
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |