Language Programming: ASP.NET with VB.NET
My problem it's not how to send a e-mail, but I would like to have (and hoe
to do it) two things.
The first is when I click in my SEND button, that opens a window (with fixed

I have an issues with my data access layer. It should have methods like:
OpenTable(tableName) that returns DataTable and UpdateTable(dataTable,
tableName) that should update, insert and delete rows from the table.
OpenTable method is fine, but the problem is with UpdateTable method. ...

My question seems to be a stupid one. I was trying to access Oracle DB using objects in System.Data.OracleClient namespace. I have .NET Framework 1.1, so the assembly is in GAC (I was able to see it there). However this bunch of code wouldn't even compile
using System.Data
using ...

I have a project where I am using a DataAdapter. A Command object is created
to use a stored procedure to insert data and the appropriate columns are
attached. The Command object is attached to the InsertCommand and the Update
method is called. So far, so good and the database ...

Here's some psuedocode, (the actual code is a little more complex),
involved in a curious occurence in our application.
 // Execute stored procedure get_page_imposition
 SqlCommand command = new SqlCommand("get_page_imposition",  

I try to make my first report but when I try to open it
in the browser I get the message Logon failed. I have MS
SQL Server, VS.NET 2002 with SP2 and Windows XP. During
the development I use Integrated security.

I have a visual basic client using soap tool kit 3 using consuming vb.net
web service . I wanted to know that at the server side when i receive an ado
recordset xml format string , how can i convert to ado.net dataset xml
format to load it to a dataset ... i.e converting an ado ...

I have a visual basic client using soap tool kit 3 using consuming vb.net
web service . I wanted to know that at the server side when i receive an ado
recordset xml format string , how can i convert to ado.net dataset xml
format to load it to a dataset ... i.e converting an ado ...

In my datatable I have a column of decimal values. I would like to edit any values in this column so that all values < 0 are set to 0, prior to updating my sql database. Any ideas on how I can achieve this
Many thank
Homer

I have a StoredProcedure that returns a ref cursor and a numeric value.
I want to populate a datatable with the returning cursor, use the numeric
value elsewhere.
What is the method for this ?

Could anyone guide me to some innformation on "Best Practise" on the matter
of designing a Data Access Layer for our klient.
We are starting to convert from VB6 to .NET. Our VB app is a single layer
app, but we do want to get the data access layer out (as recomended). Any

Is it possible to convert a System.Type to Data.DbType (this is
unfortunately an enumaeration)?
Thanks, Rainer.

I have a table in a dataset with 4 columns.
Except for the third, all columns are NVARCHAR2.
The third is a CLOB. I read it can hold up to 4Gb.
The column of the dataset is bound with a textbox, so the datalimit is 32kb.

I used Access to define a record with a couple of columns of type TimeStamp.
When using perl, I use the syntax {ts '2004-MAR-15 23:44:22'} to insert a
value using the SQL insert statement. It works great (except for the fact
that I'm using Perl cgi.)

Using ASP.Net to read/write to an Access DB on a webserver.
   How can I check to make sure I haven't left any connections open ? I
have physical access to the server if I need to check it there. I really
want to verify all is well before I go live with it.