| 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 Adding data to table Posted by Trevor at 10/23/2003 4:23:49 PM Hey,
I am trying to do this tutorial on the microsoft site :
http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/dndotnet/html/usingadonet.asp
I can get everything to work up to the DataAdd part
(Section heading is Adding Rows to a DataSet)
I dont really know what to do a...more >>
DataSet.Tables["table1"] or .Tables[1] Posted by Ondrej Sevecek at 10/23/2003 4:10:34 PM Hello,
IS? searching for table by name (inspite of number) MUCH more slower than
by number? Or the speeds and loads are comparable and quite same efficient?
Thanks Ondra.
...more >>
How to make multiple queries to the database.. Posted by sona at 10/23/2003 2:53:19 PM Can anyone help?
I am trying to do 2 things within the same sub method.
Firstly, having made the connection to the SQL Server
database and creating a new adapter, i have made a query
to insert values in the database. This works fine.
Now i need to get some data from this database(i.e selec...more >>
VFP OLEDB Posted by Shahin at 10/23/2003 2:35:10 PM Greetings,
I have a WebService that uses VFP OLEDB to access fox pro database. Unless I
give the Everyone full access to the Fox Pro Files I get an access denied
for the user Network Service. I am not sure what user I need to give access
to this data directory for this to work.
Shahin
...more >>
ODBC Stored Procedure Problem Posted by Jason MacKenzie at 10/23/2003 1:46:02 PM If have a stored procedure that seems to work fine through query analyzer
but if I attempt the same thing via code, no exceptions are thrown but no
results are ever returned. I'm using the ODBC.NET dataprovider.
The string that I cut and paste when I debug is:
sp_OrgChart 1900,
'''ANALYS'',...more >>
result from stored procedure Posted by René de Leeuw at 10/23/2003 1:18:52 PM Hi,
Can someone provide me with code how to send a string (@name) to the test
table. And how to read the result column wich contains the just generated
testid value from the test table. Here details of the table and the stored
procedure. Thanks in advance.
Regards René.
CREATE TABLE [te...more >>
Update multiple rows in dataset Posted by shiv at 10/23/2003 12:41:34 PM Hi all,
I am this problem. I need to populate a dataset with two
tables along with relations. make changes to multiple rows
simulataneously and update the datasource.
Does any body has idea about doing this stuff?
thanx in advance
shiv...more >>
SELECT * FROM INFORMATION_SCHEMA Posted by chak at 10/23/2003 11:49:18 AM The above SQL statement is supposed to help us get the schema information of
all standard RDBMS. However, it works for SQL Server, but not for Oracle -
in Oracle, i get numbers instead of data types of the columns. These numbers
are not consistent enough to derive the data types. Any ideas on how...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
ExecuteOracleScalar error?? Posted by daiyuan at 10/23/2003 11:42:03 AM Hi:
When I run this project,I miss a error:
it's say: convert is falied!
I don't konw why.
Please advice.
Thanks!!!
This is my codes:
////////////////////////////////////////////////////////////////////////////
///
using System.Data.OracleClient;
....
private int...more >>
How lookup ADO version???? Posted by Nothing at 10/23/2003 11:32:52 AM hi
i need to know version of ADO how i could to do this?
...more >>
Updating database from multiple application Posted by seban at 10/23/2003 11:24:19 AM Hi All
I have a multi user application.I am populating the data to a datagrid from
a dataset.If i had made the changes on it. I am updating it by using the
datatsets getchanges and sqldataadapters update methods.
Suppose 2 users say A and B opened the application in their respective
machin...more >>
Adding an existing datatable to an existing dataset Posted by STom at 10/23/2003 11:10:16 AM I am trying to add an existing datatable to a dataset that I created via:
Dim ds as new Dataset
Currently I have no connection to a database.
Is there a way to put this table I have into the datasets Table(0) position?
Thanks.
STom
...more >>
Oracle query returns table structure but no lines Posted by AW at 10/23/2003 10:35:08 AM Hello,
I'm using Microsoft's OracleClient (part of the v1.1 framework) to access an
Oracle database. I issue a select statement which is supposed to return
lines from a table, but no line is returned.
The method I use is an OracleDataAdapter that fills a DataTable. Strangely
enough, after t...more >>
AcceptRejectRule strange behavior Posted by hype NO[at]SPAM videotron.ca at 10/23/2003 9:47:42 AM This is an issue that I have seen many times in this forum but was
never answered clearly.
So here it is again:
I have a parent child relation between table A and B this relation is
mark with cascade Update and Casdade delete (because the database does
the same)
I also mark AcceptRejectR...more >>
Can't save my data in the DB with ADO.NET Posted by Torben Madsen at 10/23/2003 9:02:28 AM Hello,
I'm trying to save the changes back to the database, but it doesn't
work -could anybody help me?
I'm using a DataSet and the wierd thing is that I can save the changes in
the memory but not in the database :-/
I have tried to duplicate an example I found on msdn -but with no luck. The
s...more >>
dataSet.HasChanges returns false after dataSet is modified Posted by pplppp23 NO[at]SPAM yahoo.com at 10/23/2003 8:44:23 AM I have a windows form application getting data from an access database
file using dataadapters, here are the objects I have:
mydataset - mydataTable - mydataview
I use the dataview to find the records I want and bind it to a windows
form control.
anyway, my problem is, when I use the following ...more >>
Cell of type integer won't clear Posted by steven_licciardinnoossppaamm NO[at]SPAM hotmail.com at 10/23/2003 7:59:28 AM Hello,
I have a textbox which is bound to a field of type
integer. Everything works fine, the number displays and
can be updated etc.. However, when I delete the entry
the number just pops right back, i.e. the field refuses
to accept nothing.
When I go into SQL Enterprise manager and...more >>
How do I use a CurrencyManager object with Relational Data? Posted by David Adams at 10/23/2003 2:29:01 AM Hi,
I have a strongly typed dataset with 15-20 tables which have typed
relationships such as:
Customers-Orders
Orders-OrderDetails
OrderDetails-ProductDetails
etc...
I am using auto-increment values for every record that is added, and
replacing them with an SQL IDENTITY() value. This ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |