I am running a tiny SQL Server 2000 database on a Small Business
server premium edition. I am connecting (using SQL Server security
logins) to it from 2 XP professional workstations each running the same
simple VB.NET program. (I am not running the server as a domain

Hi List,
I use the folloiwng code to fill up a DataGrid with one table's data
from SQL:
fillGrid.SetDataBinding(m_DataSet, tableName)

Dear Friends,
I'm trying to create a .NET class named TESTE using VB.NET that can be
called by an ASP page but I got an error that I could not fix.
TEST CLASS code:

Whats wrong with the below code?  On every loop it seems to be jumping 3
sometimes 4 records.  As you can see the SQL query is asking for all records
with no filters.  I want to loop each record as I asked.  Is there something
with wrong with my code?  Thanks in adavnce, Steve.

I'm attempting to update an SQL Server database from a datagrid. I have
followed one of microsofts walkthroughs as far as possible, but I am
using stored procedures where it did not, though i don't think that
should be a problem.

OK, I have a solution that works fine on my laptop and my desktop.  When I
tried to move the solution to the production server, I keep getting the error
message
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found

Hi Ng,
i have a sucking problem......
select * from test where nId IN (1, 2, 3)
Now i want to execute this with an sqlcommand and more interesting with

Why is the last line of this code snippit pulling up with an error?  Any help
will be appreciated - Thanks, Steve.
string str_SQLLayoutsPound = "SELECT * FROM Layouts ORDER BY Name";
OleDbCommand obj_SQLLayoutsPound = new OleDbCommand( str_SQLLayoutsPound,

I have code that stores integer data from the control to the database.
(I am using Option Strict). The problem is when I try to do the code
below, I get that the string is not properly formatted because there is
no value. Each page has a lot of variables. Is there a way to solve

I am trying to get the number of records selected using the ExecuteNonQuery
(MARKED BELOW BY ***). It does not crash but returns a "-1". The select
returns one record.  What am I doing wrong?  please help.
strSQL = "SELECT [med-id], [animal-id], [animal-name], medication, date,

I am getting a NullReferenceException deep in the bowels of ADO.NET.
I figured out that it only happens when I change column values within RowUpdating
event handler.
       private void _dataAdapter_RowUpdating(object sender, OleDbRowUpdatingEventArgs

This Point has always make me confuse
Sure that DataSet is in the RAM but where in the RAM the Server or the
Client
Shall be Very Kind of you if any one can take a lill of there time to

I''ve created an OleDbDataReader that will contain the number of records that
the used SQL query will return.  I'm then using a while loop to loop while
the OleDBDataReader object has records.  I would like to know does the
OleDbDataReader contain the actual information on each ...

This is really stumping me.  I have a dataset where I compute certain
columns because I need to reorganize the data to a certain format, but
I need to take the new columns and put them into a new dataset.  I have
a custom control where a user performs some actions and it combines

My update method is not working, I am getting
An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred
in system.data.dll
Additional information: System error.