1. Is there a way to create a .Net 2.0 webservice that does NOT write
to c:\windows\TEMP to create temporary classes? I have security issues
with that.
2. If not, Is it possible to instruct .NET 2.0 to write its temporary

I'm having trouble refreshing a datagrid control bound to a dataset that was
created from the New Data Source wizard.  What is the code required to
refresh the datagrid with data from the data source (sql db)?
More Details:

I tried to browse a table which have 2 million of records.
it's too slow to browse -it directly so i tried to use caching
methods.
(Implementing Virtual Mode with Just-In-Time Data Loading in the

i am applying aggregate function on datatable.compute.  I have one
fiter criteria and based on that i want to apply sum function on two
columns like sum(sal), sum(pf).  if i write query in sql it is
allowing me to use more than one aggregate function but how to do it

I made a database (http://users.skynet.be/fc042048/Pizza.jpg) in Access
which I want to use via typed datasets on my website. Problem is, if I i.e.
want to edit the datatable "Pizza" in a gridview, I get the error "Can't
delete or update the record because there are related ...

I have an SP, which is calling from .NET code using ODP.
In that SP i have few update table statement followed by Insert
statement and then delete statement.
When I am executing its not updating the table. means the code flows

I have two tables, mc_Workouts and mc_WorkoutDetails, that have a
one-to-many relationship with each other.
I use the stored procedure below to copy a workout. It needs to create a new
workout with a new name and then copy all the workout details from the

Most of my DB experience is many years ago with Access. SQL's fine but I
find managing relationships awkward and confusing.
Anyway, I've created a table that is on the many side of a one-to-many
relationship. So it contains a foreign key that references a primary key in

The following query runs fine in Oracle SQL Developer, it also runs fine
using the .net oracle managed provider on my local dev machine.  However, it
errors out when I run it on our web server with the following error message:  
ORA-01830: date format picture ends before ...

What´s the diference between TableAdapter and DataTable? When I should use a
TableAdapter and DataTable?
Hugs,
Willian

I´m starting with C# and .NET. So, I have some difficulties with some codes.
I´m already a programmer and I´m migrating from Delphi to C#. My questions
are:
1) Into a form I´ve made my connection string and my SqlConnection variable.

Is there a rule about when should I have to use a typed or untyped DataSet?
What are your tips and advices?
Thanks,
Willian

I'm having the oddest issue.  I can execute a select query on a database but
I get an error when I try to execute a stored procedure.  It is probably
something dumb but I have tried everything I can think of.  I'm not having
much luck searching the web either.

The database I use is SQL Server 2005.
The user to login database is 'PG_TestUser', it has 'dbo' schema, and it has
datareader and datawriter permission.
I have .NET Code like this.

I'm developing a Web App in C#. The following method executes without
exceptions but the database does not get changed. The data is changed in the
record[0] at the point prior to executing the   " adapter.Update(record);"
instruction.