I have an application where by I am storing images in SQL server, is there a
way in ADO.Net that I can replace the value of a declared varible when it
does not match the conditions say (jpeg,gif). Can I replace this with
another image on the server so that the DB table does not have ...

I tried to set the NULL Value in the property tab of the Schema Designer for
a DataTable field of type DateTime.
When i put somthing like 1.1.1900 there the Debugger tells me that not a
correct Date value ?

I have a need to remove a DataRow that is part of one table, and physically
move it over to another table (with the same schema).
I remove the row using the Remove method, and insert it into the other table
using the InsertAt table.

If you have two tables in a DataSet and need to do a SELECT with a JOIN
between the two tables (or RIGHT OUTER JOIN in my case), how do you do that
if the data was read in from an XML file using DataSet1.ReadXML ?
Isn't the DataTable SELECT only for working with one table?  And also ...

I have a datatable that was created within a dataset.  I dynamically add columns to the table as I add data.  Previously added rows probably did not have data for the column that is being added.  Since I’m added rows and maybe columns at the same time what is column content for ...

When I create a view using VS.NET 2003 it sometimes inserts TOP 100 PERSENT
right after SELECT clause. Why? It will slow down execution, right?
Thanx for any help

I'm filling a DataTable with data from a Sybase database table via ODBC provider.  I have a varchar(10) column in the database table that stores " " (one blank character) as valid data for special cases.  Once I fill my DataTable, the data rows contain empty string for this ...

In the past I've successfully databound a conventional Winforms checkbox to
a number column in an Oracle table, where 1 represents true and 0 represents
false.  The checkbox would be ticked if the value was 1 and unticked if the
value was 0 - earth shattering news I know! :-)

I've an MS mdb file that I want to update the information daily.
I have to clear the columns (about 20 of them) of the hundreds of rows of the
information before I can update it (otherwise, I'm just adding to the file).
How can I do this in either VB.net or ADO.net?

I am connecting to SQL Server through OleDB provider. The
SQL server I am testing is running on the same machine
that my VB.Net app is running. Here is my connection
string:

HI  There,
How can I check if the dataset is empty? I just want to check to see if the
dataset is empty or null when the query is run, couls someone help me out
with some code please?

I am doing the visual studio.net walkthrough for web
application(msde sql server). I am getting the error
message:
System.Data.SqlClient.SqlException: Login failed for

can i be assured that the following ("lastrowadded") will always refer to the last row that was added to the collection? or are there exceptions?
int c= dataSet1.tbl1.Rows.Count;
DataRow lastrowadded=dataSet1.tbl1[c-1];
thanks

I am trying to program a small database for myself wich will hold less than
1000 records.
Which solution do I have?
Of course, not SQL Server, and maybe not Access.

I have a stored procedure, that is pretty lengthy.  It has 2 temp tables, one of which the final select statement is ran against to be returned as the result. When configuring the dataadapter, I get warning that the the temp table is an "Invalid Object MyTable".  At first because ...