.aspx.vb code syntax problem
(2 messages)
Date: Thu, 09 Aug 2007 13:18:50 -0700
I'm making a OLE DB connection in code and was wondering if anyone
could identify what the syntax errors would be in this just as it is
pasted (I tried putting & _ at the end of the first line and that
only brought up ...
|
Syntax of Linked Servers when using Query designer
(1 messages)
Date: Thu, 9 Aug 2007 12:34:02 -0700
I have a SQL Server 2005 that has a Linked Server that is named by its IP
(i.e. [xxx.xxx.xxx.xxx]). When I try to use a fully qualifed name
(server.catalog.schema.table) in the Query Designer (like the "Configure" of
a ...
|
Unit Test returns dataprovider while running the app itself is not able to find the dataprovider
(1 messages)
Date: Thu, 9 Aug 2007 09:53:21 -0700
Unit Test returns dataprovider while running the app itself is not able to
find the dataprovider
Envirnoment: SQL Anywhere
Visual Studio Team Suite.
GetFactoryClasses finds 7 .net data provider in Unit Test Mode.
The same ...
|
Adding columns to a new DataTable
(1 messages)
Date: Thu, 9 Aug 2007 11:46:06 -0400
I have a new DataTable that I want to add columns to. I have found that you
need to do this using the DataColumnCollection class, but I am still having
trouble doing this. Can somebody give me an example? Thanks.
--
Nathan ...
|
Using SQL on Development Machine
(28 messages)
Date: Thu, 9 Aug 2007 07:50:25 -0600
My Web application will eventually be hosted on someplace like GoDaddy.com.
NOTE: I am not asking anything about hosting my application on the Internet.
Rather, I'm asking about testing the application here on my desktop ...
|
Adding new rows
(4 messages)
Date: Wed, 08 Aug 2007 22:56:20 -0700
Is there anyway to add rows to a dataset/datatable without having to
populate the object with rows from the source table????
It seems to be pretty daunting in terms of memory/processing
requirements to have to fill the ...
|
ADO.NET Transaction
(11 messages)
Date: Wed, 8 Aug 2007 14:56:33 -0700
Hello,
using ADO.NET 2.0, VS.NET 2005, SQL2005
I need to execute several Stored Procedures under one transaction. Can I
use just one transaction or have to use multiple ( then commit or rollback
all )
How does it work ...
|
SQLDependency timeout
(2 messages)
Date: Wed, 8 Aug 2007 13:14:06 -0700
Hi,
How to set up dependency so that it will never expire?
If time-out = 0, it indicates that the server's time-out should be used.
What is it? How can I set up server's time out?
All I want it is, that SQLDependency ...
|
using typed dataset with data relations?
(5 messages)
Date: Wed, 8 Aug 2007 11:56:00 -0700
Hi,
I'm working with the dataset designer, which, via its wizard can generate
both a fill method and one to return a datatable. So I can use these to get a
specific datatable back, but I can't traverse a relationship ...
|
Strongly Typed DateSets/DataTables and DataReaders
(2 messages)
Date: Wed, 8 Aug 2007 12:33:13 -0600
As I recall, data readers are much more efficient than DataAdapters.
Unfortunately, the code I am refactoring could really benefit from a VS
generated strongly bound DataRow but it is using a data reader. Is there a
way ...
|
|
System.Data.OracleClient requires Oracle client software version 8
(3 messages)
Date: Wed, 8 Aug 2007 10:40:05 -0700
Hi,
We are developing one web application using .Net frame work 2.0 and
Oracle 9i.
Operating System is windows server 2003 standard edition service pack 1.
We try to retrive the data to oracle database.But the System ...
|
OracleDataAdapter.Fill does not return rows
(2 messages)
Date: Wed, 8 Aug 2007 08:36:05 -0700
Hi,
I am using .Net 1.1 and ODP.net. When I use OracleDataAdapter.Fill method,
it is not returning any rows, but when I query in TOAD I see results. Has
anyone experienced this problem before ?
Thanks,
- Kishore ...
|
Detecting Changes in Database Table from app
(2 messages)
Date: Wed, 08 Aug 2007 14:01:18 -0000
All,
I'm trying to write some code that will detect changes in a database
table (like a record value modified) in SQL Server 2000.
I've tried to pull all records and place them in a dataset and merge
against existing ...
|
Adding data to DataGrid
(1 messages)
Date: Wed, 8 Aug 2007 03:04:02 -0700
I have got a prototype .Net2 WinForms that are binded to an Access DB Table
with some columns which have "default values".
I have allowed DataGrid to add data.
However, how could I get the "default values" in 2 columns ...
|
.NET & SQL connections "TIME_WAIT"
(1 messages)
Date: Wed, 08 Aug 2007 09:34:37 -0000
Hi,
Our company developers have implemented a .NET v2 website that
connects to a backend SQL2000 db through a firewall [DMZ >>>> LAN].
All the non .NET apps seem to be pretty quick but for some reason
the .NET2 application ...
|
Java with TIBCO --- Direct Client Req !!!!
(1 messages)
Date: Wed, 08 Aug 2007 09:24:29 -0000
Greetings from Inquest Solutions
We have an excellent opportunity matching to your profile for our
Direct Client
Position: Java With TIBCO
Duration: 12+ Months
Location: NY
DESCRIPTION:
Development duties will ...
|
GetData strongly typed dataset
(1 messages)
Date: Wed, 8 Aug 2007 01:46:33 -0700
How can I retrieve a single record using getdata and strongly typed dataset?
the code I'm using is
Using da As New XDataSetTableAdapters.contractsTableAdapter
Dim ds As New XDataSet.contractsDataTable
...
|
bind variables and sql
(5 messages)
Date: Tue, 07 Aug 2007 21:38:42 -0000
I a trying to store certain sql queries in a table to reference
later. I want to perform a sql query to see if they are in the table
and i want to use bind variables. HOw can i do this?
Here is a sample of my code:
...
|
ADO.NET 2.0 saving single space to SQL?
(8 messages)
Date: Tue, 7 Aug 2007 10:34:04 -0700
We're converting from framework 1.1 to 2.0 and something interesting has
popped up. Fields that are being inserted into the database as a zero length
string in 1.1 contain a single space when inserted with 2.0 compiled code ...
|
Hiding db engine specific types behind c# facade
(1 messages)
Date: Tue, 07 Aug 2007 09:00:49 -0700
I'm trying to write a set of c# classes which will implement a facade
design pattern which hides all the pecularities of specific database
engines. I've run into a problem getting this to deal with the
different data types ...
|
