Ars Technica

Speeding up SQL/VB.NET application.

I have written an application that takes in a fixed-width file (thanks in no small part to advice I recieved in a seperate thread) and then dissasembles each line, runs a fairly meaty SQL SELECT query ...
Visual Studio Magazine

Edit Your SQL Data

ActiveData assists Visual Basic 5/6 developers in their data application development. It helps you see and edit a DAO or ADO recordset's data, connection properties, recordset properties, and field ...
Visual Studio Magazine

A CLR Alternative to the SQL Server ISNUMERIC function

Recently I encountered a problem in a stored procedure that was caused by an unexpected result from the SQL Server ISNUMERIC() function. I was using SQL Server 2008 R2 but the issue has long been ...
csdn

[醒目]VB+PROCEDURE(SQL SERVER2000)

VB调用一个PROCEDURE的时候,可以传入参数集合么? 比如:传入n条记录,目的是调用一次PROCEDURE就可以往数据库表里插入n条数据. 具体例如:表RestDay;存储过程:MyProcedure; 现在，从画面端传来一整年的休息日信息，一共n条记录，每条记录包括以下4个域RestDaySetID(varchar(4 ...
Ars Technica

Visual Basic/SQL problem

You should check the .EOF and/or .BOF properties of your recordset before you do anything with it. If .EOF = True right after creating the recordset, then your query returned no records.<P>As for ...