VS2003 versus VS2005 data adapters: Auto-generated update commands generate parameter errors?
Sun, 25 Feb 2007 15:18:36 -0500
Gents,
Been using 2003 for 4 years, and have several large Windows Forms based
project that I need to continue to develop with VS2005. I have imported one
of these projects, fixed some newly detected errors, and it appears to work
great in VS2005.
The problem I am having is updating Dataadapters (ther ...
|
TSQL to populate datagridview
Sun, 25 Feb 2007 14:09:56 GMT
Hello everyone,
I'm programming in VB.NET 2005 and I habe not much experience with database
programming. I'm in search for some sql for the following :
I have 3 database tables: Movies, Theaters and a MovieProgram. Now I'm
looking for some TSQL (SQL SERVER 2005) that can do the following:
...
|
vb.net
Fri, 23 Feb 2007 00:01:33 -0800
can you send examle with datatable using datarow ...
|
Scheduling movies in a sql sever 2005 database
Thu, 22 Feb 2007 15:23:00 GMT
Hello college programmers,
I have a ProgramItem-class as follow:
mItemID as Integer
mDtg as shortDateTime
mMovieID as Integer (linked to a ICollection of Movies from a table Movies)
mTheaterID as Integer (linked to a ICollection Theaters from a table
Theaters)
And a Server 2005 TSQL ...
|
SQL Express Warning
Wed, 21 Feb 2007 15:07:33 -0500
Gonna teach myself SQL Express...
Installing SQL Express I got a warning - Minimum Hardware Requirement.
"The Current system does not meet the recommended hardware requirments for
this SQL Server release. For detailed hardware and sofware requirments, see
the readme file or the SQL Server Books Online.
...
|
Replace in access queries
Tue, 20 Feb 2007 12:47:50 -0000
I wish to run a Replace against an Access database.
Here is a sample query, qryReplace, that works in Access:
UPDATE Clients SET Clients.TestText = Replace([ClientName],"i",2);
I try to run this through code:
Dim oleCommand As New OleDbCommand(stSQL, oleConnection)
oleCommand.Command ...
|
Reports advice needed
Mon, 19 Feb 2007 00:52:36 +0200
I am using Visual Basic 2005 Express Edition and would like to print and
email reports. Does someone have any suggestions what I should best be
using, plain english please.
I've tried downloading Visual Studio 2005 Tools for Office 2003 but can only
find for Office 2007. Possibly this might also work but w ...
|
|
|
Beginner question re. Configuring a data source
Sat, 17 Feb 2007 19:16:02 -0800
I'm a beginning programmer trying to learn my way around visual basic express
and ADO.Net. I'm currently working my way through Microsoft Press's ADO.NET
2.0 Step by Step book. I have using visual studio express and SQL server
express.
The first exercise in the book involves connecting to a database prov ...
|
VS2005: using IN ( list ) SQL construct in queries
15 Feb 2007 18:59:30 -0800
I have a situation where the user can select a variable number of
values, and I need to find records that match any of the values. It's
a perfect situation to use an SQL construct like
SELECT * FROM Table WHERE Column IN ( value1, value2, value3.... )
I would like to be able to build the list and give it ...
|
Retrieve XML from web site
Thu, 15 Feb 2007 14:55:53 -0500
How do I get an xml page from a web site
In VB6 I would do:
Dim objhttp As New MSXML.XMLHTTPRequest
Dim xmlDocument As DOMDocument
objhttp.Open "GET", sUrl, False
objhttp.send
'this puts the result directly into an xml domdocument
Set xmlDocument = objhttp.responseXML
W ...
|
