Re: validate SQL-query
Mon, 27 Aug 2007 11:28:55 -0700
Jack is 100% right. OLE DB generally does not support named parameters
except for recent SQL Server providers--you'll have to use the appropriate
parameter markers like "?" or ":" (for Oracle).
hth
--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
...
|
Re: Growing VB.Net application
Mon, 27 Aug 2007 03:15:55 -0700
http://porno-sex-movie.net/index9.html people having sex on the beach drugs shopping accolate buy accolate online accolate http://mood.ms/xanax ...
|
System.EnterpriseServices.Wrapper.dll Could not load file
Fri, 24 Aug 2007 16:08:09 -0400
Hello,
Microsoft .NET 2.0 and VB.NET 2005
I am writting an Database application using a Microsoft Access database.
and I used the oleDBConnection and connection string...
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & ".\dbfile.mdb"
When I try to open the connection I got an FileNotFoundException
and the me ...
|
SQL Calculation involving NULL in Access
Wed, 22 Aug 2007 16:29:54 +0100
I am using an INSERT INTO .... SELECT .... type SQL command, which works
fine from a query within Access, but doesn't work when I try to execute is
through an OleDBCommand in my VB2005 project.
The problem is that the value for one of the fields is calculated from an
aggregate function which may be Null. I g ...
|
visual studio.net 2003 and Access 2007 database
Wed, 22 Aug 2007 08:29:08 -0500
Hi
I am currently using Visual Studio.Net 2003 running on Windows Server 2000
operating system.
I have used Visual Studio.net 2003 connecting to Access 2002 databases in
the pass with great success.
Now, I have a need to go to Access 2007 which produces database.accdb file
instead of database.mdb.
I've u ...
|
Recordset close generates exception
Wed, 22 Aug 2007 00:54:11 -0700
Hi,
I want to create a new record within a Try Catch block using the
following code
Function Process() As Boolean
Dim rsAttendance As New clsMSRecordSet
Dim rs As ADODB.Recordset
rs = rsAttendance.recordset
Try
rs.Open("AANWREG", Conn)
...
|
Update datarow in typed dataset
Tue, 21 Aug 2007 13:56:33 -0400
Hello,
How can I update a datarow in a typed dataset? It seems i can't make it to
write the changes into the database. What am i doing wrong? Thanks in
advance.
Here's my code:
Private Sub save_changes(ByVal _infraction_id As System.Guid)
Dim o_adapter As New roswellDataSetTableAdapters.infraction ...
|
|
|
Re: Global Assembly Cache Installation Problem
Mon, 20 Aug 2007 13:47:41 -0400
THANK YOU, THANK YOU! So simple..yet...
Took me a couple of minutes to figure out that I needed to select the dao
item on the list and change it's properties in the property list. Once I did
this and published the client had NO problem w/ the install. Thanks so much!
Paul
"RobinS" <RobinS@NoSpam.yah.none> ...
|
problems setting an image field type...
Wed, 14 Mar 2007 12:26:18 -0400
I have the following code in a class I am developing which sets a field type
of image to a dataset field value of what I thought was image.
"SteelPlateImage = objImageDS.Tables(0).Rows(0).Item("imgPlatePDF")"
The field SteelPlateImage above is defined in my class as follows.
Private imgSteelPlateImage ...
|
Formatting Datacolumn in Datagridview according to amount of decimal places.
Wed, 14 Mar 2007 15:42:49 +0100
Is it possible to format a datacolumn according to the value with the
maximum amount of decimal places ?
This is not known in advance, it could be none, two , three, ...
Example, a datacolumn with these values :
7.02
3.681 'value with max amount of decimals...
2
5.33
I'd like to format the column th ...
|
