|
|
|
February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 |
Insert row to vfp 6 from ado.net Posted by Hardik Shah at 1/30/2007 10:12:52 AM Hi,
I am using vb.net 2003 with vfp6 table. insert command has been build
automatically through data wizard. select command work properly , but when I
am going to add any new row , dataadapter.fill(dataset) command give
following error.
An unhandled exception of type 'System.Data.Odbc.OdbcE...more >>
Update won't work Posted by Ivan Jericevich at 1/25/2007 4:12:41 PM For some reason the update does not change the data in the database. It was
working fine before, I checked that the bindingsource and tableadapter are
still on the form....what else could be wrong?
...more >>
VBScript or VB.Net? Posted by Systems Admin at 1/25/2007 8:21:03 AM Hi All,
I need to write a program/script that gathers some data from Windows
systems, compare it with SQL Database and update if it's changed.
My question is what should i use? VBScript or VB.Net?
Here is my background..
I am a systems administrator.
I have experience with: C, C++, ...more >>
How can I enable the Enter key Posted by Ivan Jericevich at 1/24/2007 11:14:44 PM I am building my first program in VB 2005 Express Edition and considering
I'm a BBC quite chuffed with my progress. All the data entries work off the
TAB Key in run mode, how do I get the ENTER or RETURN Key to do the same. It
is totaly disabled.
...more >>
using listviews and datasets... Posted by Brad Pears at 1/24/2007 4:44:11 PM I am developing a vb.net 2005 application using SQL server 2000 as the back
end. I am new to .net am am just wondering what the best way to go about
the following is...
WHen the app loads, I load a listview of rows from teh database. The user
can filter the records by selecting various it...more >>
Retrieving an outpuit paramater from a stored procedure.. Posted by Brad Pears at 1/23/2007 4:35:58 PM In my vb.net 2005 project, I run a stored procedure on our SQL Server 2000
database.
In this stored procedure, I have defined an output parameter.
I want to then use this output parameter in my vb code. How do I access this
output parameter in code?
Thanks,
Brad
...more >>
Does VB.net have the data1 control that we had in vb6 Posted by nach at 1/23/2007 11:46:00 AM In vb6 we were able to have a data1 control and link the textbox on the form
with the data1 control via the datasource property.
Can something similair be done in vb.net ???...more >>
Accessing sql server behind proxy Posted by John at 1/21/2007 4:17:51 AM Hi
My app is running on a windows 2000 server with isa 2000 installed. How can
it access an external sql server (using its ip) from within the isa 2000
firewall/proxy via code?
Thanks
Regards
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Reading a single field from table Posted by John at 1/17/2007 10:35:29 AM Hi
I need to run a simple select query like below;
select field1 from mytable where id = 123
and assign the returned value of field1 to a variable. What is an easy way
to do this?
Thanks
Regards
...more >>
Splitting string Posted by John at 1/16/2007 5:39:34 PM Hi
I have a multi-line address field which has each line separated by CRLF. How
can I split this field into individual strings using crlf as separator?
Thanks
Regards
...more >>
Problem running query in code Posted by John at 1/15/2007 8:19:04 PM Hi
I am using the below code to run a sql on an underlying access table;
insStr = "INSERT INTO [Web Site Action Queue] ( Action, [Client ID],
[Operator], Request_Date ) " & _
"VALUES (""Modify Client"", 93, ""Administrator"", Now())"
Dim insCmd As New OleDbCommand(insStr, dbConContacts)...more >>
Adding .pdf docs to an SQL Server 2000 database table Posted by Brad Pears at 1/15/2007 3:32:42 PM In a new vb.net 2005 app I am developing, I want to save a .pdf file in the
actual row - rather than just storing the file location of where the related
..pdf file resides. Please let me know if you think this may be a bad idea. I
have never done this before so thought the application I am dev...more >>
not CLS-compliant Posted by John at 1/15/2007 12:42:55 AM Hi
After importing my vs 2003 project into vs 2005 I am getting the error Name
'_DateColumn' is not CLS-compliant. on the second line of below code;
<System.Diagnostics.DebuggerNonUserCodeAttribute()> _
Public ReadOnly Property _DateColumn() As System.Data.DataColumn
Get
Return Me...more >>
vs2003 to vs2005 Posted by John at 1/14/2007 8:33:31 PM Hi
I have a vb.net 2003 database winform app which uses non-bound controls and
the associated plumbing is done in code. If I move it to vs 2005 would it
work without any change?
Thanks
Regards
...more >>
Data Bind from Child table To Parent Table Posted by Mar72Vin at 1/12/2007 7:11:46 PM Hi All,
I have two tables in a dataset with a relation.
tblPerson and tblAddress
tblPerson.PostalAddressID relates to tblAddress.AddressID
I have a DataGrid bound to tblPerson. I can change the current record
and all related textboxes on the form are updated correctly through
binding. tx...more >>
Copying from one db into another Posted by John at 1/12/2007 12:36:16 PM Hi
I am trying to copy data from one db into another. Thanks for everyone who
suggested ways to do that. After some more research I have come up with the
below simple looking way. My question in, is it supposed to work this way
and will it work?
LocalConn.Open()
Dim DBCommand As New ...more >>
Inserting from one db into another Posted by John at 1/12/2007 3:36:16 AM Hi
I have open connection to two separate databases. I now need to insert
records from a table in one db into a table in second db. How can I go about
doing it?
Thanks
Regards
...more >>
If Exists Datatable Posted by Kevin Humphreys at 1/10/2007 5:49:29 PM To Whom It May Concern,
Is it possible to check if a data table is created?
E.G.
If not exists(DataTable("Basket")) then
Dim Table1 As DataTable
Table1 = New DataTable("Basket")
End
If not exists(DataTable("Basket")) then
'Work with existing datatable.
End
...more >>
BackgroundWorker and closing an OleDbConnection Posted by eforden at 1/8/2007 12:12:36 PM Hi,
I am new at using the BackgroundWorker so please forgive me if this topic
has already been covered.
I'm using BackgroundWorker to import data into an Access 2000 database using
OleDbConnection. After the thread is complete, I'm noticing that the Access
..ldb lock file still remains,...more >>
Which database?/SQL Server License Posted by HKSHK at 1/6/2007 7:36:34 PM Hello,
I am currently writing a database application which uses ADO.
However as I experience a runtime error 3014 (Can't open any more
tables) I want to move away from Access databases as backend.
The application I work on is for schools, so I do not expect state of
the art computers and ...more >>
Stored Procedure and SQLCommand Posted by fniles at 1/6/2007 10:19:10 AM I am using VB.NET 2003 and SQL2000 database.
I have a stored procedure called "INSERT_INTO_MYTABLE" that accepts 1
parameter (varchar(10)) and returns the identity column value from that
table.
When calling the stored procedure from VB.NET, in the CommandText, can I
just say "INSERT_INTO_MYT...more >>
Executing Stored Procedures Posted by Vayse at 1/5/2007 3:20:19 PM Hi
I have a bit of code that executes several stored procedures. Just looking
for advice on speeding the whole process up.
Here's what I have at the moment, after setting up the parameters for each
command:
sqlConnection.Open()
lRows = cmdDelete.ExecuteNonQuery
lRows = cmdPre_This.ExecuteNo...more >>
Query problem Posted by Ivan Jericevich at 1/4/2007 3:22:43 PM In my code below the result returns two rows. This particular Tenant occupys
2 Units. How do I join the two rows to give me "Unit1 and Unit4"
ALTER PROCEDURE dbo.getUnitNumbers
@TenantID int,
@UnitNumber varchar(50) OUTPUT
as
SELECT TOP (8) @UnitNumber = UnitNumber
FROM Area
WHER...more >>
Column Number Posted by Vayse at 1/3/2007 12:52:41 PM In a large For loop, I have code like this:
rowRenewal.ThisYearsPremium = viewLedger(iRow).Item("Debt")
viewLedger is a dataview. I'd like to use a column number instead of "Debt".
Is there a way of finding out the column number of the "Debt" field in the
view?
Thanks
Vayse
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |