| 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 DataTable.Select problem Posted by Alex Markov at 9/5/2003 11:55:27 PM When I read table from Excel to DataTable object and one
of the field's names is with "?" (for example "class?")at
the end Select function throws the folowing exception:
"...
An unhandled exception of
type 'System.Data.SyntaxErrorException' occurred in
system.data.dll
Additional informati...more >>
copying data from one table to another Posted by Deepak at 9/5/2003 10:11:52 PM Hi all,
I am trying to copy data from one table to another. These tables are on
different servers. I am successfully able to read data from the destination
table. When I do DataAdapter.Update it does not give me an error and the
data does not go in either. I think its got to do with the insert c...more >>
Serious Bug in BindingContext Position? Posted by Mark Olbert at 9/5/2003 8:47:06 PM There appears to be a very serious bug in the BindingContext's position handling code. When a
BindingContext object is based on a DataView, and a new record is added to the DataView, the
BindingContext object will not "allow" you to position onto the new record.
The following code adds a new re...more >>
Output Stream(adExecuteStream) disappeared? Posted by Porgányi Géza at 9/5/2003 7:16:50 PM Hi!
Before in ADO I used to get data from database with the technic below:
Stored procedure:
SELECT N'<XML><Data1>'
SELECT N'<Item>' + fField1 + '</Item>' FROM tbXXX WHERE ....
SELECT N'</Data1><Data2>'
SELECT N'<Item>' + fField2 + '</Item>' FROM tbYYY WHERE ....
SELECT N'</Data2>'
SELEC...more >>
ADO Wrapper Posted by JB at 9/5/2003 5:22:20 PM I use my own home grown ADO wrapper, but I've heard of a version created by
MS to do this same thing, anybody heard of such a thing, or know where it
is?
Jason
...more >>
Hello! Hello! What magic words are required to have questions answered. Posted by Burton Wilkins at 9/5/2003 4:49:28 PM Gentlemen:
How is it that some get their questions answered, and
others don't? If there is a "do-not-answer" list, and my
name is on it, would you please take my name off it? I'm
asking some serious questions on Byte arrays. Could
someone please respond?
I am building a general tool...more >>
ACCESS over TCP/IP Posted by Nuno Fonseca at 9/5/2003 4:08:10 PM Anyone knows if it is possible to make a database connection over TCP/IP to
an MS ACCESS database? If yes please give me an example or any documentation
please.
Best regards,
Nuno
...more >>
Typed DataTable example Posted by Donal McWeeney at 9/5/2003 3:25:43 PM Hi,
Anyone know of some sample code that shows a good working example of a typed
DataTable.
Thanks
Donal
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Uniqueidentifier type problem in a dataset... Posted by Jérôme Poudou at 9/5/2003 3:02:00 PM Hi,
I've a table with a uniqueindentifier column in SQL server
I want to fill an untyped dataset with a simple select * from table query,
but the uniqueindentifier column is empty !
if I cast my column in a varchar type, there is no problem.
Why ?
How to resolve the problem ?
thanks
...more >>
Creating and Opening MSDE DBs Posted by Wayne Wengert at 9/5/2003 1:30:03 PM I want to convert a VB6 app that used Access 2000 as its DB to a VB.NET app
using MSDE and I have some questions.
In the old VB6/Access app, the user could define a new database using a Open
File Dialog. The user specified the path and file name. Using MSDE I believe
I can only let the user pr...more >>
General network error. Posted by Kevin Burton at 9/5/2003 12:36:49 PM Does anyone here understand what a 'General network
error.' is? I have two machines one of them works
flawlessly, the other gives me errors intermittently
declaring a 'General network error.' in the SqlException.
I have looked in MSDN and found nothing really helpful.
One page suggested us...more >>
Problem accessing FoxPro database across shared network Posted by Glenn Wilson at 9/5/2003 11:55:36 AM Hi,
I am having problems connecting to a FoxPro database sitting on a shared
folder on a network from within my .NET application. I am using a the
following connection string to connect to the database:
'provider=VFPOLEDB.1;data
source='\\myServer\DataDirectory\FoxProDatabase.dbc'
When ...more >>
Stored Procedure Posted by Catalin Porancea at 9/5/2003 10:14:03 AM Hello,
I need to execute a sp from a command at run time. If the command is a
"select" statement I use:
cmd.commandtext = "select * from table"
cmd.executenonquery
I tried
cmd.commandtext = "exec sp_procedure"
cmd.executenonquery
but it didn't work.
My connection is ODBC.
Can...more >>
Is there a recommended common approach for reading and writing arrays of Bytes t Posted by Burton G. Wilkins at 9/5/2003 7:46:13 AM Gentlemen:
I am building a general tool that should be able to read
and write all SQL Server datatypes. Presently, I am
working on that section of the program that reads and
writes Images. Going to the helps that come with .Net, I
find that Image map to an array of Bytes. Checking o...more >>
return string of more than 255 chars Posted by Igor at 9/5/2003 7:03:33 AM How to get more than 255 characters from a database using
any of ADO.Net numerous possibilities?
I created a field "Big" of type String in a table "Huge"
(Microsoft Access) with the size of 250. I've put a text
string "AAA...ZZZ" of length 250 into it.
The sql statement I want to use is: ...more >>
When did Password become a Reserved Word? Posted by Charles Law at 9/5/2003 1:10:45 AM I thought I would bring this back up to the top, as I have resolved my
original problem.
I discovered that using ADO.NET, OleDb and the CommandBuilder, I got a
syntax error when a column in my table was called "Password".
Was everyone else aware that Password could not be used as a column na...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |