|
|
|
Recordset close generates exception
Replies (1) 22 August 2007
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.Record...
|
|
|
|
|
visual studio.net 2003 and Access 2007 database
Replies (1) 22 August 2007
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 su...
|
|
|
|
|
SQL Calculation involving NULL in Access
Replies (1) 22 August 2007
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.
...
|
|
|
|
|
Global Assembly Cache Installation Problem
Replies (2) 17 August 2007
I have a VB2005 program that is using DAO against Access 97 files. (Yes,
this is what I need to do...ADO.Net is over 20X slower and my incoming files
are Access '97. Would that I could change that...
|
|
|
|
|
Copying tables in SLQEXPRESS
Replies (2) 16 August 2007
Hello,
I have a program, running in several places, using SQLEXPRESS as database.
The different places are stand-alone, and not connected to a network.
Regulary, I have to apply changes on certai...
|
|
|
|
|
Database Access error i when deployingVB6 system c ...
Replies (1) 7 August 2007
I have converted a substantial VB6 application (conversion took 3 months) to
VB2005 and it works beautifully EXCEPT on SOME PCs to which it is deployed
I deploy by XCOPY ( I cannot use one click)...
|
|
|
|
|
Visual Studio 2008 - should we bother?
Replies (1) 1 August 2007
I like using VB2005, but I'm still unhappy about unstable it is. Basically,
there are loads of bugs that require work arounds.
VS2008 will be out within 6 months. I'd bet good money that will sev...
|
|
|
|
|
Error: data truncated.
Replies (1) 30 July 2007
Hello,
When writing a text to a SQL database nvarchar(6) field, I get following
error when the size of the input is larger than the available length of the
textfield (larger than 6).
Strin...
|
|
|
|
|
dataset Issues
Replies (1) 28 July 2007
This is all very confusing, but I'm trying.
I am using strongly typed datasets, that I simply drag on to the form.
I have a dataset created here:
Me.PODetailTableAdapter.Fill(Me.PODataSet.PODet...
|
|
|
|
|
Visual Studio / Microsoft
Replies (3) 28 July 2007
For the first time in my long career as an application developer, I
really do hate my job!
I am used to tools like Borland Basic, Turbo C, Clipper and Foxpro to
develop applications in a short time...
|
|
|
|
|
Inserting information into 2 tables
Replies (1) 28 July 2007
Can anyone tell me how to insert one set of data entered in a
microsoft access form with multiple fields, into two different tables
in the same access db??
thanks!...
|
|
|
|
|
Using BindingManagerBase with a dataset with two r ...
Replies (1) 27 July 2007
Hi
I have made two Sqldataadapters. One has the table Film and the other
adapter has the table Category. I have generated a dataset wich contain
these tables and made a relationship between them....
|
|
|
|
|
Pass date as parameter to Access DB
Replies (2) 25 July 2007
ASP .net - webforms
I changing things from sql string concatenation to parameters, for sql
injection reasons.
I keep getting a data type mismatch error.
I know the field / column is date/ti...
|
|
|
|
|
DataReader values and .ToString
Replies (1) 24 July 2007
Hello,
In order to avoid errors, I have all my DataReader-fields converted with a
.ToString.
This in case some record could have Null-fields and an error would be
thrown.
This works fine, e...
|
|
|
|
|
Detach my database from SQL SERVER
Replies (1) 23 July 2007
Hello,
When I have closed my appliciation in VB.NET, and I try to detach my
database from SQL SERVER, I often get a message that the database cannot be
detatched, because it is still in use.
S...
|
|
|
|
|
BindingSource problem?
Replies (1) 22 July 2007
I'm making a small app for a few friends of mine. It's for membership
info. It uses multiple tabs. It connects to an access DB with 2
tables.
On one tab it has a datagridview control on it and it...
|
|
|
|
|
cant get data from not visible datagrid column
Replies (1) 20 July 2007
Hi all,
In asp.net 2.0 I'm having trouble getting data from a cell whose
column is marked as not visible
Sub MyGridView_SelectedIndexChanged(ByVal sender As Object, ByVal e As
EventArgs)
...
|
|
|
|
|
TableAdapter Configuration Wizard do not create I ...
Replies (1) 18 July 2007
TableAdapter Configuration Wizard do not create Insert Statement(It Creates
SELECT, UPDATE, DELETE statements) So if I try using
Myadapter.update(MydataTable) to add a new row.
I get Error message...
|
|
|
|
|
Geen inkomend videosignaal
Replies (1) 17 July 2007
Dag allemaal,
Heel regelmatig gebeurt het dat mijn beeldscherm meldt dat er geen inkomend
videosignaal is. Dit is altijd na een tijd inactiviteit. Blijkbaar gaat
het systeem in een soort van ...
|
|
|
|
|
!VB.NET/Access: OleDbException (Data type mismatch ...
Replies (1) 16 July 2007
Dear group,
I hope someone can help me, as I've been tearing my hair out with this one
all day!
Using: VB.NET (2005/.NET 2.0 & MS Access (2000) MDB)
Process: This is a Wizard to make a mont...
|
|
|
|
|
ADO Createdatabase
Replies (5) 16 July 2007
Hi,
I want to make a db sometimes 97 and sometimes 2000 compatible. on my system
it always make an 2003 file. How must I do that? For the furure maybe I need
2007 again how?
Jan
I...
|
|
|
|
|
Dynamic DropDownlist
Replies (1) 15 July 2007
Hi everyone,
I have one problem, but when I solve the one, another appears:
I've written a loop that creates a variable number of dropdownlist
controls. When I load the page, the required numb...
|
|
|
|
|
DAO Deployment Question
Replies (2) 15 July 2007
I have a VB 2005 program that must use DAO. I have it running on my system
using Interop. When I deploy it, I get the following message on the local
PC:
System.Runtime.InteropServices.COMException ...
|
|
|
|
|
validate SQL-query
Replies (5) 12 July 2007
Is it possible to validate or format a dynamic SQL-query in vb.net?
I have an application that passes data from a form to a MySQL database.
This data can include all kinds of user passed data lik...
|
|
|
|
|
Deploying Interop DAO Errors
Replies (1) 11 July 2007
I have a VB 2005 program that must use DAO. I have it running on my system
using Interop. When I deploy it, I get the following message on the local
PC:
System.Runtime.InteropServices.COMException ...
|
|
|
|
|
Retrieve primary key after insert
Replies (4) 11 July 2007
If I add a record into a database by executing a sql command using an INSERT
INTO query. How can I then get the value of the primary key field for the
new record? The database will be either Acces...
|
|
|
|
|
Dynamically change connectionstring
Replies (1) 9 July 2007
I would like to be able to redirect a dataset "binding" from one database to
another during runtime. The database makeup will be identical, but the
actual files will be located in different folder...
|
|
|
|
|
Hiding Tables...???
Replies (7) 8 July 2007
IN my old VB6 apps, I used DAO and was able to hide tables using the
following code:
For Each myTableDef In dbLAILOKEN.TableDefs
myTableDef.Attributes = dbHiddenObject
DoEvents
Next my...
|
|
|
|
|
how to pass a to a stored procedure paramete ...
Replies (1) 6 July 2007
I have a vb.net 2005 project using an sql server 2000 backend db. I want to
be able to insert null values into two of the date fields on new inserts
(there may be a valid date - but possibly it wi...
|
|
|
|
|
ADO System.AccessViolationException
Replies (1) 5 July 2007
I have an app in VB.Net 2005 which uses a dBase database for two tables. On
every I've deployed to except one, all goes great. However, this one machine
is causing me a real headache.
When I tr...
|
|
|
|
|
View Consumer
Replies (1) 3 July 2007
I'm not able to a gadget on a SCSI connector to the Fast
hard disk to download to forward on a program....
|
|
|
|
|
XSD validation in VB .NET
Replies (1) 28 June 2007
Hi,
I'm doing validation of a xml file with a xsd schema and it works
fine.
I get validation errors in the form:
=ABMessage:{0} The 'NAM' attribute has an invalid value according to its
dat...
|
|
|
|
|
SQL Server application - User instance?
Replies (1) 26 June 2007
Hi
I'm about to start working on a simple SQL server based application. Since
I'm often on the road I have to do development both from my workstation on
the office, and from my laptop. What's t...
|
|
|
|
|
"readonly" SQL Server 2000 connection string quest ...
Replies (2) 21 June 2007
I have a project in vb.net 2005. I am accessing two SQL Server 2000
databases in this project. I want to make sure that the one database is in a
'READONLY' state. The connection string in the .xml...
|
|
|
|
|
Why does using ODBC & DSN open the wrong database?
Replies (1) 21 June 2007
Why does using ODBC & DSN open the wrong database?
Using VB.NET 2003, If I use the following connection string:
ConnectString = "packet size=4096;Trusted_connection=yes;" _
...
|
|
|
|
|
New China Sex Hotline!
Replies (1) 19 June 2007
free to listen live.. +86 13925265554...
|
|
|
|
|
New China Sex Hotline!
Replies (1) 19 June 2007
free to listen live.. +86 13925265554...
|
|
|
|
|
My.Settings with a DLL?
Replies (1) 19 June 2007
I have created some XSD files in my VB.NET 2.0 project using the DataSet
designer. It creates some Settings entries (for the connection string that
specifies the location of the MDB file) in the ...
|
|
|
|
|
Check password
Replies (2) 13 June 2007
This is a multi-part message in MIME format.
------=_NextPart_000_001C_01C7AD9E.539218B0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Hello,
is there a w...
|
|
|
|
|
Growing VB.Net application
Replies (12) 12 June 2007
This is a multi-part message in MIME format.
------=_NextPart_000_0012_01C7AD00.46E77E50
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Hello to you all,
I...
|
|
|
|
|
Data connection
Replies (1) 12 June 2007
Hello,
When creating a new report with Crystal Reports XI, which connection should
I use when my database is SQL Server 2005?
Can that same connection be used when I would eventually have to use ...
|
|
|
|
|
richtextbox control
Replies (1) 11 June 2007
Hello,
I need to implement an email editor control in my application.
The control should allow me to type in text in any format,font etc.
This i have managed using the richtextbox control avail...
|
|
|
|
|
DateTimePicker1.Value can't save to oledb
Replies (1) 11 June 2007
I've a db sqlserver with a table where a column have data type
smalldatetime.
When i must insert a date from DateTimePicker1 i use:
rc.CommandText = "Insert into CRMPratiche (IDScadenza, CRMIDAna,...
|
|
|
|
|
TableAdapter Update problem
Replies (1) 11 June 2007
Hi There
I'm using the TableAdapter method to save changes to my record. Some fields
are filled in programmatically, but those don't update to the database at
all. Why is this? Code sample fol...
|
|
|
|
|
Use non-VS2005 XSD as data source?
Replies (1) 10 June 2007
I'm working on a project where all the data will be stored and
manipulated as XML. There is an XML schema to define what can be
contained in the XML. Since data sources in VS2005 are themselves
n...
|
|
|
|
|
VB.NET data access - newby question
Replies (13) 5 June 2007
I have gone through the introductory help topics in the documentation
relating to data access, and it talks you through creating a database, and
connecting to the database. Then it jumps straight ...
|
|
|
|
|
Dealing with a single record result set.
Replies (2) 4 June 2007
Hi,
In all my coding to date, i have been dealing with multiple results in my
dataset, looping through them with
For each row in daatset.table("blah")
label1.text = row("fieldname")
...
|
|
|
|
|
create Piclist in vb for access database
Replies (1) 3 June 2007
hi,
How can I create a piclist into a access db in a vb2003 ado programm
Jan...
|
|
|
|
|
Can't login afther publishing
Replies (1) 2 June 2007
Hello,
I've created a aspx website (ASP.NET 2.0 - VB 2005) in Visual Studio. I've
also added security by using the ASP.NET configuration tool (Rols, users &
permissions). When I debug (run) the...
|
|
|
|
|
Exporting DataGrid to flat text file
Replies (1) 1 June 2007
|