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