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 > july 2004 > threads for tuesday july 6

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

Server Error in '/test' Application.
Posted by Moe Sizlak at 7/6/2004 4:24:40 PM
Hi, I am using an SQL parameter in my SQL statement, I have never done this before ans it seems to be retuning an error saying that the parameter '@ID' must be declared, I know I am close, could someone have a look at it form me please? cheers lads Moe Dim DS As New DataSet() Dim s...more >>

Regenerate the dataset and expressions
Posted by Woody Splawn at 7/6/2004 4:18:58 PM
I am struggling with the basics in Ado.net using VB.net for non web applications. I have been using expressions in the design mode of strongly typed datasets (.xsd files). However, I have discovered that if you regenerate the dataset, the expression goes away. This is not what I want. I am ...more >>

Expressions and their limitations
Posted by Woody Splawn at 7/6/2004 4:12:01 PM
I am using VB.net in a non Web applications I have been reading up on expressions and they seem quite helpful. However, in one book I've read it talks about what appears to be a severe limitation. The book may have been written before VS 2003 so maybe the issue has been fixed. I don't know. ...more >>

Activate edit mode on CurrencyManager?
Posted by Jorge at 7/6/2004 2:55:04 PM
Hi there, I have a WinForm with two textboxes binded to a CurrencyManager. What I want to do is this: to get the CurrencyManager's edit mode activated when the content of any of the binded textboxes is changed. Then, I would like to capture this change of state (in some event perhaps?) so I ca...more >>

Second binding
Posted by Brad Allison at 7/6/2004 2:27:49 PM
If I need to post code, I will do so, but I think explaining my question my result in a good answer. I have a form that asks a user for a unique id number. This then runs the data adapter's parametized query and then fills a dataset with the one resulting row. This works fine and dandy. ...more >>

"IF" test in SP evals to True and False at same time using DataAdapter.FillSchema()
Posted by David Elliott at 7/6/2004 12:51:15 PM
The IF test in a Stored Procedure is evaluating to true and false at the same time for FillSchema() (See result below -- SELECT TOP 2 TOP 100 PERCENT) Any thoughts are appreciated. Dave Information on Problem =============================== Below is the output from the Fill() and ...more >>

Super-fast keyfile
Posted by Lee Gillie at 7/6/2004 12:48:33 PM
New to ADO.NET so seeking comments on strategy. I need to scan data, and build a "keyfile" on data I am extracting during the scan. Actual fields varies by job, and I dynamically create this from a description, and there may be 5-30 fields of integers and strings typically. Small jobs may b...more >>

Oracle Tables
Posted by baila_pau NO[at]SPAM hotmail.com at 7/6/2004 11:58:21 AM
Hello : Can you create a table in an Oracle data base using sentences in your .NET code? I explain: example: sqlSentence = "CREATE TABLE tableName (...)" command.commandtext = sqlSentence; command.ExecuteNonQuery(); If you can, how can you set auto_increment data typ...more >>



datagrid columns from different datatables help
Posted by strongmace NO[at]SPAM yahoo-dot-com.no-spam.invalid at 7/6/2004 9:03:05 AM
Sorry to the mods: I posted this in asp.net forum but I think its more appropriate here? Anyways: Hi. I'm rather new to vs.net so explaining things in detail would be of great help to me. I'm working on a WebForms Project. Basically I have a datagrid I need to populate. I have it set up s...more >>

Lookup tables
Posted by JPretorius at 7/6/2004 1:47:01 AM
Hi There I have 3 dataadapters each relating to a table - daCompany, daAccountant, daCompanyType. These tables have foreign constraints set in the dataset schema. (Company many to Accountant, CompanyType many to CompanyType) I've databound all relevant text boxes and comboboxes however when mod...more >>

Example Search Form Required
Posted by Liddle Feesh at 7/6/2004 1:19:50 AM
Hi, I have a table named "Person" in a MSDE (2000) database, and am building a search form comprising of search fields on the top section (forename, surname, telephonenumber, etc) which all correspond to columns to search in the database. I'm relatively new to ADO.net and haven't the foggie...more >>


DevelopmentNow Blog